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