question Issue: Create HBASE table on Hive in Archives of Support Questions (Read Only)

Issue: Create HBASE table on Hive

MasterOfPuppets — Fri, 16 Sep 2022 11:23:30 GMT

Hi there.

The following statement fails to create HBASE table on hive:

CREATE TABLE passwd_hbase(userid STRING, uid INT, shell STRING)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,passwd:uid,passwd:shell');

Error:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.RuntimeException: java.lang.NullPointerException
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:208)
at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:320)

Any idea ?

Thx

x sRe: Issue: Create HBASE table on Hive

jmspaggi — Fri, 31 Mar 2017 22:09:49 GMT

Hi,

Your syntax seems to be incomplete. Where do you detail which HBase table your Hive table should be map to? Usually this is done using the TBLPROPERTIES field...

JMS

Re: x sRe: Issue: Create HBASE table on Hive

MasterOfPuppets — Sat, 01 Apr 2017 00:41:25 GMT

Still failing using :

CREATE TABLE passwd_hbase(userid STRING, uid INT, shell STRING)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,passwd:uid,passwd:shell')

TBLPROPERTIES("hbase.table.name" = "mytable");

Caused by: java.lang.NullPointerException
   at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.getMetaReplicaNodes(ZooKeeperWatcher.java:489)
   at org.apache.hadoop.hbase.zookeeper.MetaTableLocator.blockUntilAvailable(MetaTableLocator.java:549)
   at org.apache.hadoop.hbase.client.ZooKeeperRegistry.getMetaRegionLocation(ZooKeeperRegistry.java:61)

when executing list command in hbase it throws:

ERROR: The node /hbase is not in ZooKeeper. It should have been written by the master. Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch with the one configured in the master.

Re: x sRe: Issue: Create HBASE table on Hive

mathieu.d — Fri, 07 Apr 2017 09:44:38 GMT

Does HBase works ?

Because with what you said (ERROR: The node /hbase is not in ZooKeeper.) I have the feeling that your HBase cluster is not working properly.

You should fix that first.

Re: x sRe: Issue: Create HBASE table on Hive

MasterOfPuppets — Fri, 07 Apr 2017 12:41:54 GMT

In fact the issue was that hbase was not installed.