i opened a ticket for this: https://issues.apache.org/jira/browse/KYLIN-833
however please do not expect it to be fixed in v0.6 or v0.7 On Tue, Jun 16, 2015 at 2:51 PM, Tao Wong <[email protected]> wrote: > 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 ? > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
