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