[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16395696#comment-16395696
]
Boaz Ben-Zvi commented on DRILL-6216:
-
Merged with commit ID - b4a783a0b0fb334134fa00411cb4b910c05baa05
> 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
> Labels: ready-to-commit
> 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)
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16392437#comment-16392437
]
ASF GitHub Bot commented on DRILL-6216:
---
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/1157
> 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
> Labels: ready-to-commit
> 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)
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390485#comment-16390485
]
ASF GitHub Bot commented on DRILL-6216:
---
Github user amansinha100 commented on the issue:
https://github.com/apache/drill/pull/1157
+1
> 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)
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390422#comment-16390422
]
ASF GitHub Bot commented on DRILL-6216:
---
GitHub user sohami opened a pull request:
https://github.com/apache/drill/pull/1157
DRILL-6216: Metadata mismatch when connecting to a Drill 1.12.0 with …
…a Drill-1.13.0-SNAPSHOT driver
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sohami/drill DRILL-6216
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/1157.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1157
commit fddde494554e74ff4f3fba89f2916900e4e2f917
Author: Sorabh Hamirwasia
Date: 2018-03-07T20:06:32Z
DRILL-6216: Metadata mismatch when connecting to a Drill 1.12.0 with a
Drill-1.13.0-SNAPSHOT driver
> 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)
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390071#comment-16390071
]
Sorabh Hamirwasia commented on DRILL-6216:
--
Based on above analysis and discussion on Dev list ([1.13 - Release Blocker] -
DRILL-6216: Metadata mismatch when connecting to a Drill 1.12.0 with a
Drill-1.13.0-SNAPSHOT driver), we have decided to revert just the name change
for 1.13 release.
> 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)
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390069#comment-16390069
]
Sorabh Hamirwasia commented on DRILL-6216:
--
Hi All,
The root cause for DRILL-6216 is due to a recent change made as part
of[https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_DRILL-2D6049&d=DwIFAw&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=YvCUBRsPY3EVX3oqGKDhUhKNuvrmpt37EuaRNYLIxlE&s=oeEFw22PxBEEd6WyfpzeD5v-oi_PsD2SaoR1SDO-RKw&e=].
With this PR a default field name for values ValueVector inside any
NullableValueVector was introduced which is $values$ [1]. Before this PR the
values ValueVector field name was same as the field name of actual
NullableValueVector holding it [2]. In the load method of certain ValueVectors
like BigIntVector there is an equality check for the ValueVector field name and
metadata.name_part name [3].
In setup where Drillbit and DrillClient are running in different version
(between 1.12 and 1.13) the equality check in load method will fail. For
example: When server is running 1.13 and client is on 1.12, in that case the
record batch from server side will come with NullableValueVector (NV1 with
field name as num_val) but with it's values ValueVector field name as $values$.
When on client side corresponding NullableValueVector (NV2) is created it will
use the actual field name (num_val) for values ValueVector. After calling load
on received NullableValueVector NV2 with metadata information from server that
internally alls load on values ValueVector and the check fails since ($values$
!= num_val).
Since the change is in template of ValueVector, to fix this issue both client
and server needs to identify their respective version on which they are running
and choose the field name for values ValueVector correspondingly. Given
DRILL-6049 touches huge sets of files I am also not sure what are the other
impacts with it. It would be great to discuss on how we should proceed with
this issue before making any further change.
[1]:
[https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_master_exec_vector_src_main_java_org_apache_drill_exec_vector_ValueVector.java-23L92&d=DwIFAw&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=YvCUBRsPY3EVX3oqGKDhUhKNuvrmpt37EuaRNYLIxlE&s=gjEcDbuGniihjh_1RdQEpGJ9eboKsgPPTJkH8_OCytU&e=]
[https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_master_exec_vector_src_main_codegen_templates_NullableValueVectors.java-23L82&d=DwIFAw&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=YvCUBRsPY3EVX3oqGKDhUhKNuvrmpt37EuaRNYLIxlE&s=miSD59RRvY6njdKTyLSf5q8U4S51NcxY3IulJGonSxw&e=]
[2]:https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_1.12.0_exec_vector_src_main_codegen_templates_NullableValueVectors.java-23L70&d=DwIFAw&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=YvCUBRsPY3EVX3oqGKDhUhKNuvrmpt37EuaRNYLIxlE&s=3VokpAZoZGSvcdfIU23QuigGGKHPPupiCcLpxDxeP84&e=
[3]:
[https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_1.12.0_exec_vector_src_main_codegen_templates_FixedValueVectors.java-23L238&d=DwIFAw&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=YvCUBRsPY3EVX3oqGKDhUhKNuvrmpt37EuaRNYLIxlE&s=-UDZrABPkMkRiAURufI-oT2AepfOHC9d5v-OXH64sHo&e=]
> 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.execu
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
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)
>
[jira] [Commented] (DRILL-6216) Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
[
https://issues.apache.org/jira/browse/DRILL-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16388756#comment-16388756
]
Abhishek Girish commented on DRILL-6216:
Also seems to be an issue when the Server is new (1.13.0-SNAPSHOT) and client
is older (1.12.0)
> 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)
