please attach your hbase version as well as kylin version. please also check if you can reproduce on sample cube as liyang asked
On Sun, May 15, 2016 at 8:28 PM, Li Yang <[email protected]> wrote: > If you could reproduce the problem with sample cube, we will be able to do > something. > > On Thu, May 12, 2016 at 3:10 PM, streemwu <[email protected]> wrote: > > > > > > > when I queried by sql > > "select sum(sample_value) as aa ,year_int,month_int,day_int,hour_int > from > > fact_samples > > inner join dim_time > > on fact_samples.time_id=dim_time.time_id > > left join dim_business1 on > > fact_samples.business1_id=dim_business1.business_id > > where ((dim_time.year_int=2016 and dim_time.month_int=5 and > > dim_time.day_int=1)) > > group by year_int,month_int,day_int,hour_int" > > > > > > I can get the result data > > > > > > when i queried by sql > > "select sum(sample_value) as aa ,year_int,month_int,day_int,hour_int > from > > fact_samples > > inner join dim_time > > on fact_samples.time_id=dim_time.time_id > > left join dim_business1 on > > fact_samples.business1_id=dim_business1.business_id > > where ((dim_time.year_int=2016 and dim_time.month_int=5 and > > dim_time.day_int=2)) > > group by year_int,month_int,day_int,hour_int" > > > > > > I also can get the result data > > > > > > > > > > but if I query data by sql > > "select sum(sample_value) as aa ,year_int,month_int,day_int,hour_int > from > > fact_samples > > inner join dim_time > > on fact_samples.time_id=dim_time.time_id > > left join dim_business1 on > > fact_samples.business1_id=dim_business1.business_id > > where ((dim_time.year_int=2016 and dim_time.month_int=5 and > > dim_time.day_int=1) or (dim_time.year_int=2016 and dim_time.month_int=5 > > and dim_time.day_int=2) ) > > group by year_int,month_int,day_int,hour_int" > > > > > > I just get empty . > > > > > > > > > > if I query data by sql > > "select sum(sample_value) as aa ,year_int,month_int,day_int,hour_int > from > > fact_samples > > inner join dim_time > > on fact_samples.time_id=dim_time.time_id > > left join dim_business1 on > > fact_samples.business1_id=dim_business1.business_id > > where ((dim_time.year_int=2016 and dim_time.month_int=5 and > > dim_time.day_int in (1,2)) ) > > group by year_int,month_int,day_int,hour_int" > > > > > > I can get the result I want. > > > > > > is there any body do experience similar problems? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
