[
https://issues.apache.org/jira/browse/DRILL-1923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aman Sinha updated DRILL-1923:
------------------------------
Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha)
> 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)
