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

["Loïc RODIER (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14336611#comment-14336611 ] 

Loïc RODIER commented on HIVE-6698:
-----------------------------------

Hi,

I have the same issue using HDP 2.2 (which should embed hive 0.14).
I cannot find patch lines in my hcat.py nor on https://apache.googlesource.com/hive/+/trunk/hcatalog/bin/hcat.py
???




> 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
>             Fix For: 0.14.0
>
>         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.3.4#6332)