??????How to modify the time zone of hive ? ????????????hive????????

[??????]

????????????????????????????????????Hive????????????????hive????kylin??????????Ambari??????????????kylin??????????????????????????????????????????????????????????????????????kylin??????????????hive??????????????????????????????????????????????????????????????????




------------------ ???????? ------------------
??????:                                                                         
                                               "??????"                         
                                                           
<3281438...@qq.com&gt;;
????????:&nbsp;2020??8??5??(??????) ????10:01
??????:&nbsp;"user"<user@kylin.apache.org&gt;;

????:&nbsp;How to modify the time zone of hive ?



Hello everyone,
&nbsp; &nbsp; &nbsp; &nbsp; Recently, I encounter a problem, when I&nbsp; 
execute some query statements&nbsp;with "date" in kylin, the result returns 
null or&nbsp; 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) &gt;= '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) &gt;= '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?