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

Switch to Plain View
Hive, mail # user - Re: Problem to get hive with remote mysql metastore working


+
demian rosas 2013-04-03, 21:22
Copy link to this message
-
Re: Problem to get hive with remote mysql metastore working
Sanjay Subramanian 2013-04-03, 21:24
U owe all of us a Jamba Juice for not checking if the service was up  - LOL
Happy Hiving
sanjay
From: demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Wednesday, April 3, 2013 2:22 PM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>, "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Problem to get hive with remote mysql metastore working

Hi all,

Just to let you know.

The problem was that the metastore service was down.

I was starting it with

sudo service hive-metastore start

and even when there was a message saying that the service was started, it was not.

I have started the service with

hive --service metastore

and now, at least can execute the "show tables" command in hive CLI and get the "OK".

Thanks a lot to all of you guys.

Cheers,
Demian
On 3 April 2013 12:56, Mark Grover <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Adding back cdh-user

Hi Demian,
Can you check the status of your metastore service?

sudo service hive-metastore status

If it is down, can you post the logs from under
/var/log/hive/hive-metastore.log?

Mark

On Wed, Apr 3, 2013 at 12:47 PM, demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
> Hi Mark,
>
> Thanks for the hint.
>
> Have changed my hive-site.xml file, now it is:
>
> <property>
>   <name>javax.jdo.option.ConnectionURL</name>
>
> <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
>   <description>JDBC connect string for a JDBC metastore</description>
> </property>
>
> <property>
>   <name>javax.jdo.option.ConnectionDriverName</name>
>   <value>com.mysql.jdbc.Driver</value>
>   <description>Driver class name for a JDBC metastore</description>
> </property>
>
> <property>
>   <name>javax.jdo.option.ConnectionUserName</name>
>   <value>drosash</value>
> </property>
>
> <property>
>   <name>javax.jdo.option.ConnectionPassword</name>
>   <value>drosash</value>
> </property>
>
> <property>
>   <name>datanucleus.autoCreateSchema</name>
>   <value>false</value>
> </property>
>
> <property>
>   <name>datanucleus.fixedDatastore</name>
>   <value>true</value>
> </property>
>
> <property>
> exit
>   <name>hive.metastore.uris</name>
>   <value>thrift://10.240.81.72:9083<http://10.240.81.72:9083></value>
>   <description>IP address (or fully-qualified domain name) and port of the
> metastore host</description>
> </property>
>
> <property>
>   <name>hive.metastore.warehouse.dir</name>
>   <value>/user/hive/warehouse</value>
> </property>
>
> <property>
>   <name>hive.server.thrift.port</name>
>    <value>10000</value>
> </property>
>
>
> Then I ran "show tables" in hive CLI with debug messages. Th output is this:
>
> hive> show tables;
> 13/04/03 12:41:53 INFO ql.Driver: <PERFLOG method=Driver.run>
> 13/04/03 12:41:53 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
> 13/04/03 12:41:53 INFO ql.Driver: <PERFLOG method=compile>
> 13/04/03 12:41:53 INFO parse.ParseDriver: Parsing command: show tables
> 13/04/03 12:41:53 INFO parse.ParseDriver: Parse Completed
> 13/04/03 12:41:53 INFO ql.Driver: Semantic Analysis Completed
> 13/04/03 12:41:53 INFO exec.ListSinkOperator: Initializing Self 0 OP
> 13/04/03 12:41:53 INFO exec.ListSinkOperator: Operator 0 OP initialized
> 13/04/03 12:41:53 INFO exec.ListSinkOperator: Initialization Done 0 OP
> 13/04/03 12:41:53 INFO ql.Driver: Returning Hive schema:
> Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from
> deserializer)], properties:null)
> 13/04/03 12:41:53 INFO ql.Driver: </PERFLOG method=compile
> start=1365018113270 end=1365018113666 duration=396>
> 13/04/03 12:41:53 INFO ql.Driver: <PERFLOG method=Driver.execute>
> 13/04/03 12:41:53 INFO ql.Driver: Starting command: show tables
> 13/04/03 12:41:53 INFO ql.Driver: </PERFLOG method=TimeToSubmit
CONFIDENTIALITY NOTICE
=====================This email message and any attachments are for the exclusive use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message along with any attachments, from your computer system. If you are the intended recipient, please be advised that the content of this message is subject to access, review and disclosure by the sender's Email System Administrator.