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.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 [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>
