[
https://issues.apache.org/jira/browse/KYLIN-833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14939297#comment-14939297
]
liyang commented on KYLIN-833:
------------------------------
"Group By" is required for Kylin to return correct result. But we do want to
produce more meaningful result without a group by...
> kylin behave abnormally when there's no groupby
> -----------------------------------------------
>
> Key: KYLIN-833
> URL: https://issues.apache.org/jira/browse/KYLIN-833
> Project: Kylin
> Issue Type: Bug
> Reporter: hongbin ma
> Assignee: hongbin ma
>
> when i execute the following sql in kylin :
> SELECT LOOKUP_1.COLUMN_1_NAME
> FROM USER_FACT as FACT_TABLE
> INNER JOIN DIM_PHONE as LOOKUP_1
> ON FACT_TABLE.COLUMN_1_ID = LOOKUP_1.COLUMN_1_ID AND
> FACT_TABLE.COLUMN_2_ID = LOOKUP_1.COLUMN_2_ID ;
> it returns with only one row.
> but when i add DISTINCT after SELECT
> it returns many rows (which is correct!)
> has anyone encounter this ?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
