Grokbase Groups Hive user May 2011
FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedMay 19, '11 at 8:00a
activeMay 20, '11 at 2:53p
posts2
users1
websitehive.apache.org

1 user in discussion

Labtrax: 2 posts

People

Translate

site design / logo © 2022 Grokbase