Drill 1.9 Null pointer Exception

Anas A Wed, 01 Mar 2017 23:38:39 -0800

Hi,

I am trying to work with Apache drill 1.9 to access HBase and Hive tables am
getting a nullpointer Exception. The same table I queried using drill 1.8
and it worked fine without any issues. Attaching the Error .Please suggest.


 

 

 

ERROR :

 

select * from twitter_test_nlp limit 10;

Error: SYSTEM ERROR: NullPointerException

 

 

[Error Id: 8c747c22-4f7f-4ba7-b30c-cb5fb3614a41 on
master01.trinitymobility.local:31010]

 

  (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
during fragment initialization: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#980:LogicalProject.NONE.ANY([]).[](input=rel#979:Subset#0.ENUMERABLE.AN
Y([]).[],id=$0,dates=$1,times=$2,time_zone=$3,users=$4,profile_image_url=$5,
latitude=$6,longitude=$7,twitter_handle=$8,sentiment=$9,language=$10,lang_pr
obability=$11,text=$12),
rel#964:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[hive, social,
twitter_test_nlp])]

    org.apache.drill.exec.work.foreman.Foreman.run():281

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.AssertionError) Internal error: Error while applying
rule DrillPushProjIntoScan, args
[rel#980:LogicalProject.NONE.ANY([]).[](input=rel#979:Subset#0.ENUMERABLE.AN
Y([]).[],id=$0,dates=$1,times=$2,time_zone=$3,users=$4,profile_image_url=$5,
latitude=$6,longitude=$7,twitter_handle=$8,sentiment=$9,language=$10,lang_pr
obability=$11,text=$12),
rel#964:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[hive, social,
twitter_test_nlp])]

    org.apache.calcite.util.Util.newInternal():792

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():251

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.AssertionError) Internal error: Error occurred while
applying rule DrillPushProjIntoScan

    org.apache.calcite.util.Util.newInternal():792

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():150

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.reflect.UndeclaredThrowableException) null

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.reflect.InvocationTargetException) null

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.reflect.UndeclaredThrowableException) null

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.reflect.InvocationTargetException) null

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.reflect.UndeclaredThrowableException) null

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.reflect.InvocationTargetException) null

    sun.reflect.GeneratedMethodAccessor6.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ReflectiveRelMetadataProvider$1$1.invoke():1
82

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (org.apache.drill.common.exceptions.DrillRuntimeException)
java.io.IOException: Failed to get numRows from HiveTable

    org.apache.drill.exec.store.hive.HiveScan.getScanStats():233

    org.apache.drill.exec.physical.base.AbstractGroupScan.getScanStats():79

    org.apache.drill.exec.planner.logical.DrillScanRel.computeSelfCost():159

 
org.apache.calcite.rel.metadata.RelMdPercentageOriginalRows.getNonCumulative
Cost():165

    sun.reflect.GeneratedMethodAccessor6.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ReflectiveRelMetadataProvider$1$1.invoke():1
82

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.io.IOException) Failed to get numRows from HiveTable

    org.apache.drill.exec.store.hive.HiveMetadataProvider.getStats():113

    org.apache.drill.exec.store.hive.HiveScan.getScanStats():224

    org.apache.drill.exec.physical.base.AbstractGroupScan.getScanStats():79

    org.apache.drill.exec.planner.logical.DrillScanRel.computeSelfCost():159

 
org.apache.calcite.rel.metadata.RelMdPercentageOriginalRows.getNonCumulative
Cost():165

    sun.reflect.GeneratedMethodAccessor6.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ReflectiveRelMetadataProvider$1$1.invoke():1
82

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.RuntimeException) java.lang.NullPointerException

 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries():208

    org.apache.hadoop.hbase.client.ClientScanner.call():320

    org.apache.hadoop.hbase.client.ClientScanner.nextScanner():295

 
org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction
():160

    org.apache.hadoop.hbase.client.ClientScanner.<init>():155

    org.apache.hadoop.hbase.client.HTable.getScanner():821

    org.apache.hadoop.hbase.client.MetaScanner.metaScan():193

    org.apache.hadoop.hbase.client.MetaScanner.metaScan():89

    org.apache.hadoop.hbase.client.MetaScanner.allTableRegions():324

    org.apache.hadoop.hbase.client.HRegionLocator.getAllRegionLocations():88

    org.apache.hadoop.hbase.util.RegionSizeCalculator.init():94

    org.apache.hadoop.hbase.util.RegionSizeCalculator.<init>():81

    org.apache.hadoop.hbase.mapreduce.TableInputFormatBase.getSplits():256

 
org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplitsInternal():4
99

    org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplits():432

    org.apache.drill.exec.store.hive.HiveMetadataProvider$1.run():253

   org.apache.drill.exec.store.hive.HiveMetadataProvider$1.run():241

    java.security.AccessController.doPrivileged():-2

    javax.security.auth.Subject.doAs():422

    org.apache.hadoop.security.UserGroupInformation.doAs():1657

 
org.apache.drill.exec.store.hive.HiveMetadataProvider.splitInputWithUGI():24
1

 
org.apache.drill.exec.store.hive.HiveMetadataProvider.getTableInputSplits():
128

    org.apache.drill.exec.store.hive.HiveMetadataProvider.getStats():96

    org.apache.drill.exec.store.hive.HiveScan.getScanStats():224

    org.apache.drill.exec.physical.base.AbstractGroupScan.getScanStats():79

    org.apache.drill.exec.planner.logical.DrillScanRel.computeSelfCost():159

 
org.apache.calcite.rel.metadata.RelMdPercentageOriginalRows.getNonCumulative
Cost():165

    sun.reflect.GeneratedMethodAccessor6.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ReflectiveRelMetadataProvider$1$1.invoke():1
82

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745

  Caused By (java.lang.NullPointerException) null

 
org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.getMetaReplicaNodes():395

 
org.apache.hadoop.hbase.zookeeper.MetaTableLocator.blockUntilAvailable():553

 
org.apache.hadoop.hbase.client.ZooKeeperRegistry.getMetaRegionLocation():61

 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.l
ocateMeta():1186

 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.l
ocateRegion():1153

 
org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLo
cations():300

    org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call():155

    org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call():59

 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries():200

    org.apache.hadoop.hbase.client.ClientScanner.call():320

    org.apache.hadoop.hbase.client.ClientScanner.nextScanner():295

 
org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction
():160

    org.apache.hadoop.hbase.client.ClientScanner.<init>():155

    org.apache.hadoop.hbase.client.HTable.getScanner():821

    org.apache.hadoop.hbase.client.MetaScanner.metaScan():193

    org.apache.hadoop.hbase.client.MetaScanner.metaScan():89

    org.apache.hadoop.hbase.client.MetaScanner.allTableRegions():324

    org.apache.hadoop.hbase.client.HRegionLocator.getAllRegionLocations():88

    org.apache.hadoop.hbase.util.RegionSizeCalculator.init():94

    org.apache.hadoop.hbase.util.RegionSizeCalculator.<init>():81

    org.apache.hadoop.hbase.mapreduce.TableInputFormatBase.getSplits():256

 
org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplitsInternal():4
99

    org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplits():432

    org.apache.drill.exec.store.hive.HiveMetadataProvider$1.run():253

    org.apache.drill.exec.store.hive.HiveMetadataProvider$1.run():241

    java.security.AccessController.doPrivileged():-2

    javax.security.auth.Subject.doAs():422

    org.apache.hadoop.security.UserGroupInformation.doAs():1657

 
org.apache.drill.exec.store.hive.HiveMetadataProvider.splitInputWithUGI():24
1

 
org.apache.drill.exec.store.hive.HiveMetadataProvider.getTableInputSplits():
128

    org.apache.drill.exec.store.hive.HiveMetadataProvider.getStats():96

    org.apache.drill.exec.store.hive.HiveScan.getScanStats():224

    org.apache.drill.exec.physical.base.AbstractGroupScan.getScanStats():79

    org.apache.drill.exec.planner.logical.DrillScanRel.computeSelfCost():159

 
org.apache.calcite.rel.metadata.RelMdPercentageOriginalRows.getNonCumulative
Cost():165

    sun.reflect.GeneratedMethodAccessor6.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ReflectiveRelMetadataProvider$1$1.invoke():1
82

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.ChainedRelMetadataProvider$ChainedInvocation
Handler.invoke():109

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

    sun.reflect.GeneratedMethodAccessor4.invoke():-1

    sun.reflect.DelegatingMethodAccessorImpl.invoke():43

    java.lang.reflect.Method.invoke():498

 
org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocation
Handler.invoke():132

    com.sun.proxy.$Proxy69.getNonCumulativeCost():-1

 
org.apache.calcite.rel.metadata.RelMetadataQuery.getNonCumulativeCost():115

    org.apache.calcite.plan.volcano.VolcanoPlanner.getCost():1112

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements0():363

 
org.apache.calcite.plan.volcano.RelSubset.propagateCostImprovements():344

    org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet():1827

    org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl():1760

    org.apache.calcite.plan.volcano.VolcanoPlanner.register():1017

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1037

    org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered():1940

    org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo():138

    org.apache.calcite.plan.RelOptRuleCall.transformTo():213

    org.apache.drill.exec.planner.logical.DrillPushProjIntoScan.onMatch():90

    org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():228

    org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():808

    org.apache.calcite.tools.Programs$RuleSetProgram.run():303

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():404

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():343

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:240

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel()
:290

 
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123

    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97

    org.apache.drill.exec.work.foreman.Foreman.runSQL():1008

    org.apache.drill.exec.work.foreman.Foreman.run():264

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745 (state=,code=0)

 

Thanks & Regards

Anas A,
Trinity Mobility Pvt. Ltd | Bangalore | +91-7736368236

 <http://www.trinityiot.in/> 

 

 <https://www.facebook.com/trinitymobilityltd>
<http://www.linkedin.com/company/trinity-mobility>

Drill 1.9 Null pointer Exception

Reply via email to