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

queries with parenthesized sub-clause in JOIN will fail

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • v2.0.0
    • None
    • None

    Description

      cognos will generate queries with parenthesized sub-clause in JOIN. for example:

      SELECT "TABLE1"."DIM1_1" "DIM1_1"
             ,"TABLE2"."DIM2_1" "DIM2_1"
             ,SUM("FACT"."M1") "M1"
             ,SUM("FACT"."M2") "M2"
        FROM ("COGNOS"."FACT" "FACT" LEFT OUTER JOIN "COGNOS"."TABLE1"
              "TABLE1" ON "FACT"."FK_1" = "TABLE1"."PK_1")
        LEFT OUTER JOIN "COGNOS"."TABLE2" "TABLE2"
          ON "FACT"."FK_2" = "TABLE2"."PK_2"
       GROUP BY "TABLE2"."DIM2_1"
                ,"TABLE1"."DIM1_1";
      

      as mentioned in https://issues.apache.org/jira/browse/CALCITE-35 such issue is difficult to handle in calcite. We'll leverage IQueryTransformer to remove unnecessary parentheses

      Attachments

        Activity

          People

            mahongbin Hongbin Ma
            mahongbin Hongbin Ma
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: