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?