[DRILL-6216] Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.13.0
• Component/s: Client - JDBC
• Assignee: Sorabh Hamirwasia
• Reporter: Kunal Khatua
• Reviewer: Aman Sinha
• Created: 06/Mar/18 23:52
• Updated: 20/Mar/18 18:04
• Resolved: 09/Mar/18 05:31

Description

When running against a 1.12.0 Drill server

 select * from sys.`options`;

I hit the following issue in Squirrel-SQL client with the 1.13.0-SNAPSHOT JDBC driver.

2018-02-20 11:41:16,557 [Thread-2] DEBUG net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter  - Error
java.sql.SQLException: Unexpected RuntimeException: java.lang.IllegalArgumentException: The field [`$values$` (BIGINT:OPTIONAL)] doesn't match the provided metadata major_type {
  minor_type: BIGINT
  mode: OPTIONAL
}
name_part {
  name: "num_val"
}
value_count: 153
buffer_length: 1224
.
	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:544)
	at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:602)
	at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1918)
	at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:66)
	at oadd.org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:630)
	at org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1106)
	at org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1117)
	at oadd.org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:638)
	at org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:193)
	at oadd.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149)
	at oadd.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:209)
	at org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
	at net.sourceforge.squirrel_sql.client.session.StatementWrapper.execute(StatementWrapper.java:165)
	at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:378)
	at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:221)
	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalArgumentException: The field [`$values$` (BIGINT:OPTIONAL)] doesn't match the provided metadata major_type {
  minor_type: BIGINT
  mode: OPTIONAL
}
name_part {
  name: "num_val"
}
value_count: 153
buffer_length: 1224
.
	at oadd.com.google.common.base.Preconditions.checkArgument(Preconditions.java:145)
	at oadd.org.apache.drill.exec.vector.BigIntVector.load(BigIntVector.java:299)
	at oadd.org.apache.drill.exec.vector.NullableBigIntVector.load(NullableBigIntVector.java:295)
	at oadd.org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:135)
	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:506)
	... 16 more

This issue however, doesn't exist when working with Apache Master 1.13.0-SNAPSHOT

Issue Links

• links to: GitHub Pull Request #1157