Member since
11-09-2017
4
Posts
0
Kudos Received
0
Solutions
02-15-2018
10:56 PM
Restart of hive metastore server and hive server worked for me.
... View more
11-22-2017
02:43 AM
Thanks for the reply. Is there any plan to handle it like it is being done in Hive? Regards Pushkin
... View more
11-09-2017
03:39 AM
Came across a strange issue where in when converting a timestamp from PST to GMT, to_utc_timestamp function is returning blank. I could see that this happening for an hour range only on the day daylight savings were switched off in US.
Query: select to_utc_timestamp(cast('2017-11-05 01:00:00' as timestamp),'PST')
Query: select to_utc_timestamp(cast('2017-11-05 01:59:59' as timestamp),'PST')
Above queries return blank output.
However the same things works fine in hive:
Query: select to_utc_timestamp(cast('2017-11-05 01:00:00' as timestamp),'PST')
OK
2017-11-05 09:00:00
Query: select to_utc_timestamp(cast('2017-11-05 01:59:59' as timestamp),'PST')
OK
2017-11-05 09:59:59
Need help understanding reason for the same and also how to work around this issue using Impala query itself.
Impala Version - v2.7.0 on CDH 5.10
Hive version - 1.1.0 on CDH 5.10
... View more