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

queries with parenthesized sub-clause in JOIN will fail

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v2.0.0
    • Component/s: None
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: