Managed Service for Greenplum® API, REST: PXFDatasource.Update

Written by

Updated at January 14, 2025

HTTP request
Path parameters
Body parameters
PXFDatasource
PXFDatasourceS3
PXFDatasourceJDBC
PXFDatasourceHDFS
PXFDatasourceCore
PXFDatasourceKerberos
PXFDatasourceHDFSDfs
PXFDatasourceHDFSDfsNamenode
PXFDatasourceHDFSYarn
PXFDatasourceHDFSYarnHaRm
PXFDatasourceHive
Response
UpdatePXFDatasourceMetadata
Status
PXFDatasource
PXFDatasourceS3
PXFDatasourceJDBC
PXFDatasourceHDFS
PXFDatasourceCore
PXFDatasourceKerberos
PXFDatasourceHDFSDfs
PXFDatasourceHDFSDfsNamenode
PXFDatasourceHDFSYarn
PXFDatasourceHDFSYarnHaRm
PXFDatasourceHive

Update PXF datasource

HTTP request

PATCH https://mdb.api.cloud.yandex.net/managed-greenplum/v1/clusters/{clusterId}/pxf_datasources

Path parameters

Field

Description

clusterId

string

Required field.

Body parameters

{
  "updateMask": "string",
  "datasource": {
    "name": "string",
    // Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`
    "s3": {
      "accessKey": "string",
      "secretKey": "string",
      "fastUpload": "boolean",
      "endpoint": "string"
    },
    "jdbc": {
      "driver": "string",
      "url": "string",
      "user": "string",
      "password": "string",
      "statementBatchSize": "string",
      "statementFetchSize": "string",
      "statementQueryTimeout": "string",
      "poolEnabled": "boolean",
      "poolMaximumSize": "string",
      "poolConnectionTimeout": "string",
      "poolIdleTimeout": "string",
      "poolMinimumIdle": "string"
    },
    "hdfs": {
      "core": {
        "defaultFs": "string",
        "securityAuthToLocal": "string"
      },
      "kerberos": {
        "enable": "boolean",
        "primary": "string",
        "realm": "string",
        "kdcServers": [
          "string"
        ],
        "adminServer": "string",
        "defaultDomain": "string",
        "keytabBase64": "string"
      },
      "userImpersonation": "boolean",
      "username": "string",
      "saslConnectionRetries": "string",
      "zkHosts": [
        "string"
      ],
      "dfs": {
        "haAutomaticFailoverEnabled": "boolean",
        "blockAccessTokenEnabled": "boolean",
        "useDatanodeHostname": "boolean",
        "namenodes": "object",
        "nameservices": "string"
      },
      "yarn": {
        "resourcemanagerHaEnabled": "boolean",
        "resourcemanagerHaAutoFailoverEnabled": "boolean",
        "resourcemanagerHaAutoFailoverEmbedded": "boolean",
        "resourcemanagerClusterId": "string",
        "haRm": "object"
      }
    },
    "hive": {
      "core": {
        "defaultFs": "string",
        "securityAuthToLocal": "string"
      },
      "kerberos": {
        "enable": "boolean",
        "primary": "string",
        "realm": "string",
        "kdcServers": [
          "string"
        ],
        "adminServer": "string",
        "defaultDomain": "string",
        "keytabBase64": "string"
      },
      "userImpersonation": "boolean",
      "username": "string",
      "saslConnectionRetries": "string",
      "zkHosts": [
        "string"
      ],
      "ppd": "boolean",
      "metastoreUris": [
        "string"
      ],
      "metastoreKerberosPrincipal": "string",
      "authKerberosPrincipal": "string"
    }
    // end of the list of possible fields
  }
}

Field

Description

updateMask

string (field-mask)

A comma-separated names off ALL fields to be updated.
Only the specified fields will be changed. The others will be left untouched.
If the field is specified in updateMask and no value for that field was sent in the request,
the field's value will be reset to the default. The default value for most fields is null or 0.

If updateMask is not sent in the request, all fields' values will be updated.
Fields specified in the request will be updated to provided values.
The rest of the fields will be reset to the default.

datasource

PXFDatasource

PXFDatasource

Field	Description
name	string Required field. Data source name.
s3	PXFDatasourceS3 Settings of an external S3 data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
jdbc	PXFDatasourceJDBC Settings of an external JDBC data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hdfs	PXFDatasourceHDFS Settings of an external HDFS data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hive	PXFDatasourceHive Settings of an external Hive data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.

PXFDatasourceS3

Field	Description
accessKey	string Public key to access S3 storage.
secretKey	string Secret key to access S3 storage.
fastUpload	boolean Manages a fast upload of big files to S3 storage. In case of the `false` value, the PXF generates files on disk before sending them to the S3 storage. In case of the `true` value, the PXF generates files in RAM (the PXF writes to disc only if there is not enough RAM). The fast upload is enabled by default.
endpoint	string S3 storage address. The default value is `storage.yandexcloud.net` used for Yandex Object Storage.

PXFDatasourceJDBC

Field	Description
driver	string JDBC driver class in Java. The possible values are the following: `com.simba.athena.jdbc.Driver` `com.clickhouse.jdbc.ClickHouseDriver` `com.ibm.as400.access.AS400JDBCDriver` `com.microsoft.sqlserver.jdbc.SQLServerDriver` `com.mysql.cj.jdbc.Driver` `org.postgresql.Driver` `oracle.jdbc.driver.OracleDriver` `net.snowflake.client.jdbc.SnowflakeDriver` `io.trino.jdbc.TrinoDriver`
url	string URL that the JDBC driver uses to connect to the database. Examples: `jdbc:mysql://mysqlhost:3306/testdb`: Local MySQL DB. `jdbc:postgresql://c-<cluster_id>.rw.mdb.yandexcloud.net:6432/db1`: Managed Service for PostgreSQL cluster. The address contains the special FQDN of the cluster's master. `jdbc:oracle:thin:@host.example:1521:orcl`: Oracle DB.
user	string Username of the DB owner.
password	string Password of the DB owner.
statementBatchSize	string (int64) Number of rows to read in an external table, in a batch. The default value is `100`.
statementFetchSize	string (int64) Number of rows to fetch (buffer) when reading from an external table. The default value is `1000`.
statementQueryTimeout	string (int64) Amount of time (in seconds) the JDBC driver waits for a statement to run. This timeout applies to statements created for both read and write operations. The default value is `60`.
poolEnabled	boolean Determines whether JDBC connection pooling is used in a server configuration. By default, it is used.
poolMaximumSize	string (int64) Maximum number of connections to the DB backend. The default value is `5`.
poolConnectionTimeout	string (int64) Maximum time, in milliseconds, to wait for a connection from the pool. The default value is `30000`.
poolIdleTimeout	string (int64) Maximum amount of time, in milliseconds, after which an inactive connection is considered idle. The default value is `30000`.
poolMinimumIdle	string (int64) Minimum number of idle connections maintained in the connection pool. The default value is `0`.

PXFDatasourceHDFS

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
userImpersonation	boolean Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
saslConnectionRetries	string (int64) Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zkHosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
dfs	PXFDatasourceHDFSDfs Settings of the distributed file system.
yarn	PXFDatasourceHDFSYarn Settings of the ResourceManager service that is responsible for tracking resources in a cluster and scheduling applications (e.g., MapReduce jobs).

PXFDatasourceCore

Field

Description

defaultFs

string

URI whose scheme and authority determine the file system implementation.

securityAuthToLocal

string

Rules for mapping Kerberos principals to operating system user accounts.

PXFDatasourceKerberos

Field	Description
enable	boolean Determines whether the Kerberos authentication server is used. By default, it is not used.
primary	string Host of the primary KDC server (Key Distribution Center).
realm	string Kerberos realm for a Greenplum® DB.
kdcServers[]	string KDC server hosts.
adminServer	string Administration server host. Usually, this is the primary Kerberos server.
defaultDomain	string Domain that is used for the host name extension. Applicable when Kerberos 4 service members become Kerberos 5 service members (for example, when rcmd.hostname is replaced with host/hostname.domain).
keytabBase64	string Base64 encoded contents of the keytab file.

PXFDatasourceHDFSDfs

Field	Description
haAutomaticFailoverEnabled	boolean Determines whether automatic failover is enabled for the high availability of the file system. The automatic failover is enabled by default.
blockAccessTokenEnabled	boolean If `true`, access tokens are used as capabilities for accessing datanodes. If `false`, no access tokens are checked on accessing datanodes. The check of access tokens is enabled by default.
useDatanodeHostname	boolean Determines whether the datanode hostname is used when connecting to datanodes.
namenodes	object (map<string, PXFDatasourceHDFSDfsNamenode>) List of HDFS service logical names. Specify them separated by commas. The names can be arbitrary.
nameservices	string Corresponds well-known HDFS client setting "dfs.nameservices" for this datasource

PXFDatasourceHDFSDfsNamenode

Field	Description
rpcAddress	string
serviceRpcAddress	string
httpAddress	string
httpsAddress	string

PXFDatasourceHDFSYarn

Field	Description
resourcemanagerHaEnabled	boolean Determines whether high availability is enabled for YARN's ResourceManager services. The high availability is enabled by default.
resourcemanagerHaAutoFailoverEnabled	boolean Determines whether another ResourceManager should automatically become active when the active ResourceManager has failed and does not respond. The switch of ResourceManagers is enabled by default if the high availability is enabled.
resourcemanagerHaAutoFailoverEmbedded	boolean Determines whether the embedded ActiveStandbyElector method should be used for the election of the active ResourceManager. If the current active ResourceManager has failed and does not respond, the ActiveStandbyElector method makes another ResourceManager active which then takes over.
resourcemanagerClusterId	string Cluster ID. Specify it, so the ResourceManager service does not become active for a different cluster.
haRm	object (map<string, PXFDatasourceHDFSYarnHaRm>) Highly available ResourceManager service.

PXFDatasourceHDFSYarnHaRm

Field	Description
resourcemanagerAddress	string
resourcemanagerSchedulerAddress	string
resourcemanagerResourceTrackerAddress	string
resourcemanagerAdminAddress	string
resourcemanagerWebappAddress	string
resourcemanagerWebappHttpsAddress	string

PXFDatasourceHive

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
userImpersonation	boolean Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
saslConnectionRetries	string (int64) Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zkHosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
ppd	boolean Specifies if predicate pushdown is enabled for queries on external tables. The predicate pushdown is enabled by default.
metastoreUris[]	string List of URIs separated by commas. To request metadata, the remote DBMS connects to Metastore by one of these URIs.
metastoreKerberosPrincipal	string Service principal for the Metastore Thrift server.
authKerberosPrincipal	string Kerberos server principal.

Response

HTTP Code: 200 - OK

{
  "id": "string",
  "description": "string",
  "createdAt": "string",
  "createdBy": "string",
  "modifiedAt": "string",
  "done": "boolean",
  "metadata": {
    "clusterId": "string",
    "datasourceName": "string"
  },
  // Includes only one of the fields `error`, `response`
  "error": {
    "code": "integer",
    "message": "string",
    "details": [
      "object"
    ]
  },
  "response": {
    "name": "string",
    // Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`
    "s3": {
      "accessKey": "string",
      "secretKey": "string",
      "fastUpload": "boolean",
      "endpoint": "string"
    },
    "jdbc": {
      "driver": "string",
      "url": "string",
      "user": "string",
      "password": "string",
      "statementBatchSize": "string",
      "statementFetchSize": "string",
      "statementQueryTimeout": "string",
      "poolEnabled": "boolean",
      "poolMaximumSize": "string",
      "poolConnectionTimeout": "string",
      "poolIdleTimeout": "string",
      "poolMinimumIdle": "string"
    },
    "hdfs": {
      "core": {
        "defaultFs": "string",
        "securityAuthToLocal": "string"
      },
      "kerberos": {
        "enable": "boolean",
        "primary": "string",
        "realm": "string",
        "kdcServers": [
          "string"
        ],
        "adminServer": "string",
        "defaultDomain": "string",
        "keytabBase64": "string"
      },
      "userImpersonation": "boolean",
      "username": "string",
      "saslConnectionRetries": "string",
      "zkHosts": [
        "string"
      ],
      "dfs": {
        "haAutomaticFailoverEnabled": "boolean",
        "blockAccessTokenEnabled": "boolean",
        "useDatanodeHostname": "boolean",
        "namenodes": "object",
        "nameservices": "string"
      },
      "yarn": {
        "resourcemanagerHaEnabled": "boolean",
        "resourcemanagerHaAutoFailoverEnabled": "boolean",
        "resourcemanagerHaAutoFailoverEmbedded": "boolean",
        "resourcemanagerClusterId": "string",
        "haRm": "object"
      }
    },
    "hive": {
      "core": {
        "defaultFs": "string",
        "securityAuthToLocal": "string"
      },
      "kerberos": {
        "enable": "boolean",
        "primary": "string",
        "realm": "string",
        "kdcServers": [
          "string"
        ],
        "adminServer": "string",
        "defaultDomain": "string",
        "keytabBase64": "string"
      },
      "userImpersonation": "boolean",
      "username": "string",
      "saslConnectionRetries": "string",
      "zkHosts": [
        "string"
      ],
      "ppd": "boolean",
      "metastoreUris": [
        "string"
      ],
      "metastoreKerberosPrincipal": "string",
      "authKerberosPrincipal": "string"
    }
    // end of the list of possible fields
  }
  // end of the list of possible fields
}

An Operation resource. For more information, see Operation.

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
createdAt	string (date-time) Creation timestamp. String in RFC3339 text format. The range of possible values is from `0001-01-01T00:00:00Z` to `9999-12-31T23:59:59.999999999Z`, i.e. from 0 to 9 digits for fractions of a second. To work with values in this field, use the APIs described in the Protocol Buffers reference. In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).
createdBy	string ID of the user or service account who initiated the operation.
modifiedAt	string (date-time) The time when the Operation resource was last modified. String in RFC3339 text format. The range of possible values is from `0001-01-01T00:00:00Z` to `9999-12-31T23:59:59.999999999Z`, i.e. from 0 to 9 digits for fractions of a second. To work with values in this field, use the APIs described in the Protocol Buffers reference. In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).
done	boolean If the value is `false`, it means the operation is still in progress. If `true`, the operation is completed, and either `error` or `response` is available.
metadata	UpdatePXFDatasourceMetadata Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
error	Status The error result of the operation in case of failure or cancellation. Includes only one of the fields `error`, `response`. The operation result. If `done == false` and there was no failure detected, neither `error` nor `response` is set. If `done == false` and there was a failure detected, `error` is set. If `done == true`, exactly one of `error` or `response` is set.
response	PXFDatasource The normal response of the operation in case of success. If the original method returns no data on success, such as Delete, the response is google.protobuf.Empty. If the original method is the standard Create/Update, the response should be the target resource of the operation. Any method that returns a long-running operation should document the response type, if any. Includes only one of the fields `error`, `response`. The operation result. If `done == false` and there was no failure detected, neither `error` nor `response` is set. If `done == false` and there was a failure detected, `error` is set. If `done == true`, exactly one of `error` or `response` is set.

UpdatePXFDatasourceMetadata

Field

Description

clusterId

string

Required field.

datasourceName

string

Required field.

Status

The error result of the operation in case of failure or cancellation.

Field	Description
code	integer (int32) Error code. An enum value of google.rpc.Code.
message	string An error message.
details[]	object A list of messages that carry the error details.

PXFDatasource

Field	Description
name	string Required field. Data source name.
s3	PXFDatasourceS3 Settings of an external S3 data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
jdbc	PXFDatasourceJDBC Settings of an external JDBC data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hdfs	PXFDatasourceHDFS Settings of an external HDFS data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hive	PXFDatasourceHive Settings of an external Hive data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.

PXFDatasourceS3

Field	Description
accessKey	string Public key to access S3 storage.
secretKey	string Secret key to access S3 storage.
fastUpload	boolean Manages a fast upload of big files to S3 storage. In case of the `false` value, the PXF generates files on disk before sending them to the S3 storage. In case of the `true` value, the PXF generates files in RAM (the PXF writes to disc only if there is not enough RAM). The fast upload is enabled by default.
endpoint	string S3 storage address. The default value is `storage.yandexcloud.net` used for Yandex Object Storage.

PXFDatasourceJDBC

Field	Description
driver	string JDBC driver class in Java. The possible values are the following: `com.simba.athena.jdbc.Driver` `com.clickhouse.jdbc.ClickHouseDriver` `com.ibm.as400.access.AS400JDBCDriver` `com.microsoft.sqlserver.jdbc.SQLServerDriver` `com.mysql.cj.jdbc.Driver` `org.postgresql.Driver` `oracle.jdbc.driver.OracleDriver` `net.snowflake.client.jdbc.SnowflakeDriver` `io.trino.jdbc.TrinoDriver`
url	string URL that the JDBC driver uses to connect to the database. Examples: `jdbc:mysql://mysqlhost:3306/testdb`: Local MySQL DB. `jdbc:postgresql://c-<cluster_id>.rw.mdb.yandexcloud.net:6432/db1`: Managed Service for PostgreSQL cluster. The address contains the special FQDN of the cluster's master. `jdbc:oracle:thin:@host.example:1521:orcl`: Oracle DB.
user	string Username of the DB owner.
password	string Password of the DB owner.
statementBatchSize	string (int64) Number of rows to read in an external table, in a batch. The default value is `100`.
statementFetchSize	string (int64) Number of rows to fetch (buffer) when reading from an external table. The default value is `1000`.
statementQueryTimeout	string (int64) Amount of time (in seconds) the JDBC driver waits for a statement to run. This timeout applies to statements created for both read and write operations. The default value is `60`.
poolEnabled	boolean Determines whether JDBC connection pooling is used in a server configuration. By default, it is used.
poolMaximumSize	string (int64) Maximum number of connections to the DB backend. The default value is `5`.
poolConnectionTimeout	string (int64) Maximum time, in milliseconds, to wait for a connection from the pool. The default value is `30000`.
poolIdleTimeout	string (int64) Maximum amount of time, in milliseconds, after which an inactive connection is considered idle. The default value is `30000`.
poolMinimumIdle	string (int64) Minimum number of idle connections maintained in the connection pool. The default value is `0`.

PXFDatasourceHDFS

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
userImpersonation	boolean Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
saslConnectionRetries	string (int64) Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zkHosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
dfs	PXFDatasourceHDFSDfs Settings of the distributed file system.
yarn	PXFDatasourceHDFSYarn Settings of the ResourceManager service that is responsible for tracking resources in a cluster and scheduling applications (e.g., MapReduce jobs).

PXFDatasourceCore

Field

Description

defaultFs

string

URI whose scheme and authority determine the file system implementation.

securityAuthToLocal

string

Rules for mapping Kerberos principals to operating system user accounts.

PXFDatasourceKerberos

Field	Description
enable	boolean Determines whether the Kerberos authentication server is used. By default, it is not used.
primary	string Host of the primary KDC server (Key Distribution Center).
realm	string Kerberos realm for a Greenplum® DB.
kdcServers[]	string KDC server hosts.
adminServer	string Administration server host. Usually, this is the primary Kerberos server.
defaultDomain	string Domain that is used for the host name extension. Applicable when Kerberos 4 service members become Kerberos 5 service members (for example, when rcmd.hostname is replaced with host/hostname.domain).
keytabBase64	string Base64 encoded contents of the keytab file.

PXFDatasourceHDFSDfs

Field	Description
haAutomaticFailoverEnabled	boolean Determines whether automatic failover is enabled for the high availability of the file system. The automatic failover is enabled by default.
blockAccessTokenEnabled	boolean If `true`, access tokens are used as capabilities for accessing datanodes. If `false`, no access tokens are checked on accessing datanodes. The check of access tokens is enabled by default.
useDatanodeHostname	boolean Determines whether the datanode hostname is used when connecting to datanodes.
namenodes	object (map<string, PXFDatasourceHDFSDfsNamenode>) List of HDFS service logical names. Specify them separated by commas. The names can be arbitrary.
nameservices	string Corresponds well-known HDFS client setting "dfs.nameservices" for this datasource

PXFDatasourceHDFSDfsNamenode

Field	Description
rpcAddress	string
serviceRpcAddress	string
httpAddress	string
httpsAddress	string

PXFDatasourceHDFSYarn

Field	Description
resourcemanagerHaEnabled	boolean Determines whether high availability is enabled for YARN's ResourceManager services. The high availability is enabled by default.
resourcemanagerHaAutoFailoverEnabled	boolean Determines whether another ResourceManager should automatically become active when the active ResourceManager has failed and does not respond. The switch of ResourceManagers is enabled by default if the high availability is enabled.
resourcemanagerHaAutoFailoverEmbedded	boolean Determines whether the embedded ActiveStandbyElector method should be used for the election of the active ResourceManager. If the current active ResourceManager has failed and does not respond, the ActiveStandbyElector method makes another ResourceManager active which then takes over.
resourcemanagerClusterId	string Cluster ID. Specify it, so the ResourceManager service does not become active for a different cluster.
haRm	object (map<string, PXFDatasourceHDFSYarnHaRm>) Highly available ResourceManager service.

PXFDatasourceHDFSYarnHaRm

Field	Description
resourcemanagerAddress	string
resourcemanagerSchedulerAddress	string
resourcemanagerResourceTrackerAddress	string
resourcemanagerAdminAddress	string
resourcemanagerWebappAddress	string
resourcemanagerWebappHttpsAddress	string

PXFDatasourceHive

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
userImpersonation	boolean Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
saslConnectionRetries	string (int64) Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zkHosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
ppd	boolean Specifies if predicate pushdown is enabled for queries on external tables. The predicate pushdown is enabled by default.
metastoreUris[]	string List of URIs separated by commas. To request metadata, the remote DBMS connects to Metastore by one of these URIs.
metastoreKerberosPrincipal	string Service principal for the Metastore Thrift server.
authKerberosPrincipal	string Kerberos server principal.

Managed Service for Greenplum® API, REST: PXFDatasource.Update

HTTP requestHTTP request

Path parametersPath parameters

Body parametersBody parameters

PXFDatasourcePXFDatasource

PXFDatasourceS3PXFDatasourceS3

PXFDatasourceJDBCPXFDatasourceJDBC

PXFDatasourceHDFSPXFDatasourceHDFS

PXFDatasourceCorePXFDatasourceCore

PXFDatasourceKerberosPXFDatasourceKerberos

PXFDatasourceHDFSDfsPXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenodePXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarnPXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRmPXFDatasourceHDFSYarnHaRm

PXFDatasourceHivePXFDatasourceHive

ResponseResponse

UpdatePXFDatasourceMetadataUpdatePXFDatasourceMetadata

StatusStatus

PXFDatasourcePXFDatasource

PXFDatasourceS3PXFDatasourceS3

PXFDatasourceJDBCPXFDatasourceJDBC

PXFDatasourceHDFSPXFDatasourceHDFS

PXFDatasourceCorePXFDatasourceCore

PXFDatasourceKerberosPXFDatasourceKerberos

PXFDatasourceHDFSDfsPXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenodePXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarnPXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRmPXFDatasourceHDFSYarnHaRm

PXFDatasourceHivePXFDatasourceHive

Was the article helpful?

HTTP request

Path parameters

Body parameters

PXFDatasource

PXFDatasourceS3

PXFDatasourceJDBC

PXFDatasourceHDFS

PXFDatasourceCore

PXFDatasourceKerberos

PXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRm

PXFDatasourceHive

Response

UpdatePXFDatasourceMetadata

Status

PXFDatasource

PXFDatasourceS3

PXFDatasourceJDBC

PXFDatasourceHDFS

PXFDatasourceCore

PXFDatasourceKerberos

PXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRm

PXFDatasourceHive