我的书签
添加书签
移除书签Example 10—Readable and Writable External Tables with XML Transformations
Parent topic: Examples for Creating External Tables
Example 10—Readable and Writable External Tables with XML Transformations
- DataDirect ODBC Drivers for Tanzu Greenplum
- DataDirect JDBC Driver for Tanzu Greenplum
- System Administration
- Managing Performance
- Querying Data
- Managing a Greenplum System
- Configuring the Greenplum Database System
- Configuration Parameter Categories
- Greenplum Master and Segment Mirroring Parameters
- Runtime Statistics Collection Parameters
- External Table Parameters
- Greenplum Database Extension Parameters
- Resource Management Parameters
- Database and Tablespace/Filespace Parameters
- Past Version Compatibility Parameters
- System Resource Consumption Parameters
- Error Reporting and Logging Parameters
- Connection and Authentication Parameters
- Lock Management Parameters
- Client Connection Default Parameters
- Greenplum Array Configuration Parameters
- Query Tuning Parameters
- Legacy Query Optimizer Costing Parameters
- Sort Operator Configuration Parameters
- Database Statistics Sampling Parameters
- Join Operator Configuration Parameters
- Aggregate Operator Configuration Parameters
- Other Legacy Query Optimizer Configuration Parameters
- Query Plan Operator Control Parameters
- GPORCA Configuration Parameters
- Automatic Statistics Collection Parameters
- System Monitoring Parameters
- Database Table Parameters
- Viewing Server Configuration Parameter Settings
- About Greenplum Database Master and Local Parameters
- Setting Configuration Parameters
- Configuration Parameter Categories
- Migrating Data
- About the Greenplum Database Release Version Number
- Monitoring a Greenplum System
- Recommended Monitoring and Maintenance Tasks
- Expanding a Greenplum System
- Backing Up and Restoring Databases
- Parallel Backup with gpbackup and gprestore
- Parallel Backup with gpcrondump and gpdbrestore
- Creating Incremental Backups
- Backup Process and Locks
- Backing Up a Set of Tables
- Backing Up Databases with Veritas NetBackup
- Using Named Pipes
- Using Direct I/O
- Backup and Restore Options
- Restoring Greenplum Databases
- Backing Up Databases with Data Domain Boost
- Backing Up with gpcrondump
- Restoring a Database Using gpdbrestore
- Restoring to a Different Greenplum System Configuration
- Backup and Restore Overview
- Enabling High Availability and Data Consistency Features
- Routine System Maintenance Tasks
- Accessing the Database
- Starting and Stopping Greenplum Database
- Configuring the Greenplum Database System
- Working with External Data
- Defining External Tables
- file:// Protocol
- gpfdists:// Protocol
- Creating and Using External Web Tables
- Using a Custom Protocol
- pxf:// Protocol
- gphdfs:// Protocol (Deprecated)
- gpfdist:// Protocol
- s3:// Protocol
- Handling Errors in External Table Data
- Examples for Creating External Tables
- Example 2—Multiple gpfdist instances
- Example 4—Single gpfdist instance with error logging
- Example 6—Multiple files in CSV format with header rows
- Example 7—Readable External Web Table with Script
- Example 5—TEXT Format on a Hadoop Distributed File Server
- Example 8—Writable External Table with gpfdist
- Example 3—Multiple gpfdists instances
- Example 10—Readable and Writable External Tables with XML Transformations
- Example 9—Writable External Web Table with Script
- Example 1—Single gpfdist instance on single-NIC machine
- Accessing HDFS Data with gphdfs (Deprecated)
- One-time gphdfs Protocol Installation (Deprecated)
- Using Amazon EMR with Greenplum Database installed on AWS (Deprecated)
- Reading and Writing Custom-Formatted HDFS Data with gphdfs (Deprecated)
- gphdfs Support for Parquet Files (Deprecated)
- Grant Privileges for the gphdfs Protocol (Deprecated)
- gphdfs Support for Avro Files (Deprecated)
- Specify gphdfs Protocol in an External Table Definition (Deprecated)
- HDFS Readable and Writable External Table Examples (Deprecated)
- Using the Greenplum Parallel File Server (gpfdist)
- Defining External Tables
- Defining Database Objects
- Inserting, Updating, and Deleting Data
- Distribution and Skew
- Managing Greenplum Database Access
- Greenplum Database Concepts
- Loading and Unloading Data
- Using the Greenplum-Informatica Connector
- Loading Data with COPY
- Using the Greenplum-Spark Connector
- Loading Kafka Data with the Greenplum-Kafka Integration
- Loading Data Using an External Table
- Unloading Data from Greenplum Database
- Optimizing Data Load and Query Performance
- Loading Data with gpload
- Handling Load Errors
- Accessing External Data with PXF
- Formatting Data Files
- Loading Data with the Greenplum Streaming Server
- Transforming External Data with gpfdist and gpload
- Loading and Writing Non-HDFS Custom Data
- Running COPY in Single Row Error Isolation Mode
- Example Custom Data Access Protocol
- Greenplum Database Security Configuration Guide
- Encrypting Data and Database Connections
- Configuring Database Authorization
- Securing the Database
- Auditing
- Configuring Client Authentication
- Enabling gphdfs Authentication with a Kerberos-secured Hadoop Cluster (Deprecated)
- Greenplum Command Center Security
- Greenplum Database Ports and Protocols
- Security Best Practices
- Reference Guide
- Server Configuration Parameters
- Summary of Built-in Functions
- SQL Command Reference
- ALTER DATABASE
- ALTER AGGREGATE
- CREATE TABLESPACE
- DROP AGGREGATE
- SET SESSION AUTHORIZATION
- ALTER PROTOCOL
- ALTER VIEW
- DEALLOCATE
- ALTER LANGUAGE
- TRUNCATE
- CREATE OPERATOR
- RESET
- LOAD
- SET
- ALTER GROUP
- BEGIN
- DROP SEQUENCE
- PREPARE
- DROP OWNED
- DROP VIEW
- DROP FUNCTION
- CREATE TABLE
- ALTER TABLESPACE
- DROP OPERATOR
- ALTER OPERATOR
- SET TRANSACTION
- CREATE OPERATOR CLASS
- DECLARE
- VACUUM
- DROP CONVERSION
- DROP OPERATOR CLASS
- DROP RULE
- DROP GROUP
- CLUSTER
- CREATE EXTENSION
- ALTER INDEX
- DROP DATABASE
- CREATE TYPE
- ALTER TYPE
- COMMIT
- CREATE RESOURCE GROUP
- ALTER CONVERSION
- CHECKPOINT
- CREATE LANGUAGE
- DROP TABLESPACE
- DROP USER
- ALTER EXTERNAL TABLE
- ABORT
- DISCARD
- COPY
- VALUES
- CREATE RULE
- CLOSE
- DROP FILESPACE
- SELECT
- COMMENT
- DROP OPERATOR FAMILY
- ALTER EXTENSION
- ALTER SCHEMA
- ALTER FILESPACE
- ALTER SEQUENCE
- CREATE TABLE AS
- ALTER ROLE
- CREATE INDEX
- INSERT
- DROP CAST
- GRANT
- DROP SCHEMA
- CREATE GROUP
- CREATE OPERATOR FAMILY
- SHOW
- EXPLAIN
- CREATE DATABASE
- DELETE
- START TRANSACTION
- CREATE CONVERSION
- ALTER USER
- CREATE VIEW
- CREATE FUNCTION
- UPDATE
- ALTER RESOURCE GROUP
- SET ROLE
- END
- RELEASE SAVEPOINT
- SELECT INTO
- ROLLBACK
- CREATE PROTOCOL
- DROP PROTOCOL
- ALTER RESOURCE QUEUE
- ALTER OPERATOR CLASS
- ALTER OPERATOR FAMILY
- MOVE
- CREATE USER
- REINDEX
- CREATE SCHEMA
- EXECUTE
- DROP RESOURCE QUEUE
- DROP EXTERNAL TABLE
- DO
- ALTER DOMAIN
- DROP INDEX
- CREATE DOMAIN
- SQL Syntax Summary
- DROP RESOURCE GROUP
- DROP TYPE
- ROLLBACK TO SAVEPOINT
- DROP DOMAIN
- DROP LANGUAGE
- LOCK
- CREATE SEQUENCE
- ALTER TABLE
- CREATE AGGREGATE
- DROP TABLE
- SAVEPOINT
- FETCH
- CREATE EXTERNAL TABLE
- CREATE CAST
- ALTER FUNCTION
- CREATE ROLE
- DROP ROLE
- ANALYZE
- DROP EXTENSION
- REASSIGN OWNED
- REVOKE
- CREATE RESOURCE QUEUE
- Greenplum PL/Perl Language Extension
- Greenplum Fuzzy String Match Extension
- Greenplum MADlib Extension for Analytics
- Greenplum PostGIS Extension
- Greenplum MapReduce Specification
- Greenplum PL/R Language Extension
- The gp_toolkit Administrative Schema
- SQL 2008 Optional Feature Compliance
- Summary of Greenplum Features
- System Catalog Reference
- System Catalogs Definitions
- pg_attribute
- gp_configuration_history
- gp_resqueue_status
- pg_available_extension_versions
- pg_language
- pg_stat_replication
- pg_exttable
- pg_user_mapping
- pg_rewrite
- gp_resgroup_config
- pg_trigger
- pg_stat_activity
- pg_depend
- pg_partition_templates
- pg_locks
- pg_resgroup
- gp_persistent_database_node
- gp_distributed_log
- gp_distribution_policy
- pg_opclass
- pg_window
- gp_persistent_filespace_node
- pg_partition_columns
- pg_index
- pg_tablespace
- pg_attrdef
- pg_shdepend
- pg_listener
- pg_am
- pg_stat_partition_operations
- gpexpand.status
- pg_proc
- gp_id
- gp_resgroup_status
- gp_transaction_log
- gp_fault_strategy
- pg_authid
- pg_enum
- gp_fastsequence
- pg_max_external_files
- pg_partition_rule
- pg_type_encoding
- pg_resqueuecapability
- pg_constraint
- gp_version_at_initdb
- pg_partition_encoding
- pg_stat_last_shoperation
- pg_partition
- pg_type
- pg_filespace_entry
- pg_resourcetype
- pg_database
- gp_persistent_relation_node
- pg_roles
- gpexpand.expansion_progress
- gp_relation_node
- pg_cast
- pg_amproc
- pg_resgroupcapability
- pg_class
- pg_partitions
- pg_statistic
- pg_resqueue_attributes
- pg_largeobject
- pg_shdescription
- pg_namespace
- pg_auth_members
- pg_operator
- pg_stat_resqueues
- pg_attribute_encoding
- pg_available_extensions
- pg_conversion
- gp_global_sequence
- pg_stat_all_indexes
- gp_pgdatabase
- pg_resqueue
- pg_stat_operations
- pg_pltemplate
- pg_extension
- pg_filespace
- gpexpand.status_detail
- pg_inherits
- pg_stat_all_tables
- pg_amop
- pg_stat_last_operation
- pg_aggregate
- gp_persistent_tablespace_node
- pg_appendonly
- pg_compression
- gp_distributed_xacts
- gp_segment_configuration
- pg_description
- System Views
- System Tables
- System Catalogs Definitions
- Character Set Support
- The gpperfmon Database
- Greenplum Environment Variables
- Greenplum PL/Python Language Extension
- Greenplum Partner Connector API
- Greenplum Database Data Types
- Greenplum PL/pgSQL Procedural Language
- PL/Container Language
- Greenplum PL/Java Language Extension
- Version 5.29
- Greenplum Database Best Practices
- Loading Data
- High Availability
- Migrating Data with gptransfer
- Tuning SQL Queries
- Encrypting Data and Database Connections
- Memory and Resource Management with Resource Groups
- Best Practices Summary
- System Configuration
- Memory and Resource Management with Resource Queues
- Schema Design
- Security
- System Monitoring and Maintenance
- UNIX Client Documentation
- Versions 5.28 and Older Docs
- Installation Guide
- Configuring Your Systems and Installing Greenplum
- About Implicit Text Casting in Greenplum Database
- Validating Your Systems
- Introduction to Greenplum
- Initializing a Greenplum Database System
- Configuring Timezone and Localization Settings
- Installation Management Utilities
- Greenplum Environment Variables
- Estimating Storage Capacity
- Installing Optional Extensions
- Verifying the VMware Tanzu Greenplum Software Download
- Cloud Technical Recommendations
- Release Notes
- Windows Client Documentation
- Utility Guide
- Additional Supplied Modules
- Client Utility Reference
- Management Utility Reference
- plcontainer
- gpmapreduce
- gpdbrestore
- gprecoverseg
- gpssh-exkeys
- gpstart
- gpkafka
- gpload
- gpseginstall
- gpstop
- gpaddmirrors
- analyzedb
- gpfilespace
- gpdeletesystem
- gprestore
- gpstate
- gpscp
- gpmfr
- pgbouncer-admin
- gpfdist
- gpinitsystem
- gpinitstandby
- gpcheck
- gpexpand
- gpconfig
- gpmt
- gpsys1
- pgbouncer.ini
- gppkg
- gpreload
- plcontainer Configuration File
- gpssh
- pgbouncer
- gpperfmon_install
- gpcopy
- gpss
- gpcheckperf
- gpactivatestandby
- gpcheckcat
- gplogfilter
- gpbackup
- gptransfer
- gpmovemirrors
- gpcrondump
暂无相关搜索结果！
本文档使用 全库网 构建
