Apache HAWQ v2.3.0 Document
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
Unloading Data Using COPY
来源 1
浏览
259
扫码
打印
2020-09-23 23:56:03
Unloading Data Using COPY
上一篇:
下一篇:
发布点评
Getting Started with HAWQ Tutorial
Lesson 5 - HAWQ Tables
Lesson 6 - HAWQ Extension Framework (PXF)
Lesson 1 - Runtime Environment
Lesson 3 - Database Administration
Lesson 4 - Sample Data Set and HAWQ Schemas
Lesson 2 - Cluster Administration
HAWQ Reference
HAWQ Management Tools Reference
createuser
hawq state
pg_dump
hawq init
createdb
pg_restore
hawq ssh-exkeys
hawq register
hawq activate
hawq start
psql
pg_dumpall
vacuumdb
hawq load
dropuser
hawq stop
hawq restart
gplogfilter
analyzedb
dropdb
hawq scp
gpfdist
hawq filespace
hawq ssh
hawq check
hawq extract
hawq checkperf
hawq config
Data Types
Character Set Support Reference
SQL Commands
END
CREATE DATABASE
COPY
DROP GROUP
CREATE CAST
DROP SCHEMA
ALTER CONVERSION
ALTER ROLE
COMMIT
ALTER AGGREGATE
BEGIN
PREPARE
ABORT
CREATE AGGREGATE
FETCH
CLOSE
EXPLAIN
DROP CAST
ALTER TABLE
SET
ALTER FUNCTION
CREATE VIEW
DROP ROLE
CREATE USER
ANALYZE
RESET
SAVEPOINT
ALTER TABLESPACE
CREATE CONVERSION
DROP DATABASE
DROP USER
SELECT
GRANT
CREATE TABLE
DROP TYPE
RELEASE SAVEPOINT
REVOKE
DROP TABLE
INSERT
DROP FUNCTION
CREATE TABLESPACE
CREATE OPERATOR
DROP OPERATOR CLASS
ALTER OPERATOR CLASS
CREATE FUNCTION
SHOW
ALTER USER
DROP LANGUAGE
CREATE OPERATOR CLASS
CREATE TYPE
TRUNCATE
DROP FILESPACE
ALTER SEQUENCE
ROLLBACK
CREATE RESOURCE QUEUE
CREATE GROUP
CREATE TABLE AS
DROP EXTERNAL TABLE
ALTER TYPE
DROP OPERATOR
SET ROLE
CREATE EXTERNAL TABLE
DROP CONVERSION
DROP RESOURCE QUEUE
CREATE SEQUENCE
ALTER DATABASE
DROP SEQUENCE
ROLLBACK TO SAVEPOINT
DECLARE
REASSIGN OWNED
CHECKPOINT
ALTER OPERATOR
SELECT INTO
CREATE ROLE
DROP TABLESPACE
SET SESSION AUTHORIZATION
CREATE SCHEMA
VACUUM
DROP AGGREGATE
DROP VIEW
DEALLOCATE
EXECUTE
CREATE LANGUAGE
DROP OWNED
ALTER RESOURCE QUEUE
The hawq_toolkit Administrative Schema
Server Configuration Parameter Reference
Configuration Parameters
Configuration Parameter Categories
Sample hawq-site.xml Configuration File
About Server Configuration Parameters
HDFS Configuration Reference
Environment Variables
System Catalog Reference
System Tables
System Views
System Catalogs Definitions
pg_partition_encoding
pg_exttable
pg_largeobject
pg_filespace
pg_locks
pg_partition_rule
gp_master_mirroring
pg_description
pg_stat_last_operation
pg_window
pg_amproc
pg_namespace
pg_tablespace
gp_persistent_database_node
pg_pltemplate
pg_rewrite
pg_partition
pg_attribute_encoding
gp_persistent_relation_node
pg_aggregate
pg_authid
pg_auth_members
pg_database
pg_stat_activity
pg_attribute
pg_resqueue_status
gp_segment_configuration
pg_conversion
pg_partition_columns
pg_constraint
pg_stats
pg_partition_templates
gp_relfile_node
pg_proc
gp_persistent_relfile_node
pg_listener
pg_index
pg_resqueue
pg_stat_partition_operations
pg_appendonly
pg_am
pg_statistic
pg_type_encoding
pg_operator
pg_shdepend
gp_global_sequence
pg_class
pg_opclass
pg_roles
pg_trigger
pg_language
pg_shdescription
pg_stat_last_shoperation
pg_compression
pg_inherits
pg_partitions
pg_amop
pg_filespace_entry
gp_version_at_initdb
pg_depend
pg_stat_operations
pg_cast
pg_attrdef
gp_distribution_policy
pg_type
gp_configuration_history
gp_persistent_tablespace_node
gp_persistent_filespace_node
Best Practices
Querying Data
Operating HAWQ
Managing Data
Managing Resources
Configuring HAWQ
Securing HAWQ
System Requirements
Defining Database Objects
Creating and Managing Tablespaces
Identifying HAWQ Table HDFS Files
Choosing the Table Storage Model
Creating and Managing Views
Creating and Managing Databases
Partitioning Large Tables
Overview
Creating and Managing Tables
Creating and Managing Schemas
Managing Data with HAWQ
Concurrency Control
Loading and Unloading Data
Optimizing Data Load and Query Performance
Using the HAWQ File Server (gpfdist)
About gpfdist Setup and Performance
Troubleshooting gpfdist
Starting and Stopping gpfdist
Installing gpfdist
Controlling Segment Parallelism
Working with File-Based External Tables
gpfdists Protocol
Accessing File-Based External Tables
gpfdist Protocol
Handling Errors in External Table Data
Loading Data with COPY
Loading Data Using an External Table
Transforming XML Data
Load the Data
Write the gpfdist Configuration
Write a Transform
XML Transformation Examples
Example using IRS MeF XML Files (In demo Directory)
Command-based Web External Tables
Example using WITSML™ Files (In demo Directory)
Transfer and Store the Data
Transforming with INSERT INTO SELECT FROM
Transforming with GPLOAD
Configuration File Format
Determine the Transformation Schema
Loading Data with hawq load
Unloading Data from HAWQ
Defining a Command-Based Writable External Web Table
Disabling EXECUTE for Web or Writable External Tables
Defining a File-Based Writable External Table
Example - HAWQ file server (gpfdist)
Unloading Data Using a Writable External Table
Unloading Data Using COPY
Creating and Using Web External Tables
Command-based Web External Tables
URL-based Web External Tables
Formatting Data Files
Character Encoding
Formatting Columns
Escaping
Escaping in CSV Formatted Files
Escaping in Text Formatted Files
Representing NULL Values
Formatting Rows
Registering Files into HAWQ Internal Tables
Handling Load Errors
Moving Data between Tables
Capture Row Formatting Errors and Declare a Reject Limit
Identifying Invalid CSV Files in Error Table Data
Define an External Table with Single Row Error Isolation
Running COPY in Single Row Error Isolation Mode
Creating External Tables - Examples
Loading and Writing Non-HDFS Custom Data
Using a Custom Format
Examples - Read Fixed-Width Data
Importing and Exporting Fixed Width Data
Basic Data Operations
HAWQ InputFormat for MapReduce
About Database Statistics
Working with Transactions
Using PXF with Unmanaged Data
Installing PXF Plugins
Accessing External SQL Databases
PXF External Tables and API
Accessing HBase Data
Writing Data to HDFS
Configuring PXF
Troubleshooting PXF
Accessing HDFS File Data
Using Profiles to Read and Write Data
Accessing JSON Data
Accessing Hive Data
Querying Data
About HAWQ Query Processing
Query Performance
About GPORCA
Determining The Query Optimizer In Use
Considerations when Using GPORCA
GPORCA Limitations
Changed Behavior with GPORCA
Enabling GPORCA
GPORCA Features and Enhancements
Overview of GPORCA
Query Profiling
Using Functions and Operators
Defining Queries
Troubleshooting
HAWQ System Overview
Elastic Query Execution Runtime
Table Distribution and Storage
Resource Management
Management Tools
HDFS Catalog Cache
High Availability, Redundancy and Fault Tolerance
What is HAWQ?
HAWQ Architecture
Managing Client Access
Connecting with psql
Using Kerberos Authentication
Example - Setting up an MIT KDC Server
Configuring HAWQ/PXF for Secure HDFS
Configuring Kerberos User Authentication for HAWQ
Overview of HAWQ Authorization
Using HAWQ Native Authorization
Disabling Kerberos Security
Establishing a Database Session
Configuring Client Authentication
Using LDAP Authentication with TLS/SSL
HAWQ Client Applications
Troubleshooting Connection Problems
HAWQ Database Drivers and APIs
Using Ranger for Authorization
Configuring HAWQ to use Ranger Policy Management
Overview of Ranger Policy Management
High Availability and HAWQ Ranger
Creating HAWQ Authorization Policies in Ranger
HAWQ Resources and Permissions
SQL Command Permissions Summary
Using MADLib with Ranger Authorization
HAWQ Ranger Kerberos Integration
Auditing Authorization Events
Managing Resources
Analyzing Resource Manager Status
Best Practices for Configuring Resource Management
Configuring Resource Management
How HAWQ Manages Resources
Working with Hierarchical Resource Queues
Integrating YARN with HAWQ
Running a HAWQ Cluster
HAWQ Filespaces and High Availability Enabled HDFS
Monitoring a HAWQ System
Backing Up and Restoring HAWQ
Introducing the HAWQ Operating Environment
Expanding a Cluster
Recommended Monitoring and Maintenance Tasks
Starting and Stopping HAWQ
HAWQ Administrative Log Files
Managing HAWQ Using Ambari
Using the Ambari REST API
High Availability in HAWQ
Overview
Master Mirroring
Routine System Maintenance Tasks
Removing a Node
HAWQ Packcore Utility
Understanding the Fault Tolerance Service
Using Procedural Languages
Using HAWQ Built-In Languages
Using PL/R
Using PL/Python
Using PL/pgSQL
Using Languages in HAWQ
Using PL/Java
暂无相关搜索结果！
本文档使用
全库网
构建
×
思维导图备注
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
我的书签
添加书签
移除书签