Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Change default timezone for Hive

Change default timezone for Hive

Which timezone setting (OS/Hadoop Core/HDFS/Hive etc.) is used as the default timezone for Hive?

Which configuration / property to change to use a different timezone?

2 REPLIES 2
Highlighted

Re: Change default timezone for Hive

Cloudera Employee

Hive uses the default timezone of the JVM. Currently the only way to change the timezone used by Hive is to change the default timezone of the JVM.

Re: Change default timezone for Hive

Rising Star

According to this post HDP uses UTC as default but a simple Hive Statement like this and multiple JIRA Issues proves that isn't true.

select concat('Example: ',cast(cast('2017-03-12 02:00:00' as timestamp) as string));

Example: 2017-03-12 03:00:00

Can someone provide guidance on how to set the JVMs Timezone?