Hey I've seen this issue when using an incompatible JDBC jar - for example, using 1.2 jar and a 1.1 Drill-bit. This was with a JDBC program. Can you make sure you are using the same version of JDBC JAR shipped with the Drill?
On Mon, Oct 5, 2015 at 8:55 AM, Nikunj Thakkar <[email protected]> wrote: > Nope, Same query works fine on sqlline and in v1.1.0 release too. The > issue is V1.1.0 doesn't support prepared statement so I thought if current > build is supporting it, I will use it. But I'm encountering whole new > issues here. > > > On Monday 05 October 2015 09:17 PM, Abdel Hakim Deneche wrote: > >> Hey Nikunj, >> >> Do you get an error if you run the same query in sqlline ? >> >> Thanks >> >> On Mon, Oct 5, 2015 at 7:26 AM, Boris Chmiel <[email protected] >> .invalid >> >>> wrote: >>> Hi NikunjNo idea about the meaning this error. I has encountered it many >>> times I found a workaround to get rid of it by changing my request >>> (usually >>> split it into 2 sub-queries)Good luck >>> >>> >>> >>> Le Lundi 5 octobre 2015 12h57, Nikunj Thakkar < >>> [email protected]> a écrit : >>> >>> >>> Hi, >>> >>> >>> I'm executing simple statement in current master branch of drill. Getting >>> following exceptions: >>> >>> 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 >>> >>> >>> net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404) >>> at >>> >>> >>> net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351) >>> at >>> >>> >>> net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:78) >>> at >>> >>> >>> org.apache.drill.jdbc.impl.DrillStatementImpl.executeQuery(DrillStatementImpl.java:97) >>> at org.apache.drill.jdbc.SampleTest.setup(SampleTest.java:21) >>> at org.apache.drill.jdbc.SampleTest.testSample(SampleTest.java:29) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> >>> >>> com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:78) >>> at >>> >>> >>> com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:212) >>> at >>> com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:68) >>> at >>> com.intellij.rt.execution.application.AppMain.main(AppMain.java:140) >>> Caused by: java.lang.IndexOutOfBoundsException: Index: 0 >>> at java.util.Collections$EmptyList.get(Collections.java:4454) >>> at >>> >>> >>> org.apache.drill.exec.proto.UserBitShared$SerializedField.getChild(UserBitShared.java:8390) >>> at >>> org.apache.drill.exec.vector.VarCharVector.load(VarCharVector.java:184) >>> at >>> >>> >>> org.apache.drill.exec.vector.complex.BaseRepeatedValueVector.load(BaseRepeatedValueVector.java:161) >>> at >>> >>> >>> org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:102) >>> at >>> >>> >>> org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:223) >>> ... 19 more >>> >>> Code: >>> >>> Class.forName("org.apache.drill.jdbc.Driver"); >>> Connection connection = >>> >>> >>> DriverManager.getConnection("jdbc:drill:zk=<my_zookepper_url>:2181/drill/drillbits1"); >>> Statement st = connection.createStatement(); >>> ResultSet rs = st.executeQuery("select * from hdfs.`/test/example.csv` >>> limit 10"); >>> while (rs.next()) { >>> System.out.println(rs.getString(1)); >>> } >>> >>> Any help would be appreciated. >>> >>> Thanks, >>> Nikunj >>> >>> >>> >>> >>> >> >> > < > http://www.quotesdaddy.com/quote/242378/dave-checkett/success-builds-character-failure-reveals-it> > > >
