Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.7.0
-
None
-
None
Description
git.commit.id.abbrev=ef6e522
When I do a union all between the below 2 queries, I got a number format exception.
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)
I attached the error log and the data set