我的书签
添加书签
移除书签SQL Syntax Summary
源文档无正文。
原文：<https://www.bookstack.cn/read/greenplum-6.24-en/107094fc1a92ae4f.md>
SQL Syntax Summary
- 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
暂无相关搜索结果！
本文档使用 WanXiangYunDang 构建
