Problems with MetaStore

[Anja Gruenheid <an...@gatech.edu>]

Hi!

I'm trying to set up a test environment locally on my laptop and it 
works if I use the standard embedded derby driver. As soon as I add a 
hive-site.xml, I tried both MySQL and Derby with servers definitely 
running and the respective parameters set in that hive-site.xml, I get 
the following exception:

FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: 
Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. 
The driver has not received any packets from the server.
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications 
link failure

The last packet sent successfully to the server was 0 milliseconds ago. 
The driver has not received any packets from the server.
FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.DDLTask

If I switch back to the embedded driver by erasing hive-site and 
restarting hadoop, it works again.

Does anyone have any idea why that error occurs?

Thanks,
Anja

RE: Problems with MetaStore

["Christopher, Pat" <pa...@hp.com>]

That message is saying, 'found all drivers, trying to connect to specified metastore db. Can't'.

Check the following:
  - MySQL/Derby server running
  - correct ip/hostname specified (I've had troubles with dynamic ips)
  - userid/pwd exists on server and has correct grants
     - will need create database, create table, insert, update, select, delete

You shouldn't need to restart hadoop to test these changes or for swapping in a hive-site.xml, you should only need to restart hive.

If all of those are correct, shoot me your hive-site.xml and I'll take a look.

Pat

-----Original Message-----
From: Anja Gruenheid [mailto:anja.gruenheid@gatech.edu] 
Sent: Sunday, March 20, 2011 12:17 PM
To: user@hive.apache.org
Subject: Problems with MetaStore

Hi!

I'm trying to set up a test environment locally on my laptop and it 
works if I use the standard embedded derby driver. As soon as I add a 
hive-site.xml, I tried both MySQL and Derby with servers definitely 
running and the respective parameters set in that hive-site.xml, I get 
the following exception:

FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: 
Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. 
The driver has not received any packets from the server.
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications 
link failure

The last packet sent successfully to the server was 0 milliseconds ago. 
The driver has not received any packets from the server.
FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.DDLTask

If I switch back to the embedded driver by erasing hive-site and 
restarting hadoop, it works again.

Does anyone have any idea why that error occurs?

Thanks,
Anja