Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> HQL *_utc_timestamp functions' timezone parameter?


Copy link to this message
-
Re: HQL *_utc_timestamp functions' timezone parameter?
Hi Mark,

I ran into the same issue last week, and ended up writing a small app to
print the results of
getAvailableIDs()<http://docs.oracle.com/javase/6/docs/api/java/util/TimeZone.html#getAvailableIDs()>in
java.util.TimeZone.

Having to convert from GMT to Pacific Time (accounting for Daylight Saving
Time), I used "PST8PDT".  You may need to multiple your unix timestamp by
1000 for the *_utc_timestamp functions, as the Timestamp datatype appears
to be counting in milliseconds.

Good luck!
On Fri, Jun 7, 2013 at 9:49 AM, <[EMAIL PROTECTED]> wrote:

> The HQL *_utc_timestamp functions' timezone parameter appears to be
> documented only as far as noting its existence. What are its allowed
> values? Does it make any attempt to account for daylight savings time aka
> summer hours? (If so, should that attempt be trusted?)
>
> Thanks in advance!
>
> Mark Pundurs
> Senior Data Analyst - Traffic
> HERE
> Chicago
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB