[ https://issues.apache.org/jira/browse/HIVE-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13943510#comment-13943510 ]
Sushanth Sowmyan commented on HIVE-6698: ---------------------------------------- Committed. Thanks, Deepesh! > 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)