You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/02/25 01:46:05 UTC
[jira] [Created] (DRILL-2301) Query fails when multiple table
aliases are provided for CTEs
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)