Re: 转发：How to modify the time zone of hive ? 请问怎么修改hive的时区？

[Rupeng Wang <wa...@live.cn>]

Hi, 

Refer to the answer of Cloudera Community , before hive3, you can change the default time zone of hive by changing the time zone of JVM. 

For Hive3(maybe not your option), refore to the Hive JIRA, https://issues.apache.org/jira/browse/HIVE-16614, we can change time zone with command like “set time zone LOCAL”. 

 

-------------------

Best wishes,

Rupeng Wang

 

 

 

发件人: 梅秋莹 <32...@qq.com>
答复: <us...@kylin.apache.org>
日期: 2020年8月13日 星期四 09:11
收件人: user <us...@kylin.apache.org>
主题: 转发：How to modify the time zone of hive ? 请问怎么修改hive的时区？

 

急急急！大佬们，请问你们知道如何修改Hive的时区吗？我们的hive以及kylin均是集成在Ambari中，现在在使用kylin的过程中发现涉及到日期查询的结果不对或者查询不出来结果的情况，经过研究kylin官网发现应该是hive时区的问题，但是不知道在哪里可以修改这个参数，请大佬们指教，谢谢！

 

 

------------------ 原始邮件 ------------------

发件人: "梅秋莹" <32...@qq.com>;

发送时间: 2020年8月5日(星期三) 上午10:01

收件人: "user"<us...@kylin.apache.org>;

主题: How to modify the time zone of hive ?

 

Hello everyone,

        Recently, I encounter a problem, when I  execute some query statements with "date" in kylin, the result returns null or  inconsistent with hive. 

 

For example:

(1)Example one, we can get results.

select sum(totalfee) from erp_by_shopsale_fact f

left join billperiod_dim b on f.fpdate_key=b.date_key

where cast("billperiod_dim "."billperiod_date" as DATE) >= '2020-07-28' 

 

(2)Example two, we get null.

select sum(totalfee) from erp_by_shopsale_fact f

left join billperiod_dim b on f.fpdate_key=b.date_key

where cast("billperiod_dim "."billperiod_date" as DATE) >= '2020-07-28' and cast("billperiod_dim "."billperiod_date" as DATE) < '2020-07-29'

 

After looking up some blogs and studying from kylin website, It maybe the time zone of hive. Do you konw how to modify the time zone of hive or where I can configure the time zone?