[ 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)