我的书签
添加书签
移除书签Accessing the Database
This topic describes the various client tools you can use to connect to Greenplum Database, and how to establish a database session.
Parent topic: Managing a Greenplum System
Accessing the Database
- 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
- 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
- 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
- Managing a Greenplum System
- About the Greenplum Database Release Version Number
- Starting and Stopping Greenplum Database
- Accessing the Database
- Configuring the Greenplum Database System
- About Greenplum Database Master and Local Parameters
- Setting Configuration Parameters
- Viewing Server Configuration Parameter Settings
- Configuration Parameter Categories
- Connection and Authentication Parameters
- System Resource Consumption 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
- System Monitoring Parameters
- Runtime Statistics Collection Parameters
- Automatic Statistics Collection Parameters
- Client Connection 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
- Greenplum Master and Segment Mirroring Parameters
- Greenplum Database Extension Parameters
- Enabling High Availability and Data Consistency Features
- 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
- Expanding a Greenplum System
- Migrating Data
- Monitoring a Greenplum System
- Routine System Maintenance Tasks
- Recommended Monitoring and Maintenance Tasks
- Managing Greenplum Database Access
- Defining Database Objects
- Distribution and Skew
- Inserting, Updating, and Deleting Data
- Querying Data
- 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)
- Defining External Tables
- Loading and Unloading Data
- 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
- 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
- Formatting Data Files
- Example Custom Data Access Protocol
- Managing Performance
- 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
- Greenplum Database Data Types
- Character Set Support
- Server 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
- SQL Command Reference
- 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
- Additional Supplied Modules
- Management Utility Reference
- UNIX Client Documentation
- Windows Client Documentation
- DataDirect ODBC Drivers for Tanzu Greenplum
- DataDirect JDBC Driver for Tanzu Greenplum
- Versions 5.28 and Older Docs
暂无相关搜索结果！
本文档使用 BookStack 构建
