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
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
;
> As you can see, the timestamp is ISO8601 compliant, and does specify Z, so as
> Andres explained, this is a UTC time.
>
>
> Regards
>
> Sekine
>
>
> 2016-09-23 5:48 GMT+02:00 Manish R :
>
>> Hi Andres,
>>
>> No that is not in UTC format. Pl
23:20:30*
On Fri, Sep 23, 2016 at 1:24 PM, Manish R
wrote:
> 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
&