[jira] [Created] (DRILL-4839) NumberFormatException with union all when a column on one side contains all nulls

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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)