Creating an external Hive data source

In Managed Service for Greenplum®, as an external data source with the Hive connection type, you can use a Hive DBMS as part of Yandex Data Processing or other third-party Hive services.

Create an external data sourceCreate an external data source

Sample REST API requestSample REST API request

The example below shows how to create an external Hive data source using the Managed Service for Greenplum® REST API. To create a source:

1. Get an IAM token. It is used for authentication in the API.

2. Add the IAM token to the following environment variable:

   export IAM_TOKEN=<token>
   

3. Send a request using cURL:

   curl --location "https://mdb.api.cloud.yandex.net/managed-greenplum/v1/clusters/<cluster_ID>/pxf_datasources" \
       --header "Content-Type: text/plain" \
       --header "Authorization: Bearer ${IAM_TOKEN}" \
       --data "{
           \"datasource\": {
               \"name\": \"hive:text\",
               \"hive\": {
                   \"kerberos\": {
                       \"enable\": true
                   }
               }
           }
       }"
   

   In the request body, specify the following parameters:

   • name: Source name, e.g., hive:text.
   • enable: Enabling the Kerberos protocol for client and server authentication (optional).

Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.