Search code examples
hadoophivehiveqlhadoop2

Converting epoch time to PST zone in hadoop/hive

I want to convert the epoch time into pst time zone. For example : 1482440069 when I convert to PST, I should get 2016-12-22

Now, when I try this I get proper answer

SELECT  from_utc_timestamp('1970-01-01 07:00:00', 'PST');

Also, When I try this, I get proper value

select from_unixtime(cast(1482440069 as bigint), 'yyyy-MM-dd')
o/p : 2016-12-22

But, When I try this query, I get NULL response

select from_utc_timestamp(from_unixtime(cast(1482440069 as bigint), 'yyyy-MM-dd'),'PST') -- Gives NULL response
Solution

  • Use yyyy-MM-dd HH:mm:ss instead of yyyy-MM-dd

    hive> select from_utc_timestamp(from_unixtime(cast(1482440069 as bigint), 'yyyy-MM-dd HH:mm:ss'),'PST');
OK
2016-12-22 04:54:29