drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jinfeng Ni <jinfengn...@gmail.com>
Subject How to load data in Drill
Date Mon, 02 Dec 2013 06:34:00 GMT
Hi Tom and Madhu,

Regarding the NullPointerException you encountered when you run the query
in sqlline:

SELECT * FROM some_parquet_file;

Could you please post some debug log in the sqlline's log?  If you use
sqlline in drill's binary distribution, sqlline's log would be in
/var/log/drill/sqlline.log.  Please search keyword "FragmentRunner" and
"Caught exception".  The sqlline.log should contain a call stack when the
NullPointerException is threw.  For instance, here is the log for an
IndexOutBoundaryException in my sqlline.log:

21:44:40.984 [WorkManager-4] DEBUG o.a.drill.exec.work.FragmentRunner -
Caught exception while running fragment
java.lang.IndexOutOfBoundsException: index: 31999268, length: 4 (expected:
range(0, 4194244))
        at
io.netty.buffer.AbstractByteBuf.checkIndex(AbstractByteBuf.java:1130)
~[netty-buffer-4.0.7.Final.jar:na]
        at io.netty.buffer.AbstractByteBuf.getInt(AbstractByteBuf.java:378)
~[netty-buffer-4.0.7.Final.jar:na]
        at
org.apache.drill.exec.vector.UInt4Vector$Accessor.get(UInt4Vector.java:188)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.vector.VarBinaryVector$Mutator.setValueCount(VarBinaryVector.java:355)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch.doWork(RemovingRecordBatch.java:92)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:63)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:42)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:42)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.physical.impl.limit.LimitRecordBatch.next(LimitRecordBatch.java:89)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:42)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.next(ScreenCreator.java:77)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
org.apache.drill.exec.work.FragmentRunner.run(FragmentRunner.java:79)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
        at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
21:44:40.990 [WorkManager-4] ERROR o.a.d.e.w.AbstractFragmentRunnerListener
- Error c8efdbf1-9a6f-427c-ab90-ce16002904af: Failure while running
fragment.

I need the call stack when the NPE is threw, to see what went wrong for
your query.

The call stack that you posted (started from

org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)
) is when the Query Result Lister detects

an exception has been threw.

Thanks!

Jinfeng

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message