Kunal Khatua created DRILL-6216: ----------------------------------- Summary: Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver Key: DRILL-6216 URL: https://issues.apache.org/jira/browse/DRILL-6216 Project: Apache Drill Issue Type: Bug Affects Versions: 1.13.0 Reporter: Kunal Khatua Assignee: Sorabh Hamirwasia Fix For: 1.13.0
When running against a 1.12.0 Drill server {code:sql} select * from sys.`options`; {code} I hit the following issue in Squirrel-SQL client with the 1.13.0-SNAPSHOT JDBC driver. {code:java} 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 {code} This issue however, doesn't exist when working with Apache Master 1.13.0-SNAPSHOT -- This message was sent by Atlassian JIRA (v7.6.3#76005)