Remote Hive metastore: Spark connecting to local installation not remote metastore

65 Views Asked by At

I have configured remote Hive metastore on RDS running MySQL. EMR creates fine and is able to connect to RDS instance on 3306 port, but when i create some table it creates it in default database.

To verify this, I checked what Hive CLI connects to and to my surprise even that connects to local db and shows only default database.

I have set correct javax.jdo.option.* properties ConnectionURL, ConnectionDriverName, ConnectionUserName, ConnectionPassword in hive-site.xml

Any idea where I could be wrong?

0

There are 0 best solutions below