Oracle Cloud Infrastructure Documentation

Creating an External Metastore for a Cluster

Create an external metastore for a Big Data Service cluster.

Data Catalog provides a highly available and scalable metastore for Hive implementations. You can configure this Data Catalog metastore as an external metastore for a Big Data Service cluster.

To create an external metastore configuration for Big Data Service, you must have the permissions and policies to access and manage a valid Data Catalog metastore. For more prerequisites, see Integrating with Data Catalog External Hive Metastore.

Note

When you create an external metastore, the local metastore for the cluster becomes inactive and the new external Data Catalog metastore is activated.
    1. On the Clusters list page, select the cluster that you want to work with. If you need help finding the list page or the cluster, see Listing Clusters in a Compartment.
    2. On the Cluster details page, select Configurations.
    3. Under Metastore configurations, select Create external metastore configuration.
    4. In the Create external metastore configuration panel, enter the folliwing details: name of the external Data Catalog metastore that's available in the specified compartment for you to configure.
      • Metastore configuration name: A name for the external metastore configuration you want to create.
      • Metastore name compartment: Compartment that contains the external Data Catalog metastore.
      • Metastore name: Name of the external Data Catalog metastore .
      • API key:
      • API key passphrase: The API key's passphrase.You specified this value when you created the API key
      • Cluster admin password: the cluster administrator password for the cluster. You specified this value when you created the cluster.
    5. Select Create.

    After successful creation of the external metastore for the Big Data Service cluster, the local metastore for the cluster becomes inactive and the new external Data Catalog metastore is activated.

  • Use the oci bds bds-metastore-configuration create command and required parameters to create an external metastore.

    oci bds bds-metastore-configuration create --bds-api-key-id <bds_api_key_id> --bds-api-key-passphrase <bds_api_key_passphrase> --bds-instance-id <bds_instance_> --cluster-admin-password <cluster_admin_password> --metastore-id <metastore_id> [OPTIONS]

    For a complete list of flags and variable options for CLI commands, see the Command Line Reference for Big Data.

  • Use the CreateBdsMetastoreConfiguration operation to create an external metastore.