afaik, kylin might behave abnormally when there's no group by in the query.(because query runtime is getting results from pre-aggregated data in HBASE)
try modify your query with a group by 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 ? > > > Thanks > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
