[DRILL-459] Hive source table containing varchar fails in drill

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Ramana Inukonda Nagaraj
• Created: 27/Mar/14 00:56
• Updated: 31/Jul/14 06:32
• Resolved: 29/May/14 17:47

Description

Query a hive table as below

hive> desc nation;
OK
n_nationkey int None
n_name varchar(25) None
n_regionkey int None
n_comment varchar(152) None
Time taken: 1.697 seconds, Fetched: 4 row(s)

0: jdbc:drill:> select * from hive.nation;
message: "Failure while parsing sql. < UnsupportedOperationException:[ Could not determine type ]"

Stacktrace:
java.lang.UnsupportedOperationException: Could not determine type
at org.apache.drill.exec.store.hive.HiveRecordReader.getMajorType(HiveRecordReader.java:374) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.store.hive.HiveRecordReader.setup(HiveRecordReader.java:198) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.physical.impl.ScanBatch.<init>(ScanBatch.java:65) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.store.hive.HiveScanBatchCreator.getBatch(HiveScanBatchCreator.java:69) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.store.hive.HiveScanBatchCreator.getBatch(HiveScanBatchCreator.java:35) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:60) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:37) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:82) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]