Home | About | Sematext search-lucene.com search-hadoop.com
 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®