---
title: "saveExternalHiveMetaStore"
slug: "cli-vhadoop-saveexternalhivemetastore"
tags: ["Cloud Hadoop", "VPC", "Cloud DB for MySQL"]
updated: 2026-10-08T05:11:27Z
published: 2026-10-08T05:11:27Z
canonical: "cli.ncloud-docs.com/cli-vhadoop-saveexternalhivemetastore"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://cli.ncloud-docs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# saveExternalHiveMetaStore

Available in VPC

Integrate a Cloud Hadoop Hive metastore with Cloud DB for MySQL.

## Syntax

The `saveExternalHiveMetaStore` syntax is as follows:

```
./ncloud vhadoop saveExternalHiveMetaStore \
    --cloudHadoopInstanceNo <cloud-hadoop-instance-no> \
    --cloudMysqlInstanceNo <cloud-mysql-instance-no> \
    --cloudMysqlUserName <cloud-mysql-user-name> \
    --cloudMysqlUserPassword <cloud-mysql-user-password> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]
```

## Options

This section describes the options available when running `saveExternalHiveMetaStore`.

### Required options

The following options are required for `saveExternalHiveMetaStore`.

| Options | Type | Required | Description |
| --- | --- | --- | --- |
| `--cloudHadoopInstanceNo` | String | Required | Cluster instance number - See [getCloudHadoopInstanceList](/docs/en/cli-vhadoop-getcloudhadoopinstancelist). |
| `--cloudMysqlInstanceNo` | String | Required | Cloud DB for MySQL instance number - See [getCloudHadoopMysqlInstanceList](/docs/en/cli-vhadoop-getcloudhadoopmysqlinstancelist). |
| `--cloudMysqlUserName` | String | Required | Database user ID - See [getCloudHadoopMysqlUserList](/docs/en/cli-vhadoop-getcloudhadoopmysqluserlist). |
| `--cloudMysqlUserPassword` | String | Required | Database user account password - Enter 8-20 characters, including English letters, numbers, and special characters. - The special characters `&apos;` `&quot;` ``` `&amp;` `+` `/` `\` and spaces can't be used. |

### Common options

For information about the options common to all `vhadoop` subcommands, see [Cloud Hadoop (VPC) options](/docs/en/cli-vhadoop#%EC%98%B5%EC%85%98).

## Examples

If the Hive metastore integration request is successful, the result of the request is returned.

### Command

The command example is as follows:

```
./ncloud vhadoop saveExternalHiveMetaStore \
    --cloudHadoopInstanceNo 34567890 \
    --cloudMysqlInstanceNo 56789012 \
    --cloudMysqlUserName hiveuser \
    --cloudMysqlUserPassword Examplepw123! \
    --regionCode KR \
    --output json
```

### Output

The output example is as follows:

```
{
  "saveExternalHiveMetaStoreResponse": {
    "requestId": "3a4b5c6d-1e2f-0789-3456-abcdef0789ab",
    "returnCode": "0",
    "returnMessage": "success"
  }
}
```