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)
