Re: Kylin cube query problem

[Dong Li <li...@apache.org>]

Hi jiangyu,


Please check the Limit value on WebUI, which will become ‘limit xxxxx’ clause in sql.
Maybe there’re so many records in Feb., so March data are excluded.


Thanks,
Dong Li


Original Message
Sender:jyzhengjyzheng@iflytek.com
Recipient:useruser@kylin.apache.org; devdev@kylin.apache.org
Date:Monday, Mar 28, 2016 11:52
Subject:Kylin cube query problem


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