思维导图备注

Greenplum Database v5.29 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Example 10—Readable and Writable External Tables with XML Transformations

 Download  来源:Greenplum 浏览 160 扫码 分享 2023-01-31 21:08:28
  • Example 10—Readable and Writable External Tables with XML Transformations

    Example 10—Readable and Writable External Tables with XML Transformations

    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

    当前内容版权归 Greenplum 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 Greenplum .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Greenplum Database v6.24 Documentation
    • Greenplum Database v6.23 Documentation
    • Greenplum Database v6.10 Documentation
    • Greenplum数据库 v5.0 中文文档
    • Greenplum数据库 v6.0 中文文档
    • Greenplum Database v5.29 Documentation
    • Version 5.29
    • Release Notes
    • Installation Guide
      • Introduction to Greenplum
      • Estimating Storage Capacity
      • Configuring Your Systems and Installing Greenplum
      • Verifying the VMware Tanzu Greenplum Software Download
      • Validating Your Systems
      • Initializing a Greenplum Database System
      • Installing Optional Extensions
        • Procedural Language, Machine Learning, and Geospatial Extensions
        • Python Data Science Module Package
        • R Data Science Library Package
        • Greenplum Platform Extension Framework (PXF)
        • Oracle Compatibility Functions
        • dblink Connectivity Functions
        • pgcrypto Cryptographic Functions
      • Configuring Timezone and Localization Settings
      • About Implicit Text Casting in Greenplum Database
      • Installation Management Utilities
      • Greenplum Environment Variables
    • Greenplum Database 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
        • Updating Statistics with ANALYZE
        • Managing Bloat in the Database
        • Monitoring Greenplum Database Log Files
      • Loading Data
      • Migrating Data with gptransfer
      • Security
      • Encrypting Data and Database Connections
      • Tuning SQL Queries
      • High Availability
    • Cloud Technical Recommendations
    • Greenplum Database Security Configuration Guide
      • Securing the Database
      • Greenplum Database Ports and Protocols
      • Configuring Client Authentication
      • Configuring Database Authorization
      • Greenplum Command Center Security
      • Auditing
      • Encrypting Data and Database Connections
      • Enabling gphdfs Authentication with a Kerberos-secured Hadoop Cluster (Deprecated)
      • Security Best Practices
    • System Administration
      • Greenplum Database Concepts
        • About the Greenplum Architecture
        • About Management and Monitoring Utilities
        • About Concurrency Control in Greenplum Database
          • Example of Managing Transaction IDs
        • About Parallel Data Loading
        • About Redundancy and Failover in Greenplum Database
        • About Database Statistics in Greenplum Database
      • Managing a Greenplum System
        • About the Greenplum Database Release Version Number
        • Starting and Stopping Greenplum Database
        • Accessing the Database
          • Establishing a Database Session
          • Supported Client Applications
          • Greenplum Database Client Applications
          • Connecting with psql
          • Using the PgBouncer Connection Pooler
          • Database Application Interfaces
          • Troubleshooting Connection Problems
        • Configuring the Greenplum Database System
          • About Greenplum Database Master and Local Parameters
          • Setting Configuration Parameters
            • Setting a Local Configuration Parameter
            • Setting a Master Configuration Parameter
              • Setting Parameters at the System Level
              • Setting Parameters at the Database Level
              • Setting Parameters at the Role Level
              • Setting Parameters in a Session
          • Viewing Server Configuration Parameter Settings
          • Configuration Parameter Categories
            • Connection and Authentication Parameters
              • Connection Parameters
              • Security and Authentication Parameters
            • System Resource Consumption Parameters
              • Memory Consumption Parameters
              • Free Space Map Parameters
              • OS Resource Parameters
              • Cost-Based Vacuum Delay Parameters
              • Transaction ID Management Parameters
            • Query Tuning Parameters
              • GPORCA Configuration Parameters
              • Query Plan Operator Control Parameters
              • Legacy Query Optimizer Costing Parameters
              • Database Statistics Sampling Parameters
              • Sort Operator Configuration Parameters
              • Aggregate Operator Configuration Parameters
              • Join Operator Configuration Parameters
              • Other Legacy Query Optimizer Configuration Parameters
            • Error Reporting and Logging Parameters
              • Log Rotation
              • When to Log
              • What to Log
            • System Monitoring Parameters
              • SNMP Alerts
              • Email Alerts
              • Greenplum Command Center Agent
            • Runtime Statistics Collection Parameters
            • Automatic Statistics Collection Parameters
            • Client Connection Default Parameters
              • Statement Behavior Parameters
              • Locale and Formatting Parameters
              • Other Client Default Parameters
            • Lock Management Parameters
            • Resource Management Parameters
            • External Table Parameters
            • Database Table Parameters
            • Database and Tablespace/Filespace Parameters
            • Past Version Compatibility Parameters
            • Greenplum Array Configuration Parameters
              • Interconnect Configuration Parameters
              • Dispatch Configuration Parameters
              • Fault Operation Parameters
              • Distributed Transaction Management Parameters
              • Read-Only Parameters
            • Greenplum Master and Segment Mirroring Parameters
            • Greenplum Database Extension Parameters
        • Enabling High Availability and Data Consistency Features
          • Overview of Greenplum Database High Availability
            • Overview of Segment Mirroring
            • Overview of Master Mirroring
            • Overview of Fault Detection and Recovery
          • Enabling Mirroring in Greenplum Database
            • Enabling Segment Mirroring
            • Enabling Master Mirroring
          • Detecting a Failed Segment
            • Enabling Alerts and Notifications
            • Checking for Failed Segments
            • Checking the Log Files for Failed Segments
          • Recovering a Failed Segment
            • Recovering From Segment Failures
              • When a segment host is not recoverable
              • About the Segment Recovery Process
          • Recovering a Failed Master
            • Restoring Master Mirroring After a Recovery
        • Backing Up and Restoring Databases
          • Backup and Restore Overview
          • Parallel Backup with gpcrondump and gpdbrestore
            • Backup and Restore Options
            • Backing Up with gpcrondump
            • Backing Up a Set of Tables
            • Creating Incremental Backups
            • Backup Process and Locks
            • Using Direct I/O
            • Using Named Pipes
            • Backing Up Databases with Data Domain Boost
            • Backing Up Databases with Veritas NetBackup
            • Restoring Greenplum Databases
            • Restoring a Database Using gpdbrestore
            • Restoring to a Different Greenplum System Configuration
          • Parallel Backup with gpbackup and gprestore
            • Creating Incremental Backups with gpbackup and gprestore
            • Using gpbackup and gprestore with BoostFS
            • Using gpbackup Storage Plugins
              • Using the S3 Storage Plugin with gpbackup and gprestore
              • Using the DD Boost Storage Plugin with gpbackup and gprestore
                • Replicating Backups
            • Backup/Restore Storage Plugin API (Beta)
              • backup_data
              • backup_file
              • cleanup_plugin_for_backup
              • cleanup_plugin_for_restore
              • plugin_api_version
              • restore_data
              • restore_file
              • setup_plugin_for_backup
              • setup_plugin_for_restore
        • Expanding a Greenplum System
          • System Expansion Overview
          • Planning Greenplum System Expansion
          • Preparing and Adding Nodes
          • Initializing New Segments
          • Redistributing Tables
          • Removing the Expansion Schema
        • Migrating Data
          • Migrating Data with gpcopy
          • Migrating Data with gptransfer
        • Monitoring a Greenplum System
        • Routine System Maintenance Tasks
        • Recommended Monitoring and Maintenance Tasks
      • Managing Greenplum Database Access
        • Configuring Client Authentication
          • Using LDAP Authentication with TLS/SSL
          • Using Kerberos Authentication
          • Configuring Kerberos for Linux Clients
          • Configuring Kerberos For Windows Clients
        • Managing Roles and Privileges
      • 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
          • Best Practices when Creating Views
          • Working with View Dependencies
          • About View Storage in Greenplum Database
      • Distribution and Skew
      • Inserting, Updating, and Deleting Data
      • Querying Data
        • About Greenplum Query Processing
        • About GPORCA
          • Overview of GPORCA
          • Enabling and Disabling GPORCA
          • Collecting Root Partition Statistics
          • Considerations when Using GPORCA
          • GPORCA Features and Enhancements
          • Changed Behavior with the GPORCA
          • GPORCA Limitations
          • Determining the Query Optimizer that is Used
          • About Uniform Multi-level Partitioned Tables
        • Defining Queries
        • WITH Queries (Common Table Expressions)
        • Using Functions and Operators
        • Working with JSON Data
        • Working with XML Data
        • Query Performance
        • Managing Spill Files Generated by Queries
        • Query Profiling
      • Working with External Data
        • Defining External Tables
          • file:// Protocol
          • gpfdist:// Protocol
          • gpfdists:// Protocol
          • gphdfs:// Protocol (Deprecated)
          • 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 HDFS Data with gphdfs (Deprecated)
          • One-time gphdfs Protocol Installation (Deprecated)
          • Grant Privileges for the gphdfs Protocol (Deprecated)
          • Specify gphdfs Protocol in an External Table Definition (Deprecated)
          • gphdfs Support for Avro Files (Deprecated)
          • gphdfs Support for Parquet Files (Deprecated)
          • HDFS Readable and Writable External Table Examples (Deprecated)
          • Reading and Writing Custom-Formatted HDFS Data with gphdfs (Deprecated)
          • Using Amazon EMR with Greenplum Database installed on AWS (Deprecated)
        • Using the Greenplum Parallel File Server (gpfdist)
      • Loading and Unloading Data
        • Loading Data Using an External Table
        • Loading and Writing Non-HDFS Custom Data
          • Using a Custom Format
            • Importing and Exporting Fixed Width Data
            • Examples: Read Fixed-Width Data
          • Using a Custom Protocol
        • Handling Load Errors
          • Define an External Table with Single Row Error Isolation
          • Capture Row Formatting Errors and Declare a Reject Limit
          • Viewing Bad Rows in the Error Log
          • Identifying Invalid CSV Files in Error Table Data
          • Moving Data between Tables
        • Loading Data with gpload
        • Accessing External Data with PXF
        • Loading Kafka Data with the Greenplum-Kafka Integration
        • Loading Data with the Greenplum Streaming Server
        • Using the Greenplum-Spark Connector
        • Using the Greenplum-Informatica Connector
        • 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
          • Defining a File-Based Writable External Table
            • Example 1—Greenplum file server (gpfdist)
            • Example 2—Hadoop file server (gphdfs (Deprecated))
          • Defining a Command-Based Writable External Web Table
            • Disabling EXECUTE for Web or Writable External Tables
          • Unloading Data Using a Writable External Table
          • Unloading Data Using COPY
        • Formatting Data Files
          • Formatting Rows
          • Formatting Columns
          • Representing NULL Values
          • Escaping
            • Escaping in Text Formatted Files
            • Escaping in CSV Formatted Files
          • Character Encoding
        • Example Custom Data Access Protocol
          • Installing the External Table Protocol
            • gpextprotocal.c
      • Managing Performance
        • Defining Database Performance
        • Common Causes of Performance Issues
        • Greenplum Database Memory Overview
        • Managing Resources
          • Using Resource Groups
          • Using Resource Queues
        • Investigating a Performance Problem
    • Reference Guide
      • SQL Command Reference
        • SQL Syntax Summary
        • ABORT
        • ALTER AGGREGATE
        • ALTER CONVERSION
        • ALTER DATABASE
        • ALTER DOMAIN
        • ALTER EXTENSION
        • ALTER EXTERNAL TABLE
        • ALTER FILESPACE
        • ALTER FUNCTION
        • ALTER GROUP
        • ALTER INDEX
        • ALTER LANGUAGE
        • ALTER OPERATOR
        • ALTER OPERATOR CLASS
        • ALTER OPERATOR FAMILY
        • ALTER PROTOCOL
        • ALTER RESOURCE GROUP
        • ALTER RESOURCE QUEUE
        • ALTER ROLE
        • ALTER SCHEMA
        • ALTER SEQUENCE
        • ALTER TABLE
        • ALTER TABLESPACE
        • ALTER TYPE
        • ALTER USER
        • ALTER VIEW
        • ANALYZE
        • BEGIN
        • CHECKPOINT
        • CLOSE
        • CLUSTER
        • COMMENT
        • COMMIT
        • COPY
        • CREATE AGGREGATE
        • CREATE CAST
        • CREATE CONVERSION
        • CREATE DATABASE
        • CREATE DOMAIN
        • CREATE EXTENSION
        • CREATE EXTERNAL TABLE
        • CREATE FUNCTION
        • CREATE GROUP
        • CREATE INDEX
        • CREATE LANGUAGE
        • 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 TABLE
        • CREATE TABLE AS
        • CREATE TABLESPACE
        • CREATE TYPE
        • CREATE USER
        • CREATE VIEW
        • DEALLOCATE
        • DECLARE
        • DELETE
        • DISCARD
        • DO
        • DROP AGGREGATE
        • DROP CAST
        • DROP CONVERSION
        • DROP DATABASE
        • DROP DOMAIN
        • DROP EXTENSION
        • DROP EXTERNAL TABLE
        • DROP FILESPACE
        • DROP FUNCTION
        • DROP GROUP
        • DROP INDEX
        • DROP LANGUAGE
        • 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 TABLE
        • DROP TABLESPACE
        • DROP TYPE
        • DROP USER
        • DROP VIEW
        • END
        • EXECUTE
        • EXPLAIN
        • FETCH
        • GRANT
        • INSERT
        • LOAD
        • LOCK
        • MOVE
        • PREPARE
        • REASSIGN OWNED
        • REINDEX
        • RELEASE SAVEPOINT
        • RESET
        • REVOKE
        • ROLLBACK
        • ROLLBACK TO SAVEPOINT
        • SAVEPOINT
        • SELECT
        • SELECT INTO
        • SET
        • SET ROLE
        • SET SESSION AUTHORIZATION
        • SET TRANSACTION
        • SHOW
        • START TRANSACTION
        • TRUNCATE
        • UPDATE
        • VACUUM
        • VALUES
      • SQL 2008 Optional Feature Compliance
      • Greenplum Environment Variables
      • System Catalog Reference
        • System Tables
        • System Views
        • System Catalogs Definitions
          • gp_configuration_history
          • gp_distributed_log
          • gp_distributed_xacts
          • gp_distribution_policy
          • gpexpand.expansion_progress
          • gpexpand.status
          • gpexpand.status_detail
          • gp_fastsequence
          • gp_fault_strategy
          • gp_global_sequence
          • gp_id
          • gp_persistent_database_node
          • gp_persistent_filespace_node
          • gp_persistent_relation_node
          • gp_persistent_tablespace_node
          • gp_pgdatabase
          • gp_relation_node
          • gp_resgroup_config
          • gp_resgroup_status
          • gp_resqueue_status
          • gp_segment_configuration
          • 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_database
          • pg_depend
          • pg_description
          • pg_enum
          • pg_extension
          • pg_exttable
          • pg_filespace
          • pg_filespace_entry
          • pg_index
          • pg_inherits
          • pg_language
          • pg_largeobject
          • pg_listener
          • pg_locks
          • pg_max_external_files
          • pg_namespace
          • pg_opclass
          • pg_operator
          • 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_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_window
      • The gp_toolkit Administrative Schema
      • The gpperfmon Database
        • database_*
        • diskspace_*
        • interface_stats_*
        • log_alert_*
        • queries_*
        • segment_*
        • socket_stats_*
        • system_*
        • dynamic_memory_info
        • memory_info
      • Greenplum Database Data Types
      • Character Set Support
      • Server Configuration Parameters
        • Parameter Categories
        • Configuration Parameters
      • Summary of Built-in Functions
      • Greenplum MapReduce Specification
      • Greenplum PL/pgSQL Procedural Language
      • Greenplum PostGIS Extension
      • Greenplum PL/R Language Extension
      • Greenplum PL/Python Language Extension
      • PL/Container Language
      • Greenplum PL/Java Language Extension
      • Greenplum PL/Perl Language Extension
      • Greenplum MADlib Extension for Analytics
      • Greenplum Partner Connector API
      • Greenplum Fuzzy String Match Extension
      • Summary of Greenplum Features
    • Utility Guide
      • Management Utility Reference
        • analyzedb
        • gpactivatestandby
        • gpaddmirrors
        • gpbackup
        • gpcheck
        • gpcheckcat
        • gpcheckperf
        • gpconfig
        • gpcrondump
        • gpdbrestore
        • gpcopy
        • gpdeletesystem
        • gpexpand
        • gpfdist
        • gpfilespace
        • gpinitstandby
        • gpinitsystem
        • gpkafka
        • gpload
        • gplogfilter
        • gpmapreduce
        • gpmfr
        • gpmovemirrors
        • gpmt
        • gpperfmon_install
        • gppkg
        • gprecoverseg
        • gpreload
        • gprestore
        • gpscp
        • gpseginstall
        • gpssh
        • gpss
        • gpssh-exkeys
        • gpstart
        • gpstate
        • gpstop
        • gpsys1
        • gptransfer
        • pgbouncer
        • pgbouncer.ini
        • pgbouncer-admin
        • plcontainer
        • plcontainer Configuration File
      • Client Utility Reference
        • clusterdb
        • createdb
        • createlang
        • createuser
        • dropdb
        • droplang
        • dropuser
        • pg_config
        • pg_dump
        • pg_dumpall
        • pg_restore
        • psql
        • reindexdb
        • vacuumdb
      • Additional Supplied Modules
        • citext Data Type
        • dblink Functions
        • hstore Functions
        • Oracle Compatibility Functions
    • UNIX Client Documentation
      • Client Tools for UNIX
        • Installing the Greenplum Client Tools
        • Client Tools Reference
      • Load Tools for UNIX
        • Installing the Greenplum Load Tools
        • Load Tools Reference
    • Windows Client Documentation
      • Client Tools for Windows
        • Installing the Greenplum Client Tools
        • Running the Greenplum Client Tools
        • Client Tools Reference
      • Load Tools for Windows
        • Installing Greenplum Loader
        • Running Greenplum Loader
        • Running gpfdist as a Windows Service
        • Loader Program Reference
    • DataDirect ODBC Drivers for Tanzu Greenplum
    • DataDirect JDBC Driver for Tanzu Greenplum
    • Versions 5.28 and Older Docs
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      • 普通下载
      • 下载码下载(免登录无限下载)
      你与大神的距离，只差一个APP
      APP下载
      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档
      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
      下载码方式下载：免费、免登录、无限制。 免费获取下载码

      微信小程序阅读

      BookChat 微信小程序阅读
      您与他人的薪资差距，只差一个随时随地学习的小程序

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度