[ 
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16388779#comment-16388779
 ] 

Abhishek Girish commented on DRILL-6216:
----------------------------------------

{code:java}

java.sql.SQLException: Unexpected RuntimeException: 
java.lang.IllegalArgumentException: The field L_QUANTITY(FLOAT8:OPTIONAL) 
[$bits$(UINT1:REQUIRED), $values$(FLOAT8:OPTIONAL)] doesn't match the provided 
metadata major_type {

  minor_type: FLOAT8

  mode: OPTIONAL

}

name_part {

  name: "$values$"

}

value_count: 1

buffer_length: 8

.

  at 
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:503)

  at org.apache.drill.jdbc.impl.DrillCursor.next(DrillCursor.java:593)

  at 
oadd.org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:215)

  at 
org.apache.drill.jdbc.impl.DrillResultSetImpl.next(DrillResultSetImpl.java:140)

  at 
org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:246)

  at org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:114)

  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

  at java.util.concurrent.FutureTask.run(FutureTask.java:266)

  at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

  at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

  at java.lang.Thread.run(Thread.java:748)

Caused by: java.lang.IllegalArgumentException: The field 
L_QUANTITY(FLOAT8:OPTIONAL) [$bits$(UINT1:REQUIRED), $values$(FLOAT8:OPTIONAL)] 
doesn't match the provided metadata major_type {

  minor_type: FLOAT8

  mode: OPTIONAL

}

name_part {

  name: "$values$"

}

value_count: 1

buffer_length: 8

.

  at 
oadd.com.google.common.base.Preconditions.checkArgument(Preconditions.java:145)

  at oadd.org.apache.drill.exec.vector.Float8Vector.load(Float8Vector.java:293)

  at 
oadd.org.apache.drill.exec.vector.NullableFloat8Vector.load(NullableFloat8Vector.java:235)

  at 
oadd.org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:131)

  at 
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:465)

  ... 10 more{code}

> 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
>          Components: Client - JDBC
>    Affects Versions: 1.13.0
>            Reporter: Kunal Khatua
>            Assignee: Sorabh Hamirwasia
>            Priority: Blocker
>             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)

Reply via email to