[KYLIN-2471] queries with parenthesized sub-clause in JOIN will fail

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v2.0.0
• Assignee: Hongbin Ma
• Reporter: Hongbin Ma
• Created: 25/Feb/17 08:34
• Updated: 24/Jan/18 16:22
• Resolved: 24/Jan/18 16:22

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