I have an external HIVE table with the underlying file in ASCII delimited, gzip format. We have created an external parquet table also via HIVE to convert data into parquet format.
Now when I INSERT into the parquet table, all the data but the time stamps change.
Eg. In HIVE table pointing to ASCII table we have the timestamp as: 2003-09-06 00:00:00
In HIVE table with parquet file format we have the same time stamp as 2003-09-06 04:00:00
In the DDL for both the ASCII and Parquet, we have defined time stamp as I2A_NEWITEMDATE TIMESTAMP