[KYLIN-833] when there's no groupby, result could be better

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Assignee: Hongbin Ma
• Reporter: Hongbin Ma
• Created: 17/Jun/15 01:57
• Updated: 09/Aug/17 08:03
• Resolved: 20/Oct/15 08:09

Description

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 ?

Issue Links

• duplicates: KYLIN-1075 select [MeasureCol] from [FactTbl] is not supported