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

Reply via email to