Re: metastore with mysql

2011-02-24 Thread hive1
Hello, thank you for your quick responses! Seems my root mysql user wasn't really 'root'. "GRANT ALL PRIVILEGES ..." with a new user got it running. however I don't understand it, because my root user has the same privileges as the new one... but whatever. Malte -- NEU: FreePhone - kostenlos

Re: metastore with mysql

2011-02-23 Thread sangeetha s
Did you add the mysql jar properly in the classpath? Before that are you able to create and populate tables using Hive CLI? If the HiveCLI is working correctly,then try to modify your hive-site.xml as follows. //hive-site.xml hive.metastore.local true javax.jdo.option.ConnectionURL jd

Re: metastore with mysql

2011-02-23 Thread Edward Capriolo
On Wed, Feb 23, 2011 at 7:28 AM, wrote: > Hello, > > I am running hive with a hadoop mini cluster and want to switch to mysql as a > metastore because I need multiple connections at same time (not sure if this > will work at all). I tried the local metastore config. The DB and two tables > in

metastore with mysql

2011-02-23 Thread hive1
Hello, I am running hive with a hadoop mini cluster and want to switch to mysql as a metastore because I need multiple connections at same time (not sure if this will work at all). I tried the local metastore config. The DB and two tables in mysql are created but I receive an error. If I commen