[
https://issues.apache.org/jira/browse/KYLIN-1075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15057259#comment-15057259
]
Dong Li edited comment on KYLIN-1075 at 12/15/15 3:16 AM:
----------------------------------------------------------
Synced with Lola. This is by-design, we didn't store raw data, 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.
was (Author: lidong_sjtu):
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)
