You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/11/12 02:50:10 UTC
[jira] [Created] (DRILL-4076) Unlike hive drill treats
_HIVE_DEFAULT_PARTITION_ as a null value
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)