[KYLIN-2097] Get 'Column does not exist in row key desc" on cube has TopN measure

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.6.0
• Component/s: Query Engine
• Assignee: Shao Feng Shi
• Reporter: Shao Feng Shi
• Created: 17/Oct/16 03:21
• Updated: 26/Nov/16 08:12
• Resolved: 18/Oct/16 07:02

Description

Define a cube which has a TopN measure to collect the top tags on Twitter; when query with the tag as a "where" condition,

select TWITTER_TAG3.HOUR_START , hashtag, count(*) as num from TWITTER_TAG3 where hashtag = 'ALDUBAnew'  group by HOUR_START, hashtag order by HOUR_START

As TopN doesn't put the UHC column into row key, it couldn't be used as the filtering condition, then Kylin reports error: "Column DEFAULT.TWITTER_TAG3.HASHTAG does not exist in row key desc"

In this ccase TopN should say no for this query as it doesn't have the capacity, then Kylin can rounte to other cubes.

For user who only has one cube, he should change to use "having" clause instead of "where", although the performance is not good, it can return result in the end.