Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Trying to create an HBase Table using HCatalog


Copy link to this message
-
RE: Trying to create an HBase Table using HCatalog
That worked!  Thanks you very much!

From: D K [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 25, 2014 12:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Trying to create an HBase Table using HCatalog

Can you change the storage handler classname in your query from "org.apache.hive.hcatalog.hbase.HBaseHCatStorageHandler" to "org.apache.hcatalog.hbase.HBaseHCatStorageHandler" and try?
-Deepesh

On Tue, Jun 24, 2014 at 12:40 PM, Carlotta Hicks <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
I am submitting the following with HCatalog:

CREATE TABLE
usTestHB (fname string, lname string, cname string)
STORED BY 'org.apache.hive.hcatalog.hbase.HBaseHCatStorageHandler '
TBLPROPERTIES (
'hbase.table.name<http://hbase.table.name>'='usTest',
'hbase.columns.mapping'='fname:fname, lname:lname, cname:cname'
);

but I keep getting this exception:

SemanticException java.io.IOException: Error in loading storage handler.org.apache.hive.hcatalog.hbase.HBaseHCatStorageHandler

I’ve found patch HIVE-6698, but this seems to be geared towards using HCatalog on windows.  I am on unix.

Can anyone provide assistance with creating an HBase table using HCatalog?

HCatalog – 0.12.0
HBase – 0.96.1.1

Thanks,

Carlotta Hicks
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>

SAS® … THE POWER TO KNOW®

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB