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