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?