You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Nicolas GERARD (JIRA)" <ji...@apache.org> on 2017/06/19 16:03:00 UTC

[jira] [Comment Edited] (DRILL-3968) JDBC driver seems to be not compatible with previous versions of apache drill.

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

Nicolas GERARD edited comment on DRILL-3968 at 6/19/17 4:02 PM:
----------------------------------------------------------------

I got also the same error when trying to connect directly through JDBC with the URL "jdbc:drill:drillbit=localhost".

After some search and try, I found that the problem was related with this issue:
https://issues.apache.org/jira/browse/DRILL-5101

I performed as advised:
mkdir %userprofile%\drill
mkdir %userprofile%\drill\udf
mkdir %userprofile%\drill\udf\registry
mkdir %userprofile%\drill\udf\tmp
mkdir %userprofile%\drill\udf\staging
takeown /R /F %userprofile%\drill 

And my error was gone.

Work on version 1.10.0


was (Author: gerardnico):
I got also the same error when trying to connect directly through JDBC with the URL "jdbc:drill:drillbit=localhost".

After some search and try, I found that the problem was related with this issue:
https://issues.apache.org/jira/browse/DRILL-5101

I performed as advised:
mkdir %userprofile%\drill
mkdir %userprofile%\drill\udf
mkdir %userprofile%\drill\udf\registry
mkdir %userprofile%\drill\udf\tmp
mkdir %userprofile%\drill\udf\staging
takeown /R /F %userprofile%\drill 

And my error was gone.

> JDBC driver seems to be not compatible with previous versions of apache drill.
> ------------------------------------------------------------------------------
>
>                 Key: DRILL-3968
>                 URL: https://issues.apache.org/jira/browse/DRILL-3968
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Dmitriy
>
> When try to execute query using jdbc-driver-all version 1.2.0 to environment with drill 1.0.0 or 1.1.0  I have the following exception
> Exception in thread "main" java.sql.SQLException: Unexpected RuntimeException: java.lang.IndexOutOfBoundsException: Index: 0
> 	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:261)
> 	at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:290)
> 	at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1359)
> 	at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:74)
> 	at oadd.net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
> 	at oadd.net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351)
> 	at oadd.net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:78)
> 	at org.apache.drill.jdbc.impl.DrillStatementImpl.executeQuery(DrillStatementImpl.java:97)
> 	at TestNewDriver.test(TestNewDriver.java:24)
> 	at TestNewDriver.main(TestNewDriver.java:17)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:497)
> 	at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)
> Caused by: java.lang.IndexOutOfBoundsException: Index: 0
> 	at java.util.Collections$EmptyList.get(Collections.java:4454)
> 	at oadd.org.apache.drill.exec.proto.UserBitShared$SerializedField.getChild(UserBitShared.java:8390)
> 	at oadd.org.apache.drill.exec.vector.NullableVarCharVector.load(NullableVarCharVector.java:258)
> 	at oadd.org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:102)
> 	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:223)
> 	... 14 more



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)