[KYLIN-1622] sql not executed and report topN error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.5.2
• Component/s: Query Engine
• Assignee: Shao Feng Shi
• Reporter: Jason Zhong
• Created: 26/Apr/16 08:45
• Updated: 26/May/16 09:16
• Resolved: 27/Apr/16 06:47

Description

pull the latest code from master branch, commit id is d899a67963af14f80fc047a9253ac7736c1983f3,
package and 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