[jira] [Created] (KYLIN-833) kylin behave abnormally when there's no groupby

["hongbin ma (JIRA)" <ji...@apache.org>]

hongbin ma created KYLIN-833:
--------------------------------

             Summary: kylin behave abnormally when there's no groupby
                 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.3.4#6332)