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
