You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 梅秋莹 <32...@qq.com> on 2020/08/05 02:01:41 UTC

How to modify the time zone of hive ?

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


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&nbsp;"."billperiod_date" as DATE) &gt;= '2020-07-28'&nbsp;



(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&nbsp;"."billperiod_date" as DATE) &gt;= '2020-07-28' and cast("billperiod_dim&nbsp;"."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?