Hi,
We want to get the job tracker Ids back in the code for logging purpose for the
queries we fire using Hive Thrift client.
We also want to get some stats that Hive displays on console like n number
rows inserted, through the Thrift client in our application java code.
Is this possible i
I have faced this issue as well . We have our timezones set to UTC on the
machines in the cluster, but we like to see UTC times and PT times for
different purposes. Currently, I have a custom UDF that serves our needs . I
have always thought, it would be great if from_unixtime takes an op
Thanks mark for the input.
I was giving sonia an idea about how can these functions be used to modify
the timezone. But I would like to go for the UDF with all the timezone
taking care of, which i ll be needing.This will also give me flexibility to
generate one time reports for different time zone
Hi Sonia and Abhishek,
I wouldn't recommend using a hardcoded number (like 28800) for calculating time
in PST/PDT. That would bite you when daylight savings kick in and out.
If you look at the source code of the from_unixtime UDF, you will find that it
uses the default time zone set in the JVM.
Yes this worked.
Thanks Abhishek!
On Thu, Dec 1, 2011 at 10:28 AM, Abhishek Pratap Singh
wrote:
> hi Sonia,
>
>
> Try this
>
> SELECT from_unixtime((unix_timestamp(TXN_DATE) - 28800), '-MM-dd
> HH:MM:SS') as TXNDATE
>
> 28800 is the 8 hours difference in seconds for PDT.
>
>
> ~Abhishek
>
>
hi Sonia,
Try this
SELECT from_unixtime((unix_timestamp(TXN_DATE) - 28800), '-MM-dd
HH:MM:SS') as TXNDATE
28800 is the 8 hours difference in seconds for PDT.
~Abhishek
On Thu, Dec 1, 2011 at 10:21 AM, sonia gehlot wrote:
> Hi All,
>
> I have Unix timestamp in my table in UTC format. Is
Hi All,
I have Unix timestamp in my table in UTC format. Is there is any inbuilt
function to convert it into PST or PDT in -MM-DD HH:MM:SS format? I
know there are functions like from_unixtime to convert unixtime to date
format, but I am not sure how to convert it to PST.
Thanks in advance,
Hello list,
Could anyone tell me the basic (and must) requirements for
integrating Hive and Hbase??? I have followed the " Hive HBase
Integration " link on cwiki but I am not able to do it. Need some
urgent help.Many thanks in advance.
Regards,
Mohammad Tariq