[
https://issues.apache.org/jira/browse/KYLIN-2471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Billy Liu resolved KYLIN-2471.
------------------------------
Resolution: Fixed
Fix Version/s: v2.0.0
Commit:
https://git1-us-west.apache.org/repos/asf?p=kylin.git;a=commit;h=d4dc6ee0
> 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
> Priority: Major
> Fix For: v2.0.0
>
>
> 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
(v7.6.3#76005)
