You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Sungwook Yoon <sy...@maprtech.com> on 2014/12/29 22:21:15 UTC

maprdb table reading error .. again?

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]

Re: maprdb table reading error .. again?

Posted by Jinfeng Ni <ji...@gmail.com>.

The log shows two errors:

1. Query failed: Failure validating SQL.
org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
line 1, column 21: Table 'mytable' not found

Can you check whether your storage plugin contains "mytable" ?

2. Query failed: Unexpected exception
during fragment initialization: Internal error: Error while applying rule
DrillPushProjIntoScan.

The root cause of this is negative row count for some HBase table. This
should be fixed in DRILL-1900, which is in the current apache master branch
0.8.0-SNAPSHOT, and not in 0.7.0-SNAPSHOT.   Can you check whether your
DRILL build have the fix of DRILL-1900?



On Mon, Dec 29, 2014 at 5:16 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

> Thanks, I guess I did not find the right error.
>
> Here is the right one,
>
> Sungwoook
>
>
> 2014-12-30 01:08:23,102 [2b5e04f8-eb44-666b-d246-a7641a00aeaa:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> 8145f411-e91c-436b-9675-51b3b4e382db: Query failed: Failure validating SQL.
> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
> line 1, column 21: Table 'mytable' not found
> org.apache.drill.exec.planner.sql.QueryInputException: Failure validating
> SQL. org.eigenbase.util.EigenbaseContextException: From line 1, column 15
> to line 1, column 21: Table 'mytable' not found
>   at
>
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:147)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> ~[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]
> Caused by: net.hydromatic.optiq.tools.ValidationException:
> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
> line 1, column 21: Table 'mytable' not found
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:178)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
>
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   ... 6 common frames omitted
> Caused by: org.eigenbase.util.EigenbaseContextException: From line 1,
> column 15 to line 1, column 21: Table 'mytable' not found
>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_55]
>   at
>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> ~[na:1.7.0_55]
>   at
>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> ~[na:1.7.0_55]
>   at
> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:673)
> ~[optiq-core-0.9-drill-r12.jar:na]
>  at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3580)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:77)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2807)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:176)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 9 common frames omitted
> Caused by: org.eigenbase.sql.validate.SqlValidatorException: Table
> 'mytable' not found
>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_55]
>   at
>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> ~[na:1.7.0_55]
>   at
>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> ~[na:1.7.0_55]
>   at
> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 26 common frames omitted
> 2014-12-30 01:08:43,712 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> fdd6dbad-f02a-4db5-8717-1229a0dad931: Query failed: Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
>
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
> org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
>
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
> [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]
> Caused by: java.lang.AssertionError: Internal error: Error while applying
> rule DrillPushProjIntoScan, args
>
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>   at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:276)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
>
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   ... 4 common frames omitted
> Caused by: java.lang.AssertionError: Internal error: Error occurred while
> applying rule DrillPushProjIntoScan
>   at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 12 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
>   at
>
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 15 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
>   at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
>
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 26 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>   at
>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
>
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 30 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) ~[na:na]
>   at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
>
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 34 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>   at
>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 38 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) ~[na:na]
>   at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
>
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 41 common frames omitted
> Caused by: java.lang.AssertionError: null
>   at
>
> org.eigenbase.rel.metadata.RelMetadataQuery.isNonNegative(RelMetadataQuery.java:368)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
>
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 45 common frames omitted
>
>
>
>
> On Mon, Dec 29, 2014 at 4:23 PM, Jinfeng Ni <ji...@gmail.com> wrote:
>
> > 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 <ja...@apache.org>
> > wrote:
> >
> > > That seems strange.  As far I remember, HBase only returns VARBINARY
> > > values.
> > >
> > > On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <ji...@gmail.com>
> > 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 <sy...@maprtech.com>
> > > 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]
> > > > >
> > > >
> > >
> >
>

Re: maprdb table reading error .. again?

Posted by Sungwook Yoon <sy...@maprtech.com>.

Turned out multiple versions of drill-bits were running.
The maprdb error coughed up from drillbit was from 0.7
With 0.8, it is gone.
Thanks for the help!

Sungwook


On Mon, Dec 29, 2014 at 5:47 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

>
> Let me correct myself again,
> Attaching another portion of the log...
>
> Sungwook
>
> 2014-12-30 01:08:43,681 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
> INFO  o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation
> disabled.
> 2014-12-30 01:08:43,712 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> fdd6dbad-f02a-4db5-8717-1229a0dad931: Query failed: Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
> org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
> [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]
> Caused by: java.lang.AssertionError: Internal error: Error while applying
> rule DrillPushProjIntoScan, args
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>   at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:276)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   ... 4 common frames omitted
> Caused by: java.lang.AssertionError: Internal error: Error occurred while
> applying rule DrillPushProjIntoScan
>   at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 12 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> ~[optiq-core-0.9-drill-r12.jar:na]
>  at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 15 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
>   at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 26 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 30 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) ~[na:na]
>   at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 34 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 38 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) ~[na:na]
>   at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 41 common frames omitted
> Caused by: java.lang.AssertionError: null
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.isNonNegative(RelMetadataQuery.java:368)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 45 common frames omitted
>
>
>
> On Mon, Dec 29, 2014 at 5:16 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
>>
>> Thanks, I guess I did not find the right error.
>>
>> Here is the right one,
>>
>> Sungwoook
>>
>>
>> 2014-12-30 01:08:23,102 [2b5e04f8-eb44-666b-d246-a7641a00aeaa:foreman]
>> ERROR o.a.drill.exec.work.foreman.Foreman - Error
>> 8145f411-e91c-436b-9675-51b3b4e382db: Query failed: Failure validating SQL.
>> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
>> line 1, column 21: Table 'mytable' not found
>> org.apache.drill.exec.planner.sql.QueryInputException: Failure validating
>> SQL. org.eigenbase.util.EigenbaseContextException: From line 1, column 15
>> to line 1, column 21: Table 'mytable' not found
>>   at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:147)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
>> ~[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]
>> Caused by: net.hydromatic.optiq.tools.ValidationException:
>> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
>> line 1, column 21: Table 'mytable' not found
>>   at
>> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:178)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   ... 6 common frames omitted
>> Caused by: org.eigenbase.util.EigenbaseContextException: From line 1,
>> column 15 to line 1, column 21: Table 'mytable' not found
>>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method) ~[na:1.7.0_55]
>>   at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>> ~[na:1.7.0_55]
>>   at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>> ~[na:1.7.0_55]
>>   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>> ~[na:1.7.0_55]
>>   at
>> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:673)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>  at
>> org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3580)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:77)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2807)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:176)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 9 common frames omitted
>> Caused by: org.eigenbase.sql.validate.SqlValidatorException: Table
>> 'mytable' not found
>>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method) ~[na:1.7.0_55]
>>   at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>> ~[na:1.7.0_55]
>>   at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>> ~[na:1.7.0_55]
>>   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>> ~[na:1.7.0_55]
>>   at
>> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 26 common frames omitted
>> 2014-12-30 01:08:43,712 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
>> ERROR o.a.drill.exec.work.foreman.Foreman - Error
>> fdd6dbad-f02a-4db5-8717-1229a0dad931: Query failed: Unexpected exception
>> during fragment initialization: Internal error: Error while applying rule
>> DrillPushProjIntoScan, args
>> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
>> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>> excel])]
>> org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception
>> during fragment initialization: Internal error: Error while applying rule
>> DrillPushProjIntoScan, args
>> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
>> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>> excel])]
>>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
>> [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]
>> Caused by: java.lang.AssertionError: Internal error: Error while applying
>> rule DrillPushProjIntoScan, args
>> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
>> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>> excel])]
>>   at org.eigenbase.util.Util.newInternal(Util.java:750)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:276)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
>> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
>> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
>> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   ... 4 common frames omitted
>> Caused by: java.lang.AssertionError: Internal error: Error occurred while
>> applying rule DrillPushProjIntoScan
>>   at org.eigenbase.util.Util.newInternal(Util.java:750)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 12 common frames omitted
>> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>   at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
>>   at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 15 common frames omitted
>> Caused by: java.lang.reflect.InvocationTargetException: null
>>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
>> Caused by: java.lang.reflect.InvocationTargetException: null
>>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
>>   at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> ~[na:1.7.0_55]
>>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>>   at
>> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 26 common frames omitted
>> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>>   at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
>> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>>   at
>> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 30 common frames omitted
>> Caused by: java.lang.reflect.InvocationTargetException: null
>>   at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) ~[na:na]
>>   at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> ~[na:1.7.0_55]
>>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>>   at
>> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 34 common frames omitted
>> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>>   at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 38 common frames omitted
>> Caused by: java.lang.reflect.InvocationTargetException: null
>>   at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) ~[na:na]
>>   at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> ~[na:1.7.0_55]
>>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>>   at
>> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 41 common frames omitted
>> Caused by: java.lang.AssertionError: null
>>   at
>> org.eigenbase.rel.metadata.RelMetadataQuery.isNonNegative(RelMetadataQuery.java:368)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   at
>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
>> ~[optiq-core-0.9-drill-r12.jar:na]
>>   ... 45 common frames omitted
>>
>>
>>
>>
>> On Mon, Dec 29, 2014 at 4:23 PM, Jinfeng Ni <ji...@gmail.com>
>> wrote:
>>
>>> 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 <ja...@apache.org>
>>> wrote:
>>>
>>> > That seems strange.  As far I remember, HBase only returns VARBINARY
>>> > values.
>>> >
>>> > On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <ji...@gmail.com>
>>> 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 <sy...@maprtech.com>
>>> > 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]
>>> > > >
>>> > >
>>> >
>>>
>>
>>
>

Re: maprdb table reading error .. again?

Posted by Sungwook Yoon <sy...@maprtech.com>.

Let me correct myself again,
Attaching another portion of the log...

Sungwook

2014-12-30 01:08:43,681 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman] INFO
 o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation disabled.
2014-12-30 01:08:43,712 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
ERROR o.a.drill.exec.work.foreman.Foreman - Error
fdd6dbad-f02a-4db5-8717-1229a0dad931: Query failed: Unexpected exception
during fragment initialization: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception
during fragment initialization: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
  at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
[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]
Caused by: java.lang.AssertionError: Internal error: Error while applying
rule DrillPushProjIntoScan, args
[rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
  at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
~[optiq-core-0.9-drill-r12.jar:na]
  at
net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
~[optiq-core-0.9-drill-r12.jar:na]
  at
net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:276)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  ... 4 common frames omitted
Caused by: java.lang.AssertionError: Internal error: Error occurred while
applying rule DrillPushProjIntoScan
  at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 12 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
  at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
~[optiq-core-0.9-drill-r12.jar:na]
 at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 15 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_55]
  at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 26 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
  at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 30 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) ~[na:na]
  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_55]
  at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 34 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
  at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 38 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) ~[na:na]
  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_55]
  at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 41 common frames omitted
Caused by: java.lang.AssertionError: null
  at
org.eigenbase.rel.metadata.RelMetadataQuery.isNonNegative(RelMetadataQuery.java:368)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
~[optiq-core-0.9-drill-r12.jar:na]
  at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 45 common frames omitted



On Mon, Dec 29, 2014 at 5:16 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

>
> Thanks, I guess I did not find the right error.
>
> Here is the right one,
>
> Sungwoook
>
>
> 2014-12-30 01:08:23,102 [2b5e04f8-eb44-666b-d246-a7641a00aeaa:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> 8145f411-e91c-436b-9675-51b3b4e382db: Query failed: Failure validating SQL.
> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
> line 1, column 21: Table 'mytable' not found
> org.apache.drill.exec.planner.sql.QueryInputException: Failure validating
> SQL. org.eigenbase.util.EigenbaseContextException: From line 1, column 15
> to line 1, column 21: Table 'mytable' not found
>   at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:147)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> ~[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]
> Caused by: net.hydromatic.optiq.tools.ValidationException:
> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
> line 1, column 21: Table 'mytable' not found
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:178)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   ... 6 common frames omitted
> Caused by: org.eigenbase.util.EigenbaseContextException: From line 1,
> column 15 to line 1, column 21: Table 'mytable' not found
>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_55]
>   at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> ~[na:1.7.0_55]
>   at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> ~[na:1.7.0_55]
>   at
> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:673)
> ~[optiq-core-0.9-drill-r12.jar:na]
>  at
> org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3580)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:77)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2807)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:176)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 9 common frames omitted
> Caused by: org.eigenbase.sql.validate.SqlValidatorException: Table
> 'mytable' not found
>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_55]
>   at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> ~[na:1.7.0_55]
>   at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> ~[na:1.7.0_55]
>   at
> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 26 common frames omitted
> 2014-12-30 01:08:43,712 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> fdd6dbad-f02a-4db5-8717-1229a0dad931: Query failed: Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
> org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
> [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]
> Caused by: java.lang.AssertionError: Internal error: Error while applying
> rule DrillPushProjIntoScan, args
> [rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>   at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:276)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
> [drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   ... 4 common frames omitted
> Caused by: java.lang.AssertionError: Internal error: Error occurred while
> applying rule DrillPushProjIntoScan
>   at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 12 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 15 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
>   at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 26 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> ~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
>   at
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 30 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) ~[na:na]
>   at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 34 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>   at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 38 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>   at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) ~[na:na]
>   at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_55]
>   at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 41 common frames omitted
> Caused by: java.lang.AssertionError: null
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.isNonNegative(RelMetadataQuery.java:368)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> ~[optiq-core-0.9-drill-r12.jar:na]
>   ... 45 common frames omitted
>
>
>
>
> On Mon, Dec 29, 2014 at 4:23 PM, Jinfeng Ni <ji...@gmail.com> wrote:
>
>> 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 <ja...@apache.org>
>> wrote:
>>
>> > That seems strange.  As far I remember, HBase only returns VARBINARY
>> > values.
>> >
>> > On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <ji...@gmail.com>
>> 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 <sy...@maprtech.com>
>> > 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]
>> > > >
>> > >
>> >
>>
>
>

Re: maprdb table reading error .. again?

Posted by Sungwook Yoon <sy...@maprtech.com>.

Thanks, I guess I did not find the right error.

Here is the right one,

Sungwoook

2014-12-30 01:08:23,102 [2b5e04f8-eb44-666b-d246-a7641a00aeaa:foreman]
ERROR o.a.drill.exec.work.foreman.Foreman - Error
8145f411-e91c-436b-9675-51b3b4e382db: Query failed: Failure validating SQL.
org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
line 1, column 21: Table 'mytable' not found
org.apache.drill.exec.planner.sql.QueryInputException: Failure validating
SQL. org.eigenbase.util.EigenbaseContextException: From line 1, column 15
to line 1, column 21: Table 'mytable' not found
  at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:147)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
~[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]
Caused by: net.hydromatic.optiq.tools.ValidationException:
org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
line 1, column 21: Table 'mytable' not found
  at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:178)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  ... 6 common frames omitted
Caused by: org.eigenbase.util.EigenbaseContextException: From line 1,
column 15 to line 1, column 21: Table 'mytable' not found
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.7.0_55]
  at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
~[na:1.7.0_55]
  at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.7.0_55]
  at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
~[na:1.7.0_55]
  at
org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
~[optiq-core-0.9-drill-r12.jar:na]
  at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:673)
~[optiq-core-0.9-drill-r12.jar:na]
 at
org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3580)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:77)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2807)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
~[optiq-core-0.9-drill-r12.jar:na]
  at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
~[optiq-core-0.9-drill-r12.jar:na]
  at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:176)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 9 common frames omitted
Caused by: org.eigenbase.sql.validate.SqlValidatorException: Table
'mytable' not found
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.7.0_55]
  at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
~[na:1.7.0_55]
  at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.7.0_55]
  at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
~[na:1.7.0_55]
  at
org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
~[optiq-core-0.9-drill-r12.jar:na]
  at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 26 common frames omitted
2014-12-30 01:08:43,712 [2b5e04e4-76a8-4822-ea95-5dbe13280f04:foreman]
ERROR o.a.drill.exec.work.foreman.Foreman - Error
fdd6dbad-f02a-4db5-8717-1229a0dad931: Query failed: Unexpected exception
during fragment initialization: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception
during fragment initialization: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
  at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
[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]
Caused by: java.lang.AssertionError: Internal error: Error while applying
rule DrillPushProjIntoScan, args
[rel#146:ProjectRel.NONE.ANY([]).[](child=rel#145:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#137:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
  at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
~[optiq-core-0.9-drill-r12.jar:na]
  at
net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
~[optiq-core-0.9-drill-r12.jar:na]
  at
net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:276)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  ... 4 common frames omitted
Caused by: java.lang.AssertionError: Internal error: Error occurred while
applying rule DrillPushProjIntoScan
  at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 12 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
  at com.sun.proxy.$Proxy63.getNonCumulativeCost(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 15 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_55]
  at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 26 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
  at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
  at
org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 30 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) ~[na:na]
  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_55]
  at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 34 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
  at com.sun.proxy.$Proxy65.getRowCount(Unknown Source) ~[na:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 38 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
  at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) ~[na:na]
  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_55]
  at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.ReflectiveRelMetadataProvider$2$1.invoke(ReflectiveRelMetadataProvider.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 41 common frames omitted
Caused by: java.lang.AssertionError: null
  at
org.eigenbase.rel.metadata.RelMetadataQuery.isNonNegative(RelMetadataQuery.java:368)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
~[optiq-core-0.9-drill-r12.jar:na]
  at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
~[optiq-core-0.9-drill-r12.jar:na]
  at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
~[optiq-core-0.9-drill-r12.jar:na]
  ... 45 common frames omitted

On Mon, Dec 29, 2014 at 4:23 PM, Jinfeng Ni <ji...@gmail.com> wrote:

> 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 <ja...@apache.org>
> wrote:
>
> > That seems strange.  As far I remember, HBase only returns VARBINARY
> > values.
> >
> > On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <ji...@gmail.com>
> 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 <sy...@maprtech.com>
> > 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]
> > > >
> > >
> >
>

Re: maprdb table reading error .. again?

Posted by Jinfeng Ni <ji...@gmail.com>.

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 <ja...@apache.org> wrote:

> That seems strange.  As far I remember, HBase only returns VARBINARY
> values.
>
> On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <ji...@gmail.com> 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 <sy...@maprtech.com>
> 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]
> > >
> >
>

Re: maprdb table reading error .. again?

Posted by Jacques Nadeau <ja...@apache.org>.

That seems strange.  As far I remember, HBase only returns VARBINARY values.

On Mon, Dec 29, 2014 at 2:52 PM, Jinfeng Ni <ji...@gmail.com> 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 <sy...@maprtech.com> 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]
> >
>

Re: maprdb table reading error .. again?

Posted by Jinfeng Ni <ji...@gmail.com>.

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 <sy...@maprtech.com> 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]
>