Kylin cube query problem

[jyzheng <jy...@iflytek.com>]

I have a question about Kylin query. When I send query, 

 

select calendar_table.week_cal, sub, count(distinct did) as uv

from vcoam_log 

inner join calendar_table on calendar_table.day_cal = vcoam_log.day_time

group by calendar_table.week_cal,sub;

 

I can only get 



But missed the data of March Month.

 

When I send query like this:

 

select sub, calendar_table.week_cal, count(distinct did) as uv

from vcoam_log

inner join calendar_table on calendar_table.day_cal = vcoam_log.day_time

where calendar_table.week_cal = '2016-03-06'

group by sub,calendar_table.week_cal;

 

I can get the expected UV:



--------------------------------

郑江雨  云平台

Phone: 15155195496