Re: changing metastore of Hive to MySQL problem

2011-06-03 Thread Viral Bajaria
--------- > *From:* sanjeev sagar > *To:* user@hive.apache.org; Ayon Sinha > *Sent:* Friday, June 3, 2011 4:58 PM > *Subject:* Re: changing metastore of Hive to MySQL problem > > This is your mysql id issue. I'm guessing that your id '*APP*'@'*dwdb002*. > in

Re: changing metastore of Hive to MySQL problem

2011-06-03 Thread Ayon Sinha
y, June 3, 2011 4:58 PM Subject: Re: changing metastore of Hive to MySQL problem This is your mysql id issue. I'm guessing that your id 'APP'@'dwdb002.internal.xxx.com'  domain is not same like you do in mysql user table.  Try this: show grants for 'AP

Re: changing metastore of Hive to MySQL problem

2011-06-03 Thread sanjeev sagar
This is your mysql id issue. I'm guessing that your id '*APP*'@'*dwdb002*. internal.xxx.com' domain is not same like you do in mysql user table. Try this: show grants for '*APP*'@'*dwdb002*.internal.xxx.com' and this will tell you if you've defined it right. Meanwhile you can have a sep