Creating an external Hive data source

Written by

Updated at December 5, 2025

In Yandex MPP Analytics for PostgreSQL, 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

REST API

gRPC API

Navigate to the folder dashboard and select Yandex MPP Analytics for PostgreSQL.
Open the page of the Greenplum® cluster in question.
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.

Get an IAM token for API authentication and set it as an environment variable:
```
export IAM_TOKEN="<IAM_token>"
```

Call the PXFDatasource.Create method, e.g., via the following cURL request:

curl \
    --request POST \
    --header "Authorization: Bearer $IAM_TOKEN" \
    --header "Content-Type: application/json" \
    --url 'https://mdb.api.cloud.yandex.net/managed-greenplum/v1/clusters/<cluster_ID>/pxf_datasources' \
    --data '{
              "datasource": {
                "name": "<external_data_source_name>",
                "hive": {
                  "kerberos": {
                    "enable": <Kerberos_authentication>
                  },
                  ...
                }
              }
            }'

Where:

name: External data source name.
hive: External data source settings. Configure at least one optional setting.

You can get the cluster ID with the list of clusters in the folder.

Check the server response to make sure your request was successful.

Get an IAM token for API authentication and set it as an environment variable:
```
export IAM_TOKEN="<IAM_token>"
```
Clone the cloudapi repository:
```
cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi
```
Below, we assume the repository contents are stored in the ~/cloudapi/ directory.

Use the PXFDatasourceService.Create call and send the following request, e.g., via gRPCurl:

grpcurl \
    -format json \
    -import-path ~/cloudapi/ \
    -import-path ~/cloudapi/third_party/googleapis/ \
    -proto ~/cloudapi/yandex/cloud/mdb/greenplum/v1/pxf_service.proto \
    -rpc-header "Authorization: Bearer $IAM_TOKEN" \
    -d '{
          "cluster_id": "<cluster_ID>"
          "datasource": {
            "name": "<external_data_source_name>",
            "hive": {
              "kerberos": {
                "enable": <Kerberos_authentication>
              },
              ...
            }
          }
        }' \
    mdb.api.cloud.yandex.net:443 \
    yandex.cloud.mdb.greenplum.v1.PXFDatasourceService.Create

Where:

name: External data source name.
hive: External data source settings. Configure at least one optional setting.

You can get the cluster ID with the list of clusters in the folder.

Check the server response to make sure your request was successful.

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

Creating an external Hive data source

Create an external data sourceCreate an external data source

Was the article helpful?

Create an external data source