Trying to connect to Hive db from Ranger ui . I have provided the full screenshot below with reference to the error message. Can someone please help with this.
where DriverName = 'com.mysql.jdbc.Driver'
ConnectionURL = 'jdbc:mysql://localhost:3306/metastore_sqldb'
UserName = 'hive'
Password = 'hive'
Then when I do Test Connection ,
Error Msg:Unable to retrieve any databases using given parameters.You can still save the repository and start creating policies, but you would not be able to use autocomplete for resource names. Check ranger_admin.log for more info.
But I am able to open the Hive shell and view the default database and tables created in it.
When I user username and password as 'admin' , I get:
Unable to retrieve any files using given parameters, You can still save the repository and start creating policies, but you would not be able to use autocomplete for resource names. Check ranger_admin.log for more info.
Hadoop version : 2.7.3
Hive : 3.1.2
Ranger-Admin version: 2.1.0-SNAPSHOT
I made change as stated in https://git-wip-us.apache.org/repos/asf?p=ranger.git;a=commitdiff;h=ed6488361660aecbba1d006f26218e51...
and rebuilt apache-ranger, copied the binaries and restarted. But face the same issue when trying to connect with hive plugin to hiveserver
I have stated Hadoop, Hive and Ranger versions, and the patch that I had applied but still facing the same issue. What version do you recommend me to use for each one of them.
Can you please help me to understand, eagerly waiting to hear from you soon.