Troubleshooting in Apache Hive™ Metastore
This section describes issues you may encounter in the service and how to troubleshoot them.
Error when creating a database in Apache Hive™ Metastore
The error occurs if you use the following syntax to create a database:
CREATE DATABASE IF NOT EXISTS <DB_name>;
Solution
Apache Hive™ 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 attaching 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.
Apache® and Apache Hive™ are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries.