I am sorry, I forget starting hadoop first, but the error messages are
confusing too :)
Xiaobo Gu
From: ransom.hezhiqiang
Date: 2012-05-12 15:46
To: user@hive.apache.org; 'guxiaobo1982'
Subject: RE: Where should I put JDBC drivers for metastore service
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://
192.168.72.1:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
If it doen't work, show the log in /tmp/{user.name}/hive.log
Best regards
Ransom.
-----Original Message-----
From: Xiaobo Gu [mailto:guxiaobo1...@gmail.com]
Sent: Saturday, May 12, 2012 3:37 PM
To: user
Subject: Where should I put JDBC drivers for metastore service
Hi,
I put mysql-connector-java-5.1.20-bin.jar into $HIVE_HOME/lib, and
configurations in hive-site.xml are
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.72.1:3306/hive</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>root</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>xiaobo</value>
<description>password to use against metastore database</description>
</property>
When I execute a test HQL in hive, got the following error message:
hive> CREATE TABLE records (year STRING, temperature INT, quality INT)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '\t';
FAILED: Error in metadata: MetaException(message:Could not connect to meta
store using any of the URIs provided)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
hive>
