When I send sql query to Kylin like this:

 

select app_name, count(distinct uid) as uv
from sdk_log
left join week_calendar on sdk_log.day_time = week_calendar.week_cal
where sdk_log.day_time = date '2016-05-01'
group by app_name
order by uv desc
limit 200 

 

 

and failed. So I have to restart Kylin. 

 

The dimension `app_name` is a great high cardinality. If I switch to
`app_tag` dimension , it will return the right result. So I can’t get the
top measure dimension in Kylin? If can, and what can I do to solve this?

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

郑江雨  云平台

Phone: 15155195496

 

Reply via email to