hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manish R <linuxtricksfordev...@gmail.com>
Subject iso 8601 to utc with timezone conversion
Date Thu, 22 Sep 2016 17:05:07 GMT
Hi Guys,

There is a scenario here that I am trying to implement

I have a table say table1 which contains aid and request_date in ISO 8601
format. I have one more table say table2 which contains aid and timezone
details. Now I want to convert request_date from table1 to UTC and apply
the timezone that is in table2 format for that corresponding aid.

Table 1 example data
*2016-09-15T23:45:22.943762Z abs123*
*2016-09-16T22:48:12.943762Z erty456*

Table 2 example data
*abs123   Asia/Kolkata*
*erty456  Europe/Amsterdam*

Mime
View raw message