saveExternalHiveMetaStore
  • PDF

saveExternalHiveMetaStore

  • PDF

Can be used in a VPC environment.

Overview

It links the Cloud Hadoop Hive metastore to the Cloud DB for MySQL (VPC) database created in the user account.

You can link and use metastores with Cloud DB for MySQL (VPC).
Link the Cloud Hadoop Hive metastore
to the Cloud DB for MySQL(VPC) database created in the user account.
For each cluster, you can only add one linkage account in the form of USER_ID + HOST (IP).

Linkage is only possible in the MySQL 5.7.x version, and this feature is only supported when the Cloud DB for MySQL (VPC) status is Running.
When running the TEST CONNECTION feature, a database in the hive_*_CHadoop format is created.
Only the DDL permission is supported for the metastore linkage accounts.

As a preliminary task, add the ACG used in Cloud Hadoop to the Cloud DB for MySQL (VPC) ACG and allow all communication for normal interworking.

Request

Request parameter

Parameter name Requirement status Type Restrictions Description
regionCode No String Region code
You can decide the region where the Hive metastore will be linked.
You can obtain the regionCode through the getRegionList action.
Default: Selects the first region of the getRegionList search results.
cloudHadoopInstanceNo Yes String Cloud Hadoop instance number
You can obtain the cloudHadoopInstanceNo through the getCloudHadoopInstanceList action.
cloudMysqlInstanceNo Yes String Instance number of the Cloud DB for MySQL (VPC) to be linked to the Hive metastore
You can obtain the cloudMysqlInstanceNo through the getCloudHadoopMysqlInstanceList action.
cloudMysqlUserName Yes String Name of the user accessing the Cloud DB for MySQL (VPC) to be linked to the Hive metastore
You can obtain the cloudMysqlUserName through the getCloudHadoopMysqlUserList action.
cloudMysqlUserPassword Yes String Password of the user accessing the Cloud DB for MySQL (VPC) to be linked to the Hive metastore
You can obtain the cloudMysqlUserPassword through the getCloudHadoopMysqlUserList action.
output No String Format type for the response result
Options: xml | json
Default: xml

Examples

Request example

ncloud vhadoop saveExternalHiveMetaStore --regionCode KR --cloudHadoopInstanceNo 821***  --cloudMysqlInstanceNo 823*** --cloudMysqlUserName test** --cloudMysqlUserPassword ******

Response example

<saveExternalHiveMetaStoreResponse>
    <requestId>65544ec3-8da6-4bf1-9b0c-5957d110bd42</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
</saveExternalHiveMetaStoreResponse>

Was this article helpful?