Exporting and importing Hive metadata in the Metastore cluster

Written by

Updated at October 13, 2024

Getting started

Create a service account named my-account with the storage.uploader role.
Create a static access key for the my-account service account. Save the ID and secret key: you will need them for work with Yandex Object Storage.
Configure the network and create a Metastore cluster. When creating, specify the static access key parameters.

Warning

Data export and import are only available in Metastore clusters with a static access key.
Create a bucket named my-bucket in Object Storage. It will store the metadata file for import and export.
Grant a READ and WRITE permission to the my-account service account for the bucket named my-bucket.

Management console

Go to the folder page and select Yandex MetaData Hub.
In the left-hand panel, select the Metastore page.
Click for the cluster you need and select Export.
In the window that opens, specify:
- The bucket named my-bucket the cluster data will be exported to.
- The .sql file the cluster data will be written to. If a file with that name already exists, it will be overwritten.
Click Export.

Before importing, upload the .sql file with metadata into my-bucket. For information on how to prepare a file and how the import process works, see Transferring data between Yandex Data Processing clusters using Metastore.

To import data to a cluster:

Management console

Go to the folder page and select Yandex MetaData Hub.
In the left-hand panel, select the Metastore page.
Click for the cluster you need and select Import.
In the window that opens, select the bucket named my-bucket and the file the cluster data will be imported from.
Click Import.