[jira] [Created] (HIVE-6698) hcat.py script does not correctly load the hbase storage handler jars

["Deepesh Khandelwal (JIRA)" <ji...@apache.org>]

Deepesh Khandelwal created HIVE-6698:
----------------------------------------

             Summary: hcat.py script does not correctly load the hbase storage handler jars
                 Key: HIVE-6698
                 URL: https://issues.apache.org/jira/browse/HIVE-6698
             Project: Hive
          Issue Type: Bug
          Components: HCatalog
    Affects Versions: 0.13.0
            Reporter: Deepesh Khandelwal
            Assignee: Deepesh Khandelwal
         Attachments: HIVE-6698.patch

Currently queries using the HBaseHCatStorageHandler when run using hcat.py fail. Example query
{code}
create table pig_hbase_1(key string, age string, gpa string)
STORED BY 'org.apache.hcatalog.hbase.HBaseHCatStorageHandler'
TBLPROPERTIES ('hbase.columns.mapping'=':key,info:age,info:gpa');
{code}
Following error is seen in the hcat logs:
{noformat}
2014-03-18 08:25:49,437 ERROR ql.Driver (SessionState.java:printError(541)) - FAILED: SemanticException java.io.IOException: Error in loading storage handler.org.apache.hcatalog.hbase.HBaseHCatStorageHandler
org.apache.hadoop.hive.ql.parse.SemanticException: java.io.IOException: Error in loading storage handler.org.apache.hcatalog.hbase.HBaseHCatStorageHandler
	at org.apache.hive.hcatalog.cli.SemanticAnalysis.CreateTableHook.postAnalyze(CreateTableHook.java:208)
	at org.apache.hive.hcatalog.cli.SemanticAnalysis.HCatSemanticAnalyzer.postAnalyze(HCatSemanticAnalyzer.java:242)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:402)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:295)
	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:949)
	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:997)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:885)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:875)
	at org.apache.hive.hcatalog.cli.HCatDriver.run(HCatDriver.java:43)
	at org.apache.hive.hcatalog.cli.HCatCli.processCmd(HCatCli.java:259)
	at org.apache.hive.hcatalog.cli.HCatCli.processLine(HCatCli.java:213)
	at org.apache.hive.hcatalog.cli.HCatCli.main(HCatCli.java:172)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
Caused by: java.io.IOException: Error in loading storage handler.org.apache.hcatalog.hbase.HBaseHCatStorageHandler
	at org.apache.hive.hcatalog.common.HCatUtil.getStorageHandler(HCatUtil.java:432)
	at org.apache.hive.hcatalog.cli.SemanticAnalysis.CreateTableHook.postAnalyze(CreateTableHook.java:199)
	... 16 more
Caused by: java.lang.ClassNotFoundException: org.apache.hcatalog.hbase.HBaseHCatStorageHandler
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.apache.hive.hcatalog.common.HCatUtil.getStorageHandler(HCatUtil.java:426)
	... 17 more
{noformat}
The problem is that the hbaseStorageJar is incorrect with the merging of hcat into hive. Also as per HIVE-6695 we should add the HBASE_LIB in the classpath.



--
This message was sent by Atlassian JIRA
(v6.2#6252)