whirr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrei Savu <savu.and...@gmail.com>
Subject Re: Error while integrating Hive and Hbase
Date Wed, 21 Dec 2011 19:17:30 GMT
It's a bit hard to debug unless you explain more about how you are setting
up Hive.

Here are some things you could try:

* make sure the ZooKeeper cluster is up and running after starting the
cluster by doing
 $ echo "ruok" | nc <zookeeper-host-ip> 2181; echo

* make sure Hive is using the right configuration files when
connecting to Hadoop & HBase

Can you share you setup scripts? Maybe by attaching them to:
https://issues.apache.org/jira/browse/WHIRR-343

-- Andrei

On Wed, Dec 21, 2011 at 8:51 PM, Mohammad Tariq <dontariq@gmail.com> wrote:
> Hello all,
>
>    I am trying to use Hbase and Hive together but facing some
> problem..Whenever I am trying to create a table in Hbase through 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
> )
>
> I am using Hive-0.7.1 and the version of Hbase provided by Whirr is
> 0.89/20100924.
>
> Regards,
>     Mohammad Tariq

Mime
View raw message