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?
