Different timestamp value in hive and impala

Asked Aug 31 '21 at 10:44

Active Aug 31 '21 at 12:51

Viewed 18 times

I hive one table and when I query it in hive it returns 2021-08-31 11:01:56 but in Impala it returns 2021-08-31 07:01:56. How can I make impala read the correct timestamp which is the one in hive ?

Solution here: Impala timestamps don't match Hive - a timezone issue?

edited Aug 31 '21 at 12:51

asked Aug 31 '21 at 10:44

DrGenius

If it is Parquet, read this: https://stackoverflow.com/q/33556226/2700344 – leftjoin Aug 31 '21 at 11:29
Thanks it helped a lot. I am closing the post. – DrGenius Aug 31 '21 at 12:50

Different timestamp value in hive and impala

0 Answers0