It looks like you are trying to query a hive table (backed by a hbase table) from drill. Can you try querying the same table from hive itself? I would also login to hbase and check whether the underlying table exists or not
On Thu, Mar 2, 2017 at 2:14 AM, Khurram Faraaz <[email protected]> wrote: > Can you please share your query and the type of data over which the query > is executed ? > > ________________________________ > From: Anas A <[email protected]> > Sent: Thursday, March 2, 2017 2:18:32 PM > To: [email protected] > Cc: [email protected]; 'Sushil' > Subject: RE: Drill 1.9 Null pointer Exception > > Hi Khurram, > Thanks for your response. The HBase and hive version is not changed , we > only updated the drill version to 1.9 . our requirement is to work with > Spatial queries which is supported from 1.9 . is there any way to fix the > issue. > > Thanks & Regards > Anas A, > Trinity Mobility Pvt. Ltd | Bangalore | +91-7736368236 > > > > > -----Original Message----- > From: Khurram Faraaz [mailto:[email protected]] > Sent: 02 March 2017 14:02 > To: [email protected] > Cc: [email protected]; 'Sushil' <[email protected]> > Subject: Re: Drill 1.9 Null pointer Exception > > Hi Anas, > > > Not sure what is causing the NPE, is your HBase version same as before ? > > > This assertion that you see in the stack trace below, was recently fixed in > DRILL-5040, you may want to try to latest available build Drill 1.10.0 > > > Caused by: java.lang.AssertionError: Internal error: Error while applying > rule DrillPushProjIntoScan, args > [rel#35532:LogicalProject.NONE.ANY([]).[](input=rel# > 35531:Subset#0.ENUMERABL > E.ANY([]).[],$f0=0), > rel#35516:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[dfs.tmp, > bfe2dad0-921a-4f06-9799-494ab8a7246d/851a124c-80a1- > 45e3-9496-d2562007911e])] > at org.apache.calcite.util.Util.newInternal(Util.java:792) > ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19] > at > org.apache.calcite.plan.volcano.VolcanoRuleCall. > onMatch(VolcanoRuleCall.java > :251) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19] > at > org.apache.calcite.plan.volcano.VolcanoPlanner. > findBestExp(VolcanoPlanner.ja > va:808) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19] > at > org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:303) > ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform( > Defau > ltSqlHandler.java:404) > ~[drill-java-exec-1.10.0-SNAPSHOT.jar:1.10.0-SNAPSHOT] > > > > Thanks, > > Khurram > > ________________________________ > From: Anas A <[email protected]> > Sent: Thursday, March 2, 2017 1:07:46 PM > To: [email protected] > Cc: [email protected]; 'Sushil' > Subject: Drill 1.9 Null pointer Exception > > 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.RpcRetryingCallerWithReadRepli > cas.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 > [148221140437883 (1)]<http://www.trinityiot.in/> > > [like_us_facebook]<https://www.facebook.com/trinitymobilityltd> > [follow_us_on_linkedin] <http://www.linkedin.com/company/trinity-mobility> > > > >
