You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Dmitriy (JIRA)" <ji...@apache.org> on 2015/10/26 10:27:27 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=14973865#comment-14973865 ]
Dmitriy edited comment on DRILL-3968 at 10/26/15 9:27 AM:
----------------------------------------------------------
Here is some examples of queries I try
1) select min(data.ownerAge), max(data.ownerAge) from fs.jsn.`/testData01.json` data
2) select distinct data.firstName from fs.jsn.`/testData01.json` data where data.ownerAge >= 30.0 order by data.firstName asc limit 10
3) select data.firstName, max(data.ownerAge) from fs.jsn.`/testData01.json` data where data.averageIncome >= 100.0 group by data.firstName order by max(data.ownerAge) desc limit 3
When I have running drill 1.0.0 and use in my code driver version 1.2.0 I have error, I printed above. If I run queries from drill web console they works ok (still drill version 1.0.0). If I run drill version 1.2.0 and use in my code driver version 1.2.0 they also works ok. When I have drill 1.0.0 or 1.1.0 and driver version 1.0.0 everything works.
Also I tried very simple query
select * from data.jsn.`testData01.json` limit 5
and have same issue.
was (Author: dimaga):
Here is some examples of queries I try
1) select min(data.ownerAge), max(data.ownerAge) from fs.jsn.`/testData01.json` data
2) select distinct data.firstName from fs.jsn.`/testData01.json` data where data.ownerAge >= 30.0 order by data.firstName asc limit 10
3) select data.firstName, max(data.ownerAge) from fs.jsn.`/testData01.json` data where data.averageIncome >= 100.0 group by data.firstName order by max(data.ownerAge) desc limit 3
When I have running drill 1.0.0 and use in my code driver version 1.2.0 I have error, I printed above. If I run queries from drill web console they works ok (still drill version 1.0.0). If I run drill version 1.2.0 and use in my code driver version 1.2.0 they also works ok. When I have drill 1.0.0 or 1.1.0 and driver version 1.0.0 everything works.
Also I tried very simple query
select * from data.jsn.`testData01.json` limit 5 and have same issue.
> 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.3.4#6332)