Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Change default timezone for Hive

avatar

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

avatar
Contributor

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.

avatar
Expert Contributor

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?