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