[
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)