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.
