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

> ## 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.

# getCloudHadoopMysqlInstanceList

Available in VPC

Get Cloud DB for MySQL that can be integrated with a Hive metastore.

## Syntax

The `getCloudHadoopMysqlInstanceList` syntax is as follows:

```
./ncloud vhadoop getCloudHadoopMysqlInstanceList \
    --cloudHadoopInstanceNo <cloud-hadoop-instance-no> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]
```

## Options

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

### Required options

The following options are required for `getCloudHadoopMysqlInstanceList`.

| Options | Type | Required | Description |
| --- | --- | --- | --- |
| `--cloudHadoopInstanceNo` | String | Required | Cluster instance number - Only MySQL instances installed in the same VPC as the cluster can be queried. - See [getCloudHadoopInstanceList](/docs/en/cli-vhadoop-getcloudhadoopinstancelist). |

### 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 request to list Cloud DB for MySQL instances that can be integrated with the Hive metastore is successful, the identification information for each instance is returned.

### Command

The command example is as follows:

```
./ncloud vhadoop getCloudHadoopMysqlInstanceList \
    --cloudHadoopInstanceNo 34567890 \
    --regionCode KR \
    --output json
```

### Output

The output example is as follows:

```
{
  "CloudMysqlInstanceListForHiveMetaStoreResponse": {
    "totalRows": 1,
    "cloudMysqlInstanceListForHiveMetaStore": [
      {
        "cloudMysqlInstanceNo": "56789012",
        "cloudMysqlInstanceName": "hive-metastore",
        "vpcName": "vpc-01"
      }
    ],
    "requestId": "0718293a-ebfc-d456-0123-789abcd45678",
    "returnCode": "0",
    "returnMessage": "success"
  }
}
```