[
https://issues.apache.org/jira/browse/KYLIN-1622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong,Jason updated KYLIN-1622:
-------------------------------
Attachment: kylin_sales_cube_desc_TOPN.json
> 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
> Attachments: kylin_sales_cube_desc_TOPN.json
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
