[DRILL-6134] Many Drill queries fail with type mismatch when using JDBC Driver from Simba

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.13.0
• Assignee: Pritesh Maker
• Reporter: Robert Hou
• Created: 05/Feb/18 07:59
• Updated: 08/Mar/18 22:59

Description

Here is an example:

Query: /root/drillAutomation/framework-master/framework/resources/Functional/limit0/union/data/union_51.q

(SELECT c2 FROM `union_01_v` ORDER BY c5 DESC nulls first) UNION (SELECT c2 FROM `union_02_v` ORDER BY c5 ASC nulls first)

This is the error:

Exception:

java.sql.SQLException: [JDBC Driver]The field c2(BIGINT:OPTIONAL) [$bits$(UINT1:REQUIRED), $values$(BIGINT:OPTIONAL)] doesn't match the provided metadata major_type {
  minor_type: BIGINT
  mode: OPTIONAL
}
name_part {
  name: "$values$"
}
value_count: 18
buffer_length: 144
.
	at com.google.common.base.Preconditions.checkArgument(Preconditions.java:145)
	at org.apache.drill.exec.vector.BigIntVector.load(BigIntVector.java:287)
	at org.apache.drill.exec.vector.NullableBigIntVector.load(NullableBigIntVector.java:274)
	at org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:131)
	at com.mapr.drill.drill.dataengine.DRJDBCResultSet.doLoadRecordBatchData(Unknown Source)
	at com.mapr.drill.drill.dataengine.DRJDBCResultSet.hasMoreRows(Unknown Source)
	at com.mapr.drill.drill.dataengine.DRJDBCResultSet.doMoveToNextRow(Unknown Source)
	at com.mapr.drill.jdbc.common.CommonResultSet.moveToNextRow(Unknown Source)
	at com.mapr.drill.jdbc.common.SForwardResultSet.next(Unknown Source)
	at org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:255)
	at org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:115)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalArgumentException: The field c2(BIGINT:OPTIONAL) [$bits$(UINT1:REQUIRED), $values$(BIGINT:OPTIONAL)] doesn't match the provided metadata major_type {
  minor_type: BIGINT
  mode: OPTIONAL
}
name_part {
  name: "$values$"
}
value_count: 18
buffer_length: 144
.
	... 16 more

 

The commit that causes these errors to occur is:

https://issues.apache.org/jira/browse/DRILL-6049
Rollup of hygiene changes from "batch size" project
commit ID e791ed62b1c91c39676c4adef438c689fd84fd4b