Hi Sungwook, Can you please confirm whether you are querying against a HBase table, or a JSON file? The error log you posted seems to show that a JSONRecordReader is used.
org.apache.drill.exec.vector.complex.fn.JsonReader.write( JsonReader.java:155) ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] at org.apache.drill.exec.store.easy.json.*JSONRecordReader*. next(JSONRecordReader.java:113) On Mon, Dec 29, 2014 at 3:43 PM, Jacques Nadeau <[email protected]> wrote: > That seems strange. As far I remember, HBase only returns VARBINARY > values. > > On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <[email protected]> wrote: > > > This might be related to heterogeneous type. I could re-create the > similar > > error with the following sample JSON file, which consist of a column "a" > > with both float8 and varchar type. > > > > {"a" : 12.3} > > {"a": "56.7"} > > > > 0: jdbc:drill:zk=local> select * from > > dfs.`/Users/jni/work/data/json/input5.json`; > > Query failed: Query stopped., You tried to write a VarChar type when you > > are using a ValueWriter of type NullableFloat8WriterImpl. [ > > c19bf527-60b3-42a9-8b9f-459f1d20ef95 on 192.168.168.92:31010 ] > > > > Please check if the data contains heterogeneous type, as Drill currently > > does not support it. > > > > > > On Mon, Dec 29, 2014 at 1:21 PM, Sungwook Yoon <[email protected]> > wrote: > > > > > Hi > > > > > > I am trying drill 0.70 > > > Trying to access simple maprdb table issuing select * from table limit > 5; > > > I hit this error. > > > > > > Attaching a snippets of the drillbit.log > > > > > > Let me know if you have any tips. > > > > > > Thanks, > > > > > > Sungwook > > > > > > > > > 2014-12-29 20:27:04,496 [UserServer-1] INFO > > > o.a.drill.exec.rpc.user.UserServer - Channel closed between local > > > 0.0.0.0/0.0.0.0:31010 and remote /10.172.11.229:59939 > > > 2014-12-29 20:27:04,507 [2b5e46e7-c1c0-826c-27f4-9de12238b4fc:frag:0:0] > > > ERROR o.a.drill.exec.work.foreman.Foreman - Error > > > 2c44016f-06fb-4aae-a405-96668f9a69ad: Query failed: Failure while > running > > > fragment., You tried to write a VarChar type when you are using a > > > ValueWriter of type NullableFloat8WriterImpl. [ > > > f0c05517-5182-4f6e-90cf-d2901dc33109 on cvcv4hdp1001:31010 ] > > > [ f0c05517-5182-4f6e-90cf-d2901dc33109 on cvcv4hdp1001:31010 ] > > > > > > org.apache.drill.exec.rpc.RemoteRpcException: Failure while running > > > fragment., You tried to write a VarChar type when you are using a > > > ValueWriter of type NullableFloat8WriterImpl. [ > > > f0c05517-5182-4f6e-90cf-d2901dc33109 on cvcv4hdp1001:31010 ] > > > [ f0c05517-5182-4f6e-90cf-d2901dc33109 on cvcv4hdp1001:31010 ] > > > > > > at > > > > > > > > > org.apache.drill.exec.work.foreman.QueryManager.statusUpdate(QueryManager.java:93) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.foreman.QueryManager$RootStatusReporter.statusChange(QueryManager.java:151) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:113) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:109) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.FragmentExecutor.internalFail(FragmentExecutor.java:166) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.foreman.QueryManager.statusUpdate(QueryManager.java:93) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.foreman.QueryManager$RootStatusReporter.statusChange(QueryManager.java:151) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:113) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:109) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.FragmentExecutor.internalFail(FragmentExecutor.java:166) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:116) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > > [na:1.7.0_55] > > > at > > > > > > > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > > [na:1.7.0_55] > > > at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] > > > 2014-12-29 20:27:04,508 [2b5e46e7-c1c0-826c-27f4-9de12238b4fc:frag:0:0] > > > WARN o.a.d.e.p.impl.SendingAccountor - Failure while waiting for send > > > complete. > > > java.lang.InterruptedException: null > > > at > > > > > > > > > java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(AbstractQueuedSynchronizer.java:1301) > > > ~[na:1.7.0_55] > > > at java.util.concurrent.Semaphore.acquire(Semaphore.java:472) > > > ~[na:1.7.0_55] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.SendingAccountor.waitForSendComplete(SendingAccountor.java:44) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.stop(ScreenCreator.java:186) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.FragmentExecutor.closeOutResources(FragmentExecutor.java:144) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:117) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > > [na:1.7.0_55] > > > at > > > > > > > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > > [na:1.7.0_55] > > > at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] > > > 2014-12-29 20:27:16,141 [2b5e46dc-4390-7eaa-b9c3-3cb7f3588e96:frag:0:0] > > > ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received > > > failure. > > > java.lang.IllegalArgumentException: You tried to write a VarChar type > > when > > > you are using a ValueWriter of type NullableFloat8WriterImpl. > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.impl.AbstractFieldWriter.fail(AbstractFieldWriter.java:625) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.impl.AbstractFieldWriter.writeVarChar(AbstractFieldWriter.java:301) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.impl.NullableFloat8WriterImpl.writeVarChar(NullableFloat8WriterImpl.java:88) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.fn.JsonReader.handleString(JsonReader.java:376) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:290) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.fn.JsonReader.writeDataSwitch(JsonReader.java:207) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.fn.JsonReader.writeToVector(JsonReader.java:181) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.vector.complex.fn.JsonReader.write(JsonReader.java:155) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.store.easy.json.JSONRecordReader.next(JSONRecordReader.java:113) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:158) > > > ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:99) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:89) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.limit.LimitRecordBatch.innerNext(LimitRecordBatch.java:113) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.limit.LimitRecordBatch.innerNext(LimitRecordBatch.java:113) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:99) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:89) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch.innerNext(RemovingRecordBatch.java:96) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:99) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:89) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:132) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > at > > > > > > > > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:97) > > > [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT] > > > > > >
