How high is the cardinality? By saying "failed" and then have to restart, do you mean crash? Any clue in kylin.log?
Sorry for many questions, but it's hard to help without the details. The new 1.5.2 release will come with a diagnosis tool that can extract necessary info into a zip, which you can share with community to diagnose. On Mon, May 9, 2016 at 5:12 PM, jyzheng <jyzh...@iflytek.com> wrote: > > > 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 > > >
