You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/01/03 00:08:34 UTC
[jira] [Updated] (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 ]
Victoria Markman updated DRILL-1923:
------------------------------------
Description:
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}
was:
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}
> 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 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)