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

Re: Server time zone !

2009-02-12 Thread Zheng Shao
cases. > > Shyam > > > > --- On Thu, 2/12/09, Zheng Shao wrote: > > > From: Zheng Shao > > Subject: Re: Server time zone ! > > To: hive-dev@hadoop.apache.org, shyam_sar...@yahoo.com > > Date: Thursday, February 12, 2009, 2:31 PM > > Not yet. I think J

Re: Server time zone !

2009-02-12 Thread Shyam Sarkar
So eventually UDFs need to be modified to operate on TIMESTAMP data type ! Can we partition a table based on TIMESTAMP ? We should because it is really important for users in many cases. Shyam --- On Thu, 2/12/09, Zheng Shao wrote: > From: Zheng Shao > Subject: Re: Server time zone

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: 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 In

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 Thank