我的书签
添加书签
移除书签pxf:// 协议
PXF协议打包为Greenplum数据库扩展。 pxf协议支持从外部数据存储读取数据。 您还可以使用pxf协议编写文本，二进制和parquet-format的数据。
使用pxf协议读取或写入外部数据之前，必须先显式初始化并启动PXF。 您还必须在每个允许用户创建外部表以访问外部数据的数据库中启用PXF，并将pxf协议的权限授予这些Greenplum数据库用户。
Parent topic: 定义外部表
pxf:// 协议
- 安全性配置指南
- Greenplum平台扩展框架(PXF)
- Greenplum数据库® 6.0文档
- Greenplum数据库最佳实践
- 参考指南
- 后台工作进程
- 用于分析的Greenplum MADlib扩展
- gp_toolkit管理模式
- 保留标识符和SQL关键字
- Greenplum 数据库数据类型
- Greenplum PL/pgSQL过程语言
- Greenplum的PL/Perl语言扩展
- Greenplum PL/Python语言扩展
- SQL 2008可选特性兼容性
- 内置函数摘要
- Greenplum Partner Connector API
- 系统目录参考
- 系统视图
- 系统表
- 系统目录定义
- pg_resgroupcapability
- pg_resgroup
- pg_inherits
- pg_partition_templates
- pg_type_encoding
- pg_exttable
- pg_index
- gp_segment_configuration
- pg_partition_columns
- pg_resourcetype
- pg_compression
- pg_pltemplate
- pg_resqueuecapability
- pg_attribute_encoding
- pg_listener
- pg_statistic
- pg_stat_replication
- pg_depend
- gp_transaction_log
- pg_amproc
- pg_type
- pg_partition_rule
- pg_shdescription
- pg_stat_partition_operations
- foreign_servers
- pg_resqueue
- pg_enum
- user_mappings
- user_mapping_options
- pg_available_extensions
- pg_database
- gp_resgroup_config
- gp_resgroup_status
- pg_cast
- pg_user_mappings
- pg_opfamily
- gp_distribution_policy
- pg_constraint
- pg_foreign_table
- gp_resqueue_status
- foreign_tables
- pg_attrdef
- pg_stat_activity
- pg_rewrite
- pg_namespace
- pg_partition_encoding
- foreign_data_wrappers
- pg_available_extension_versions
- pg_authid
- pg_stat_operations
- pg_language
- gp_stat_replication
- pg_stat_last_shoperation
- pg_extension
- foreign_data_wrapper_options
- pg_conversion
- pg_auth_members
- gp_distributed_xacts
- gp_pgdatabase
- pg_trigger
- pg_tablespace
- pg_locks
- gpexpand.status_detail
- gpexpand.status
- pg_resqueue_attributes
- gp_configuration_history
- gp_version_at_initdb
- pg_max_external_files
- pg_stat_last_operation
- pg_opclass
- pg_proc
- pg_am
- pg_partitions
- gpexpand.expansion_progress
- foreign_table_options
- pg_foreign_server
- pg_class
- pg_shdepend
- pg_amop
- pg_attribute
- pg_roles
- pg_description
- pg_partition
- pg_aggregate
- gp_resgroup_status_per_host
- pg_largeobject
- gp_id
- gp_resgroup_status_per_segment
- pg_appendonly
- pg_db_role_setting
- gp_fastsequence
- pg_user_mapping
- pg_stat_resqueues
- pg_operator
- foreign_server_options
- pg_foreign_data_wrapper
- gp_distributed_log
- 服务器配置参数
- 字符集支持
- Greenplum的PL/Java语言扩展
- SQL Command Reference
- CREATE TEXT SEARCH PARSER
- ANALYZE
- ALTER RESOURCE GROUP
- ALTER OPERATOR
- CREATE CAST
- CREATE USER
- CREATE EXTERNAL TABLE
- ALTER FUNCTION
- ABORT
- ALTER SEQUENCE
- DO
- CREATE OPERATOR
- ALTER SCHEMA
- ALTER DOMAIN
- ALTER COLLATION
- CLOSE
- EXPLAIN
- ALTER OPERATOR CLASS
- CREATE COLLATION
- CREATE VIEW
- START TRANSACTION
- DROP USER MAPPING
- RESET
- DROP EXTENSION
- DROP PROTOCOL
- ALTER RESOURCE QUEUE
- CREATE OPERATOR FAMILY
- ALTER DATABASE
- REINDEX
- DROP RESOURCE GROUP
- CREATE TYPE
- EXECUTE
- PREPARE
- DROP RESOURCE QUEUE
- DROP AGGREGATE
- CREATE PROTOCOL
- SET
- COPY
- CREATE ROLE
- ALTER VIEW
- SQL Syntax Summary
- CREATE AGGREGATE
- DROP LANGUAGE
- CREATE FUNCTION
- CREATE FOREIGN DATA WRAPPER
- LOCK
- CREATE TEXT SEARCH CONFIGURATION
- ROLLBACK
- CREATE GROUP
- ALTER USER MAPPING
- VALUES
- CREATE TEXT SEARCH TEMPLATE
- ALTER EXTENSION
- CREATE CONVERSION
- DROP TEXT SEARCH PARSER
- SELECT
- ALTER USER
- DROP TEXT SEARCH DICTIONARY
- CHECKPOINT
- DROP TEXT SEARCH TEMPLATE
- RELEASE SAVEPOINT
- ALTER FOREIGN DATA WRAPPER
- DROP USER
- ALTER INDEX
- DROP SCHEMA
- CREATE DATABASE
- CREATE RESOURCE QUEUE
- TRUNCATE
- DROP TABLESPACE
- FETCH
- COMMENT
- ALTER SERVER
- DROP SEQUENCE
- CREATE SEQUENCE
- CREATE RESOURCE GROUP
- ALTER FOREIGN TABLE
- SELECT INTO
- DEALLOCATE
- DROP FOREIGN DATA WRAPPER
- DROP FOREIGN TABLE
- VACUUM
- ALTER CONVERSION
- COMMIT
- ALTER TEXT SEARCH PARSER
- ALTER GROUP
- REASSIGN OWNED
- SET CONSTRAINTS
- ALTER AGGREGATE
- CREATE RULE
- DROP VIEW
- DISCARD
- END
- DROP ROLE
- DROP TYPE
- DROP OPERATOR
- CREATE TABLE AS
- BEGIN
- LOAD
- DROP TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH CONFIGURATION
- CREATE TABLESPACE
- REVOKE
- CREATE INDEX
- DELETE
- DROP SERVER
- ROLLBACK TO SAVEPOINT
- DROP COLLATION
- SET SESSION AUTHORIZATION
- ALTER TABLESPACE
- MOVE
- ALTER LANGUAGE
- SHOW
- GRANT
- CREATE DOMAIN
- DROP FUNCTION
- ALTER OPERATOR FAMILY
- ALTER PROTOCOL
- CREATE LANGUAGE
- DROP DATABASE
- DROP EXTERNAL TABLE
- DROP TABLE
- DROP INDEX
- CREATE SCHEMA
- DROP OPERATOR FAMILY
- INSERT
- CREATE FOREIGN TABLE
- ALTER DEFAULT PRIVILEGES
- DROP OWNED
- SAVEPOINT
- CREATE EXTENSION
- UPDATE
- CREATE TEXT SEARCH DICTIONARY
- DROP CAST
- ALTER ROLE
- DROP DOMAIN
- SET TRANSACTION
- DROP CONVERSION
- ALTER TEXT SEARCH DICTIONARY
- CREATE USER MAPPING
- ALTER TEXT SEARCH TEMPLATE
- ALTER TYPE
- DECLARE
- CLUSTER
- SET ROLE
- CREATE SERVER
- DROP GROUP
- ALTER EXTERNAL TABLE
- ALTER TABLE
- CREATE OPERATOR CLASS
- DROP OPERATOR CLASS
- DROP RULE
- CREATE TABLE
- Greenplum MapReduce规范
- gpperfmon 数据库
- 附加提供的模块
- Greenplum环境变量
- Greenplum 特点概要
- Greenplum PL/R 语言扩展
- Greenplum PL/Container语言扩展
- 工具指南
- 管理工具参考
- gplogfilter
- pxf
- gpstop
- gpssh
- gpssh-exkeys
- gpbackup
- gprecoverseg
- gpcheckperf
- gpexpand
- gpdeletesystem
- gpperfmon_install
- pgbouncer-admin
- gpcheckcat
- gpaddmirrors
- gpreload
- gpmovemirrors
- pgbouncer.ini
- gpfdist
- gprestore
- gpload
- analyzedb
- gpsys1
- gpinitstandby
- pxf cluster
- gpscp
- gpactivatestandby
- gpmapreduce
- pgbouncer
- gpinitsystem
- gppkg
- gpseginstall
- gpstart
- gpstate
- gpconfig
- gpcheck
- 客户端工具参考
- 附加程序
- 管理工具参考
- 管理员指南
- 性能管理
- 装载和卸载数据
- 查询数据
- 分布与倾斜
- 管理一个Greenplum系统
- 定义数据库对象
- 使用外部数据
- 使用Greenplum的并行文件服务器（gpfdist）
- 定义外部表
- 使用自定义协议
- gpfdist://协议
- file://协议
- 创建和使用外部Web表
- pxf:// 协议
- s3:// 协议
- 处理外部表数据中的错误
- gpfdists:// 协议
- Examples for Creating External Tables
- Example 6—Multiple files in CSV format with header rows
- Example 3—Multiple gpfdists instances
- Example 5—TEXT Format on a Hadoop Distributed File Server
- Example 10—Readable and Writable External Tables with XML Transformations
- Example 8—Writable External Table with gpfdist
- Example 7—Readable External Web Table with Script
- Example 2—Multiple gpfdist instances
- Example 9—Writable External Web Table with Script
- Example 1—Single gpfdist instance on single-NIC machine
- Example 4—Single gpfdist instance with error logging
- 使用外部表访问外部数据
- Greenplum数据库概念
- 管理Greenplum数据库访问
- 插入, 更新, 和删除数据
暂无相关搜索结果！
本文档使用 全库网 构建
