drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4839) NumberFormatException with union all when a column on one side contains all nulls
Date Tue, 09 Aug 2016 20:47:20 GMT
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)

Mime
View raw message