Alternative Timestamp Support in Hive (ISO-8601)
Hive does not support for ISO-8601 timestamp format, like this “2017-02-16T11:24:29.000Z” by default. Check the following test case: 1. Create a file with the following content: 2. Put the file in HDFS: 3. Create an external table links to it: 4. When you select the table, first record will be …