You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/01/03 00:01:34 UTC
[jira] [Created] (DRILL-1923) Unexpected exception when one column
of a leg of a UNION ALL is a numeric constant
Victoria Markman created DRILL-1923:
---------------------------------------
Summary: 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 - Operators
Affects Versions: 0.8.0
Reporter: Victoria Markman
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 it 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)