Shaofeng SHI created KYLIN-2097:
-----------------------------------

             Summary: Get 'Column does not exist in row key desc" on cube has 
TopN measure
                 Key: KYLIN-2097
                 URL: https://issues.apache.org/jira/browse/KYLIN-2097
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
            Reporter: Shaofeng SHI
            Assignee: Shaofeng SHI
             Fix For: v1.6.0


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

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

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.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to