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/12 15:44:38 UTC
maprdb setting up foreman error
Querying maprdb, I got this error.
0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel limit 2;
Query failed: Failure while setting up Foreman.
Error: exception while executing query: Failure while executing query.
(state=,code=0)
What's going on?
Drillbit reads the column family information correctly, just does not go to
columns.
Thanks,
Sungwook
Re: maprdb setting up foreman error
Posted by Sungwook Yoon <sy...@maprtech.com>.
Okay.. I tested with a few different MapRDB tables.
I made one row table and increased the number of columns.
Couldn't say when, but after making 150 columns, I am seeing the error from
the drill.
I guess, it is the number of the columns in the table is causing the issue.
Sungwook
On Mon, Dec 15, 2014 at 6:12 PM, Steven Phillips <sp...@maprtech.com>
wrote:
> If TableStatsCalculator is disabled, it's supposed to simply return some
> constant value per region. If it's showing the row count is negative, that
> indicates a bug of some sort.
>
> On Mon, Dec 15, 2014 at 6:06 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
> >
> > The other thing about this table is that, this table has 158 columns on
> one
> > family, could this be an issue?
> > thanks,
> >
> > Sungwook
> >
> >
> > On Mon, Dec 15, 2014 at 2:58 PM, Sungwook Yoon <sy...@maprtech.com>
> wrote:
> >
> > > Could this be a unicode issue?
> > >
> > > Sungwook
> > >
> > >
> > > On Mon, Dec 15, 2014 at 2:54 PM, Sungwook Yoon <sy...@maprtech.com>
> > wrote:
> > >
> > >>
> > >> Here is the most recent error,
> > >>
> > >> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
> > >> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> > >> c3194685-31c8-4b5e-afca-83985aee7dd2: Failure while setting up
> Foreman.
> > >> java.lang.AssertionError: Internal error: Error while applying rule
> > >> DrillPushProjIntoScan, args
> > >>
> >
> [rel#13410:ProjectRel.NONE.ANY([]).[](child=rel#13409:Subset#0.ENUMERABLE.ANY([]).[],Row_Key=CAST($0):VARCHAR(255)
> > >> CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT
> NULL),
> > >>
> rel#13401:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > >> excel])]
> > >> at org.eigenbase.util.Util.newInternal(Util.java:750)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> > net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at
> > >>
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at
> > >>
> >
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at
> > >>
> >
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> > >>
> >
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred
> > while
> > >> applying rule DrillPushProjIntoScan
> > >> at org.eigenbase.util.Util.newInternal(Util.java:750)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> ... 12 common frames omitted
> > >> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > >> at com.sun.proxy.$Proxy60.getNonCumulativeCost(Unknown Source)
> > ~[na:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> > org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> ... 15 common frames omitted
> > >> Caused by: java.lang.reflect.InvocationTargetException: null
> > >> at sun.reflect.GeneratedMethodAccessor11.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-r8.jar:na]
> > >> ... 26 common frames omitted
> > >> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > >>
> > >> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> > >>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> ... 30 common frames omitted
> > >> Caused by: java.lang.reflect.InvocationTargetException: null
> > >> at sun.reflect.GeneratedMethodAccessor28.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-r8.jar:na]
> > >> ... 34 common frames omitted
> > >> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > >> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> ... 38 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-r8.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-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> at
> > >>
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> > >> ~[optiq-core-0.9-drill-r8.jar:na]
> > >> ... 45 common frames omitted
> > >> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
> > >> WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> state
> > :
> > >> FAILED
> > >> 2014-12-15 19:19:35,103 [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.200.174.108:50546
> > >> 2014-12-15 19:19:38,002 [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.200.174.108:50542
> > >>
> > >>
> > >>
> > >>
> > >> On Mon, Dec 15, 2014 at 2:50 PM, Aman Sinha <as...@maprtech.com>
> > wrote:
> > >>
> > >>> The assertion at the bottom of the stack indicates that the row count
> > for
> > >>> the HBase table was found as negative.
> > >>> One of the info messages indicates 'TableStatsCalculator - Region
> size
> > >>> calculation disabled.'
> > >>> What is the value of your exec.hbase.scan.sizecalculator.enabled
> > setting
> > >>> in sys.options ?
> > >>>
> > >>> Even with this disabled, I would think you should not see the
> > assertion,
> > >>> so
> > >>> you are probably hitting a bug....perhaps Aditya will have input on
> > this.
> > >>>
> > >>> On Mon, Dec 15, 2014 at 2:48 PM, Jinfeng Ni <ji...@gmail.com>
> > >>> wrote:
> > >>> >
> > >>> > The log shows this is query planner error, when it tries to apply
> the
> > >>> > optimizer rule : DrillPushProjIntoScan.
> > >>> >
> > >>> > java.lang.AssertionError: Internal error: Error while applying rule
> > >>> > DrillPushProjIntoScan, args
> > >>> > [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
> > >>> > Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
> > >>> > independent_vars=$2),
> > >>> >
> > rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > >>> > excel])]
> > >>> >
> > >>> > On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <syoon@maprtech.com
> >
> > >>> wrote:
> > >>> > >
> > >>> > > Hi,
> > >>> > >
> > >>> > > Do you have some comment on this yet?
> > >>> > >
> > >>> > > Thanks,
> > >>> > >
> > >>> > > Sungwook
> > >>> > >
> > >>> > >
> > >>> > > On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <
> syoon@maprtech.com
> > >
> > >>> > wrote:
> > >>> > >
> > >>> > > >
> > >>> > > > Hi,
> > >>> > > >
> > >>> > > > Sorry for delayed response, was traveling.
> > >>> > > > Can you take a look at the log?
> > >>> > > >
> > >>> > > > Thanks,
> > >>> > > >
> > >>> > > > Sungwook
> > >>> > > >
> > >>> > > >
> > >>> > > > 2014-12-12 19:02:24,849
> > >>> [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
> > >>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished
> query
> > >>> > state :
> > >>> > > > COMPLETED
> > >>> > > > 2014-12-12 19:02:24,906 [UserServer-1] WARN
> > >>> > > > o.a.d.exec.work.foreman.QueryStatus - Update running or
> pending
> > >>> query
> > >>> > > > state : PENDING
> > >>> > > > 2014-12-12 19:02:24,974
> > >>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > >>> > > > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size
> > >>> calculation
> > >>> > > > disabled.
> > >>> > > > 2014-12-12 19:02:24,984
> > >>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > >>> > > > ERROR o.a.drill.exec.work.foreman.Foreman - Error
> > >>> > > > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up
> > >>> Foreman.
> > >>> > > > java.lang.AssertionError: Internal error: Error while applying
> > rule
> > >>> > > > DrillPushProjIntoScan, args
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> > >>> > > >
> > >>>
> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > >>> > > > excel])]
> > >>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> >
> > >>>
> > net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> >
> > >>>
> > net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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
> > occurred
> > >>> > while
> > >>> > > > applying rule DrillPushProjIntoScan
> > >>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> >
> > >>>
> > org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > ... 12 common frames omitted
> > >>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > >>> > > > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown
> Source)
> > >>> > ~[na:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> >
> > >>>
> > org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> > >>> > > > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
> > >>> > > > ... 26 common frames omitted
> > >>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > >>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source)
> ~[na:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > ... 30 common frames omitted
> > >>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> > >>> > > > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
> > >>> > > > ... 34 common frames omitted
> > >>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > >>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source)
> ~[na:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > ... 38 common frames omitted
> > >>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> > >>> > > > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > at
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> > >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > >>> > > > ... 45 common frames omitted
> > >>> > > > 2014-12-12 19:02:24,985
> > >>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > >>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished
> query
> > >>> > state :
> > >>> > > > FAILED
> > >>> > > > 2014-12-12 19:02:24,999 [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.190.22.16:51773
> > >>> > > >
> > >>> > > >
> > >>> > > >
> > >>> > > > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
> > >>> > > sphillips@maprtech.com>
> > >>> > > > wrote:
> > >>> > > >
> > >>> > > >> You need to look at the drillbit logs to see what the problem
> > is.
> > >>> We
> > >>> > > can't
> > >>> > > >> diagnose this without that information.
> > >>> > > >>
> > >>> > > >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <jsun@maprtech.com
> >
> > >>> wrote:
> > >>> > > >> >
> > >>> > > >> > Sungwook,
> > >>> > > >> >
> > >>> > > >> > What's the column family permission? You probably want to
> do
> > >>> > > something
> > >>> > > >> > like this to give r/w permissions:
> > >>> > > >> >
> > >>> > > >> > maprcli table cf edit -cfname dependent_vars -path
> > >>> '/tables/lecxe'
> > >>> > > >> > -readperm 'u:root|u:mapr'
> > >>> > > >> > maprcli table cf edit -cfname dependent_vars -path
> > >>> '/tables/lecxe'
> > >>> > > >> > -writeperm 'u:root|u:mapr'
> > >>> > > >> >
> > >>> > > >> > -James
> > >>> > > >> >
> > >>> > > >> >
> > >>> > > >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> > >>> > > >> >
> > >>> > > >> >> Querying maprdb, I got this error.
> > >>> > > >> >>
> > >>> > > >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select *
> from
> > >>> excel
> > >>> > > >> limit
> > >>> > > >> >> 2;
> > >>> > > >> >> Query failed: Failure while setting up Foreman.
> > >>> > > >> >>
> > >>> > > >> >> Error: exception while executing query: Failure while
> > executing
> > >>> > > query.
> > >>> > > >> >> (state=,code=0)
> > >>> > > >> >>
> > >>> > > >> >>
> > >>> > > >> >> What's going on?
> > >>> > > >> >> Drillbit reads the column family information correctly,
> just
> > >>> does
> > >>> > not
> > >>> > > >> go
> > >>> > > >> >> to
> > >>> > > >> >> columns.
> > >>> > > >> >> Thanks,
> > >>> > > >> >>
> > >>> > > >> >> Sungwook
> > >>> > > >> >>
> > >>> > > >> >>
> > >>> > > >> >
> > >>> > > >>
> > >>> > > >> --
> > >>> > > >> Steven Phillips
> > >>> > > >> Software Engineer
> > >>> > > >>
> > >>> > > >> mapr.com
> > >>> > > >>
> > >>> > > >
> > >>> > > >
> > >>> > >
> > >>> >
> > >>>
> > >>
> > >>
> > >
> >
>
>
> --
> Steven Phillips
> Software Engineer
>
> mapr.com
>
Re: maprdb setting up foreman error
Posted by Steven Phillips <sp...@maprtech.com>.
If TableStatsCalculator is disabled, it's supposed to simply return some
constant value per region. If it's showing the row count is negative, that
indicates a bug of some sort.
On Mon, Dec 15, 2014 at 6:06 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> The other thing about this table is that, this table has 158 columns on one
> family, could this be an issue?
> thanks,
>
> Sungwook
>
>
> On Mon, Dec 15, 2014 at 2:58 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> > Could this be a unicode issue?
> >
> > Sungwook
> >
> >
> > On Mon, Dec 15, 2014 at 2:54 PM, Sungwook Yoon <sy...@maprtech.com>
> wrote:
> >
> >>
> >> Here is the most recent error,
> >>
> >> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
> >> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> >> c3194685-31c8-4b5e-afca-83985aee7dd2: Failure while setting up Foreman.
> >> java.lang.AssertionError: Internal error: Error while applying rule
> >> DrillPushProjIntoScan, args
> >>
> [rel#13410:ProjectRel.NONE.ANY([]).[](child=rel#13409:Subset#0.ENUMERABLE.ANY([]).[],Row_Key=CAST($0):VARCHAR(255)
> >> CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL),
> >> rel#13401:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> >> excel])]
> >> at org.eigenbase.util.Util.newInternal(Util.java:750)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at
> >>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at
> >>
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at
> >>
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> >>
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred
> while
> >> applying rule DrillPushProjIntoScan
> >> at org.eigenbase.util.Util.newInternal(Util.java:750)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> ... 12 common frames omitted
> >> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> >> at com.sun.proxy.$Proxy60.getNonCumulativeCost(Unknown Source)
> ~[na:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> ... 15 common frames omitted
> >> Caused by: java.lang.reflect.InvocationTargetException: null
> >> at sun.reflect.GeneratedMethodAccessor11.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-r8.jar:na]
> >> ... 26 common frames omitted
> >> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> >>
> >> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> >>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> ... 30 common frames omitted
> >> Caused by: java.lang.reflect.InvocationTargetException: null
> >> at sun.reflect.GeneratedMethodAccessor28.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-r8.jar:na]
> >> ... 34 common frames omitted
> >> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> >> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> ... 38 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-r8.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-r8.jar:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> at
> >>
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> >> ~[optiq-core-0.9-drill-r8.jar:na]
> >> ... 45 common frames omitted
> >> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
> >> WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state
> :
> >> FAILED
> >> 2014-12-15 19:19:35,103 [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.200.174.108:50546
> >> 2014-12-15 19:19:38,002 [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.200.174.108:50542
> >>
> >>
> >>
> >>
> >> On Mon, Dec 15, 2014 at 2:50 PM, Aman Sinha <as...@maprtech.com>
> wrote:
> >>
> >>> The assertion at the bottom of the stack indicates that the row count
> for
> >>> the HBase table was found as negative.
> >>> One of the info messages indicates 'TableStatsCalculator - Region size
> >>> calculation disabled.'
> >>> What is the value of your exec.hbase.scan.sizecalculator.enabled
> setting
> >>> in sys.options ?
> >>>
> >>> Even with this disabled, I would think you should not see the
> assertion,
> >>> so
> >>> you are probably hitting a bug....perhaps Aditya will have input on
> this.
> >>>
> >>> On Mon, Dec 15, 2014 at 2:48 PM, Jinfeng Ni <ji...@gmail.com>
> >>> wrote:
> >>> >
> >>> > The log shows this is query planner error, when it tries to apply the
> >>> > optimizer rule : DrillPushProjIntoScan.
> >>> >
> >>> > java.lang.AssertionError: Internal error: Error while applying rule
> >>> > DrillPushProjIntoScan, args
> >>> > [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
> >>> > Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
> >>> > independent_vars=$2),
> >>> >
> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> >>> > excel])]
> >>> >
> >>> > On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <sy...@maprtech.com>
> >>> wrote:
> >>> > >
> >>> > > Hi,
> >>> > >
> >>> > > Do you have some comment on this yet?
> >>> > >
> >>> > > Thanks,
> >>> > >
> >>> > > Sungwook
> >>> > >
> >>> > >
> >>> > > On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <syoon@maprtech.com
> >
> >>> > wrote:
> >>> > >
> >>> > > >
> >>> > > > Hi,
> >>> > > >
> >>> > > > Sorry for delayed response, was traveling.
> >>> > > > Can you take a look at the log?
> >>> > > >
> >>> > > > Thanks,
> >>> > > >
> >>> > > > Sungwook
> >>> > > >
> >>> > > >
> >>> > > > 2014-12-12 19:02:24,849
> >>> [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
> >>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> >>> > state :
> >>> > > > COMPLETED
> >>> > > > 2014-12-12 19:02:24,906 [UserServer-1] WARN
> >>> > > > o.a.d.exec.work.foreman.QueryStatus - Update running or pending
> >>> query
> >>> > > > state : PENDING
> >>> > > > 2014-12-12 19:02:24,974
> >>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> >>> > > > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size
> >>> calculation
> >>> > > > disabled.
> >>> > > > 2014-12-12 19:02:24,984
> >>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> >>> > > > ERROR o.a.drill.exec.work.foreman.Foreman - Error
> >>> > > > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up
> >>> Foreman.
> >>> > > > java.lang.AssertionError: Internal error: Error while applying
> rule
> >>> > > > DrillPushProjIntoScan, args
> >>> > > >
> >>> > >
> >>> >
> >>>
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> >>> > > >
> >>> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> >>> > > > excel])]
> >>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> >
> >>>
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> >
> >>>
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> >>> > > >
> >>> > >
> >>> >
> >>>
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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
> occurred
> >>> > while
> >>> > > > applying rule DrillPushProjIntoScan
> >>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> >
> >>>
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > ... 12 common frames omitted
> >>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> >>> > > > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source)
> >>> > ~[na:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> >>> > > > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
> >>> > > > ... 26 common frames omitted
> >>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> >>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> >>> > > >
> >>> > >
> >>> >
> >>>
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > ... 30 common frames omitted
> >>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> >>> > > > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
> >>> > > > ... 34 common frames omitted
> >>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> >>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > ... 38 common frames omitted
> >>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> >>> > > > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > at
> >>> > > >
> >>> > >
> >>> >
> >>>
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> >>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> >>> > > > ... 45 common frames omitted
> >>> > > > 2014-12-12 19:02:24,985
> >>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> >>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> >>> > state :
> >>> > > > FAILED
> >>> > > > 2014-12-12 19:02:24,999 [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.190.22.16:51773
> >>> > > >
> >>> > > >
> >>> > > >
> >>> > > > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
> >>> > > sphillips@maprtech.com>
> >>> > > > wrote:
> >>> > > >
> >>> > > >> You need to look at the drillbit logs to see what the problem
> is.
> >>> We
> >>> > > can't
> >>> > > >> diagnose this without that information.
> >>> > > >>
> >>> > > >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com>
> >>> wrote:
> >>> > > >> >
> >>> > > >> > Sungwook,
> >>> > > >> >
> >>> > > >> > What's the column family permission? You probably want to do
> >>> > > something
> >>> > > >> > like this to give r/w permissions:
> >>> > > >> >
> >>> > > >> > maprcli table cf edit -cfname dependent_vars -path
> >>> '/tables/lecxe'
> >>> > > >> > -readperm 'u:root|u:mapr'
> >>> > > >> > maprcli table cf edit -cfname dependent_vars -path
> >>> '/tables/lecxe'
> >>> > > >> > -writeperm 'u:root|u:mapr'
> >>> > > >> >
> >>> > > >> > -James
> >>> > > >> >
> >>> > > >> >
> >>> > > >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> >>> > > >> >
> >>> > > >> >> Querying maprdb, I got this error.
> >>> > > >> >>
> >>> > > >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from
> >>> excel
> >>> > > >> limit
> >>> > > >> >> 2;
> >>> > > >> >> Query failed: Failure while setting up Foreman.
> >>> > > >> >>
> >>> > > >> >> Error: exception while executing query: Failure while
> executing
> >>> > > query.
> >>> > > >> >> (state=,code=0)
> >>> > > >> >>
> >>> > > >> >>
> >>> > > >> >> What's going on?
> >>> > > >> >> Drillbit reads the column family information correctly, just
> >>> does
> >>> > not
> >>> > > >> go
> >>> > > >> >> to
> >>> > > >> >> columns.
> >>> > > >> >> Thanks,
> >>> > > >> >>
> >>> > > >> >> Sungwook
> >>> > > >> >>
> >>> > > >> >>
> >>> > > >> >
> >>> > > >>
> >>> > > >> --
> >>> > > >> Steven Phillips
> >>> > > >> Software Engineer
> >>> > > >>
> >>> > > >> mapr.com
> >>> > > >>
> >>> > > >
> >>> > > >
> >>> > >
> >>> >
> >>>
> >>
> >>
> >
>
--
Steven Phillips
Software Engineer
mapr.com
Re: maprdb setting up foreman error
Posted by Sungwook Yoon <sy...@maprtech.com>.
The other thing about this table is that, this table has 158 columns on one
family, could this be an issue?
thanks,
Sungwook
On Mon, Dec 15, 2014 at 2:58 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
> Could this be a unicode issue?
>
> Sungwook
>
>
> On Mon, Dec 15, 2014 at 2:54 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
>>
>> Here is the most recent error,
>>
>> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
>> ERROR o.a.drill.exec.work.foreman.Foreman - Error
>> c3194685-31c8-4b5e-afca-83985aee7dd2: Failure while setting up Foreman.
>> java.lang.AssertionError: Internal error: Error while applying rule
>> DrillPushProjIntoScan, args
>> [rel#13410:ProjectRel.NONE.ANY([]).[](child=rel#13409:Subset#0.ENUMERABLE.ANY([]).[],Row_Key=CAST($0):VARCHAR(255)
>> CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL),
>> rel#13401:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>> excel])]
>> at org.eigenbase.util.Util.newInternal(Util.java:750)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at
>> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
>> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred while
>> applying rule DrillPushProjIntoScan
>> at org.eigenbase.util.Util.newInternal(Util.java:750)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> ... 12 common frames omitted
>> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>> at com.sun.proxy.$Proxy60.getNonCumulativeCost(Unknown Source) ~[na:na]
>> at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> ... 15 common frames omitted
>> Caused by: java.lang.reflect.InvocationTargetException: null
>> at sun.reflect.GeneratedMethodAccessor11.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-r8.jar:na]
>> ... 26 common frames omitted
>> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>
>> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
>> at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> at
>> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> ... 30 common frames omitted
>> Caused by: java.lang.reflect.InvocationTargetException: null
>> at sun.reflect.GeneratedMethodAccessor28.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-r8.jar:na]
>> ... 34 common frames omitted
>> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
>> at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> ... 38 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-r8.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-r8.jar:na]
>> at
>> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> at
>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
>> ~[optiq-core-0.9-drill-r8.jar:na]
>> ... 45 common frames omitted
>> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
>> WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
>> FAILED
>> 2014-12-15 19:19:35,103 [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.200.174.108:50546
>> 2014-12-15 19:19:38,002 [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.200.174.108:50542
>>
>>
>>
>>
>> On Mon, Dec 15, 2014 at 2:50 PM, Aman Sinha <as...@maprtech.com> wrote:
>>
>>> The assertion at the bottom of the stack indicates that the row count for
>>> the HBase table was found as negative.
>>> One of the info messages indicates 'TableStatsCalculator - Region size
>>> calculation disabled.'
>>> What is the value of your exec.hbase.scan.sizecalculator.enabled setting
>>> in sys.options ?
>>>
>>> Even with this disabled, I would think you should not see the assertion,
>>> so
>>> you are probably hitting a bug....perhaps Aditya will have input on this.
>>>
>>> On Mon, Dec 15, 2014 at 2:48 PM, Jinfeng Ni <ji...@gmail.com>
>>> wrote:
>>> >
>>> > The log shows this is query planner error, when it tries to apply the
>>> > optimizer rule : DrillPushProjIntoScan.
>>> >
>>> > java.lang.AssertionError: Internal error: Error while applying rule
>>> > DrillPushProjIntoScan, args
>>> > [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
>>> > Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
>>> > independent_vars=$2),
>>> > rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>>> > excel])]
>>> >
>>> > On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <sy...@maprtech.com>
>>> wrote:
>>> > >
>>> > > Hi,
>>> > >
>>> > > Do you have some comment on this yet?
>>> > >
>>> > > Thanks,
>>> > >
>>> > > Sungwook
>>> > >
>>> > >
>>> > > On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <sy...@maprtech.com>
>>> > wrote:
>>> > >
>>> > > >
>>> > > > Hi,
>>> > > >
>>> > > > Sorry for delayed response, was traveling.
>>> > > > Can you take a look at the log?
>>> > > >
>>> > > > Thanks,
>>> > > >
>>> > > > Sungwook
>>> > > >
>>> > > >
>>> > > > 2014-12-12 19:02:24,849
>>> [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
>>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
>>> > state :
>>> > > > COMPLETED
>>> > > > 2014-12-12 19:02:24,906 [UserServer-1] WARN
>>> > > > o.a.d.exec.work.foreman.QueryStatus - Update running or pending
>>> query
>>> > > > state : PENDING
>>> > > > 2014-12-12 19:02:24,974
>>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
>>> > > > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size
>>> calculation
>>> > > > disabled.
>>> > > > 2014-12-12 19:02:24,984
>>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
>>> > > > ERROR o.a.drill.exec.work.foreman.Foreman - Error
>>> > > > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up
>>> Foreman.
>>> > > > java.lang.AssertionError: Internal error: Error while applying rule
>>> > > > DrillPushProjIntoScan, args
>>> > > >
>>> > >
>>> >
>>> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
>>> > > >
>>> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>>> > > > excel])]
>>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> >
>>> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> >
>>> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
>>> > > >
>>> > >
>>> >
>>> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred
>>> > while
>>> > > > applying rule DrillPushProjIntoScan
>>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> >
>>> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > ... 12 common frames omitted
>>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>> > > > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source)
>>> > ~[na:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
>>> > > > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
>>> > > > ... 26 common frames omitted
>>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
>>> > > >
>>> > >
>>> >
>>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > ... 30 common frames omitted
>>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
>>> > > > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
>>> > > > ... 34 common frames omitted
>>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
>>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > ... 38 common frames omitted
>>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
>>> > > > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > at
>>> > > >
>>> > >
>>> >
>>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
>>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>>> > > > ... 45 common frames omitted
>>> > > > 2014-12-12 19:02:24,985
>>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
>>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
>>> > state :
>>> > > > FAILED
>>> > > > 2014-12-12 19:02:24,999 [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.190.22.16:51773
>>> > > >
>>> > > >
>>> > > >
>>> > > > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
>>> > > sphillips@maprtech.com>
>>> > > > wrote:
>>> > > >
>>> > > >> You need to look at the drillbit logs to see what the problem is.
>>> We
>>> > > can't
>>> > > >> diagnose this without that information.
>>> > > >>
>>> > > >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com>
>>> wrote:
>>> > > >> >
>>> > > >> > Sungwook,
>>> > > >> >
>>> > > >> > What's the column family permission? You probably want to do
>>> > > something
>>> > > >> > like this to give r/w permissions:
>>> > > >> >
>>> > > >> > maprcli table cf edit -cfname dependent_vars -path
>>> '/tables/lecxe'
>>> > > >> > -readperm 'u:root|u:mapr'
>>> > > >> > maprcli table cf edit -cfname dependent_vars -path
>>> '/tables/lecxe'
>>> > > >> > -writeperm 'u:root|u:mapr'
>>> > > >> >
>>> > > >> > -James
>>> > > >> >
>>> > > >> >
>>> > > >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
>>> > > >> >
>>> > > >> >> Querying maprdb, I got this error.
>>> > > >> >>
>>> > > >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from
>>> excel
>>> > > >> limit
>>> > > >> >> 2;
>>> > > >> >> Query failed: Failure while setting up Foreman.
>>> > > >> >>
>>> > > >> >> Error: exception while executing query: Failure while executing
>>> > > query.
>>> > > >> >> (state=,code=0)
>>> > > >> >>
>>> > > >> >>
>>> > > >> >> What's going on?
>>> > > >> >> Drillbit reads the column family information correctly, just
>>> does
>>> > not
>>> > > >> go
>>> > > >> >> to
>>> > > >> >> columns.
>>> > > >> >> Thanks,
>>> > > >> >>
>>> > > >> >> Sungwook
>>> > > >> >>
>>> > > >> >>
>>> > > >> >
>>> > > >>
>>> > > >> --
>>> > > >> Steven Phillips
>>> > > >> Software Engineer
>>> > > >>
>>> > > >> mapr.com
>>> > > >>
>>> > > >
>>> > > >
>>> > >
>>> >
>>>
>>
>>
>
Re: maprdb setting up foreman error
Posted by Sungwook Yoon <sy...@maprtech.com>.
Could this be a unicode issue?
Sungwook
On Mon, Dec 15, 2014 at 2:54 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> Here is the most recent error,
>
> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> c3194685-31c8-4b5e-afca-83985aee7dd2: Failure while setting up Foreman.
> java.lang.AssertionError: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#13410:ProjectRel.NONE.ANY([]).[](child=rel#13409:Subset#0.ENUMERABLE.ANY([]).[],Row_Key=CAST($0):VARCHAR(255)
> CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL),
> rel#13401:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
> at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred while
> applying rule DrillPushProjIntoScan
> at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 12 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> at com.sun.proxy.$Proxy60.getNonCumulativeCost(Unknown Source) ~[na:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 15 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
> at sun.reflect.GeneratedMethodAccessor11.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-r8.jar:na]
> ... 26 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
>
> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 30 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
> at sun.reflect.GeneratedMethodAccessor28.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-r8.jar:na]
> ... 34 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 38 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-r8.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-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 45 common frames omitted
> 2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
> WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
> FAILED
> 2014-12-15 19:19:35,103 [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.200.174.108:50546
> 2014-12-15 19:19:38,002 [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.200.174.108:50542
>
>
>
>
> On Mon, Dec 15, 2014 at 2:50 PM, Aman Sinha <as...@maprtech.com> wrote:
>
>> The assertion at the bottom of the stack indicates that the row count for
>> the HBase table was found as negative.
>> One of the info messages indicates 'TableStatsCalculator - Region size
>> calculation disabled.'
>> What is the value of your exec.hbase.scan.sizecalculator.enabled setting
>> in sys.options ?
>>
>> Even with this disabled, I would think you should not see the assertion,
>> so
>> you are probably hitting a bug....perhaps Aditya will have input on this.
>>
>> On Mon, Dec 15, 2014 at 2:48 PM, Jinfeng Ni <ji...@gmail.com>
>> wrote:
>> >
>> > The log shows this is query planner error, when it tries to apply the
>> > optimizer rule : DrillPushProjIntoScan.
>> >
>> > java.lang.AssertionError: Internal error: Error while applying rule
>> > DrillPushProjIntoScan, args
>> > [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
>> > Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
>> > independent_vars=$2),
>> > rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>> > excel])]
>> >
>> > On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <sy...@maprtech.com>
>> wrote:
>> > >
>> > > Hi,
>> > >
>> > > Do you have some comment on this yet?
>> > >
>> > > Thanks,
>> > >
>> > > Sungwook
>> > >
>> > >
>> > > On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <sy...@maprtech.com>
>> > wrote:
>> > >
>> > > >
>> > > > Hi,
>> > > >
>> > > > Sorry for delayed response, was traveling.
>> > > > Can you take a look at the log?
>> > > >
>> > > > Thanks,
>> > > >
>> > > > Sungwook
>> > > >
>> > > >
>> > > > 2014-12-12 19:02:24,849
>> [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
>> > state :
>> > > > COMPLETED
>> > > > 2014-12-12 19:02:24,906 [UserServer-1] WARN
>> > > > o.a.d.exec.work.foreman.QueryStatus - Update running or pending
>> query
>> > > > state : PENDING
>> > > > 2014-12-12 19:02:24,974
>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
>> > > > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation
>> > > > disabled.
>> > > > 2014-12-12 19:02:24,984
>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
>> > > > ERROR o.a.drill.exec.work.foreman.Foreman - Error
>> > > > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up
>> Foreman.
>> > > > java.lang.AssertionError: Internal error: Error while applying rule
>> > > > DrillPushProjIntoScan, args
>> > > >
>> > >
>> >
>> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
>> > > >
>> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
>> > > > excel])]
>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> >
>> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
>> > > >
>> > >
>> >
>> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred
>> > while
>> > > > applying rule DrillPushProjIntoScan
>> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > ... 12 common frames omitted
>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
>> > > > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source)
>> > ~[na:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
>> > > > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
>> > > > ... 26 common frames omitted
>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
>> > > >
>> > >
>> >
>> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > ... 30 common frames omitted
>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
>> > > > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
>> > > > ... 34 common frames omitted
>> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
>> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > ... 38 common frames omitted
>> > > > Caused by: java.lang.reflect.InvocationTargetException: null
>> > > > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > at
>> > > >
>> > >
>> >
>> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
>> > > > ~[optiq-core-0.9-drill-r8.jar:na]
>> > > > ... 45 common frames omitted
>> > > > 2014-12-12 19:02:24,985
>> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
>> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
>> > state :
>> > > > FAILED
>> > > > 2014-12-12 19:02:24,999 [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.190.22.16:51773
>> > > >
>> > > >
>> > > >
>> > > > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
>> > > sphillips@maprtech.com>
>> > > > wrote:
>> > > >
>> > > >> You need to look at the drillbit logs to see what the problem is.
>> We
>> > > can't
>> > > >> diagnose this without that information.
>> > > >>
>> > > >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com>
>> wrote:
>> > > >> >
>> > > >> > Sungwook,
>> > > >> >
>> > > >> > What's the column family permission? You probably want to do
>> > > something
>> > > >> > like this to give r/w permissions:
>> > > >> >
>> > > >> > maprcli table cf edit -cfname dependent_vars -path
>> '/tables/lecxe'
>> > > >> > -readperm 'u:root|u:mapr'
>> > > >> > maprcli table cf edit -cfname dependent_vars -path
>> '/tables/lecxe'
>> > > >> > -writeperm 'u:root|u:mapr'
>> > > >> >
>> > > >> > -James
>> > > >> >
>> > > >> >
>> > > >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
>> > > >> >
>> > > >> >> Querying maprdb, I got this error.
>> > > >> >>
>> > > >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from
>> excel
>> > > >> limit
>> > > >> >> 2;
>> > > >> >> Query failed: Failure while setting up Foreman.
>> > > >> >>
>> > > >> >> Error: exception while executing query: Failure while executing
>> > > query.
>> > > >> >> (state=,code=0)
>> > > >> >>
>> > > >> >>
>> > > >> >> What's going on?
>> > > >> >> Drillbit reads the column family information correctly, just
>> does
>> > not
>> > > >> go
>> > > >> >> to
>> > > >> >> columns.
>> > > >> >> Thanks,
>> > > >> >>
>> > > >> >> Sungwook
>> > > >> >>
>> > > >> >>
>> > > >> >
>> > > >>
>> > > >> --
>> > > >> Steven Phillips
>> > > >> Software Engineer
>> > > >>
>> > > >> mapr.com
>> > > >>
>> > > >
>> > > >
>> > >
>> >
>>
>
>
Re: maprdb setting up foreman error
Posted by Sungwook Yoon <sy...@maprtech.com>.
Here is the most recent error,
2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman]
ERROR o.a.drill.exec.work.foreman.Foreman - Error
c3194685-31c8-4b5e-afca-83985aee7dd2: Failure while setting up Foreman.
java.lang.AssertionError: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#13410:ProjectRel.NONE.ANY([]).[](child=rel#13409:Subset#0.ENUMERABLE.ANY([]).[],Row_Key=CAST($0):VARCHAR(255)
CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL),
rel#13401:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
~[optiq-core-0.9-drill-r8.jar:na]
at
net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
~[optiq-core-0.9-drill-r8.jar:na]
at
net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred while
applying rule DrillPushProjIntoScan
at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
~[optiq-core-0.9-drill-r8.jar:na]
... 12 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy60.getNonCumulativeCost(Unknown Source) ~[na:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:131)
~[optiq-core-0.9-drill-r8.jar:na]
... 15 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at sun.reflect.GeneratedMethodAccessor11.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-r8.jar:na]
... 26 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
~[optiq-core-0.9-drill-r8.jar:na]
... 30 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at sun.reflect.GeneratedMethodAccessor28.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-r8.jar:na]
... 34 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy62.getRowCount(Unknown Source) ~[na:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
~[optiq-core-0.9-drill-r8.jar:na]
... 38 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-r8.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-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
~[optiq-core-0.9-drill-r8.jar:na]
at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
~[optiq-core-0.9-drill-r8.jar:na]
... 45 common frames omitted
2014-12-15 19:19:35,036 [4b4019f1-40f9-497e-bcaa-8d80633d0a07:foreman] WARN
o.a.d.exec.work.foreman.QueryStatus - Update finished query state : FAILED
2014-12-15 19:19:35,103 [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.200.174.108:50546
2014-12-15 19:19:38,002 [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.200.174.108:50542
On Mon, Dec 15, 2014 at 2:50 PM, Aman Sinha <as...@maprtech.com> wrote:
> The assertion at the bottom of the stack indicates that the row count for
> the HBase table was found as negative.
> One of the info messages indicates 'TableStatsCalculator - Region size
> calculation disabled.'
> What is the value of your exec.hbase.scan.sizecalculator.enabled setting
> in sys.options ?
>
> Even with this disabled, I would think you should not see the assertion, so
> you are probably hitting a bug....perhaps Aditya will have input on this.
>
> On Mon, Dec 15, 2014 at 2:48 PM, Jinfeng Ni <ji...@gmail.com> wrote:
> >
> > The log shows this is query planner error, when it tries to apply the
> > optimizer rule : DrillPushProjIntoScan.
> >
> > java.lang.AssertionError: Internal error: Error while applying rule
> > DrillPushProjIntoScan, args
> > [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
> > Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
> > independent_vars=$2),
> > rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > excel])]
> >
> > On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <sy...@maprtech.com>
> wrote:
> > >
> > > Hi,
> > >
> > > Do you have some comment on this yet?
> > >
> > > Thanks,
> > >
> > > Sungwook
> > >
> > >
> > > On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <sy...@maprtech.com>
> > wrote:
> > >
> > > >
> > > > Hi,
> > > >
> > > > Sorry for delayed response, was traveling.
> > > > Can you take a look at the log?
> > > >
> > > > Thanks,
> > > >
> > > > Sungwook
> > > >
> > > >
> > > > 2014-12-12 19:02:24,849
> [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> > state :
> > > > COMPLETED
> > > > 2014-12-12 19:02:24,906 [UserServer-1] WARN
> > > > o.a.d.exec.work.foreman.QueryStatus - Update running or pending
> query
> > > > state : PENDING
> > > > 2014-12-12 19:02:24,974
> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > > > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation
> > > > disabled.
> > > > 2014-12-12 19:02:24,984
> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > > > ERROR o.a.drill.exec.work.foreman.Foreman - Error
> > > > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up
> Foreman.
> > > > java.lang.AssertionError: Internal error: Error while applying rule
> > > > DrillPushProjIntoScan, args
> > > >
> > >
> >
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> > > >
> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > > > excel])]
> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at
> > > >
> > >
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at
> > > >
> > >
> >
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at
> > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at
> > > >
> > >
> >
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> > > >
> > >
> >
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred
> > while
> > > > applying rule DrillPushProjIntoScan
> > > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > ... 12 common frames omitted
> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > > > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source)
> > ~[na:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> > > > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
> > > > ... 26 common frames omitted
> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> > > >
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > ... 30 common frames omitted
> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> > > > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
> > > > ... 34 common frames omitted
> > > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > ... 38 common frames omitted
> > > > Caused by: java.lang.reflect.InvocationTargetException: null
> > > > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > at
> > > >
> > >
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> > > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > > ... 45 common frames omitted
> > > > 2014-12-12 19:02:24,985
> [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> > state :
> > > > FAILED
> > > > 2014-12-12 19:02:24,999 [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.190.22.16:51773
> > > >
> > > >
> > > >
> > > > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
> > > sphillips@maprtech.com>
> > > > wrote:
> > > >
> > > >> You need to look at the drillbit logs to see what the problem is. We
> > > can't
> > > >> diagnose this without that information.
> > > >>
> > > >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com>
> wrote:
> > > >> >
> > > >> > Sungwook,
> > > >> >
> > > >> > What's the column family permission? You probably want to do
> > > something
> > > >> > like this to give r/w permissions:
> > > >> >
> > > >> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> > > >> > -readperm 'u:root|u:mapr'
> > > >> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> > > >> > -writeperm 'u:root|u:mapr'
> > > >> >
> > > >> > -James
> > > >> >
> > > >> >
> > > >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> > > >> >
> > > >> >> Querying maprdb, I got this error.
> > > >> >>
> > > >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from
> excel
> > > >> limit
> > > >> >> 2;
> > > >> >> Query failed: Failure while setting up Foreman.
> > > >> >>
> > > >> >> Error: exception while executing query: Failure while executing
> > > query.
> > > >> >> (state=,code=0)
> > > >> >>
> > > >> >>
> > > >> >> What's going on?
> > > >> >> Drillbit reads the column family information correctly, just does
> > not
> > > >> go
> > > >> >> to
> > > >> >> columns.
> > > >> >> Thanks,
> > > >> >>
> > > >> >> Sungwook
> > > >> >>
> > > >> >>
> > > >> >
> > > >>
> > > >> --
> > > >> Steven Phillips
> > > >> Software Engineer
> > > >>
> > > >> mapr.com
> > > >>
> > > >
> > > >
> > >
> >
>
Re: maprdb setting up foreman error
Posted by Aman Sinha <as...@maprtech.com>.
The assertion at the bottom of the stack indicates that the row count for
the HBase table was found as negative.
One of the info messages indicates 'TableStatsCalculator - Region size
calculation disabled.'
What is the value of your exec.hbase.scan.sizecalculator.enabled setting
in sys.options ?
Even with this disabled, I would think you should not see the assertion, so
you are probably hitting a bug....perhaps Aditya will have input on this.
On Mon, Dec 15, 2014 at 2:48 PM, Jinfeng Ni <ji...@gmail.com> wrote:
>
> The log shows this is query planner error, when it tries to apply the
> optimizer rule : DrillPushProjIntoScan.
>
> java.lang.AssertionError: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
> Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
> independent_vars=$2),
> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
>
> On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
> >
> > Hi,
> >
> > Do you have some comment on this yet?
> >
> > Thanks,
> >
> > Sungwook
> >
> >
> > On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <sy...@maprtech.com>
> wrote:
> >
> > >
> > > Hi,
> > >
> > > Sorry for delayed response, was traveling.
> > > Can you take a look at the log?
> > >
> > > Thanks,
> > >
> > > Sungwook
> > >
> > >
> > > 2014-12-12 19:02:24,849 [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
> > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> state :
> > > COMPLETED
> > > 2014-12-12 19:02:24,906 [UserServer-1] WARN
> > > o.a.d.exec.work.foreman.QueryStatus - Update running or pending query
> > > state : PENDING
> > > 2014-12-12 19:02:24,974 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation
> > > disabled.
> > > 2014-12-12 19:02:24,984 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > > ERROR o.a.drill.exec.work.foreman.Foreman - Error
> > > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up Foreman.
> > > java.lang.AssertionError: Internal error: Error while applying rule
> > > DrillPushProjIntoScan, args
> > >
> >
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> > > rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > > excel])]
> > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at
> > >
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at
> > >
> >
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at
> > >
> >
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> > >
> >
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred
> while
> > > applying rule DrillPushProjIntoScan
> > > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > ... 12 common frames omitted
> > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source)
> ~[na:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > Caused by: java.lang.reflect.InvocationTargetException: null
> > > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
> > > ... 26 common frames omitted
> > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> > >
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > ... 30 common frames omitted
> > > Caused by: java.lang.reflect.InvocationTargetException: null
> > > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
> > > ... 34 common frames omitted
> > > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > ... 38 common frames omitted
> > > Caused by: java.lang.reflect.InvocationTargetException: null
> > > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > at
> > >
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> > > ~[optiq-core-0.9-drill-r8.jar:na]
> > > ... 45 common frames omitted
> > > 2014-12-12 19:02:24,985 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query
> state :
> > > FAILED
> > > 2014-12-12 19:02:24,999 [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.190.22.16:51773
> > >
> > >
> > >
> > > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
> > sphillips@maprtech.com>
> > > wrote:
> > >
> > >> You need to look at the drillbit logs to see what the problem is. We
> > can't
> > >> diagnose this without that information.
> > >>
> > >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com> wrote:
> > >> >
> > >> > Sungwook,
> > >> >
> > >> > What's the column family permission? You probably want to do
> > something
> > >> > like this to give r/w permissions:
> > >> >
> > >> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> > >> > -readperm 'u:root|u:mapr'
> > >> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> > >> > -writeperm 'u:root|u:mapr'
> > >> >
> > >> > -James
> > >> >
> > >> >
> > >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> > >> >
> > >> >> Querying maprdb, I got this error.
> > >> >>
> > >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel
> > >> limit
> > >> >> 2;
> > >> >> Query failed: Failure while setting up Foreman.
> > >> >>
> > >> >> Error: exception while executing query: Failure while executing
> > query.
> > >> >> (state=,code=0)
> > >> >>
> > >> >>
> > >> >> What's going on?
> > >> >> Drillbit reads the column family information correctly, just does
> not
> > >> go
> > >> >> to
> > >> >> columns.
> > >> >> Thanks,
> > >> >>
> > >> >> Sungwook
> > >> >>
> > >> >>
> > >> >
> > >>
> > >> --
> > >> Steven Phillips
> > >> Software Engineer
> > >>
> > >> mapr.com
> > >>
> > >
> > >
> >
>
Re: maprdb setting up foreman error
Posted by Jinfeng Ni <ji...@gmail.com>.
The log shows this is query planner error, when it tries to apply the
optimizer rule : DrillPushProjIntoScan.
java.lang.AssertionError: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:
Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,
independent_vars=$2),
rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
On Mon, Dec 15, 2014 at 2:29 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> Hi,
>
> Do you have some comment on this yet?
>
> Thanks,
>
> Sungwook
>
>
> On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> >
> > Hi,
> >
> > Sorry for delayed response, was traveling.
> > Can you take a look at the log?
> >
> > Thanks,
> >
> > Sungwook
> >
> >
> > 2014-12-12 19:02:24,849 [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
> > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
> > COMPLETED
> > 2014-12-12 19:02:24,906 [UserServer-1] WARN
> > o.a.d.exec.work.foreman.QueryStatus - Update running or pending query
> > state : PENDING
> > 2014-12-12 19:02:24,974 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation
> > disabled.
> > 2014-12-12 19:02:24,984 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > ERROR o.a.drill.exec.work.foreman.Foreman - Error
> > 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up Foreman.
> > java.lang.AssertionError: Internal error: Error while applying rule
> > DrillPushProjIntoScan, args
> >
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> > rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> > excel])]
> > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> > net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> > net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at
> >
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at
> >
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at
> >
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> >
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred while
> > applying rule DrillPushProjIntoScan
> > at org.eigenbase.util.Util.newInternal(Util.java:750)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> > org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > ... 12 common frames omitted
> > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source) ~[na:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> > org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > Caused by: java.lang.reflect.InvocationTargetException: null
> > at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
> > ... 26 common frames omitted
> > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> >
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> > at
> >
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > ... 30 common frames omitted
> > Caused by: java.lang.reflect.InvocationTargetException: null
> > at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
> > ... 34 common frames omitted
> > Caused by: java.lang.reflect.UndeclaredThrowableException: null
> > at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > ... 38 common frames omitted
> > Caused by: java.lang.reflect.InvocationTargetException: null
> > at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > at
> >
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> > ~[optiq-core-0.9-drill-r8.jar:na]
> > ... 45 common frames omitted
> > 2014-12-12 19:02:24,985 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> > WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
> > FAILED
> > 2014-12-12 19:02:24,999 [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.190.22.16:51773
> >
> >
> >
> > On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <
> sphillips@maprtech.com>
> > wrote:
> >
> >> You need to look at the drillbit logs to see what the problem is. We
> can't
> >> diagnose this without that information.
> >>
> >> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com> wrote:
> >> >
> >> > Sungwook,
> >> >
> >> > What's the column family permission? You probably want to do
> something
> >> > like this to give r/w permissions:
> >> >
> >> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> >> > -readperm 'u:root|u:mapr'
> >> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> >> > -writeperm 'u:root|u:mapr'
> >> >
> >> > -James
> >> >
> >> >
> >> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> >> >
> >> >> Querying maprdb, I got this error.
> >> >>
> >> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel
> >> limit
> >> >> 2;
> >> >> Query failed: Failure while setting up Foreman.
> >> >>
> >> >> Error: exception while executing query: Failure while executing
> query.
> >> >> (state=,code=0)
> >> >>
> >> >>
> >> >> What's going on?
> >> >> Drillbit reads the column family information correctly, just does not
> >> go
> >> >> to
> >> >> columns.
> >> >> Thanks,
> >> >>
> >> >> Sungwook
> >> >>
> >> >>
> >> >
> >>
> >> --
> >> Steven Phillips
> >> Software Engineer
> >>
> >> mapr.com
> >>
> >
> >
>
Re: maprdb setting up foreman error
Posted by Sungwook Yoon <sy...@maprtech.com>.
Hi,
Do you have some comment on this yet?
Thanks,
Sungwook
On Sun, Dec 14, 2014 at 8:34 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> Hi,
>
> Sorry for delayed response, was traveling.
> Can you take a look at the log?
>
> Thanks,
>
> Sungwook
>
>
> 2014-12-12 19:02:24,849 [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
> WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
> COMPLETED
> 2014-12-12 19:02:24,906 [UserServer-1] WARN
> o.a.d.exec.work.foreman.QueryStatus - Update running or pending query
> state : PENDING
> 2014-12-12 19:02:24,974 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> INFO o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation
> disabled.
> 2014-12-12 19:02:24,984 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> ERROR o.a.drill.exec.work.foreman.Foreman - Error
> 1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up Foreman.
> java.lang.AssertionError: Internal error: Error while applying rule
> DrillPushProjIntoScan, args
> [rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
> rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
> excel])]
> at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
> [drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred while
> applying rule DrillPushProjIntoScan
> at org.eigenbase.util.Util.newInternal(Util.java:750)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 12 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source) ~[na:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
> ~[optiq-core-0.9-drill-r8.jar:na]
> Caused by: java.lang.reflect.InvocationTargetException: null
> at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
> ... 26 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
> ~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
> at
> org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 30 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
> at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
> ... 34 common frames omitted
> Caused by: java.lang.reflect.UndeclaredThrowableException: null
> at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 38 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
> at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
> ~[optiq-core-0.9-drill-r8.jar:na]
> at
> org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
> ~[optiq-core-0.9-drill-r8.jar:na]
> ... 45 common frames omitted
> 2014-12-12 19:02:24,985 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
> WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
> FAILED
> 2014-12-12 19:02:24,999 [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.190.22.16:51773
>
>
>
> On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <sp...@maprtech.com>
> wrote:
>
>> You need to look at the drillbit logs to see what the problem is. We can't
>> diagnose this without that information.
>>
>> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com> wrote:
>> >
>> > Sungwook,
>> >
>> > What's the column family permission? You probably want to do something
>> > like this to give r/w permissions:
>> >
>> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
>> > -readperm 'u:root|u:mapr'
>> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
>> > -writeperm 'u:root|u:mapr'
>> >
>> > -James
>> >
>> >
>> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
>> >
>> >> Querying maprdb, I got this error.
>> >>
>> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel
>> limit
>> >> 2;
>> >> Query failed: Failure while setting up Foreman.
>> >>
>> >> Error: exception while executing query: Failure while executing query.
>> >> (state=,code=0)
>> >>
>> >>
>> >> What's going on?
>> >> Drillbit reads the column family information correctly, just does not
>> go
>> >> to
>> >> columns.
>> >> Thanks,
>> >>
>> >> Sungwook
>> >>
>> >>
>> >
>>
>> --
>> Steven Phillips
>> Software Engineer
>>
>> mapr.com
>>
>
>
Re: maprdb setting up foreman error
Posted by Sungwook Yoon <sy...@maprtech.com>.
Hi,
Sorry for delayed response, was traveling.
Can you take a look at the log?
Thanks,
Sungwook
2014-12-12 19:02:24,849 [5ac94869-8e24-4f26-8fd0-b9df6f96b7a1:frag:0:0]
WARN o.a.d.exec.work.foreman.QueryStatus - Update finished query state :
COMPLETED
2014-12-12 19:02:24,906 [UserServer-1] WARN
o.a.d.exec.work.foreman.QueryStatus - Update running or pending query
state : PENDING
2014-12-12 19:02:24,974 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman] INFO
o.a.d.e.s.hbase.TableStatsCalculator - Region size calculation disabled.
2014-12-12 19:02:24,984 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman]
ERROR o.a.drill.exec.work.foreman.Foreman - Error
1c924dfc-8d60-470e-b328-641997f76a4f: Failure while setting up Foreman.
java.lang.AssertionError: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#13473:ProjectRel.NONE.ANY([]).[](child=rel#13472:Subset#0.ENUMERABLE.ANY([]).[],row_key=$0,dependent_vars=$1,independent_vars=$2),
rel#13464:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[maprdb,
excel])]
at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:246)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:661)
~[optiq-core-0.9-drill-r8.jar:na]
at
net.hydromatic.optiq.tools.Programs$RuleSetProgram.run(Programs.java:165)
~[optiq-core-0.9-drill-r8.jar:na]
at
net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:273)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:155)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:134)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:132)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:385)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:204)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-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 occurred while
applying rule DrillPushProjIntoScan
at org.eigenbase.util.Util.newInternal(Util.java:750)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:143)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:210)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch(DrillPushProjIntoScan.java:85)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
~[optiq-core-0.9-drill-r8.jar:na]
... 12 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy94.getNonCumulativeCost(Unknown Source) ~[na:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getNonCumulativeCost(RelMetadataQuery.java:125)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.getCost(VolcanoPlanner.java:926)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements0(RelSubset.java:333)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.RelSubset.propagateCostImprovements(RelSubset.java:314)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.asd(VolcanoPlanner.java:1635)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1568)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:837)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:860)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1750)
~[optiq-core-0.9-drill-r8.jar:na]
Caused by: java.lang.reflect.InvocationTargetException: null
at sun.reflect.GeneratedMethodAccessor23.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-r8.jar:na]
... 26 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.apache.drill.exec.planner.common.DrillProjectRelBase.computeSelfCost(DrillProjectRelBase.java:64)
~[drill-java-exec-0.6.0.r2-incubating-SNAPSHOT-rebuffed.jar:0.6.0.r2-incubating-SNAPSHOT]
at
org.eigenbase.rel.metadata.RelMdPercentageOriginalRows.getNonCumulativeCost(RelMdPercentageOriginalRows.java:159)
~[optiq-core-0.9-drill-r8.jar:na]
... 30 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at sun.reflect.GeneratedMethodAccessor39.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-r8.jar:na]
... 34 common frames omitted
Caused by: java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy96.getRowCount(Unknown Source) ~[na:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:96)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:62)
~[optiq-core-0.9-drill-r8.jar:na]
... 38 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at sun.reflect.GeneratedMethodAccessor24.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-r8.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-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.validateResult(RelMetadataQuery.java:387)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:97)
~[optiq-core-0.9-drill-r8.jar:na]
at org.eigenbase.relopt.volcano.RelSubset.getRows(RelSubset.java:135)
~[optiq-core-0.9-drill-r8.jar:na]
at
org.eigenbase.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:103)
~[optiq-core-0.9-drill-r8.jar:na]
... 45 common frames omitted
2014-12-12 19:02:24,985 [1a48def7-07e1-4250-b42f-4f3f8012fba6:foreman] WARN
o.a.d.exec.work.foreman.QueryStatus - Update finished query state : FAILED
2014-12-12 19:02:24,999 [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.190.22.16:51773
On Fri, Dec 12, 2014 at 10:16 AM, Steven Phillips <sp...@maprtech.com>
wrote:
> You need to look at the drillbit logs to see what the problem is. We can't
> diagnose this without that information.
>
> On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com> wrote:
> >
> > Sungwook,
> >
> > What's the column family permission? You probably want to do something
> > like this to give r/w permissions:
> >
> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> > -readperm 'u:root|u:mapr'
> > maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> > -writeperm 'u:root|u:mapr'
> >
> > -James
> >
> >
> > On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> >
> >> Querying maprdb, I got this error.
> >>
> >> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel
> limit
> >> 2;
> >> Query failed: Failure while setting up Foreman.
> >>
> >> Error: exception while executing query: Failure while executing query.
> >> (state=,code=0)
> >>
> >>
> >> What's going on?
> >> Drillbit reads the column family information correctly, just does not go
> >> to
> >> columns.
> >> Thanks,
> >>
> >> Sungwook
> >>
> >>
> >
>
> --
> Steven Phillips
> Software Engineer
>
> mapr.com
>
Re: maprdb setting up foreman error
Posted by Steven Phillips <sp...@maprtech.com>.
You need to look at the drillbit logs to see what the problem is. We can't
diagnose this without that information.
On Fri, Dec 12, 2014 at 9:49 AM, James Sun <js...@maprtech.com> wrote:
>
> Sungwook,
>
> What's the column family permission? You probably want to do something
> like this to give r/w permissions:
>
> maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> -readperm 'u:root|u:mapr'
> maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
> -writeperm 'u:root|u:mapr'
>
> -James
>
>
> On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
>
>> Querying maprdb, I got this error.
>>
>> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel limit
>> 2;
>> Query failed: Failure while setting up Foreman.
>>
>> Error: exception while executing query: Failure while executing query.
>> (state=,code=0)
>>
>>
>> What's going on?
>> Drillbit reads the column family information correctly, just does not go
>> to
>> columns.
>> Thanks,
>>
>> Sungwook
>>
>>
>
--
Steven Phillips
Software Engineer
mapr.com
Re: maprdb setting up foreman error
Posted by James Sun <js...@maprtech.com>.
Sungwook,
What's the column family permission? You probably want to do
something like this to give r/w permissions:
maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
-readperm 'u:root|u:mapr'
maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
-writeperm 'u:root|u:mapr'
-James
On 12/12/14, 6:44 AM, Sungwook Yoon wrote:
> Querying maprdb, I got this error.
>
> 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from excel limit 2;
> Query failed: Failure while setting up Foreman.
>
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
>
>
> What's going on?
> Drillbit reads the column family information correctly, just does not go to
> columns.
> Thanks,
>
> Sungwook
>