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?
