This is your mysql id issue. I'm guessing that your id '*APP*'@'*dwdb002*. internal.xxxxxxx.com' domain is not same like you do in mysql user table.
Try this: show grants for '*APP*'@'*dwdb002*.internal.xxxxxxx.com' and this will tell you if you've defined it right. Meanwhile you can have a separate hive id like hive@'%' in your mysql for testing. And you can mention id and pswd in the hive-site.xml file. -Sanjeev On Fri, Jun 3, 2011 at 4:52 PM, Ayon Sinha <ayonsi...@yahoo.com> wrote: > 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 <http://www.flickr.com/photos/ayonsinha/> > Also check out my Blog for answers to commonly asked > questions.<http://dailyadvisor.blogspot.com> > > > -- Sanjeev Sagar
