Re: Trouble using mysql metastore

2011-03-03 Thread Bennie Schut
Yeah we have it on the lib folder of hive "mysql-connector-java-5.1.6.jar" but I also find the name mysql.jar a bit suspicious. Just download from http://www.mysql.com/downloads/connector/j/ and move it somewhere on the classpath On 03/02/2011 08:42 PM, Viral Bajaria wrote: This definitely lo

Re: Trouble using mysql metastore

2011-03-02 Thread Viral Bajaria
This definitely looks like a CLASSPATH error. Where did you get the mysql.jar from ? Can you open it up and make sure that it includes the com.mysql.jdbc.Driver namespace ? I am guessing the mysql.jar is not the one that you need. you can download a new one from the mysql website. To be clear, I

Re: Trouble using mysql metastore

2011-03-02 Thread Ajo Fod
Hi Bennie, Thanks for the response ! I had CLASSPATH set to include /usr/share/java/mysql.jar ... in addition, I just copied the mysql.jar to the lib directory of hive. I still get the same bug. Any other ideas? Thanks, -Ajo On Wed, Mar 2, 2011 at 7:01 AM, Bennie Schut wrote: > Usually t

Re: Trouble using mysql metastore

2011-03-02 Thread Bennie Schut
Usually this is caused by not having the mysql jdbc driver on the classpath (it's not default included in hive). Just put the mysql jdbc driver in the hive folder under "lib/" On 03/02/2011 03:15 PM, Ajo Fod wrote: I've checked the mysql connection with a separate java file with the same string