Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6216

Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.13.0
    • Fix Version/s: 1.13.0
    • Component/s: Client - JDBC
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shamirwasia Sorabh Hamirwasia
                Reporter:
                kkhatua Kunal Khatua
                Reviewer:
                Aman Sinha
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: