Hi Andres, No that is not in UTC format. Plz see the description of that field below. so if timezone of table2 is Europe/Amsterdam then we have to convert the request_date of table1 in UTC Europe/Amsterdam timezone ( for example 2016-09-18 23:30:52). We have a lot of timezone entries in table2 and I wonder how am I going to convert all the request_date field according to timezone field. Do I have to maintains separate table for that?
timestamp The time when the load balancer received the request from the client, in ISO 8601 format. On Fri, Sep 23, 2016 at 1:26 AM, Andres Koitmäe <andres.koit...@gmail.com> wrote: > Hi! > > It seems that in Table1 you already have request_date in UTC format. *Z *at > the end of the timezone is the zone designator for the zero UTC offset. > > Now all you have to do is to use standard Hive functions which you can > find from Hive wiki https://cwiki.apache.org/confluence/display/Hive/ > LanguageManual+UDF#LanguageManualUDF-TypeConversionFunctions > > Use from_utc_timestamp to convert request_date to timestamp to timezone > specified in Table 2 (join two tables using aid column) > > Regards, > > Andres Koitmäe > > On 22 September 2016 at 20:05, Manish R <linuxtricksfordev...@gmail.com> > wrote: > >> 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* >> > >
