Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB