Rahul Challapalli created DRILL-4076:
----------------------------------------
Summary: Unlike hive drill treats _HIVE_DEFAULT_PARTITION_ as a
null value
Key: DRILL-4076
URL: https://issues.apache.org/jira/browse/DRILL-4076
Project: Apache Drill
Issue Type: Bug
Components: Storage - Hive
Affects Versions: 1.3.0
Reporter: Rahul Challapalli
Priority: Critical
git.commit.id.abbrev=e78e286
Query From Drill :
{code}
select * from hive.empty_lengthy_p where varchar_col is null;
+----------+--------------+
| int_col | varchar_col |
+----------+--------------+
| 3 | null |
| 5 | null |
| 6 | null |
+----------+--------------+
{code}
The same query from hive returns an empty data set.
Dump of whole table from hive :
{code}
select * from empty_lengthy_p;
OK
3 __HIVE_DEFAULT_PARTITION__
5 __HIVE_DEFAULT_PARTITION__
6 __HIVE_DEFAULT_PARTITION__
1 dhfawriuueiq dshfjklhfiue eiufhwelfhleiruhj ejfwekjlf hsjdkgfhsdjk hjd
hdfkh sdhg dkj hsdhg jds gsdlgd sd hjk sdjhkjdhgsdhg
2 jkdshgf jhg sdgj dlsg jsdgjg jkdhgiergergd fgjgioug8945u
irjfoiej0930j pofkqpgogogj dogj09g djvkldsjgjgirewoie dkflvsd
vkdvskgjiwegjwe;sdkvjsdgfdgksdjgkdjkdjgksjg sdkjgdsjg skdjggj;sdgjd sk;gjsd
7 jkdshgf jhg sdgj dlsg jsdgjg jkdhgiergergd fgjgioug8945u
irjfoiej0930j pofkqpgogogj dogj09g djvkldsjgjgirewoie dkflvsd
vkdvskgjiwegjwe;sdkvjsdgfdgksdjgkdjkdjgksjg sdkjgdsjg skdjggj;sdgjd sk;gjsd
4 sdjklhkhjdfgjhdfgkjhdfkjldfsgjdsfkjhdfmnb,cv
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
