incubator-hcatalog-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vandana Ayyalasomayajula <>
Subject Re: Could not set up Hcatalog.
Date Mon, 11 Jun 2012 16:25:19 GMT
Hi Steven,

The METASTORE_PORT and the portnum ( or server_port)  are the same. If you look at the script
"", the server_port has a default value of "9933" which
you can override by specifying in the command line. Also, the script does uses the same value
for METASTORE_PORT variable also.

You need to set the hive.metastore.uris=thrift://<hostname>:<server_port>


On Jun 8, 2012, at 12:08 PM, Steven Truong wrote:

Hi Alan,

I am using 0.4.0.

I am consulting this for my
hcatalog installation.

I am very confused with this sentence: You will also need your hadoop_home, the directory
where you have Hadoop installed, and the port number you wish HCatalog to operate on which
you will use to set portnum.

share/hcatalog/scripts/ -r root -d dbroot -h hadoop_home -p portnum

hive.metastore.uris thrift://hostname:portnum where hostname is the name of the machine hosting
the Thrift server, and portnum is the port number used above in the installation script.

What is the different between this portnum mentioned in the install.hml and the Hive metastore
server port and what I should put in hive-site.xml for
hive.metastore.uris thrift://<>
hive.metastore.uris thrift://<>

in my case the Hive metastore server listens on 9083 and the Hive thrift server listen on

Because the installation script create so
>> cat hcatalog/
>> ROOT=/usr/local/hive
>> DBROOT=/usr/lib/hive/lib/
>> USER=hive
>> HADOOP_HOME=/usr/lib/hadoop-0.20
>> export METASTORE_PORT=9083              <---- portnum.

So the metatstore_port and the hcatalog server port are the same or different?

Thanks in advance,
On Fri, Jun 8, 2012 at 8:43 AM, Alan Gates <<>>
> Which version of HCatalog are you using?  Assuming you're using 0.4.0 (the latest release),
once you've started Hive's metastore service there's nothing more to start for HCatalog. 
You Pig or MR jobs will need to have the directory that contains hive-site.xml in their path
so they can find the config file.
> Alan.
> On Jun 7, 2012, at 6:05 PM, Steven Truong wrote:
>> Dear all,
>> I am new to Hive and Hcatalog and in the process of setting one up.
>> Currently Hive, mysql, Hcatalog are all in the same machine.  Hadoop
>> cluster is somewhere else in other machines. mysql connector is in
>> /usr/lib/hive/lib.  Hive was installed in /usr/lib/hive.
>> I created hive user and /usr/local/hive and install hcatalog in /usr/local/hive
>> I started the metatstore server as:
>> ./hive --config ../conf --service metastore
>> and saw this  "metastore.HiveMetaStore: Started the new metaserver on
>> port [9083]..."
>> I also started the Hive Thrift server and saw this: " Starting hive
>> server on port 10000"
>> cat hcatalog/
>> ROOT=/usr/local/hive
>> DBROOT=/usr/lib/hive/lib/
>> USER=hive
>> HADOOP_HOME=/usr/lib/hadoop-0.20
>> export METASTORE_PORT=9083
>> Here are some parameters in hive-site.xml
>> hive.metastore.local true
>> hive.metastore.uris thrift://<>
>> I started hcatalog but it did not work at all:
>> HIVE_HOME=/usr/lib/hive/ sbin/ start
>> Started metastore server init, testing if initialized correctly...
>> Metastore startup failed, see /usr/local/hive/sbin/../var/log/hcat.err
>> cat var/log/hcat.err
>> Exception in thread "main" java.lang.NullPointerException
>>       at org.apache.hadoop.hive.metastore.HiveMetaStore.main(
>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>       at sun.reflect.NativeMethodAccessorImpl.invoke(
>>       at sun.reflect.DelegatingMethodAccessorImpl.invoke(
>>       at java.lang.reflect.Method.invoke(
>>       at org.apache.hadoop.util.RunJar.main(
>> It seems like Hcatalog could not connect to the metastore.
>> Could you please tell me what I did wrong?
>> Thanks,
>> Steven.

Vandana Ayyalasomayajula

View raw message