Troubleshooting in Hive Metastore

This section describes issues you may encounter in the service and how to troubleshoot them.

• Error when creating a database
• No permission error when connecting a service account to a cluster

Error when creating a database in Hive MetastoreError when creating a database in Hive Metastore

The error occurs if you use the following syntax to create a database:

CREATE DATABASE IF NOT EXISTS <DB_name>;

Solution
Metastore does not allow creating a database or table in Hive: they are stored in a Yandex Object Storage bucket linked to a Yandex Data Processing cluster. To create a database, use the following syntax:

CREATE DATABASE IF NOT EXISTS <DB_name> LOCATION <DB_location>;

In the LOCATION parameter, specify the path to the bucket and the database in it in the following format: s3a://<bucket_name>/<folder_name>/<DB_name>. Specifying a folder is optional; however, objects will load into a folder faster than into the bucket root.

No permission error when connecting a service account to the clusterNo permission error when connecting a service account to the cluster

Error message:

ERROR: rpc error: code = PermissionDenied desc = you do not have permission to access the requested service account or service account does not exist

This error occurs if you link a service account to a cluster while creating or modifying it.

Solution
Assign the iam.serviceAccounts.user role or higher to your Yandex Cloud account.