You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2017/08/09 08:04:00 UTC
[jira] [Closed] (KYLIN-833) when there's no groupby, result could
be better
[ https://issues.apache.org/jira/browse/KYLIN-833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI closed KYLIN-833.
------------------------------
> when there's no groupby, result could be better
> -----------------------------------------------
>
> 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.4.14#64029)