[
https://issues.apache.org/jira/browse/DRILL-4839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15414217#comment-15414217
]
Rahul Challapalli commented on DRILL-4839:
------------------------------------------
This looks just like a regular schema change error. Raised this issue so that a
developer can confirm there is nothing else going on.
> 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
> Attachments: error.log, l_3level.tgz
>
>
> 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)
