- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Change default timezone for Hive
- Labels:
-
Apache Hive
Created ‎02-09-2017 05:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created ‎02-09-2017 06:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎07-27-2017 02:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
