Server time zone !

2009-02-12 Thread Shyam Sarkar 
Is there any 'Server's time zone' implementation inside Hive? For proper 
implementation of TIMESTAMP data type, this is necessay to translate from 
stored string type. I am focusing on MySQL 6.0 (with limited properties) for 
TIMESTAMP.

http://dev.mysql.com/doc/refman/6.0/en/timestamp.html

Thanks,
Shyam

Re: Server time zone !

2009-02-12 Thread Zheng Shao 
Not yet. I think JVM take the environment variable TZ for that purpose for
all java-related functions.

In build-common.xml you should find the following:
env key=TZ value=US/Pacific/

This makes sure all current UDFs related to time/date are using the
US/Pacific time zone. (Note: all these UDFs are operating on String and
Integer types right now)

Zheng

On Thu, Feb 12, 2009 at 2:21 PM, Shyam Sarkar shyam_sar...@yahoo.comwrote:

 Is there any 'Server's time zone' implementation inside Hive? For proper
 implementation of TIMESTAMP data type, this is necessay to translate from
 stored string type. I am focusing on MySQL 6.0 (with limited properties) for
 TIMESTAMP.

 http://dev.mysql.com/doc/refman/6.0/en/timestamp.html

 Thanks,
 Shyam






-- 
Yours,
Zheng

RE: Server time zone !

2009-02-12 Thread Ashish Thusoo 
You could just use the

java.util.TimeZone

to get the current timezone.

Ashish 

-Original Message-
From: Zheng Shao [mailto:zsh...@gmail.com] 
Sent: Thursday, February 12, 2009 2:31 PM
To: hive-dev@hadoop.apache.org; shyam_sar...@yahoo.com
Subject: Re: Server time zone !

Not yet. I think JVM take the environment variable TZ for that purpose for all 
java-related functions.

In build-common.xml you should find the following:
env key=TZ value=US/Pacific/

This makes sure all current UDFs related to time/date are using the US/Pacific 
time zone. (Note: all these UDFs are operating on String and Integer types 
right now)

Zheng

On Thu, Feb 12, 2009 at 2:21 PM, Shyam Sarkar shyam_sar...@yahoo.comwrote:

 Is there any 'Server's time zone' implementation inside Hive? For 
 proper implementation of TIMESTAMP data type, this is necessay to 
 translate from stored string type. I am focusing on MySQL 6.0 (with 
 limited properties) for TIMESTAMP.

 http://dev.mysql.com/doc/refman/6.0/en/timestamp.html

 Thanks,
 Shyam






--
Yours,
Zheng