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
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
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
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