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

Switch to Plain View
Hive >> mail # user >> Whirr+Hive


Hello all,
   I have created a cluster on EC2 using Whirr-0.7.0 that has
hadoop-0.20.2 and hbase-hbase-0.89.20100924..Now I am trying to use
hbase through hive but I am facing some problems.whenever I am trying
to create a table in hbase using hive I am getting the following error
-

hive> CREATE 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.ZooKeeperConnectionException:
org.apache.hadoop.hbase.ZooKeeperConnectionException:
org.apache.zookeeper.KeeperException$ConnectionLossException:
KeeperErrorCode = ConnectionLoss for /hbase
       at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getZooKeeperWatcher(HConnectionManager.java:985)
       at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.setupZookeeperTrackers(HConnectionManager.java:301)
       at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.<init>(HConnectionManager.java:292)
       at org.apache.hadoop.hbase.client.HConnectionManager.getConnection(HConnectionManager.java:155)
       at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:79)
       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)
Caused by: org.apache.hadoop.hbase.ZooKeeperConnectionException:
org.apache.zookeeper.KeeperException$ConnectionLossException:
KeeperErrorCode = ConnectionLoss for /hbase
       at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.<init>(ZooKeeperWatcher.java:147)
       at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getZooKeeperWatcher(HConnectionManager.java:983)
       ... 23 more
Caused by: org.apache.zookeeper.KeeperException$ConnectionLossException:
KeeperErrorCode = ConnectionLoss for /hbase
       at org.apache.zookeeper.KeeperException.create(KeeperException.java:90)
       at org.apache.zookeeper.KeeperException.create(KeeperException.java:42)
       at org.apache.zookeeper.ZooKeeper.create(ZooKeeper.java:637)
       at org.apache.hadoop.hbase.zookeeper.ZKUtil.createAndFailSilent(ZKUtil.java:886)
       at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.<init>(ZooKeeperWatcher.java:133)
       ... 24 more
)

Need some help.Many thanks.

Regards,
    Mohammad Tariq