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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.13.0
    • 1.13.0
    • Client - JDBC
    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment