Creating an external Hive data source

Written by

Updated at November 18, 2024

Create an external data source
Example of a REST API request

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 source

Management console

API

Go to the folder page and select Managed Service for Greenplum.
Open the page of the Managed Service for Greenplum® cluster you need.
In the left-hand panel, select PXF.
Click Create data source.
Select the Hive connection type.
Enter a source name.
Configure at least one optional setting.
Click Create.

To add a Hive data source to a Managed Service for Greenplum® cluster, use the create REST API method for the PXFDatasource resource or the PXFDatasourceService/Create gRPC API call and provide the following in the request:

Cluster ID in the clusterId parameter. To find out the cluster ID, get a list of clusters in the folder.
Data source name in the name parameter.
External source settings in the hive parameter.

Example of a 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:

Get an IAM token. It is used for authentication in the API.
Add the IAM token to the following environment variable:
```
export IAM_TOKEN=<token>
```

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.

Creating an external Hive data source

Create an external data sourceCreate an external data source

Example of a REST API requestExample of a REST API request

Was the article helpful?

Create an external data source

Example of a REST API request