hive hbase auxpath jars

[labtrax <hi...@gmx.de>]

Hello,

some questions about the hbase/hive integration:
I am running a cloudera hadoop/hbase cluster. I want to get access with hive to hbase tables.
This actually works fine with cli like
sudo -u hdfs hive --auxpath /usr/lib/hive/lib/hive-hbase-handler-0.7.0-cdh3u0.jar,/usr/lib/hive/lib/hbase-0.90.1-cdh3u0.jar,/usr/lib/hive/lib/zookeeper-3.3.1.jar
The zookeeper quorum is defined in the hife-site.xml.

If I run it without the jars config like
sudo -u hdfs 
or in standalone mode with
sudo -u hdfs hive --auxpath /usr/lib/hive/lib/hive-hbase-handler-0.7.0-cdh3u0.jar,/usr/lib/hive/lib/hbase-0.90.1-cdh3u0.jar,/usr/lib/hive/lib/zookeeper-3.3.1.jar --service hiveserver
for (map/reduced) queries I do get
java.io.FileNotFoundException: File does not exist: /usr/lib/hive/lib/hive-hbase-handler-0.7.0-cdh3u0.jar
        at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:546)
        at org.apache.hadoop.filecache.DistributedCache.getFileStatus(DistributedCache.java:185)
        at org.apache.hadoop.filecache.TrackerDistributedCacheManager.determineTimestamps(TrackerDistributedCacheManager.java:804)
        at org.apache.hadoop.mapred.JobClient.copyAndConfigureFiles(JobClient.java:746)
        at org.apache.hadoop.mapred.JobClient.copyAndConfigureFiles(JobClient.java:637)
        at org.apache.hadoop.mapred.JobClient.access$300(JobClient.java:170)
        at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:848)
        at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)

Seems hive is not very interested my hive-site.xml property:
<property>
        <name>hive.aux.jars.path</name>
        <value>/usr/lib/hive/lib/hive-hbase-handler-0.7.0-cdh3u0.jar,/usr/lib/hive/lib/hbase-0.90.1-cdh3u0.jar,/usr/lib/hive/lib/zookeeper-3.3.1.jar</value>
</property>
I already tried different configs like file:///... or file:///${HIVE_HOME}.
Any clues?

Thanks in advance
labtrax
-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de