Abhishek Girish created DRILL-2301:
--------------------------------------
Summary: Query fails when multiple table aliases are provided for
CTEs
Key: DRILL-2301
URL: https://issues.apache.org/jira/browse/DRILL-2301
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 0.8.0
Reporter: Abhishek Girish
Assignee: Jinfeng Ni
When a query contains a WITH clause which defines Common Table Expressions
(CTEs), a second alias for the same the temporary table cannot be provided.
*The following query fails to validate:*
WITH C AS
(
SELECT c_customer_id cid
FROM customer
GROUP BY c_customer_id )
SELECT c2.cid
FROM C c1,
C c2
WHERE c2.cid = c1.cid
ORDER BY c2.cid limit 10;
Query failed: SqlValidatorException: Table 'c2' not found
The above query validates and executes successfully on Postgres.
When the WITH clause is removed, the query succeeds.
*The following query executes fine:*
SELECT c2.c_customer_id
FROM customer c1,
customer c2
WHERE c2.c_customer_id = c1.c_customer_id
ORDER BY c2.c_customer_id limit 10;
Logs attached.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
