saveExternalHiveMetaStore

Prev Next

Available in VPC

Overview

Integrate a 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 linked account in the form of USER_ID + HOST (IP).

Integration is only possible with MySQL 8.0.x, and is only supported when the Cloud DB for MySQL (VPC) status is Running.
When the TEST CONNECTION feature is performed, a database in the form of hive_*_CHadoop is created.
Only the DDL permission is supported for the metastore linked accounts.

You should add the ACG used in Cloud Hadoop to the Cloud DB for MySQL (VPC) ACG and allow all communication in advance for the integration to be set up successfully.

Request

Request parameters

Parameter name Required Type Restrictions Description
regionCode No String Region code
  • Determine the Region in which the Hive metastore will be integrated.
  • regionCode can be obtained through the getRegionList action.
  • Default: Select the first Region of the getRegionList query result.
cloudHadoopInstanceNo Yes String Cloud Hadoopinstance number
cloudMysqlInstanceNo Yes String Cloud DB for MySQL (VPC) instance number to integrate Hive metastore with
cloudMysqlUserName Yes String Cloud DB for MySQL (VPC) access username to integrate the Hive metastore with
cloudMysqlUserPassword Yes String It must have at least one English letter, one special character, and one number.
` & + \ " ' / and spaces can't be used in passwords.
Min: 8
Max: 20		 Access user password of Cloud DB for MySQL (VPC) instance to integrate Hive metastore with
output No String Response result's format type
  • Options: xml | json
  • Default: xml

Examples

Call

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

Response

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