Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Hive/Hbase integration Problem


Copy link to this message
-
Hive/Hbase integration Problem
shashwat shriparv 2011-11-29, 08:03
I have followed
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration my hbase
is running finne

here is the screen shot attachments

for integrating hive with hbase. as i a trying to create table i am getting
following error
shashwat@ubuntu:~/hive$ bin/hive --auxpath
/home/shashwat/hive/lib/hive_hbase-handler-0.7.1.jar,/home/shashwat/hive/lib/hbase-0.89.0.jar,/home/shashwat/hive/lib/zookeeper-3.3.1.jar
-hiveconf hbase.master=ubuntu.ubuntu-domain:60000

WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please
use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties
files.
Hive history
file=/tmp/shashwat/hive_job_log_shashwat_201111291314_1466942791.txt

hive> CREATE EXTERNAL TABLE hbase_table_1(key int, value string) STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES ("hbase.table.name"
= "xyz");

FAILED: Error in metadata:
MetaException(message:org.apache.hadoop.hbase.MasterNotRunningException:
ubuntu.ubuntu-domain:58680
    at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getMaster(HConnectionManager.java:394)
    at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:83)
    at
org.apache.hadoop.hive.hbase.HBaseStorageHandler.getHBaseAdmin(HBaseStorageHandler.java:74)
    at
org.apache.hadoop.hive.hbase.HBaseStorageHandler.preCreateTable(HBaseStorageHandler.java:158)
    at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:344)
    at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470)
    at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3146)
    at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213)
    at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
    at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
    at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
    at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

Its giving error as hmaster not running but i have looked through jps
Hmaster is running fine

what is the probable cause for this. what exactly should be the host file
configuration for pseudo distribution ??

Thanks and regards
Shashwat