You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/03/10 18:19:38 UTC
[jira] [Resolved] (DRILL-1923) Unexpected exception when one column
of a leg of a UNION ALL is a numeric constant
[ https://issues.apache.org/jira/browse/DRILL-1923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu resolved DRILL-1923.
--------------------------------------
Resolution: Fixed
Resolved in commit #: 0368adf0c
> Unexpected exception when one column of a leg of a UNION ALL is a numeric constant
> ----------------------------------------------------------------------------------
>
> Key: DRILL-1923
> URL: https://issues.apache.org/jira/browse/DRILL-1923
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 0.8.0
> Reporter: Victoria Markman
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 0.9.0
>
>
> t.json:
> {code}
> {"a1": 0, "b1": 0, "c1": "true" }
> {"a1": 0, "b1": 0, "c1": "false" }
> {"a1": 0, "b1": 0, "c1": "false" }
> {"a1": 1, "b1": 1, "c1": "true" }
> {"a1": 1, "b1": 1, "c1": "true" }
> {code}
> {code}
> select a1, b1, c1 from `t.json` union all select 1, b1, 'abc' from `t.json`;
> Query failed: Query failed: Unexpected exception during fragment initialization: Node [rel#518297:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state:
> select a1, b1, c1 from `t.json` union all select a1, 1, 'abc' from `t.json`;
> Query failed: Query failed: Unexpected exception during fragment initialization: Node [rel#518297:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state:
> {code}
> It seems to work when column is a string literal
> {code}
> 0: jdbc:drill:schema=dfs> select a1, b1, c1 from `t.json` union all select a1, b1, 'abc' from `t.json`;
> +------------+------------+------------+
> | a1 | b1 | c1 |
> +------------+------------+------------+
> | 0 | 0 | true |
> | 0 | 0 | false |
> | 0 | 0 | false |
> | 1 | 1 | true |
> | 1 | 1 | true |
> | 0 | 0 | abc |
> | 0 | 0 | abc |
> | 0 | 0 | abc |
> | 1 | 1 | abc |
> | 1 | 1 | abc |
> +------------+------------+------------+
> 10 rows selected (0.087 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)