[ https://issues.apache.org/jira/browse/DRILL-1169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-1169: ---------------------------------- Issue Type: New Feature (was: Bug) > Simple UNION query fails > ------------------------ > > Key: DRILL-1169 > URL: https://issues.apache.org/jira/browse/DRILL-1169 > Project: Apache Drill > Issue Type: New Feature > Components: Query Planning & Optimization > Environment: Running Drill on MacOSX standalone. > #Sun Jul 20 20:12:53 PDT 2014 > git.commit.id.abbrev=e5c2da0 > Reporter: Bob Rumsby > Fix For: Future > > > A query that selects a compatible column from the same JSON file on either > side of the UNION operator fails. The same query works if UNION ALL is used. > Example of Failure: > 0: jdbc:drill:zk=local> select id from dfs.`/Users/brumsby/drill/donuts.json` > union select id from dfs.`/Users/brumsby/drill/donuts.json`; > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while > running query.[error_id: "dfe76b6b-7eb0-49ee-8084-1e29ea995be0" > endpoint { > address: "10.250.0.28" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > error_type: 0 > message: "Failure while parsing sql. < CannotPlanException:[ Node > [rel#880:Subset#6.PHYSICAL.SINGLETON([]).[]] could not be implemented; > planner state: > ... > Same query with UNION ALL (which works): > 0: jdbc:drill:zk=local> select id from dfs.`/Users/brumsby/drill/donuts.json` > union all select id from dfs.`/Users/brumsby/drill/donuts.json`; > +------------+ > | id | > +------------+ > | 0001 | > | 0001 | > +------------+ > 2 rows selected (0.111 seconds) -- This message was sent by Atlassian JIRA (v6.3.4#6332)