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)
