Support Questions
Find answers, ask questions, and share your expertise

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?


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.

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?

; ;