[DRILL-537] Reading from hive fails with nullpointerexception for certain values/types

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Ramana Inukonda Nagaraj
• Created: 17/Apr/14 18:24
• Updated: 12/Jun/14 16:47
• Resolved: 12/Jun/14 16:47

Description

hive> desc alldrilltypes;
OK
c1 int None
c2 boolean None
c3 double None
c4 string None
c9 tinyint None
c10 smallint None
c11 float None
c12 bigint None
c19 binary None

hive> select * from alldrilltypes;
OK
NULL NULL NULL NULL NULL NULL NULL NULL NULL
-1 false -1.1 -1 -1 -1.0 -1 NULL
1 true 1.1 1 1 1 1.0 1 abcd
Time taken: 0.333 seconds, Fetched: 3 row(s)

Now from Drill:

SELECT c1,c2,c3,c4,c9,c10,c11,c12,c19 from alldrilltypes;

Lilith log capture:

java.lang.NullPointerException
org.apache.drill.exec.store.hive.HiveRecordReader.setValue(HiveRecordReader.java:394) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.store.hive.HiveRecordReader.next(HiveRecordReader.java:446) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:94) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:42) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.next(ScreenCreator.java:85) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:83) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]