Affects Version/s: None
Fix Version/s: None
when i execute the following sql in kylin :
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 ?