hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ayon Sinha <ayonsi...@yahoo.com>
Subject changing metastore of Hive to MySQL problem
Date Fri, 03 Jun 2011 23:52:49 GMT
Hi,
I am trying to change the metastore from Derby to Mysql and following the directions.
We changed the hive-site.xml to point to the right jdbc connection URL. The jars are available
in the classpath. It seems to pick up the local box's hostname and try default username and
password.
 Neither the XML change nor the command line arg is affecting it. 

I have this in xml file
<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>hive.metastore.local</name>
  <value>true</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://internaldb001.internal.xxxxx.com/hive_metastore</value>
</property>

<property>
  <name>javax.job.option.ConnectionUserName</name>
  <value>app</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>xxxxxxxx</value>
</property>



hive -hiveconf  javax.jdo.option.ConnectionURL=jdbc:mysql://internaldb001/hive_metastore
-e "show tables"
Hive history file=/tmp/ayon/hive_job_log_ayon_201106032335_873482984.txt
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Access denied for user 'APP'@'dwdb002.internal.xxxxxxx.com'
(using password: YES)
NestedThrowables:
java.sql.SQLException: Access denied for user 'APP'@'dwdb002.internal.shopkick.com' (using
password: YES)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
 
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
Mime
View raw message