Support Questions

Find answers, ask questions, and share your expertise

Hive/Hbase Table Select query Error

when executing query select * from table_name limit 10; getting below exception

Exception in thread "main" java.lang.NoSuchMethodError:;Lorg/apache/hadoop/hbase/security/User;Lorg/apache/hadoop/mapreduce/Job;)V at org.apache.hadoop.hive.hbase.HBaseStorageHandler.addHBaseDelegationToken( at org.apache.hadoop.hive.hbase.HBaseStorageHandler.configureTableJobProperties( at org.apache.hadoop.hive.hbase.HBaseStorageHandler.configureInputJobProperties( at org.apache.hadoop.hive.ql.plan.PlanUtils.configureJobPropertiesForStorageHandler( at org.apache.hadoop.hive.ql.plan.PlanUtils.configureInputJobPropertiesForStorageHandler( at org.apache.hadoop.hive.ql.optimizer.SimpleFetchOptimizer$FetchData.convertToWork( at org.apache.hadoop.hive.ql.optimizer.SimpleFetchOptimizer$FetchData.access$000( at org.apache.hadoop.hive.ql.optimizer.SimpleFetchOptimizer.optimize( at org.apache.hadoop.hive.ql.optimizer.SimpleFetchOptimizer.transform( at org.apache.hadoop.hive.ql.optimizer.Optimizer.optimize( at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal( at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal( at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze( at org.apache.hadoop.hive.ql.Driver.compile( at org.apache.hadoop.hive.ql.Driver.compile( at org.apache.hadoop.hive.ql.Driver.compileInternal( at org.apache.hadoop.hive.ql.Driver.runInternal( at at at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd( at org.apache.hadoop.hive.cli.CliDriver.processCmd( at org.apache.hadoop.hive.cli.CliDriver.processLine( at org.apache.hadoop.hive.cli.CliDriver.executeDriver( at at org.apache.hadoop.hive.cli.CliDriver.main( at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke( at sun.reflect.DelegatingMethodAccessorImpl.invoke( at java.lang.reflect.Method.invoke( at at org.apache.hadoop.util.RunJar.main(

Need Help to Solve this.


Super Guru
@sajid mohammed

Just to confirm the process, you created an external table in Hive using HBaseStorageHandler and used required properties like, hbase.mapred.output.outputtable, or hbase.column.mapping?

If this is correct and all worked fine, then you need to make sure you have correct jar files for your HBase and hive version. Is this using HDP sandbox?


Created Internal table in Hive using HBaseSerDe, HBaseStorageHandler using properties like, hbase.mapred.output.outputtable, or hbase.column.mapping

And i have correct jar files for HBase and Hive version. i am using HDP

the same query working on one edge node, in other edge node it is giving above error.

Super Guru
@sajid mohammed

I would think that your edge node where this is failing does not have same jar files as your edge node where everything is working.

I still think this is mismatched HBase libraries.

@mqureshi I just checked in both the nodes, all hive and hbase jars are the same, still didnt get why it is failed.

@sajid mohammed

Yes I believe that might be the issue as stated by @mqureshi. Please trying adding the jar in the node in which you are working to execute the commands. "add jar <Jar path with name>;"