Rahul Challapalli created DRILL-4839:
----------------------------------------
Summary: NumberFormatException with union all when a column on one
side contains all nulls
Key: DRILL-4839
URL: https://issues.apache.org/jira/browse/DRILL-4839
Project: Apache Drill
Issue Type: Bug
Components: Execution - Relational Operators
Affects Versions: 1.7.0
Reporter: Rahul Challapalli
git.commit.id.abbrev=ef6e522
When I do a union all between the below 2 queries, I got a number format
exception.
{code}
select l_orderkey, dir0 from `l_3level/1/one` where l_discount > 0.05 limit 5;
+-------------+------------+
| l_orderkey | dir0 |
+-------------+------------+
| 1 | 2015-7-13 |
| 1 | 2015-7-13 |
| 1 | 2015-7-13 |
| 1 | 2015-7-13 |
| 3 | 2015-7-13 |
+-------------+------------+
5 rows selected (0.313 seconds)
0: jdbc:drill:zk=10.10.100.190:5181> select l_orderkey, dir0 from
`l_3level/1/one/2015-7-12`;
+-------------+-------+
| l_orderkey | dir0 |
+-------------+-------+
| 1 | null |
| 1 | null |
| 1 | null |
| 1 | null |
| 1 | null |
| 1 | null |
| 2 | null |
| 3 | null |
| 3 | null |
| 3 | null |
+-------------+-------+
10 rows selected (0.25 seconds)
{code}
I attached the error log and the data set
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
