AnsweredAssumed Answered

Error accessing "HBase" (MapR-DB JSON Table) from HUE

Question asked by chris.crawford on Mar 30, 2018
Latest reply on Apr 2, 2018 by chris.crawford

MapR Team,

 

Using HUE -> Data Browsers -> HBase, when I navigate to my MapR-DB table and click on it, I receive the following error:

Api Error: java.io.IOException: java.lang.RuntimeException: Error occurred while instantiating com.mapr.fs.hbase.HTableImpl11

 

Based on the logs, it appears that Hbase APIs cannot be used for MapR-DB JSON tables.  Am I reading this correctly? (and if so, the error message should be a little more informative )

 

And perhaps a better questions is if there is a good way to access my MapR-DB JSON tables from Hive.  Seems like Drill is the best option? but what if I wanted to do a join across a dataset that was in the Hive Metastore and a MapR-DB JSON Table?

 

Thanks!

 

==> java.lang.UnsupportedOperationException: HBase api's cannot be used for MapR-DB JSON tabletype tables..
java.io.IOException: java.lang.RuntimeException: Error occurred while instantiating com.mapr.fs.hbase.HTableImpl11.
==> java.lang.UnsupportedOperationException: HBase api's cannot be used for MapR-DB JSON tabletype tables..
        at org.apache.hadoop.hbase.client.mapr.GenericHFactory.handleIOException(GenericHFactory.java:62)
        at org.apache.hadoop.hbase.client.HTable.initIfMapRTableImpl(HTable.java:526)
        at org.apache.hadoop.hbase.client.HTable.initIfMapRTable(HTable.java:473)
        at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:230)
        at com.mapr.fs.hbase.MapRClusterConnectionImpl.getTable(MapRClusterConnectionImpl.java:174)
        at com.mapr.fs.hbase.MapRClusterConnectionImpl.getTable(MapRClusterConnectionImpl.java:53)
        at org.apache.hadoop.hbase.util.ConnectionCache.getTable(ConnectionCache.java:154)
        at org.apache.hadoop.hbase.thrift.ThriftServerRunner$HBaseHandler.getTable(ThriftServerRunner.java:742)
        at org.apache.hadoop.hbase.thrift.ThriftServerRunner$HBaseHandler.getTable(ThriftServerRunner.java:746)
        at org.apache.hadoop.hbase.thrift.ThriftServerRunner$HBaseHandler.getColumnDescriptors(ThriftServerRunner.java:1739)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.hadoop.hbase.thrift.HbaseHandlerMetricsProxy.invoke(HbaseHandlerMetricsProxy.java:67)
        at com.sun.proxy.$Proxy9.getColumnDescriptors(Unknown Source)
        at org.apache.hadoop.hbase.thrift.generated.Hbase$Processor$getColumnDescriptors.getResult(Hbase.java:4153)
        at org.apache.hadoop.hbase.thrift.generated.Hbase$Processor$getColumnDescriptors.getResult(Hbase.java:4137)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at org.apache.hadoop.hbase.thrift.TBoundedThreadPoolServer$ClientConnnection.run(TBoundedThreadPoolServer.java:289)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)

Outcomes