Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-833

when there's no groupby, result could be better

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      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 ?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mahongbin Hongbin Ma
                Reporter:
                mahongbin Hongbin Ma
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: