我的书签
添加书签
移除书签Greenplum Database can read and write XML data to and from external tables with gpfdist. For information about setting up an XML transform, see Transforming External Data with gpfdist and gpload.
Parent topic: Examples for Creating External Tables
Example 10—Readable and Writable External Tables with XML Transformations
- Version 6.24
- Release Notes
- Platform Requirements
- Concepts
- Deploying to VMware vSphere
- Overview
- Architecture
- Planning VMware vSphere with Greenplum
- Prerequisites
- Setting Up VMware vSphere Network
- Setting Up VMware vSphere DRS and HA
- Setting Up VMware vSphere Storage
- Setting Up VMware vSphere Encryption
- Validating VMware vSphere Setup Performance with HCI Bench
- Creating the Jumpbox Virtual Machine
- Choosing Your Deployment Option
- Validating the Greenplum Installation
- Managing Single Host Failures in vSphere
- Planning Downtime for Maintenance
- Installing and Upgrading
- Estimating Storage Capacity
- Configuring Your Systems
- Installing the Greenplum Database Software
- Verifying a Greenplum Database Software Download
- Creating the Data Storage Areas
- Validating Your Systems
- Initializing a Greenplum Database System
- Installing Optional Extensions
- Installing Additional Supplied Modules
- Configuring Timezone and Localization Settings
- Upgrading to Greenplum 6
- Migrating Open Source Greenplum Database to VMware Greenplum Database
- Enabling iptables (Optional)
- Installation Management Utilities
- Greenplum Environment Variables
- Example Ansible Playbook
- Securing Your System
- Managing Data
- Defining Database Objects
- Creating and Managing Databases
- Creating and Managing Tablespaces
- Creating and Managing Schemas
- Creating and Managing Tables
- Choosing the Table Storage Model
- Partitioning Large Tables
- Creating and Using Sequences
- Using Indexes in Greenplum Database
- Creating and Managing Views
- Creating and Managing Materialized Views
- Working with External Data
- Defining External Tables
- file:// Protocol
- gpfdist:// Protocol
- gpfdists:// Protocol
- pxf:// Protocol
- s3:// Protocol
- Using a Custom Protocol
- Handling Errors in External Table Data
- Creating and Using External Web Tables
- Examples for Creating External Tables
- Example 1—Single gpfdist instance on single-NIC machine
- Example 2—Multiple gpfdist instances
- Example 3—Multiple gpfdists instances
- Example 4—Single gpfdist instance with error logging
- Example 5—TEXT Format on a Hadoop Distributed File Server
- Example 6—Multiple files in CSV format with header rows
- Example 7—Readable External Web Table with Script
- Example 8—Writable External Table with gpfdist
- Example 9—Writable External Web Table with Script
- Example 10—Readable and Writable External Tables with XML Transformations
- Accessing External Data with Foreign Tables
- Using the Greenplum Parallel File Server (gpfdist)
- Defining External Tables
- Loading and Unloading Data
- Greenplum Client and Loader Tools Package
- Loading Data Using an External Table
- Loading and Writing Non-HDFS Custom Data
- Handling Load Errors
- Loading Data with gpload
- Accessing External Data with PXF
- Transforming External Data with gpfdist and gpload
- Loading Data with COPY
- Running COPY in Single Row Error Isolation Mode
- Optimizing Data Load and Query Performance
- Unloading Data from Greenplum Database
- Formatting Data Files
- Example Custom Data Access Protocol
- Querying Data
- Advanced Analytics
- Inserting, Updating, and Deleting Data
- Defining Database Objects
- System Administration
- About the Greenplum Database Release Version Number
- Starting and Stopping Greenplum Database
- Managing Database Access
- Accessing the Database
- Configuring the Greenplum Database System
- Enabling Compression
- Configuring Proxies for the Greenplum Interconnect
- Enabling High Availability and Data Consistency Features
- Backing Up and Restoring Databases
- Expanding a Greenplum System
- Migrating Data with gpcopy
- Monitoring a Greenplum System
- Routine System Maintenance Tasks
- Recommended Monitoring and Maintenance Tasks
- Managing Performance
- Best Practices
- Best Practices Summary
- System Configuration
- Schema Design
- Memory and Resource Management with Resource Groups
- Memory and Resource Management with Resource Queues
- System Monitoring and Maintenance
- Loading Data
- Identifying and Mitigating Heap Table Performance Issues
- Security
- Encrypting Data and Database Connections
- Tuning SQL Queries
- High Availability
- Reference
- SQL Commands
- SQL Syntax Summary
- ABORT
- ALTER AGGREGATE
- ALTER COLLATION
- ALTER CONVERSION
- ALTER DATABASE
- ALTER DEFAULT PRIVILEGES
- ALTER DOMAIN
- ALTER EXTENSION
- ALTER EXTERNAL TABLE
- ALTER FOREIGN DATA WRAPPER
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER MATERIALIZED VIEW
- ALTER OPERATOR
- ALTER OPERATOR CLASS
- ALTER OPERATOR FAMILY
- ALTER PROTOCOL
- ALTER RESOURCE GROUP
- ALTER RESOURCE QUEUE
- ALTER ROLE
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER SERVER
- ALTER TABLE
- ALTER TABLESPACE
- ALTER TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH DICTIONARY
- ALTER TEXT SEARCH PARSER
- ALTER TEXT SEARCH TEMPLATE
- ALTER TYPE
- ALTER USER
- ALTER USER MAPPING
- ALTER VIEW
- ANALYZE
- BEGIN
- CHECKPOINT
- CLOSE
- CLUSTER
- COMMENT
- COMMIT
- COPY
- CREATE AGGREGATE
- CREATE CAST
- CREATE COLLATION
- CREATE CONVERSION
- CREATE DATABASE
- CREATE DOMAIN
- CREATE EXTENSION
- CREATE EXTERNAL TABLE
- CREATE FOREIGN DATA WRAPPER
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INDEX
- CREATE LANGUAGE
- CREATE MATERIALIZED VIEW
- CREATE OPERATOR
- CREATE OPERATOR CLASS
- CREATE OPERATOR FAMILY
- CREATE PROTOCOL
- CREATE RESOURCE GROUP
- CREATE RESOURCE QUEUE
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLESPACE
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- CREATE TEXT SEARCH PARSER
- CREATE TEXT SEARCH TEMPLATE
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- DEALLOCATE
- DECLARE
- DELETE
- DISCARD
- DO
- DROP AGGREGATE
- DROP CAST
- DROP COLLATION
- DROP CONVERSION
- DROP DATABASE
- DROP DOMAIN
- DROP EXTENSION
- DROP EXTERNAL TABLE
- DROP FOREIGN DATA WRAPPER
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP MATERIALIZED VIEW
- DROP OPERATOR
- DROP OPERATOR CLASS
- DROP OPERATOR FAMILY
- DROP OWNED
- DROP PROTOCOL
- DROP RESOURCE GROUP
- DROP RESOURCE QUEUE
- DROP ROLE
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP SERVER
- DROP TABLE
- DROP TABLESPACE
- DROP TEXT SEARCH CONFIGURATION
- DROP TEXT SEARCH DICTIONARY
- DROP TEXT SEARCH PARSER
- DROP TEXT SEARCH TEMPLATE
- DROP TYPE
- DROP USER
- DROP USER MAPPING
- DROP VIEW
- END
- EXECUTE
- EXPLAIN
- FETCH
- GRANT
- INSERT
- LISTEN
- LOAD
- LOCK
- MOVE
- NOTIFY
- PREPARE
- REASSIGN OWNED
- REFRESH MATERIALIZED VIEW
- REINDEX
- RELEASE SAVEPOINT
- RESET
- RETRIEVE
- REVOKE
- ROLLBACK
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- START TRANSACTION
- TRUNCATE
- UNLISTEN
- UPDATE
- VACUUM
- VALUES
- Data Types
- Summary of Built-in Functions
- Additional Supplied Modules
- Character Set Support
- Server Configuration Parameters
- Database Utilities
- About the Greenplum Database Utilities
- Utility Reference
- analyzedb
- clusterdb
- createdb
- createuser
- dropdb
- dropuser
- gpactivatestandby
- gpaddmirrors
- gpcheckcat
- gpcheckperf
- gpconfig
- gpcopy
- gpdeletesystem
- gpexpand
- gpfdist
- gpinitstandby
- gpinitsystem
- gpload
- gplogfilter
- gpmapreduce
- gpmapreduce.yaml
- gpmemreport
- gpmemwatcher
- gpmovemirrors
- gpmt
- gppkg
- gprecoverseg
- gpreload
- gpscp
- gpss
- gpssh
- gpssh-exkeys
- gpstart
- gpstate
- gpstop
- pg_config
- pg_dump
- pg_dumpall
- pg_restore
- pgbouncer
- pgbouncer.ini
- pgbouncer-admin
- plcontainer
- plcontainer Configuration File
- psql
- reindexdb
- vacuumdb
- Additional Supplied Programs
- System Catalogs
- System Tables
- System Views
- System Catalogs Definitions
- foreign_data_wrapper_options
- foreign_data_wrappers
- foreign_server_options
- foreign_servers
- foreign_table_options
- foreign_tables
- gp_configuration_history
- gp_distributed_log
- gp_distributed_xacts
- gp_distribution_policy
- gpexpand.expansion_progress
- gp_endpoints
- gpexpand.status
- gpexpand.status_detail
- gp_fastsequence
- gp_id
- gp_pgdatabase
- gp_resgroup_config
- gp_resgroup_status
- gp_resgroup_status_per_host
- gp_resgroup_status_per_segment
- gp_resqueue_status
- gp_segment_configuration
- gp_segment_endpoints
- gp_session_endpoints
- gp_stat_replication
- gp_transaction_log
- gp_version_at_initdb
- pg_aggregate
- pg_am
- pg_amop
- pg_amproc
- pg_appendonly
- pg_attrdef
- pg_attribute
- pg_attribute_encoding
- pg_auth_members
- pg_authid
- pg_available_extension_versions
- pg_available_extensions
- pg_cast
- pg_class
- pg_compression
- pg_constraint
- pg_conversion
- pg_cursors
- pg_database
- pg_db_role_setting
- pg_depend
- pg_description
- pg_enum
- pg_extension
- pg_exttable
- pg_foreign_data_wrapper
- pg_foreign_server
- pg_foreign_table
- pg_index
- pg_inherits
- pg_language
- pg_largeobject
- pg_locks
- pg_matviews
- pg_max_external_files
- pg_namespace
- pg_opclass
- pg_operator
- pg_opfamily
- pg_partition
- pg_partition_columns
- pg_partition_encoding
- pg_partition_rule
- pg_partition_templates
- pg_partitions
- pg_pltemplate
- pg_proc
- pg_resgroup
- pg_resgroupcapability
- pg_resourcetype
- pg_resqueue
- pg_resqueue_attributes
- pg_resqueuecapability
- pg_rewrite
- pg_roles
- pg_rules
- pg_shdepend
- pg_shdescription
- pg_stat_activity
- pg_stat_all_indexes
- pg_stat_all_tables
- pg_stat_last_operation
- pg_stat_last_shoperation
- pg_stat_operations
- pg_stat_partition_operations
- pg_stat_replication
- pg_statistic
- pg_stat_resqueues
- pg_tablespace
- pg_trigger
- pg_type
- pg_type_encoding
- pg_user_mapping
- pg_user_mappings
- user_mapping_options
- user_mappings
- The gp_toolkit Administrative Schema
- The gpperfmon Database
- SQL Features, Reserved and Key Words, and Compliance
- Objects Removed in Greenplum 6
- Server Configuration Changes from Greenplum 5 to 6
- SQL Commands
- Server Programmatic Interfaces
暂无相关搜索结果！
本文档使用 BookStack 构建
