[
https://issues.apache.org/jira/browse/KYLIN-1075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dong Li updated KYLIN-1075:
---------------------------
Comment: was deleted
(was: Synced with Lola. This is by-design, we didn't store by-design, so we use
SUM aggregation to display value for measure for better look of result.
This JIRA is work-around to return better look of result rather of immediate
exceptions, which might be stopper in some client software.)
> select [MeasureCol] from [FactTbl] is not supported
> ---------------------------------------------------
>
> Key: KYLIN-1075
> URL: https://issues.apache.org/jira/browse/KYLIN-1075
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Reporter: Dong Li
> Assignee: Dong Li
> Priority: Minor
> Labels: QE
> Fix For: v2.0, v1.3
>
> Attachments:
> 1.x-KYLIN-1075-select-MeasureCol-from-FactTbl-is-not-sup.patch,
> 2.x-KYLIN-1075-select-MeasureCol-from-FactTbl-is-not-sup.patch
>
>
> Input SQL:
> select item_count from test_kylin_fact
> Output exception:
> Column DEFAULT.TEST_KYLIN_FACT.ITEM_COUNT does not exist in row key desc
> while executing SQL: "select item_count from test_kylin_fact LIMIT 50000"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
