Zhong,Jason created KYLIN-1622: ---------------------------------- Summary: sql not executed and report topN error Key: KYLIN-1622 URL: https://issues.apache.org/jira/browse/KYLIN-1622 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Zhong,Jason Assignee: Shaofeng SHI
pull the latest code from master branch, commit id is d899a67963af14f80fc047a9253ac7736c1983f3, deploy in sandbox, and run bin/sample.sh to get sample cube "kylin_sales_cube", and created a cube called "kylin_sales_cube_desc_TOPN". I build "kylin_sales_cube_desc_TOPN" first and then build "kylin_sales_cube". topN sql is " SELECT SUM (t0.PRICE), t1.WEEK_BEG_DT FROM "DEFAULT".KYLIN_SALES AS t0 INNER JOIN "DEFAULT".KYLIN_CAL_DT AS t1 ON t0.PART_DT = t1.CAL_DT GROUP BY t1.WEEK_BEG_DT ORDER BY SUM (t0.PRICE) " but !!! when run sql " SELECT t1.WEEK_BEG_DT FROM "DEFAULT".KYLIN_SALES AS t0 INNER JOIN "DEFAULT".KYLIN_CAL_DT AS t1 ON t0.PART_DT = t1.CAL_DT GROUP BY t1.WEEK_BEG_DT " it reports Error while executing SQL "SELECT t1.WEEK_BEG_DT FROM "DEFAULT".KYLIN_SALES AS t0 INNER JOIN "DEFAULT".KYLIN_CAL_DT AS t1 ON t0.PART_DT = t1.CAL_DT GROUP BY t1.WEEK_BEG_DT LIMIT 50000": When query with topN, only one metrics is allowed. I'll attach kylin_sales_cube_desc_TOPN.json for "kylin_sales_cube" you can run bin/sample.sh -- This message was sent by Atlassian JIRA (v6.3.4#6332)