question Re: No database is being detecting in import-hive.sh in Support Questions

No database is being detecting in import-hive.sh

ashish_inamdar — Tue, 11 Aug 2020 03:58:02 GMT

Hi,

I am trying to import a hive table that has an MYSQL DB as metastore into Atlas by using import-hive.sh command but even when I explicitly pass the database name it fails to detect the same.

@Shelton,

Can you please suggest on this?

The above snippet shows AMBDB existing in the MySQL DB.

Re: No database is being detecting in import-hive.sh

Shelton — Tue, 11 Aug 2020 12:32:43 GMT

@ashish_inamdar

Have you enabled ranger hive plugin? If so then ensure the Atlas user has a Ranger policy that allows the user to correct database and tables permissions. Because once Ranger hive plugin has been enabled you MUST use Ranger for authorization.
Hope that helps

Re: No database is being detecting in import-hive.sh

ashish_inamdar — Fri, 14 Aug 2020 04:24:11 GMT

@Shelton,

We were trying to see if database and tables created in MySQL are imported through import-hive.sh. What we saw that import-hive.sh only imports the database and tables created through hive shell and not MySQL. Once we started creating the tables through the hive shell, the import-hive.sh started importing them and the same was seen in Atlas as well.