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)
