Re: iso 8601 to utc with timezone conversion

Guys, I tried below query but it looks like the conversion is somehow not correct. The logs are from AWS ELB in Singapore region. Can you guys please check and let me know what am I missing? hive> SELECT s.request_date, a.tz, FROM_UTC_TIMESTAMP(UNIX_TIMESTAMP(s.request_date,

Re: iso 8601 to utc with timezone conversion

Yes Sekine I am talking about AWS ELB logs in Mumbai region. Let me try implementing what Andres suggested and I also in a verge of implementing some other solution as well. I will let you all know once any of the solution works. On Sep 23, 2016 1:11 PM, "Sékine Coulibaly"

Re: iso 8601 to utc with timezone conversion

Manish, UTC is not a format (but, ISO 8601 is). Consider UTC as + at the end of a ISO 8601 time. Eg: 2016-01-01T*23:45:22.943762*+ is stricylt equivalent to : 2016-01-01T*23:45:22.943762Z* *and is also strictly equivalent to the same time expressed in another timezone such as

Re: iso 8601 to utc with timezone conversion

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

Re: iso 8601 to utc with timezone conversion

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

iso 8601 to utc with timezone conversion

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