drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Hou (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-6134) Many Drill queries fail with type mismatch when using JDBC Driver from Simba
Date Mon, 05 Feb 2018 09:44:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-6134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Robert Hou updated DRILL-6134:
------------------------------
    Summary: Many Drill queries fail with type mismatch when using JDBC Driver from Simba
 (was: Many Drill queries fail when using JDBC Driver from Simba)

> Many Drill queries fail with type mismatch when using JDBC Driver from Simba
> ----------------------------------------------------------------------------
>
>                 Key: DRILL-6134
>                 URL: https://issues.apache.org/jira/browse/DRILL-6134
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.13.0
>            Reporter: Robert Hou
>            Assignee: Pritesh Maker
>            Priority: Major
>
> Here is an example:
> Query: /root/drillAutomation/framework-master/framework/resources/Functional/limit0/union/data/union_51.q
> {noformat}
> (SELECT c2 FROM `union_01_v` ORDER BY c5 DESC nulls first) UNION (SELECT c2 FROM `union_02_v`
ORDER BY c5 ASC nulls first){noformat}
> This is the error:
> {noformat}
> Exception:
> java.sql.SQLException: [JDBC Driver]The field c2(BIGINT:OPTIONAL) [$bits$(UINT1:REQUIRED),
$values$(BIGINT:OPTIONAL)] doesn't match the provided metadata major_type {
>   minor_type: BIGINT
>   mode: OPTIONAL
> }
> name_part {
>   name: "$values$"
> }
> value_count: 18
> buffer_length: 144
> .
> 	at com.google.common.base.Preconditions.checkArgument(Preconditions.java:145)
> 	at org.apache.drill.exec.vector.BigIntVector.load(BigIntVector.java:287)
> 	at org.apache.drill.exec.vector.NullableBigIntVector.load(NullableBigIntVector.java:274)
> 	at org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:131)
> 	at com.mapr.drill.drill.dataengine.DRJDBCResultSet.doLoadRecordBatchData(Unknown Source)
> 	at com.mapr.drill.drill.dataengine.DRJDBCResultSet.hasMoreRows(Unknown Source)
> 	at com.mapr.drill.drill.dataengine.DRJDBCResultSet.doMoveToNextRow(Unknown Source)
> 	at com.mapr.drill.jdbc.common.CommonResultSet.moveToNextRow(Unknown Source)
> 	at com.mapr.drill.jdbc.common.SForwardResultSet.next(Unknown Source)
> 	at org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:255)
> 	at org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:115)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:748)
> Caused by: java.lang.IllegalArgumentException: The field c2(BIGINT:OPTIONAL) [$bits$(UINT1:REQUIRED),
$values$(BIGINT:OPTIONAL)] doesn't match the provided metadata major_type {
>   minor_type: BIGINT
>   mode: OPTIONAL
> }
> name_part {
>   name: "$values$"
> }
> value_count: 18
> buffer_length: 144
> .
> 	... 16 more{noformat}
>  
> The commit that causes these errors to occur is:
> {noformat}
> https://issues.apache.org/jira/browse/DRILL-6049
> Rollup of hygiene changes from "batch size" project
> commit ID e791ed62b1c91c39676c4adef438c689fd84fd4b{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message