[ https://issues.apache.org/jira/browse/DRILL-2308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533236#comment-14533236 ]
Abhishek Girish commented on DRILL-2308: ---------------------------------------- Testcase: Functional/Passing/tpcds/bugs/DRILL-2308.sql > Exists co-related sub-query throws CannotPlanException > ------------------------------------------------------ > > Key: DRILL-2308 > URL: https://issues.apache.org/jira/browse/DRILL-2308 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.8.0 > Reporter: Abhishek Girish > Assignee: Abhishek Girish > Fix For: 0.9.0 > > > *The following query fails to plan:* > SELECT Count(*) > FROM customer c > WHERE EXISTS (SELECT * > FROM store_sales ss, > date_dim d > WHERE c.c_customer_sk = ss.ss_customer_sk > AND ss.ss_sold_date_sk = d.d_date_sk); > Query failed: RelOptPlanner.CannotPlanException: Node > [rel#147450:Subset#18.LOGICAL.ANY([]).[]] could not be implemented; planner > state: > Root: rel#147450:Subset#18.LOGICAL.ANY([]).[] > ... > ... -- This message was sent by Atlassian JIRA (v6.3.4#6332)