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,
"-MM-dd'T'hh:mm:s
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" wrote:
> Manish,
>
> U
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 Europe/Pa*
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
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/Langu
