[jira] [Created] (KYLIN-2471) queries with parenthesized sub-clause in JOIN will fail

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

hongbin ma created KYLIN-2471:
---------------------------------

             Summary: queries with parenthesized sub-clause in JOIN will fail
                 Key: KYLIN-2471
                 URL: https://issues.apache.org/jira/browse/KYLIN-2471
             Project: Kylin
          Issue Type: Bug
            Reporter: hongbin ma
            Assignee: hongbin ma


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

{code}
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";
{code}

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 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)