Respected Sir,

Componet used:-
-Ubuntu 12.04, hive(0.9.0), hbase(0.94.3), hadoop(0.20.2)-single-node,
zookeeper-3.4.3, guava-11.0.2, hive-hbase-handler-0.9.0

tutorials:-https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration

steps
1) start hadoop,
2) start hbase-master
3) start hiveserver
4) start hive shell using --auxpath parameters as in tutorial
 (all works without errors -   when I jps,-->
JobTracker,HMaster,DataNode,NameNode,SecondaryNameNode,TaskTracker,Jps)

    hbase(main):001:0> status
    1 servers, 0 dead, 2.0000 average load
On hive shell I create can create table as

    CREATE TABLE IF NOT EXISTS familia (id_familia INT,fk_veiculo
INT,fk_cliente INT,nome STRING) ROW FORMAT delimited fields terminated by
',' STORED AS TEXTFILE;
    load data local inpath
'/home/trendwise/hive_data/tables_csv/familia.csv' overwrite into table
familia;

but when I do below query,nothing shown,just cursor blinking.I waited for
long time,then error shown

    CREATE TABLE hbase_familia_1 (key int, id_familia int, fk_veiculo
INT,fk_cliente INT,nome STRING)
    STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
    WITH SERDEPROPERTIES("hbase.columns.mapping" = ":key, cf1:id_familia,
cf2:fk_veiculo,cf3:fk_cliente, cf4:nome")
    TBLPROPERTIES ("hbase.table.name" = "hbase_familia");

I did `list` on hbase shell,which didn't show any table what I tried ?

Error:-

    FAILED: Error in metadata:
MetaException(message:org.apache.hadoop.hbase.MasterNotRunningException:
Retried 10 times
at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:127)
at
org.apache.hadoop.hive.hbase.HBaseStorageHandler.getHBaseAdmin(HBaseStorageHandler.java:73)
at
org.apache.hadoop.hive.hbase.HBaseStorageHandler.preCreateTable(HBaseStorageHandler.java:147)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:398)
at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:538)
at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3305)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:242)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
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

hbase-site.xml

    <property>
     <name>hbase.rootdir</name>
     <value>hdfs://localhost:54310/hbase</value>
    </property>
    <property>
     <name>dfs.replication</name>
     <value>1</value>
    </property>
    <property>
     <name>hbase.zookeeper.property.dataDir</name>
     <value>/home/trendwise/hadoop/hbase-0.94.3/hbase_dataDir</value>
    </property>
    <property>
     <name>hbase.zookeeper.property.clientPort</name>
     <value>2222</value>
     <description>Property from ZooKeeper's config zoo.cfg.
     </description>
    </property>
    <property>
     <name>hbase.zookeeper.quorum</name>
     <value>localhost</value>
     <description></description>
    </property>
    <property>
     <name>hbase.cluster.distributed</name>
     <value>true</value>
     <description></description>
    </property>
core-site.xml (Hadoop)

<configuration>
<property>
  <name>hadoop.tmp.dir</name>
  <value>/home/trendwise/hadoop/hadoop-0.20.2/hadoop_temp/</value>
  <description>A base for other temporary directories.</description>
</property>

<property>
  <name>fs.default.name</name>
  <value>hdfs://localhost:54310</value>
  <description>The name of the default file system.  A URI whose
  scheme and authority determine the FileSystem implementation.  The
  uri's scheme determines the config property (fs.SCHEME.impl) naming
  the FileSystem implementation class.  The uri's authority is used to
  determine the host, port, etc. for a filesystem.</description>
</property>

<property>
  <name>fs.inmemory.size.mb </name>
  <value>200 </value>
 </property>
<property>
  <name>io.sort.factor</name>
  <value>100 </value>
 </property>
<property>
  <name>io.sort.mb</name>
  <value>200 </value>
 </property>
<property>
  <name>io.file.buffer.size</name>
  <value>131072 </value>
 </property>

hive-site.xml (attached)

Hi Sagar,

If you do a jps after the error shows, do you still see HMaster in the
list?  It is possible that the Master came up for a bit and then died.

Ted.

On Tue, Jan 8, 2013 at 5:24 PM, sagar nikam <[EMAIL PROTECTED]> wrote:

> MasterNotRunningException

Respected sir,

I am using Ubuntu-12.04, Hadoop-1.04,Hive 0.010

I stopped/interrupted hiveserver using Ctrl+z in terminal where hiveserver
is running.
but after that whenever I am going to start hive or hiveserver,it gives
below error

FAILED: Error in metadata: MetaException(message:Got exception:
java.net.ConnectException Call to masternode/192.168.1.12:19100 failed on
connection exception: java.net.ConnectException: Connection refused)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

I no where mention port 19100 for Hadoop in any config file.but why its
calling to that ?
My hadoop is running on 192.168.1.12/54310(Namenode)
I searched in hive-site.xml file about 19100, but not found anything.

Is it a bug ?

Everytime I am formatting namenode, remove metastore_db folder & reload
data into hive.
So this painstaking exercise I am doing now.
What will be the solution for this ?