GaussDB(DWS)
GaussDB(DWS)
All results for "
" in this service
All results for "
" in this service
What's New
Product Bulletin
Product Notice
GaussDB(DWS) Hot Data Storage Resource Price Adjustment on May 27th, 2024
Checking the GaussDB (DWS) Version
Version 8.1.3
New Features in Version 8.1.3
New Features and Resolved Issues in 8.1.3.x
Version 8.1.1
Version Support Notes
Function Overview
Service Overview
What Is GaussDB(DWS)?
Data Warehouse Types
Data Warehouse Flavors
Advantages
Application Scenarios
Functions
Concepts
Related Services
Security
Shared Responsibilities
Authentication and Access Control
Resource Access Control (IAM Permission Control)
Separation of Database Access Permissions
Permissions Management Using GRANT and REVOKE
Row-Level Access Control
Data Protection Technologies
Data Backup
Transparent Data Encryption
SSL-encrypted Data Transmission
Data Redaction
Function-based Encryption
Audit and Logging
Service Resilience
Risk Monitoring
Certificates
Security Notices
Vulnerability Fixing Description
GaussDB(DWS) Permissions Management
GaussDB(DWS) Access
Pricing Details
Restrictions
Service Quotas
Technical Specifications
Version Description
Getting Started
Checkpoint Vehicle Analysis
Supply Chain Requirement Analysis of a Company
Operations Status Analysis of a Retail Department Store
Creating a Time Series Table
Best Practices of Hot and Cold Data Management
Best Practices for Automatic Partition Management
Creating a Cluster and Connecting to It
Step 1: Starting Preparations
Step 2: Creating a Cluster
Step 3: Connecting to a Cluster
Step 4: Viewing Other Documents and Deleting Resources
Using CDM to Migrate MySQL Data to the GaussDB(DWS) Cluster
Using DLI Flink Jobs to Write Kafka Data to GaussDB(DWS) in Real Time
Basic SQL Operations
Database Quick Start
Before You Start
Creating and Managing Databases
Planning a Storage Model
Creating and Managing Tables
Creating a Table
Inserting Data to a Table
Updating Data in a Table
Viewing Data
Deleting Data from a Table
Loading Sample Data
Querying System Catalogs
Creating and Managing Schemas
Creating and Managing Partitioned Tables
Creating and Managing Indexes
Creating and Managing Views
Creating and Managing Sequences
Creating and Managing Scheduled Tasks
Management Guide
Procedure for Using GaussDB(DWS)
Preparations
Creating or Deleting a Cluster
Accessing the GaussDB(DWS) Management Console
Creating a Dedicated Cluster
Creating a Cluster
Creating a DWS 3.0 Cluster
Purchasing a Discount Package
Yearly/Monthly Billing
Deleting a Cluster
Cluster Connection
Methods of Connecting to a Cluster
Obtaining the Cluster Connection Address
Using the Data Studio GUI Client to Connect to a Cluster
Using the gsql CLI Client to Connect to a Cluster
Downloading the Client
Using the Linux gsql Client to Connect to a Cluster
Using the Windows gsql Client to Connect to a Cluster
Establishing Secure TCP/IP Connections in SSL Mode
Using the JDBC and ODBC Drivers to Connect to a Cluster
Development Specifications
JDBC Version Description
Downloading the JDBC or ODBC Driver
Using JDBC to Connect to a Cluster
Configuring JDBC to Connect to a Cluster (Load Balancing Mode)
Configuring JDBC to Connect to a Cluster (IAM Authentication Mode)
Using ODBC to Connect to a Cluster
Using the Third-Party Function Library psycopg2 of Python to Connect to a Cluster
Using the Python Library PyGreSQL to Connect to a Cluster
Managing Database Connections
SQL Editor Development Tool
Overview
Using the SQL Editor to Connect to a Cluster
Data Development Operations
Data Development Settings
Monitoring and Alarms
Dashboard
Databases Monitoring (DMS)
Database Monitoring Overview
Monitoring Metrics
Cluster Overview
Monitoring
Node Monitoring
Performance Monitoring
Database Monitoring
Real-Time Queries
Historical Queries
Instance Monitoring
Resource Pool Monitoring
Utilities
SQL Diagnosis
SQL Probes
Table Diagnosis
Intelligent Distribution Column Recommendation
Workload Analysis
Workload Analysis Overview
Workload Snapshots
Workload Reports
Settings
Checking Task Details
Typical Scenarios
SQL Diagnosis
Monitoring Clusters Using Cloud Eye
Alarms
Alarm Management
Alarm Rules
Alarm Subscriptions
Alarm Handling
DWS_2000000001 Node CPU Usage Exceeds the Threshold
DWS_2000000006 Node Data Disk Usage Exceeds the Threshold
DWS_2000000009 Node Data Disk I/O Usage Exceeds the Threshold
DWS_2000000012 Node Data Disk Latency Exceeds the Threshold
DWS_2000000016 Data Spilled to Disks for a Query Statement Exceeds the Threshold
DWS_2000000017 Number of Queuing Query Statements Exceeds the Threshold
DWS_2000000018 Queue Congestion in the Cluster Default Resource Pool
DWS_2000000020 SQL Probe of the Cluster Usage Exceeds the Threshold
DWS_2000000023 Vacuum Full Operation That Holds A Table Lock Exceeds the Threshold
DWS_2000000027 Instance Memory Usage of a Node in a GaussDB(DWS) Cluster Exceeds the Threshold
DWS_2000000028 Dynamic Memory Usage of a Node in a GaussDB(DWS) Cluster Exceeds the Threshold
Event Notifications
Event Notifications Overview
Subscribing to Event Notifications
Viewing Events
Specifications Change and Scaling
Viewing Inspection Results
Managing Nodes
Scaling Nodes
Scaling Out a Cluster
Cluster Redistribution
Redistributing Data
Viewing Redistribution Details
Scaling In a Cluster
Changing Specifications
Changing the Node Flavor
Changing All Specifications
Disk Capacity Expansion of an EVS Cluster
Backup and Disaster Recovery
Snapshots
Overview
Manual Snapshots
Creating a Manual Snapshot
Deleting a Manual Snapshot
Automated Snapshots
Automatic Snapshot Overview
Configuring an Automated Snapshot Policy
Copying Automated Snapshots
Deleting an Automated Snapshot
Viewing Snapshot Information
Restoration Using a Snapshot
Constraints on Restoring a Snapshot
Restoring a Snapshot to a New Cluster
Restoring a Snapshot to the Original Cluster
Configuring a Snapshot
Stopping Snapshot Creation
Cluster DR
DR Overview
Creating a DR Task
Viewing DR Information
DR Management
Mutually Exclusive DR Cases
Intelligent O&M
Overview
Managing O&M Plans
Viewing O&M Tasks
Cluster Management
Modifying Database Parameters
Checking the Cluster Status
Viewing Cluster Details
Changing a Cluster Name
O&M Account
Common O&M Commands
Managing Access Domain Names
Cluster Topology
Managing Tags
Overview
Managing Tags
Managing Enterprise Projects
Managing Clusters That Fail to Be Created
Removing the Read-only Status
Performing a Primary/Standby Switchback
Starting and Stopping a Cluster
Resetting a Password
Cluster Upgrade
Associating and Disassociating ELB
Managing CNs
Data Integration
Overview
Managing Instances
Managing Connections
Managing Table Mappings
Managing Jobs
Cluster Log Management
Database User Management
Managing Users
Managing Roles
Audit Logs
Audit Log Overview
Management Console Audit Logs
Database Audit Logs
Configuring the Database Audit Logs
Dumping the Database Audit Logs
Viewing Database Audit Logs
Cluster Security Management
Configuring Separation of Duties for the GaussDB(DWS) Cluster
Encrypting Databases
Overview
Rotating Encryption Keys
Converting an Ordinary Cluster to an Encrypted Cluster
Permissions
Creating a User and Granting GaussDB(DWS) Permissions
Creating a GaussDB(DWS) Custom Policy
Syntax of Fine-Grained Permissions Policies
RBAC Syntax of RBAC Policies
Protection for Mission-Critical Operations
Resource Management
Overview
Resource Pool
Feature Description
Creating a Resource Pool
Modifying a Resource Pool
Deleting a Resource Pool
Resource Management Plan
Managing Resource Management Plans
Managing Resource Management Plan Stages
Workspace Management
Exception Rules
Data Source Management
MRS Data Sources
MRS Data Source Usage Overview
Creating an MRS Data Source Connection
Updating the MRS Data Source Configuration
Managing OBS Data Sources
Managing Logical Clusters
Logical Cluster Overview
Adding/Deleting a Logical Cluster
Managing Logical Clusters
Elastically Adding or Deleting a Logical Cluster
Tutorial: Converting a Physical Cluster That Contains Data into a Logical Cluster
Tutorial: Dividing a New Physical Cluster into Logical Clusters
Tutorial: Setting a Read-Only Logical Cluster and Binding It to a User
Best Practices
Import and Export
Best Practices for DataImport
GDS Practice Guide
Tutorial: Importing Data from OBS to a Cluster
Tutorial: Using GDS to Import Data from a Remote Server
Tutorial: Importing Remote GaussDB(DWS) Data Sources
Data Migration
Migrating Data From Oracle to GaussDB(DWS)
Migration Process
Required Tools
Migrating Table Definitions
Installing the PL/SQL Developer on the Local Host
Migrating Table Definitions and Syntax
Migrating Full Table Data
Configuring a GaussDB(DWS) Data Source Connection
Configuring an Oracle Data Source Connection
Migrating Tables
Verification
Migrating SQL Statements
Migrating Syntax
Verification
Synchronizing MySQL Table Data to GaussDB(DWS) in Real Time
Using DLI Flink Jobs to Write Kafka Data to GaussDB(DWS) in Real Time
Practice of Data Interconnection Between Two DWS Clusters Based on GDS
Table Optimization Practices
Table Structure Design
Table Optimization Overview
Selecting a Table Model
Step 1: Creating an Initial Table and Loading Sample Data
Step 2: Testing System Performance of the Initial Table and Establishing a Baseline
Step 3: Optimizing a Table
Step 4: Creating Another Table and Loading Data
Step 5: Testing System Performance in the New Table
Step 6: Evaluating the Performance of the Optimized Table
Appendix: Table Creation Syntax
Usage
Creating an Initial Table
Creating a Another Table After Design Optimization
Creating a Foreign Table
Advanced Features
Creating a Time Series Table
Best Practices of Hot and Cold Data Management
Best Practices for Automatic Partition Management
GaussDB (DWS) View Decoupling and Automatic Rebuilding
Best Practices of Column-Store Delta Tables
Database Management
Best Practices of Resource Management
Excellent Practices for SQL Queries
Analyzing SQL Statements that Are Being Executed
Excellent Practices for Data Skew Queries
Real-Time Detection of Storage Skew During Data Import
Quickly Locating the Tables That Cause Data Skew
Best Practices for User Management
Viewing Table and Database Information
Best Practices of Database SEQUENCE
Sample Data Analysis
Checkpoint Vehicle Analysis
Supply Chain Requirement Analysis of a Company
Operations Status Analysis of a Retail Department Store
Security Management
Role-based Access Control (RBAC)
Encrypting and Decrypting Data Columns
Managing and Controlling Data Permissions Through Views
Data Migration and Synchronization
Data Migration to GaussDB(DWS)
Importing Data
Importing Data from OBS in Parallel
About Parallel Data Import from OBS
Importing CSV/TXT Data from the OBS
Creating Access Keys (AK and SK)
Uploading Data to OBS
Creating an OBS Foreign Table
Importing Data
Handling Import Errors
Importing ORC or CarbonData Data from OBS
Preparing Data on OBS
Creating a Foreign Server
Creating a Foreign Table
Querying Data on OBS Through Foreign Tables
Deleting Resources
Supported Data Types
Using GDS to Import Data from a Remote Server
Importing Data In Parallel Using GDS
Preparing Source Data
Installing, Configuring, and Starting GDS
Creating a GDS Foreign Table
Importing Data
Handling Import Errors
Stopping GDS
Example of Importing Data Using GDS
Importing Data from MRS to a Cluster
Overview
Preparing Data in an MRS Cluster
Manually Creating a Foreign Server
Creating a Foreign Table
Importing Data
Deleting Resources
Error Handling
Importing Data from One GaussDB(DWS) Cluster to Another
GDS-based Cross-Cluster Interconnection
Using a gsql Meta-Command to Import Data
Running the COPY FROM STDIN Statement to Import Data
Data Import Using COPY FROM STDIN
Introduction to the CopyManager Class
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MySQL to GaussDB(DWS)
Full Database Migration
Using DRS to Import Data to GaussDB(DWS)
Using CDM to Migrate Data to GaussDB(DWS)
Using DSC to Migrate SQL Scripts
Metadata Migration
Using gs_dump and gs_dumpall to Export Metadata
Overview
Exporting a Single Database
Exporting a Database
Exporting a Schema
Exporting a Table
Exporting All Databases
Exporting All Databases
Exporting Global Objects
Data Export By a User Without Required Permissions
Using gs_restore to Import Data
Exporting Data
Exporting Data to OBS
Parallel OBS Data Export
Exporting CSV/TXT Data to OBS
Planning Data Export
Creating an OBS Foreign Table
Exporting Data
Examples
Exporting ORC Data to OBS
Planning Data Export
Creating a Foreign Server
Creating a Foreign Table
Exporting Data
Exporting ORC Data to MRS
Overview
Planning Data Export
Creating a Foreign Server
Creating a Foreign Table
Exporting Data
Using GDS to Export Data to a Remote Server
Exporting Data In Parallel Using GDS
Planning Data Export
Installing, Configuring, and Starting GDS
Creating a GDS Foreign Table
Exporting Data
Stopping GDS
Examples of Exporting Data Using GDS
Other Operations
GDS Pipe FAQs
Checking for Data Skew
Analyzing a Table
Developer Guide
Standard Data Warehouse (8.1.3.x)
Welcome
Target Readers
Reading Guide
Prerequisites
System Overview
Highly Reliable Transaction Processing
High Query Performance
Related Concepts
Defining Database Objects
Creating and Managing Databases
Creating and Managing Schemas
Creating and Managing Tables
Selecting a Table Storage Mode
Defining Table Partitions
Creating and Managing Indexes
Creating and Using Sequences
Creating and Managing Views
Creating and Managing Scheduled Tasks
Viewing a System Catalog
Development and Design Proposal
Development and Design Proposal
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Column Design
Constraint Design
View and Joined Table Design
JDBC Configuration
SQL Compilation
User-defined External Function Usage (pgSQL/Java)
PL/pgSQL Usage
Database Security Management
Managing Users and Their Permissions
Database Users
User Management
User-defined Password Policy
Permissions Management
Separation of Permissions
Sensitive Data Management
Row-Level Access Control
Data Redaction
Using Functions for Encryption and Decryption
Syntax Compatibility Differences Among Oracle, Teradata, and MySQL
Guide: JDBC- or ODBC-Based Development
Development Specifications
Downloading Drivers
JDBC-Based Development
JDBC Package and Driver Class
Development Process
Loading a Driver
Connecting to a Database
Executing SQL Statements
Processing Data in a Result Set
Closing the Connection
Example: Common Operations
Example: Retrying SQL Queries for Applications
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MySQL to GaussDB(DWS)
JDBC Interface Reference
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
ODBC-Based Development
ODBC Package and Its Dependent Libraries and Header Files
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
ODBC Development Example
ODBC Interfaces
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
Data Read
Querying a Single Table
Querying Joined Tables
WITH Expression
User-Defined Functions
PL/Java Functions
PL/pgSQL Functions
Stored Procedures
Stored Procedure
Data Types
Data Type Conversion
Arrays and Records
Arrays
record
Syntax
Basic Structure
Anonymous Block
Subprogram
Basic Statements
Variable Definition Statement
Assignment Statement
Call Statement
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Advanced Packages
DBMS_LOB
DBMS_RANDOM
DBMS_OUTPUT
UTL_RAW
DBMS_JOB
DBMS_SQL
Debugging
Hot and Cold Data Management
PostGIS Extension
PostGIS
Using PostGIS
PostGIS Support and Constraints
OPEN SOURCE SOFTWARE NOTICE (For PostGIS)
Resource Monitoring
User Resource Monitoring
Resource Pool Monitoring
Monitoring Memory Resources
Instance Resource Monitoring
Real-time Top SQL
Historical Top SQL
TopSQL Query Example
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_OBSSCANINFO
GS_RESPOOL_RESOURCE_HISTORY
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_SESSION_INFO
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_ENUM
PG_EXTENSION
PG_EXTENSION_DATA_SOURCE
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_INDEX
PG_INHERITS
PG_JOBS
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OBSSCANINFO
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_RANGE
PG_REDACTION_COLUMN
PG_REDACTION_POLICY
PG_RELFILENODE_SIZE
PG_RLSPOLICY
PG_RESOURCE_POOL
PG_REWRITE
PG_SECLABEL
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_STATISTIC
PG_STATISTIC_EXT
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_ACTION
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PLAN_TABLE_DATA
SNAPSHOT
TABLES_SNAP_TIMESTAMP
System Catalogs for Performance View Snapshot
System Views
ALL_ALL_TABLES
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
ALL_COL_COMMENTS
ALL_DEPENDENCIES
ALL_IND_COLUMNS
ALL_IND_EXPRESSIONS
ALL_INDEXES
ALL_OBJECTS
ALL_PROCEDURES
ALL_SEQUENCES
ALL_SOURCE
ALL_SYNONYMS
ALL_TAB_COLUMNS
ALL_TAB_COMMENTS
ALL_TABLES
ALL_USERS
ALL_VIEWS
DBA_DATA_FILES
DBA_USERS
DBA_COL_COMMENTS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_IND_COLUMNS
DBA_IND_EXPRESSIONS
DBA_IND_PARTITIONS
DBA_INDEXES
DBA_OBJECTS
DBA_PART_INDEXES
DBA_PART_TABLES
DBA_PROCEDURES
DBA_SEQUENCES
DBA_SOURCE
DBA_SYNONYMS
DBA_TAB_COLUMNS
DBA_TAB_COMMENTS
DBA_TAB_PARTITIONS
DBA_TABLES
DBA_TABLESPACES
DBA_TRIGGERS
DBA_VIEWS
DUAL
GLOBAL_COLUMN_TABLE_IO_STAT
GLOBAL_REDO_STAT
GLOBAL_REL_IOSTAT
GLOBAL_ROW_TABLE_IO_STAT
GLOBAL_STAT_DATABASE
GLOBAL_TABLE_CHANGE_STAT
GLOBAL_TABLE_STAT
GLOBAL_WORKLOAD_SQL_COUNT
GLOBAL_WORKLOAD_SQL_ELAPSE_TIME
GLOBAL_WORKLOAD_TRANSACTION
GS_ALL_CONTROL_GROUP_INFO
GS_CLUSTER_RESOURCE_INFO
GS_COLUMN_TABLE_IO_STAT
GS_INSTR_UNIQUE_SQL
GS_NODE_STAT_RESET_TIME
GS_REL_IOSTAT
GS_RESPOOL_RUNTIME_INFO
GS_RESPOOL_RESOURCE_INFO
GS_ROW_TABLE_IO_STAT
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY_STATISTICS
GS_SQL_COUNT
GS_STAT_DB_CU
GS_STAT_SESSION_CU
GS_TABLE_CHANGE_STAT
GS_TABLE_STAT
GS_TOTAL_NODEGROUP_MEMORY_DETAIL
GS_USER_TRANSACTION
GS_VIEW_DEPENDENCY
GS_VIEW_DEPENDENCY_PATH
GS_VIEW_INVALID
GS_WAIT_EVENTS
GS_WLM_OPERAROR_INFO
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_SESSION_INFO
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_STATISTICS
GS_WLM_SQL_ALLOW
GS_WORKLOAD_SQL_COUNT
GS_WORKLOAD_SQL_ELAPSE_TIME
GS_WORKLOAD_TRANSACTION
MPP_TABLES
PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSIONS
PG_BULKLOAD_STATISTICS
PG_COMM_CLIENT_INFO
PG_COMM_DELAY
PG_COMM_STATUS
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_QUERY_SPEED
PG_CONTROL_GROUP_CONFIG
PG_CURSORS
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_INDEXES
PG_JOB
PG_JOB_PROC
PG_JOB_SINGLE
PG_LIFECYCLE_DATA_DISTRIBUTE
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_POOLER_STATUS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_QUERYBAND_ACTION
PG_REPLICATION_SLOTS
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SESSION_WLMSTAT
PG_SESSION_IOSTAT
PG_SETTINGS
PG_SHADOW
PG_SHARED_MEMORY_DETAIL
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_GET_MEM_MBYTES_RESERVED
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_REPLICATION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_THREAD_WAIT_STATUS
PG_TABLES
PG_TDE_INFO
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_SCHEMA_INFO
PG_TOTAL_USER_RESOURCE_INFO
PG_USER
PG_USER_MAPPINGS
PG_VIEWS
PG_WLM_STATISTICS
PGXC_BULKLOAD_PROGRESS
PGXC_BULKLOAD_STATISTICS
PGXC_COLUMN_TABLE_IO_STAT
PGXC_COMM_CLIENT_INFO
PGXC_COMM_DELAY
PGXC_COMM_RECV_STREAM
PGXC_COMM_SEND_STREAM
PGXC_COMM_STATUS
PGXC_COMM_QUERY_SPEED
PGXC_DEADLOCK
PGXC_GET_STAT_ALL_TABLES
PGXC_GET_STAT_ALL_PARTITIONS
PGXC_GET_TABLE_SKEWNESS
PGXC_GTM_SNAPSHOT_STATUS
PGXC_INSTANCE_TIME
PGXC_LOCKWAIT_DETAIL
PGXC_INSTR_UNIQUE_SQL
PGXC_LOCK_CONFLICTS
PGXC_NODE_ENV
PGXC_NODE_STAT_RESET_TIME
PGXC_OS_RUN_INFO
PGXC_OS_THREADS
PGXC_PREPARED_XACTS
PGXC_REDO_STAT
PGXC_REL_IOSTAT
PGXC_REPLICATION_SLOTS
PGXC_RESPOOL_RUNTIME_INFO
PGXC_RESPOOL_RESOURCE_INFO
PGXC_RESPOOL_RESOURCE_HISTORY
PGXC_ROW_TABLE_IO_STAT
PGXC_RUNNING_XACTS
PGXC_SETTINGS
PGXC_SESSION_WLMSTAT
PGXC_STAT_ACTIVITY
PGXC_STAT_BAD_BLOCK
PGXC_STAT_BGWRITER
PGXC_STAT_DATABASE
PGXC_STAT_REPLICATION
PGXC_STAT_TABLE_DIRTY
PGXC_SQL_COUNT
PGXC_TABLE_CHANGE_STAT
PGXC_TABLE_STAT
PGXC_THREAD_WAIT_STATUS
PGXC_TOTAL_MEMORY_DETAIL
PGXC_TOTAL_SCHEMA_INFO
PGXC_TOTAL_SCHEMA_INFO_ANALYZE
PGXC_USER_TRANSACTION
PGXC_VARIABLE_INFO
PGXC_WAIT_DETAIL
PGXC_WAIT_EVENTS
PGXC_WLM_OPERATOR_HISTORY
PGXC_WLM_OPERATOR_INFO
PGXC_WLM_OPERATOR_STATISTICS
PGXC_WLM_SESSION_INFO
PGXC_WLM_SESSION_HISTORY
PGXC_WLM_SESSION_STATISTICS
PGXC_WLM_WORKLOAD_RECORDS
PGXC_WORKLOAD_SQL_COUNT
PGXC_WORKLOAD_SQL_ELAPSE_TIME
PGXC_WORKLOAD_TRANSACTION
PLAN_TABLE
PV_FILE_STAT
PV_INSTANCE_TIME
PV_OS_RUN_INFO
PV_SESSION_MEMORY
PV_SESSION_MEMORY_DETAIL
PV_SESSION_STAT
PV_SESSION_TIME
PV_TOTAL_MEMORY_DETAIL
PV_REDO_STAT
REDACTION_COLUMNS
REDACTION_POLICIES
REMOTE_TABLE_STAT
USER_COL_COMMENTS
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_INDEXES
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_JOBS
USER_OBJECTS
USER_PART_INDEXES
USER_PART_TABLES
USER_PROCEDURES
USER_SEQUENCES
USER_SOURCE
USER_SYNONYMS
USER_TAB_COLUMNS
USER_TAB_COMMENTS
USER_TAB_PARTITIONS
USER_TABLES
USER_TRIGGERS
USER_VIEWS
V$SESSION
V$SESSION_LONGOPS
Collation Support
GUC Parameters
Viewing GUC Parameters
Configuring GUC Parameters
GUC Parameter Usage
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Statement Disk Space Control
Kernel Resources
Cost-based Vacuum Delay
Asynchronous I/O Operations
Parallel Data Import
Write Ahead Logs
Settings
Checkpoints
HA Replication
Sending Server
Primary Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Time
Logging Content
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Resource Management
Automatic Cleanup
Default Settings of Client Connection
Statement Behavior
Zone and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Cluster Transaction Parameters
Developer Operations
Auditing
Audit Switch
Operation Audit
Transaction Monitoring
GTM Parameters
Miscellaneous Parameters
Glossary
Standard Data Warehouse (9.1.0.x)
Welcome
Target Readers
Reading Guide
Prerequisites
System Overview
Highly Reliable Transaction Processing
High Query Performance
Related Concepts
Defining Database Objects
Creating and Managing Databases
Creating and Managing Schemas
Creating and Managing Tables
Selecting a Table Storage Mode
Defining Table Partitions
Creating and Managing Indexes
Creating and Using Sequences
Creating and Managing Views
Creating and Managing Scheduled Tasks
Viewing a System Catalog
Development and Design Proposal
Development and Design Proposal
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Column Design
Constraint Design
View and Joined Table Design
JDBC Configuration
SQL Compilation
User-defined External Function Usage (pgSQL/Java)
PL/pgSQL Usage
Database Security Management
Managing Users and Their Permissions
Database Users
User Management
User-defined Password Policy
Permissions Management
Separation of Permissions
Sensitive Data Management
Row-Level Access Control
Data Redaction
Using Functions for Encryption and Decryption
Use pgcrypto to Encrypt Data
Syntax Compatibility Differences Among Oracle, Teradata, and MySQL
Guide: JDBC- or ODBC-Based Development
Development Specifications
Downloading Drivers
JDBC-Based Development
JDBC Package and Driver Class
Development Process
Loading a Driver
Connecting to a Database
Executing SQL Statements
Processing Data in a Result Set
Closing the Connection
Example: Common Operations
Example: Retrying SQL Queries for Applications
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MySQL to GaussDB(DWS)
Example: Processing the RoaringBitmap Result Set on Application Then Importing It to GaussDB(DWS)
JDBC Interface Reference
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
ODBC-Based Development
ODBC Package and Its Dependent Libraries and Header Files
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
ODBC Development Example
ODBC Interfaces
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
Data Read
Querying a Single Table
Querying Joined Tables
WITH Expression
Data Reading/Writing Across Logical Clusters
User-Defined Functions
PL/Java Functions
PL/pgSQL Functions
Stored Procedures
Stored Procedure
Data Types
Data Type Conversion
Arrays and Records
Arrays
record
Syntax
Basic Structure
Anonymous Block
Subprogram
Basic Statements
Variable Definition Statement
Assignment Statement
Call Statement
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Advanced Packages
DBMS_LOB
DBMS_RANDOM
DBMS_OUTPUT
UTL_RAW
DBMS_JOB
DBMS_SQL
Debugging
Hot and Cold Data Management
PostGIS Extension
PostGIS
Using PostGIS
PostGIS Support and Constraints
OPEN SOURCE SOFTWARE NOTICE (For PostGIS)
Hybrid Data Warehouse
Introduction to Hybrid Data Warehouse
Support and Constraints
Hybrid Data Warehouse Syntax
CREATE TABLE
INSERT
DELETE
UPDATE
UPSERT
MERGE INTO
SELECT
ALTER TABLE
Hybrid Data Warehouse Functions
Hybrid Data Warehouse GUC Parameters
Resource Monitoring
User Resource Monitoring
Resource Pool Monitoring
Monitoring Memory Resources
Instance Resource Monitoring
Real-time Top SQL
Historical Top SQL
TopSQL Query Example
RDMA Configuration
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_BLOCKLIST_QUERY
GS_OBSSCANINFO
GS_RESPOOL_RESOURCE_HISTORY
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_SESSION_INFO
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_BLOCKLISTS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_ENUM
PG_EXCEPT_RULE
PG_EXTENSION
PG_EXTENSION_DATA_SOURCE
PG_FINE_DR_INFO
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_INDEX
PG_INHERITS
PG_JOB_INFO
PG_JOBS
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OBSSCANINFO
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_PUBLICATION
PG_PUBLICATION_NAMESPACE
PG_PUBLICATION_REL
PG_RANGE
PG_REDACTION_COLUMN
PG_REDACTION_POLICY
PG_RELFILENODE_SIZE
PG_RLSPOLICY
PG_RESOURCE_POOL
PG_REWRITE
PG_SECLABEL
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_STATISTIC
PG_STATISTIC_EXT
PG_STAT_OBJECT
PG_SUBSCRIPTION
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_ACTION
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PLAN_TABLE_DATA
SNAPSHOT
TABLES_SNAP_TIMESTAMP
System Catalogs for Performance View Snapshot
System Views
ALL_ALL_TABLES
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
ALL_COL_COMMENTS
ALL_DEPENDENCIES
ALL_IND_COLUMNS
ALL_IND_EXPRESSIONS
ALL_INDEXES
ALL_OBJECTS
ALL_PROCEDURES
ALL_SEQUENCES
ALL_SOURCE
ALL_SYNONYMS
ALL_TAB_COLUMNS
ALL_TAB_COMMENTS
ALL_TABLES
ALL_USERS
ALL_VIEWS
DBA_DATA_FILES
DBA_USERS
DBA_COL_COMMENTS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_IND_COLUMNS
DBA_IND_EXPRESSIONS
DBA_IND_PARTITIONS
DBA_INDEXES
DBA_OBJECTS
DBA_PART_INDEXES
DBA_PART_TABLES
DBA_PROCEDURES
DBA_SEQUENCES
DBA_SOURCE
DBA_SYNONYMS
DBA_TAB_COLUMNS
DBA_TAB_COMMENTS
DBA_TAB_PARTITIONS
DBA_TABLES
DBA_TABLESPACES
DBA_TRIGGERS
DBA_VIEWS
DUAL
GET_ALL_TSC_INFO
GET_TSC_INFO
GLOBAL_COLUMN_TABLE_IO_STAT
GLOBAL_REDO_STAT
GLOBAL_REL_IOSTAT
GLOBAL_ROW_TABLE_IO_STAT
GLOBAL_STAT_DATABASE
GLOBAL_TABLE_CHANGE_STAT
GLOBAL_TABLE_STAT
GLOBAL_WORKLOAD_SQL_COUNT
GLOBAL_WORKLOAD_SQL_ELAPSE_TIME
GLOBAL_WORKLOAD_TRANSACTION
GS_ALL_CONTROL_GROUP_INFO
GS_BLOCKLIST_QUERY
GS_CLUSTER_RESOURCE_INFO
GS_COLUMN_TABLE_IO_STAT
GS_OBS_READ_TRAFFIC
GS_OBS_WRITE_TRAFFIC
GS_INSTR_UNIQUE_SQL
GS_NODE_STAT_RESET_TIME
GS_OBS_LATENCY
GS_QUERY_MONITOR
GS_QUERY_RESOURCE_INFO
GS_REL_IOSTAT
GS_RESPOOL_RUNTIME_INFO
GS_RESPOOL_RESOURCE_INFO
GS_RESPOOL_MONITOR
GS_ROW_TABLE_IO_STAT
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY_STATISTICS
GS_SQL_COUNT
GS_STAT_DB_CU
GS_STAT_SESSION_CU
GS_TABLE_CHANGE_STAT
GS_TABLE_STAT
GS_TOTAL_NODEGROUP_MEMORY_DETAIL
GS_USER_MONITOR
GS_USER_TRANSACTION
GS_VIEW_DEPENDENCY
GS_VIEW_DEPENDENCY_PATH
GS_VIEW_INVALID
GS_WAIT_EVENTS
GS_WLM_OPERAROR_INFO
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_SESSION_INFO
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_STATISTICS
GS_WLM_SQL_ALLOW
GS_WORKLOAD_SQL_COUNT
GS_WORKLOAD_SQL_ELAPSE_TIME
GS_WORKLOAD_TRANSACTION
MPP_TABLES
PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSIONS
PG_BULKLOAD_STATISTICS
PG_COMM_CLIENT_INFO
PG_COMM_DELAY
PG_COMM_STATUS
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_QUERY_SPEED
PG_CONTROL_GROUP_CONFIG
PG_CURSORS
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_INDEXES
PG_JOB
PG_JOB_PROC
PG_JOB_SINGLE
PG_LIFECYCLE_DATA_DISTRIBUTE
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_POOLER_STATUS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_PUBLICATION_TABLES
PG_QUERYBAND_ACTION
PG_REPLICATION_SLOTS
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SEQUENCES
PG_SESSION_WLMSTAT
PG_SESSION_IOSTAT
PG_SETTINGS
PG_SHADOW
PG_SHARED_MEMORY_DETAIL
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_GET_MEM_MBYTES_RESERVED
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_REPLICATION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_THREAD_WAIT_STATUS
PG_TABLES
PG_TDE_INFO
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_SCHEMA_INFO
PG_TOTAL_USER_RESOURCE_INFO
PG_USER
PG_USER_MAPPINGS
PG_VIEWS
PG_WLM_STATISTICS
PGXC_AIO_RESOURCE_POOL_STATS
PGXC_BULKLOAD_PROGRESS
PGXC_BULKLOAD_INFO
PGXC_BULKLOAD_STATISTICS
PGXC_COLUMN_TABLE_IO_STAT
PGXC_COMM_CLIENT_INFO
PGXC_COMM_DELAY
PGXC_COMM_RECV_STREAM
PGXC_COMM_SEND_STREAM
PGXC_COMM_STATUS
PGXC_COMM_QUERY_SPEED
PGXC_DEADLOCK
PGXC_DISK_CACHE_STATS
PGXC_DISK_CACHE_ALL_STATS
PGXC_DISK_CACHE_PATH_INFO
PGXC_GET_STAT_ALL_TABLES
PGXC_GET_STAT_ALL_PARTITIONS
PGXC_GET_TABLE_SKEWNESS
PGXC_GTM_SNAPSHOT_STATUS
PGXC_INSTANCE_TIME
PGXC_LOCKWAIT_DETAIL
PGXC_INSTR_UNIQUE_SQL
PGXC_LOCK_CONFLICTS
PGXC_MEMORY_DEBUG_INFO
PGXC_NODE_ENV
PGXC_NODE_STAT_RESET_TIME
PGXC_OBS_IO_SCHEDULER_STATS
PGXC_OBS_IO_SCHEDULER_PERIODIC_STATS
PGXC_OS_RUN_INFO
PGXC_OS_THREADS
PGXC_POOLER_STATUS
PGXC_PREPARED_XACTS
PGXC_REDO_STAT
PGXC_REL_IOSTAT
PGXC_REPLICATION_SLOTS
PGXC_RESPOOL_RUNTIME_INFO
PGXC_RESPOOL_RESOURCE_INFO
PGXC_RESPOOL_RESOURCE_HISTORY
PGXC_ROW_TABLE_IO_STAT
PGXC_RUNNING_XACTS
PGXC_SETTINGS
PGXC_SESSION_WLMSTAT
PGXC_STAT_ACTIVITY
PGXC_STAT_BAD_BLOCK
PGXC_STAT_BGWRITER
PGXC_STAT_DATABASE
PGXC_STAT_OBJECT
PGXC_STAT_REPLICATION
PGXC_STAT_TABLE_DIRTY
PGXC_STAT_WAL
PGXC_SQL_COUNT
PGXC_TABLE_CHANGE_STAT
PGXC_TABLE_STAT
PGXC_THREAD_WAIT_STATUS
PGXC_TOTAL_MEMORY_DETAIL
PGXC_TOTAL_SCHEMA_INFO
PGXC_TOTAL_SCHEMA_INFO_ANALYZE
PGXC_TOTAL_USER_RESOURCE_INFO
PGXC_USER_TRANSACTION
PGXC_VARIABLE_INFO
PGXC_WAIT_DETAIL
PGXC_WAIT_EVENTS
PGXC_WLM_OPERATOR_HISTORY
PGXC_WLM_OPERATOR_INFO
PGXC_WLM_OPERATOR_STATISTICS
PGXC_WLM_SESSION_INFO
PGXC_WLM_SESSION_HISTORY
PGXC_WLM_SESSION_STATISTICS
PGXC_WLM_TABLE_DISTRIBUTION_SKEWNESS
PGXC_WLM_USER_RESOURCE_HISTORY
PGXC_WLM_WORKLOAD_RECORDS
PGXC_WORKLOAD_SQL_COUNT
PGXC_WORKLOAD_SQL_ELAPSE_TIME
PGXC_WORKLOAD_TRANSACTION
PLAN_TABLE
PV_FILE_STAT
PV_INSTANCE_TIME
PV_OS_RUN_INFO
PV_SESSION_MEMORY
PV_SESSION_MEMORY_DETAIL
PV_SESSION_STAT
PV_SESSION_TIME
PV_TOTAL_MEMORY_DETAIL
PV_REDO_STAT
PV_RUNTIME_ATTSTATS
PV_RUNTIME_RELSTATS
REDACTION_COLUMNS
REDACTION_POLICIES
REMOTE_TABLE_STAT
SHOW_TSC_INFO
SHOW_ALL_TSC_INFO
USER_COL_COMMENTS
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_INDEXES
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_JOBS
USER_OBJECTS
USER_PART_INDEXES
USER_PART_TABLES
USER_PROCEDURES
USER_SEQUENCES
USER_SOURCE
USER_SYNONYMS
USER_TAB_COLUMNS
USER_TAB_COMMENTS
USER_TAB_PARTITIONS
USER_TABLES
USER_TRIGGERS
USER_VIEWS
V$SESSION
V$SESSION_LONGOPS
Collation rules
GUC Parameters
Viewing GUC Parameters
Configuring GUC Parameters
GUC Parameter Usage
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Statement Disk Space Control
Kernel Resources
Cost-based Vacuum Delay
Asynchronous I/O Operations
Disk Caching
Parallel Data Import
Write Ahead Logs
Settings
Checkpoints
Archiving
HA Replication
Sending Server
Primary Server
Standby Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Time
Logging Content
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Resource Management
Automatic Cleanup
Default Settings of Client Connection
Statement Behavior
Zone and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Cluster Transaction Parameters
Developer Operations
Auditing
Audit Switch
Operation Audit
Transaction Monitoring
GTM Parameters
Miscellaneous Parameters
Glossary
SQL Syntax Reference
SQL Syntax Reference (9.1.0.x)
GaussDB(DWS) SQL Overview
Differences Between GaussDB(DWS) and PostgreSQL
Keyword
Data Types
Numeric Types
Monetary Types
Boolean Type
Character Types
Binary Data Types
Date/Time Types
Geometric Types
Array
Enumeration Type
Network Address Types
Bit String Types
Text Search Types
UUID Type
JSON Types
RoaringBitmap
HLL Data Types
Object Identifier Types
Pseudo-Types
Range Types
Composite Types
Data Types Supported by Column-Store Tables
XML
Constant and Macro
Functions and Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Numeric Functions and Operators
Numeric Operators
Numeric Functions
Date and Time Processing Functions and Operators
Date and Time Operators
Date and Time Functions
EXTRACT
date_part
date_format
time_format
SEQUENCE Functions
Array Functions and Operators
Array Operators
Array Functions
Logical Operators
Comparison Operators
Pattern Matching Operators
Aggregate Functions
Window Functions
Type Conversion Functions
JSON/JSONB Functions and Operators
JSON/JSONB Operators
JSON/JSONB Functions
Security Functions
Conditional Expression Functions
Range Functions and Operators
Range Operators
Range Functions
Data Redaction Functions
Bitmap Functions and Operators
Roaring Bitmap Operators
Bitmap Functions
Roaring Bitmap Aggregation Functions
Use Cases
UUID Functions
Text Search Functions and Operators
Text Search Operators
Text Search Functions
Text Search Debugging Functions
HLL Functions and Operators
HLL Operators
Hash Functions
Precision Functions
Aggregate Functions
Functional Functions
Built-in Functions
Set Returning Functions
Series Generating Functions
Subscript Generating Functions
Geometric Functions and Operators
Geometric Operators
Geometric Functions
Geometric Type Conversion Functions
Network Address Functions and Operators
cidr and inet Operators
Network Address Functions
System Information Functions
Session Information Functions
Access Privilege Inquiry Functions
Schema Visibility Inquiry Functions
System Catalog Information Functions
System Function Checking Function
Comment Checking Functions
Transaction IDs and Snapshots
Computing Node Group Function
Lock Information Function
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signaling Functions
Snapshot Synchronization Functions
Advisory Lock Functions
Replication Functions
Resource Management Functions
Memory Management Functions
Other Functions
Backup and Restoration Control Functions
Backup Control Functions
Restoration Control Functions
Database Object Functions
Database Object Size Functions
Database Object Position Functions
Partition Management Function
Collation Version Function
Hot and Cold Table Functions
Residual File Management Functions
Functions for Obtaining the Residual File List
Functions for Scanning Residual Files
Functions for Verifying Residual Files
Functions for Deleting Residual Files
Using Residual File Management Functions
Statistics Information Functions
Trigger Functions
XML Functions
Generating XML Content
XML Predicates
Processing XML
Mapping a Table to XML
Call Stack Recording Functions
Funnel and Retention Functions
EXTERNAL SCHEMA System Functions
Storage-Compute Decoupling Functions
Data Sharing Functions
Expressions
Simple Expressions
Conditional Expressions
Subquery Expressions
Array Expressions
Row Expressions
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Full Text Search
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Table and index
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Manipulating Queries
Rewriting Queries
Gathering Document Statistics
Parsers
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Configuration Examples
Testing and Debugging Text Search
Testing a Configuration
Testing a Parser
Testing a Dictionary
Limitations
System Operation
Transaction Management
DDL Syntax
DDL Syntax Overview
ALTER BLOCK RULE
ALTER DATABASE
ALTER EXCEPT RULE
ALTER FOREIGN TABLE (GDS Import and Export)
ALTER FOREIGN TABLE (for HDFS or OBS)
ALTER FOREIGN TABLE (SQL on other GaussDB(DWS))
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LARGE OBJECT
ALTER PUBLICATION
ALTER REDACTION POLICY
ALTER RESOURCE POOL
ALTER ROLE
ALTER SUBSCRIPTION
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
CREATE BARRIER
CREATE BLOCK RULE
CREATE DATABASE
CREATE EXCEPT RULE
CREATE FOREIGN TABLE (for GDS Import and Export)
CREATE FOREIGN TABLE (SQL on OBS or Hadoop)
CREATE FOREIGN TABLE (for OBS Import and Export)
CREATE FOREIGN TABLE (SQL on other GaussDB(DWS))
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE PROCEDURE
CREATE PUBLICATION
CREATE REDACTION POLICY
CREATE ROW LEVEL SECURITY POLICY
CREATE RESOURCE POOL
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SUBSCRIPTION
CREATE SYNONYM
CREATE TABLE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CURSOR
DISCARD
DROP BLOCK RULE
DROP DATABASE
DROP EXCEPT RULE
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP OWNED
DROP PUBLICATION
DROP REDACTION POLICY
DROP ROW LEVEL SECURITY POLICY
DROP PROCEDURE
DROP RESOURCE POOL
DROP ROLE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SUBSCRIPTION
DROP SYNONYM
DROP TABLE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
FETCH
MOVE
REINDEX
RENAME TABLE
RESET
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SHOW
TRUNCATE
VACUUM
DML Syntax
DML Syntax Overview
CALL
COPY
DELETE
EXPLAIN
EXPLAIN PLAN
LOCK
MERGE INTO
INSERT and UPSERT
INSERT
UPSERT
UPDATE
VALUES
DCL Syntax
DCL Syntax Overview
ALTER DEFAULT PRIVILEGES
ANALYZE | ANALYSE
DEALLOCATE
DO
EXECUTE
EXECUTE DIRECT
GRANT
PREPARE
REASSIGN OWNED
REVOKE
DQL Syntax
DQL Syntax Overview
SELECT
SELECT INTO
TCL Syntax
TCL Syntax Overview
ABORT
BEGIN
CHECKPOINT
COMMIT | END
COMMIT PREPARED
PREPARE TRANSACTION
SAVEPOINT
SET TRANSACTION
START TRANSACTION
ROLLBACK
RELEASE SAVEPOINT
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SQL Syntax Reference (8.1.3.x)
About GaussDB(DWS) SQL
Differences Between GaussDB(DWS) and PostgreSQL
GaussDB(DWS) gsql, PostgreSQL psql, and libpq
Data Type Differences
Function Differences
PostgreSQL Features Unsupported by GaussDB(DWS)
Keyword
Data Types
Numeric Types
Monetary Types
Boolean Type
Character Types
Binary Data Types
Date/Time Types
Geometric Types
Network Address Types
Bit String Types
Text Search Types
UUID Type
JSON Types
RoaringBitmap
HLL Data Types
Object Identifier Types
Pseudo-Types
Data Types Supported by Column-Store Tables
XML
Constant and Macro
Functions and Operators
Logical Operators
Comparison Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Pattern Matching Operators
Mathematical Functions and Operators
Numeric Operators
Numeric Operation Functions
Date and Time Processing Functions and Operators
Date and Time Operators
Time/Date functions
EXTRACT
date_part
date_format
time_format
Type Conversion Functions
Geometric Functions and Operators
Geometric Operators
Geometric Functions
Geometric Type Conversion Functions
Network Address Functions and Operators
cidr and inet Operators
Network Address Functions
Text Search Functions and Operators
Text Search Operators
Text Search Functions
Text Search Debugging Functions
UUID Functions
JSON/JSONB Functions and Operators
JSON/JSONB Operators
JSON/JSONB Functions
Bitmap Functions and Operators
Bitmap Operators
Bitmap Functions
Bitmap Aggregate Functions
Use Cases
HLL Functions and Operators
HLL Operators
Hash Functions
Precision Functions
Aggregate Functions
Functional Functions
Built-in Functions
SEQUENCE Functions
Array Functions and Operators
Array Operators
Array Functions
Range Functions and Operators
Range Operators
Range Functions
Aggregate Functions
Window Functions
Security Functions
Set Returning Functions
Series Generating Functions
Subscript Generating Functions
Conditional Expression Functions
System Information Functions
Session Information Functions
Access Privilege Inquiry Functions
Schema Visibility Inquiry Functions
System Catalog Information Functions
System Function Checking Functions
Comment Checking Functions
Transaction IDs and Snapshots
Computing Node Group Function
Lock Information Function
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signaling Functions
Snapshot Synchronization Functions
Advisory Lock Functions
Replication Functions
Other Functions
Resource Management Functions
Backup and Restoration Control Functions
Backup Control Functions
Restoration Control Functions
Database Object Functions
Database Object Size Functions
Database Object Position Functions
Partition Management Function
Collation Version Function
Residual File Management Functions
Functions for Obtaining the Residual File List
Functions for Verifying Residual Files
Functions for Deleting Residual Files
Residual File Management Functions
Data Redaction Functions
Statistics Information Functions
Trigger Functions
XML Functions
Generating XML Content
XML Predicates
Processing XML
Mapping a Table to XML
Call Stack Recording Functions
Expressions
Simple Expressions
Conditional Expressions
Subquery Expressions
Array Expressions
Row Expressions
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Full Text Search
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Limitations
Searching for Texts in Database Tables
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Handling TSQuery
Rewriting Queries
Collecting Document Statistics
Text Search Parser
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Text Search Configuration Example
Testing and Debugging Text Search
Testing a Configuration
Testing a Parser
Testing a Dictionary
System Operation
Controlling Transactions
DDL Syntax
DDL Syntax Overview
ALTER DATABASE
ALTER FOREIGN TABLE (for GDS)
ALTER FOREIGN TABLE (for HDFS or OBS)
ALTER FOREIGN TABLE (SQL on other GaussDB(DWS))
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LARGE OBJECT
ALTER REDACTION POLICY
ALTER RESOURCE POOL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
CREATE BARRIER
CREATE DATABASE
CREATE FOREIGN TABLE (for GDS Import and Export)
CREATE FOREIGN TABLE (SQL on OBS or Hadoop)
CREATE FOREIGN TABLE (for OBS Import and Export)
CREATE FOREIGN TABLE (SQL on other GaussDB(DWS))
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE REDACTION POLICY
CREATE ROW LEVEL SECURITY POLICY
CREATE PROCEDURE
CREATE RESOURCE POOL
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CURSOR
DROP DATABASE
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP OWNED
DROP REDACTION POLICY
DROP ROW LEVEL SECURITY POLICY
DROP PROCEDURE
DROP RESOURCE POOL
DROP ROLE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
FETCH
MOVE
REINDEX
RENAME TABLE
RESET
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SHOW
TRUNCATE
VACUUM
DML Syntax
DML Syntax Overview
CALL
COPY
DELETE
EXPLAIN
EXPLAIN PLAN
LOCK
MERGE INTO
INSERT and UPSERT
INSERT
UPSERT
UPDATE
VALUES
DCL Syntax
DCL Syntax Overview
ALTER DEFAULT PRIVILEGES
ANALYZE | ANALYSE
DEALLOCATE
DO
EXECUTE
EXECUTE DIRECT
GRANT
PREPARE
REASSIGN OWNED
REVOKE
DQL Syntax
DQL Syntax Overview
SELECT
SELECT INTO
TCL Syntax
TCL Syntax Overview
ABORT
BEGIN
CHECKPOINT
COMMIT | END
COMMIT PREPARED
PREPARE TRANSACTION
SAVEPOINT
SET TRANSACTION
START TRANSACTION
ROLLBACK
RELEASE SAVEPOINT
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
3.0 Developer Guide
Reading Guide
Introduction to GaussDB(DWS) 3.0
Support and Constraints
SQL Syntax Reference
CREATE TABLE
CREATE EXTERNAL SCHEMA
ALTER EXTERNAL SCHEMA
ALTER TABLE
Function
System Catalogs
PG_CLASS
PG_CONSTRAINT
PG_EXTERNAL_NAMESPACE
PG_NAMESPACE
PG_PARTITION
PG_REWRITE
PG_TRIGGER
PGXC_GROUP
PGXC_NODE
System Views
PGXC_DISK_CACHE_STATS
PGXC_DISK_CACHE_PATH_INFO
PGXC_DISK_CACHE_ALL_STATS
PGXC_OBS_IO_SCHEDULER_STATS
PGXC_OBS_IO_SCHEDULER_PERIODIC_STATS
GUC Parameters
Development Practices
Data Reading/Writing Across Logical Clusters
Data Lakehouse
Accessing HiveMetaStore Across Clusters
Stream Data Warehouse
Introduction to Stream Data Warehouse
Support and Constraints
Extension Constraints
Data Types Supported by TSFIELD
Stream Data Warehouse Syntax
CREATE TABLE
DROP TABLE
ALTER TABLE
CREATE INDEX
Functions and Expressions
Stream Data Warehouse GUC Parameters
Performance Tuning
Overview of Query Performance Optimization
Query Analysis
Query Execution Process
Overview of the SQL Execution Plan
Deep Dive on the SQL Execution Plan
Querying SQL Statements That Affect Performance Most
Checking Blocked Statements
Query Improvement
Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Typical SQL Optimization Methods
SQL Self-Diagnosis
Optimizing Statement Pushdown
Optimizing Subqueries
Optimizing Statistics
Optimizing Operators
Optimizing Data Skew
Experience in Rewriting SQL Statements
Adjusting Key Parameters During SQL Tuning
Hint-based Tuning
Plan Hint Optimization
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Operation Hints
Sublink Name Hints
Skew Hints
Hint That Disables Subquery Pull-up
Configuration Parameter Hints
Hint Errors, Conflicts, and Other Warnings
Plan Hint Cases
Routinely Maintaining Tables
Routinely Recreating an Index
Configuring the SMP
Application Scenarios and Restrictions
Resource Impact on SMP Performance
Other Factors Affecting SMP Performance
Suggestions for SMP Parameter Settings
SMP Manual Optimization Suggestions
Optimization Cases
Case: Selecting an Appropriate Distribution Column
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Pushing Down Sort Operations to DNs
Case: Configuring cost_param for Better Query Performance
Case: Adjusting the Distribution Key
Case: Adjusting the Partial Clustering Key
Case: Adjusting the Table Storage Mode in a Medium Table
Case: Adjusting the Local Clustering Column
Case: Reconstructing Partition Tables
Case: Adjusting the GUC Parameter best_agg_plan
Case: Rewriting SQL and Deleting Subqueries (Case 1)
Case: Rewriting SQL and Deleting Subqueries (Case 2)
Case: Rewriting SQL Statements and Eliminating Prune Interference
Case: Rewriting SQL Statements and Deleting in-clause
Case: Setting Partial Cluster Keys
SQL Execution Troubleshooting
Low Query Efficiency
DROP TABLE Fails to Be Executed
Different Data Is Displayed for the Same Table Queried By Multiple Users
An Error Occurs During the Integer Conversion
Automatic Retry upon SQL Statement Execution Errors
query_band Load Identification
Tool Guide
Overview
Downloading Client Tools
gsql - CLI Client
Overview
Instruction
Online Help
Command Reference
Meta-Command Reference
Troubleshooting
Data Studio - Integrated Database Development Tool
About Data Studio
Overview
Constraints and Limitations
Structure of a Release Package
System Requirements
Installing and Configuring Data Studio
Quick Start
Data Studio GUI
Data Studio Menus
File
Edit
Run
Debug
Settings
Help
Data Studio Toolbar
Data Studio Right-Click Menus
Connection Profiles
Overview
Adding a Connection
Renaming a Connection
Editing a Connection
Removing a Connection
Viewing Connection Properties
Refreshing a Database Connection
Databases
Creating a Database
Disconnecting All Databases
Connecting to a Database
Disconnecting a Database
Renaming a Database
Dropping a Database
Viewing Properties of a Database
Schemas
Overview
Creating a Schema
Exporting Schema DDL
Exporting Schema DDL and Data
Renaming a Schema
Supporting Sequence DDL
Granting/Revoking a Privilege
Dropping a Schema
Creating a Function/Procedure
Editing a Function/Procedure
Granting/Revoking a Permission (Function/Procedure)
Debugging a PL/SQL Function
Overview
Using Breakpoints
Controlling Execution
Checking Debugging Information
Working with Functions/Procedures
Overview
Selecting a DB Object in the PL/SQL Viewer
Exporting a Function/Procedure DDL
Viewing Object Properties in the PL/SQL Viewer
Dropping a Function/Procedure
Executing a Function/Procedure
Granting/Revoking a Privilege
GaussDB(DWS) Tables
Table Management Overview
Creating Regular Table
Overview
Working with Columns
Working with Constraints
Managing Indexes
Creating Foreign Table
Creating Partition Table
Overview
Working with Partitions
Grant/Revoke Privilege - Regular/Partition Table
Managing Table
Overview
Renaming a Table
Truncating a Table
Reindexing a Table
Analyzing a Table
Vacuuming a Table
Setting the Table Description
Setting the Schema
Dropping a Table
Viewing Table Properties
Grant/Revoke Privilege
Managing Table Data
Overview
Exporting Table DDL
Exporting Table DDL and Data
Exporting Table Data
Show DDL
Importing Table Data
Viewing Table Data
Editing Table Data
Editing Temporary Tables
Sequences
Creating Sequence
Grant/Revoke Privilege
Working with Sequences
Views
Creating a View
Granting/Revoking a Privilege
Working with Views
Users/Roles
Creating a User/Role
Working with Users/Roles
SQL Terminal
Opening Multiple SQL Terminal Tabs
Managing the SQL Query Execution History
Opening and Saving SQL Scripts
Viewing Object Properties in the SQL Terminal
Canceling the Execution of SQL Queries
Formatting of SQL Queries
Selecting a DB Object in the SQL Terminal
Viewing the Query Execution Plan and Cost
Viewing the Query Execution Plan and Cost Graphically
Working with SQL Terminals
Exporting Query Results
Managing SQL Terminal Connections
Batch Operation
Overview
Dropping a Batch of Objects
Granting/Revoking Privileges
Personalizing Data Studio
General
Editor
Environment
Result Management
Security
Performance Specifications
Security Management
Overview
Login History
Password Expiry Notification
Securing the Application In-Memory Data
Data Encryption for Saved Data
SQL History
SSL Certificates
Troubleshooting
FAQs
GDS: Parallel Data Loader
Installing, Configuring, and Starting GDS
Stopping GDS
Example of Importing Data Using GDS
gds
gds_ctl.py
Handling Import Errors
DSC: SQL Syntax Migration Tool
Overview
Supported Keywords and Features
Constraints and Limitations
System Requirements
Installing DSC
Configuring DSC
Overview
DSC Configuration
Teradata SQL Configuration
Oracle SQL Configuration
Teradata Perl Configuration
MySQL SQL Configuration
Netezza Configuration
Using DSC
Migration Process
Overview
Prerequisites
Preparations
Migrating Data Using DSC
Viewing Output Files and Logs
Troubleshooting
Teradata SQL Migration
Oracle SQL Migration
Teradata Perl Migration
Netezza SQL Migration
MySQL SQL Migration
SQL Formatter
Teradata Syntax Migration
Overview
Schema Objects
Table Migration
Index Migration
View Migration
COLLECT STATISTICS
ACCESS LOCK
DBC.COLUMNS
DBC.TABLES
DBC.INDICES
SHOW STATS VALUES SEQUENCED
DML
Querying Migration Operators
Query Optimization Operators
System Functions and Operators
Math Functions
String Functions
Date and Time Functions
Type Casting and Formatting
BTEQ Utility Command
DSQL
Oracle Syntax Migration
Overview
Schema Objects
Tables
Temporary Tables
Global Temporary Tables
Indexes
Views
Sequences
PURGE
Database Keywords
COMPRESS Phrase
Bitmap Index
Custom Tablespace
Supplemental Log Data
LONG RAW
SYS_GUID
DML
Pseudo Columns
OUTER JOIN
OUTER QUERY (+)
CONNECT BY
System Functions
Date Functions
LOB Functions
String Functions
Analytical Functions
Regular Expression Functions
PL/SQL
PL/SQL Collections (Using User-Defined Types)
PL/SQL Packages
Packages
Package Variables
Splitting Packages
REF CURSOR
Creating a Schema for Package
VARRAY
Granting Execution Permissions
Package Name List
Data Type
Chinese Character Support
Netezza Syntax Migration
Tables
PROCEDURE with RETURNS
Procedure
System Functions
Operator
DML
Index
MySQL Syntax Migration
Basic Data Types
Table (Optional)
Table Operations
Unique Indexes
Normal and Prefix Indexes
Hash Indexes
B-tree Indexes
Spatial Indexes
Delete an Index
Comments
Databases
Data Manipulation Language (DML)
Transaction Management and Database Management
DB2 Syntax Migration
Tables
DML
Index
NICKNAME
Statement
System Functions
Command Reference
Database Schema Conversion
Version
Help
Log Reference
Overview
SQL Migration Logs
Perl Migration Logs
Troubleshooting
FAQs
Security Management
DWS-Connector
DWS-Connector Version Description
dws-client
dws-connector-flink
Server Tool
gs_dump
gs_dumpall
gs_restore
gds_check
gds_install
gds_uninstall
gds_ctl
gs_sshexkey
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Basic Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Response
Getting Started
API Description
Cluster Management APIs
Creating a Cluster
Querying the Cluster List
Querying Cluster Details
Querying the Supported Node Types
Deleting a Cluster
Restarting a Cluster
Scaling Out Clusters
Resetting a Password
Snapshot Management APIs
Creating a Snapshot
Querying the Snapshot List
Querying Snapshot Details
Deleting a Manual Snapshot
Restoring a Cluster
Application Cases
Using Postman to Call the API for Creating a Snapshot
Permissions Policies and Supported Actions
Appendix
Status Code
Error Code
Creating a VPC
Obtaining a Project ID
Obtaining an Account ID
Obtaining the Cluster ID
Change History
FAQs
General Problems
Why Are Data Warehouses Necessary?
What Are the Differences Between a Data Warehouse and the Hadoop Big Data Platform?
Why Should I Use Public Cloud GaussDB(DWS)?
Should I Choose Public Cloud GaussDB(DWS) or RDS?
When Should I Use GaussDB(DWS) and MRS?
What Is the User Quota?
What Are the Differences Between Users and Roles?
How Do I Check the Creation Time of a Database User?
Regions and AZs
Is My Data Secure in GaussDB(DWS)?
How Is GaussDB(DWS) Secured?
Can I Modify the Security Group of a GaussDB(DWS) Cluster?
How Are LibrA, GaussDB A, and GaussDB(DWS) Related?
What Is a Database/Data Warehouse/Data Lake/Lakehouse?
Cluster Management
What Do I Do If Creating a GaussDB(DWS) Cluster Failed?
How Can I Clear and Reclaim the Storage Space?
Can I Switch My Cluster Nodes to Another Region After Purchase?
Why Did the Used Storage Shrink After Scale-out?
How Do I View Node Metrics (CPU, Memory, and Disk Usage)?
Does GaussDB(DWS) Support BMS?
How Is the Disk Space or Capacity of GaussDB(DWS) Calculated?
What Are the gaussdb and postgres Databases of GaussDB(DWS)?
How Do I Set the Maximum Number of Sessions When Adding an Alarm Rule on Cloud Eye?
What Should I Do If the Scale-out Check Fails?
When Should I Add CNs or Scale out a cluster?
What Are the Scenarios of Resizing a Cluster, Changing the Node Flavor, Scale-out, and Scale-in?
How Should I Select from a Small-Flavor Many-Node Cluster and a Large-Flavor Three-Node Cluster with Same CPU Cores and Memory?
What Are the Differences Between Cloud SSDs and Local SSDs?
What Are the Differences Between Hot Data Storage and Cold Data Storage?
Database Connections
How Applications Communicate with GaussDB(DWS)?
Does GaussDB(DWS) Support Third-Party Clients and JDBC and ODBC Drivers?
Can I Connect to GaussDB(DWS) Cluster Nodes Using SSH?
What Should I Do If I Cannot Connect to a Data Warehouse Cluster?
Why Was I Not Notified of Failure Unbinding the EIP When GaussDB(DWS) Is Connected Over the Internet?
How Do I Configure a Whitelist to Protect Clusters Available Through a Public IP Address?
Data Import and Export
What Are the Differences Between Data Formats Supported by OBS and GDS Foreign Tables?
How Do I Import Incremental Data Using an OBS Foreign Table?
How Can I Import Data to GaussDB(DWS)?
How Much Service Data Can a Data Warehouse Store?
How Do I Use \Copy to Import and Export Data?
How Do I Implement Fault Tolerance Import Between Different Encoding Libraries
Can I Import and Export Data to and from OBS Across Regions?
How Do I Import GaussDB(DWS)/Oracle/MySQL/SQL Server Data to GaussDB(DWS) (Whole Database Migration)?
Can I Import Data over the Public/External Network Using GDS?
Which Are the Factors That Affect GaussDB(DWS) Import Performance?
Account, Password, and Permissions
How Does GaussDB(DWS) Implement Workload Isolation?
How Do I Change the Password of a Database Account When the Password Expires?
How Do I Grant Table Permissions to a User?
How Do I Grant Schema Permissions to a User?
How Do I Create a Database Read-only User?
How Do I Create Private Database Users and Tables?
How Do I Revoke the CONNECT ON DATABASE Permission from a User?
How Do I View the Table Permissions of a User?
Who Is User Ruby?
Database Usage
How Do I Change Distribution Columns?
How Do I View and Set the Database Character Encoding?
What Do I Do If Date Type Is Automatically Converted to the Timestamp Type During Table Creation?
Do I Need to Run VACUUM FULL and ANALYZE on Common Tables Periodically?
Do I Need to Set a Distribution Key After Setting a Primary Key?
Is GaussDB(DWS) Compatible with PostgreSQL Stored Procedures?
What Are Partitioned Tables, Partitions, and Partition Keys?
How Can I Export the Table Structure?
How Can I Delete Table Data Efficiently?
How Do I View Foreign Table Information?
If No Distribution Column Is Specified, How Will Data Be Stored?
How Do I Replace the Null Result with 0?
How Do I Check Whether a Table Is Row-Stored or Column-Stored?
How Do I Query the Information About GaussDB(DWS) Column-Store Tables?
Why Sometimes the GaussDB(DWS) Query Indexes Become Invalid?
How Do I Use a User-Defined Function to Rewrite the CRC32() Function?
What Are the Schemas Starting with pg_toast_temp* or pg_temp*?
Solutions to Inconsistent GaussDB(DWS) Query Results
Which System Catalogs That the VACUUM FULL Operation Cannot Be Performed on?
In Which Scenarios Would a Statement Be "idle in transaction"?
How Does GaussDB(DWS) Implement Row-to-Column and Column-to-Row Conversion?
What Are the Differences Between Unique Constraints and Unique Indexes?
Database Performance
Why Is SQL Execution Slow After Long GaussDB(DWS) Usage?
Why Does GaussDB(DWS) Perform Worse Than a Single-Server Database in Extreme Scenarios?
How Can I View SQL Execution Records in a Certain Period When Read and Write Requests Are Blocked?
What Do I Do If My Cluster Is Unavailable Because of Insufficient Space?
What is Operator Spilling in GaussDB(DWS)?
GaussDB(DWS) CPU Resource Management
Why the Tasks Executed by an Ordinary User Are Slower Than That Executed by the dbadmin User?
What Are the Factors Related to the Single-Table Query Performance in GaussDB(DWS)?
Snapshot Backup and Restoration
Why Is Creating an Automated Snapshot So Slow?
Does a DWS Snapshot Have the Same Function as an EVS Snapshot?
Billing
How Do I Renew the Service?
Is Refund Supported?
How Am I Billed for Scheduled Synchronization of GaussDB(DWS) Data to a PostgreSQL Database?
How Can I Try Out GaussDB(DWS) for Free?
Why Was I Deducted Fees After My GaussDB(DWS) Free Trial Expired?
Why Can't I See a Cluster After I Subscribe to a Free GaussDB(DWS) Trial?
How Can I Stop GaussDB(DWS) Billing?
Does Pay-per-Use Billing Stop When My Cluster Stops?
Why Is the Purchase Button Unavailable When I Create a Cluster?
How Do I Unfreeze a Cluster?
Can I Freeze or Shut Down a GaussDB(DWS) Cluster to Stop Billing?
Troubleshooting
Database Connections
What Do I Do If gsql: command not found Is Displayed When I Run gsql to Connect to the Database?
Database Cannot Be Connected Using the gsql Client
An Error Indicating Too Many Client Connections Is Reported When a User Connects to a GaussDB(DWS) Database
Cluster IP Address Cannot Be Pinged/Accessed
Error "An I/O error occurred while sending to the backend" Is Reported During Service Execution
JDBC/ODBC
Locating JDBC Issues
Database Connection Fails
Service Execution Exceptions
Performance Issues
Function Support Issues
Data Import and Export
"ERROR: invalid byte sequence for encoding 'UTF8': 0x00" Is Reported When Data Is Imported to GaussDB(DWS) Using COPY FROM
Data Import and Export Faults with GDS
Failed to Create a GDS Foreign Table and An Error Is Reported Indicating that ROUNDROBIN Is Not Supported
When CDM Is Used to Import MySQL Data to GaussDB(DWS), the Column Length Exceeds the Threshold and Data Synchronization Fails
"Access Denied" Is Displayed When the SQL Statement for Creating an OBS Foreign Table Is Executed
Disk Usage Increases After Data Fails to Be Imported Using GDS
Error Message "out of memory" Is Displayed When GDS Is Used to Import Data
Error Message "connection failure error" Is Displayed During GDS Data Transmission
Data to Be Imported Contains Chinese When the DataArts Studio Service Is Used to Create a GaussDB(DWS) Foreign Table
Database Parameter Modification
How to Change a Database's Default Time Zone When the Database Time Is Different from the System Time
Error "Cannot get stream index, maybe comm_max_stream is not enough" Is Reported
SQL Execution Fails With the Error Message "canceling statement due to statement timeout" Reported
Account/Permission/Password
How Do I Unlock an Account?
Account Still Locked After Password Resetting
After the Permission for Querying Tables in a Schema Is Granted to a User, the User Still Cannot Query the Tables
How Do I Revoke the Permission of a User If grant select on table t1 to public Has Been Executed on a Table
An Error Message Is Displayed When a Common User Executes the Statement for Creating or Deleting a GDS or OBS Foreign Table, Indicating that the User Does Not Have the Permission or the Permission Is Insufficient
After the all Permission Is Granted to the Schema of a User, the Error Message "ERROR: current user does not have privilege to role tom" Persists During Table Creation
An Error Message Is Reported During Statement Execution, Indicating that the User Does Not Have the Required Permission
Failed to Run the create extension Command and An Error Indicating No Permission Is Reported
A User Cannot Be Deleted Due to Its Dependencies
Cluster Performance
Lock Wait Detection
During SQL Execution, a Table Deadlock Occurs and An Error Stating LOCK_WAIT_TIMEOUT Is Reported
Error "abort transaction due to concurrent update" Is Reported During SQL Execution
Solution to High Disk Usage and Cluster Read-Only
SQL Execution Is Slow with Low Performance and Sometimes Does Not End After a Long Period of Time
Data Skew Causes Slow SQL Statement Execution and Operations Fail on Large Tables
Table Size Does not Change After VACUUM FULL Is Executed on the Table
VACUUM Is Executed After Table Data Deletion, But the Space Is Not Released
Error LOCK_WAIT_TIMEOUT Is Reported When VACUUM FULL Is Executed
VACUUM FULL Is Slow
Table Bloating Causes Slow SQL Query and Failed Data Loading on the GUI
Memory Overflow Occurs in a Cluster
Statements with User-defined Functions Cannot Be Pushed Down
Column-Store Tables Cannot Be Updated or Table Bloat Occurs
Table Bloat Occurs After Data Is Inserted into a Column-Store Table for Multiple Times
Writing Data to GaussDB(DWS) Is Slow and Client Data Is Stacked
Low Query Efficiency
Poor Query Performance Due to the Lack of Statistics
Execution of SQL Statements with NOT IN and NOT EXISTS Is Slow Due to Nested Loops in Execution Plans
SQL Query Is Slow Because Partitions Are Not Pruned
Optimizer Uses Nested Loop Due to the Small Estimated Number of Rows and the Performance Deteriorates
SQL Statements Contain the in Constant and No Result Is Returned After SQL Statement Execution
Performance of Single-Table Point Query Is Poor
CCN Queuing Under Dynamic Load Management
Performance Deterioration Due to Data Bloat
Slow Performance Caused by Too Many Small CUs in Column Storage
Cluster Exceptions
The Disk Usage Alarm Is Frequently Generated
Database Use
An Error Is Reported When Data Is Inserted or Updated, Indicating that the Distribution Key Cannot Be Updated
"Connection reset by peer" Is Displayed When a User Executes an SQL Statement
"value too long for type character varying" Is Displayed When VARCHAR(n) Stores Chinese Characters
Case Sensitivity in SQL Statements
cannot drop table test because other objects depend on it Is Displayed When a Table Is Deleted
Failed to Execute MERGE INTO UPDATE for Multiple Tables
JDBC Error Occurs Due to session_timeout Settings
DROP TABLE Fails to Be Executed
Execution Results of the string_agg Function Are Inconsistent
Error "could not open relation with OID xxxx" Is Reported During Table Size Query
DROP TABLE IF EXISTS Syntax Errors
Different Data Is Displayed for the Same Table Queried By Multiple Users
When a User Specifies Only an Index Name to Modify the Index, A Message Indicating That the Index Does Not Exist Is Displayed
An Error Is Reported During SQL Statement Execution, Indicating that the Schema Exists
Failed to Delete a Database and an Error Is Reported Indicating that a Session Is Connected to the Database
Byte Type Is Returned After a Table Column of the Character Type Is Read in Java
"ERROR:start value of partition 'XX' NOT EQUAL up-boundary of last partition." Is Displayed When Operations Related to Table Partitions Are Performed
Reindexing Fails
A View Failed to Be Queried
Global SQL Query
How Do I Check Whether a Table Has Been Updated or Deleted?
"Can't fit xid into page" Is Reported
"unable to get a stable set of rows in the source table" Is Reported
DWS Metadata Inconsistency - Abnormal Partition Index
An Error Is Reported When the truncate Command Is Executed on the System Table pg_catalog.gs_wlm_session_info
"inserted partition key does not map to any table partition" Is Reported When Data Is Inserted into a Partitioned Table
Error upper boundary of adding partition MUST overtop last existing partition Is Reported When a New Partition Is Added to a Range Partitioned Table
Error Reported During Table Query: "missing chunk number %d for toast value %u in pg_toast_XXXX"
When Inserting Data Into a Table, An Error Is Reported: "duplicate key value violates unique constraint "%s""
Error could not determine which collation to use for string hashing Reported During Service Execution
When the ODBC Driver of GaussDB(DWS) Is Used, Content of Fields of the Character Type in the SQL Query Result Is Truncated
Execution Plan Scan Hints Do Not Take Effect
Error "invalid input syntax for xxx" Is Reported During Data Type Conversion
Error UNION types %s and %s cannot be matched Is Reported
"ERROR: Non-deterministic UPDATE" Is Reported During Update
Error Reported During Data Insertion: null value in column ' %s' violates not-null constraint
Error "unable to get a stable set of rows in the source table"
Query Results Are Inconsistent in Oracle, Teradata, and MySQL Compatibility Modes
Videos
Error Code Reference
Management Console Error Code
Data Warehouse Service Error Codes
Description of SQL Error Codes
Third-Party Library Error Codes
GAUSS-00001 -- GAUSS-00100
GAUSS-00001 -- GAUSS-00010
GAUSS-00011 -- GAUSS-00020
GAUSS-00021 -- GAUSS-00030
GAUSS-00031 -- GAUSS-00040
GAUSS-00041 -- GAUSS-00050
GAUSS-00051 -- GAUSS-00060
GAUSS-00061 -- GAUSS-00070
GAUSS-00071 -- GAUSS-00080
GAUSS-00081 -- GAUSS-00090
GAUSS-00091 -- GAUSS-00100
GAUSS-00101 -- GAUSS-00200
GAUSS-00101 -- GAUSS-00110
GAUSS-00111 -- GAUSS-00120
GAUSS-00121 -- GAUSS-00130
GAUSS-00131 -- GAUSS-00140
GAUSS-00141 -- GAUSS-00150
GAUSS-00151 -- GAUSS-00160
GAUSS-00161 -- GAUSS-00170
GAUSS-00171 -- GAUSS-00180
GAUSS-00181 -- GAUSS-00190
GAUSS-00191 -- GAUSS-00200
GAUSS-00201 -- GAUSS-00300
GAUSS-00201 -- GAUSS-00210
GAUSS-00211 -- GAUSS-00220
GAUSS-00221 -- GAUSS-00230
GAUSS-00231 -- GAUSS-00240
GAUSS-00241 -- GAUSS-00250
GAUSS-00251 -- GAUSS-00260
GAUSS-00261 -- GAUSS-00270
GAUSS-00271 -- GAUSS-00280
GAUSS-00281 -- GAUSS-00290
GAUSS-00291 -- GAUSS-00300
GAUSS-00301 -- GAUSS-00400
GAUSS-00301 -- GAUSS-00310
GAUSS-00311 -- GAUSS-00320
GAUSS-00321 -- GAUSS-00330
GAUSS-00331 -- GAUSS-00340
GAUSS-00341 -- GAUSS-00350
GAUSS-00351 -- GAUSS-00360
GAUSS-00361 -- GAUSS-00370
GAUSS-00371 -- GAUSS-00380
GAUSS-00381 -- GAUSS-00390
GAUSS-00391 -- GAUSS-00400
GAUSS-00401 -- GAUSS-00500
GAUSS-00401 -- GAUSS-00410
GAUSS-00411 -- GAUSS-00420
GAUSS-00421 -- GAUSS-00430
GAUSS-00431 -- GAUSS-00440
GAUSS-00441 -- GAUSS-00450
GAUSS-00451 -- GAUSS-00460
GAUSS-00461 -- GAUSS-00470
GAUSS-00471 -- GAUSS-00480
GAUSS-00481 -- GAUSS-00490
GAUSS-00491 -- GAUSS-00500
GAUSS-00501 -- GAUSS-00600
GAUSS-00501 -- GAUSS-00510
GAUSS-00511 -- GAUSS-00520
GAUSS-00521 -- GAUSS-00530
GAUSS-00531 -- GAUSS-00540
GAUSS-00541 -- GAUSS-00550
GAUSS-00551 -- GAUSS-00560
GAUSS-00561 -- GAUSS-00570
GAUSS-00571 -- GAUSS-00580
GAUSS-00581 -- GAUSS-00590
GAUSS-00591 -- GAUSS-00600
GAUSS-00601 -- GAUSS-00700
GAUSS-00601 -- GAUSS-00610
GAUSS-00611 -- GAUSS-00620
GAUSS-00621 -- GAUSS-00630
GAUSS-00631 -- GAUSS-00640
GAUSS-00641 -- GAUSS-00650
GAUSS-00651 -- GAUSS-00660
GAUSS-00661 -- GAUSS-00670
GAUSS-00671 -- GAUSS-00680
GAUSS-00681 -- GAUSS-00690
GAUSS-00691 -- GAUSS-00700
GAUSS-00701 -- GAUSS-00800
GAUSS-00701 -- GAUSS-00710
GAUSS-00711 -- GAUSS-00720
GAUSS-00721 -- GAUSS-00730
GAUSS-00731 -- GAUSS-00740
GAUSS-00741 -- GAUSS-00750
GAUSS-00751 -- GAUSS-00760
GAUSS-00761 -- GAUSS-00770
GAUSS-00771 -- GAUSS-00780
GAUSS-00781 -- GAUSS-00790
GAUSS-00791 -- GAUSS-00800
GAUSS-00801 -- GAUSS-00900
GAUSS-00801 -- GAUSS-00810
GAUSS-00811 -- GAUSS-00820
GAUSS-00821 -- GAUSS-00830
GAUSS-00831 -- GAUSS-00840
GAUSS-00841 -- GAUSS-00850
GAUSS-00851 -- GAUSS-00860
GAUSS-00861 -- GAUSS-00870
GAUSS-00871 -- GAUSS-00880
GAUSS-00881 -- GAUSS-00890
GAUSS-00891 -- GAUSS-00900
GAUSS-00901 -- GAUSS-01000
GAUSS-00901 -- GAUSS-00910
GAUSS-00911 -- GAUSS-00920
GAUSS-00921 -- GAUSS-00930
GAUSS-00931 -- GAUSS-00940
GAUSS-00941 -- GAUSS-00950
GAUSS-00951 -- GAUSS-00960
GAUSS-00961 -- GAUSS-00970
GAUSS-00971 -- GAUSS-00980
GAUSS-00981 -- GAUSS-00990
GAUSS-00991 -- GAUSS-01000
GAUSS-01001 -- GAUSS-01100
GAUSS-01001 -- GAUSS-01010
GAUSS-01011 -- GAUSS-01020
GAUSS-01021 -- GAUSS-01030
GAUSS-01031 -- GAUSS-01040
GAUSS-01041 -- GAUSS-01050
GAUSS-01051 -- GAUSS-01060
GAUSS-01061 -- GAUSS-01070
GAUSS-01071 -- GAUSS-01080
GAUSS-01081 -- GAUSS-01090
GAUSS-01091 -- GAUSS-01100
GAUSS-01101 -- GAUSS-01200
GAUSS-01101 -- GAUSS-01110
GAUSS-01111 -- GAUSS-01120
GAUSS-01121 -- GAUSS-01130
GAUSS-01131 -- GAUSS-01140
GAUSS-01141 -- GAUSS-01150
GAUSS-01151 -- GAUSS-01160
GAUSS-01161 -- GAUSS-01170
GAUSS-01171 -- GAUSS-01180
GAUSS-01181 -- GAUSS-01190
GAUSS-01191 -- GAUSS-01200
GAUSS-01201 -- GAUSS-01300
GAUSS-01201 -- GAUSS-01210
GAUSS-01211 -- GAUSS-01220
GAUSS-01221 -- GAUSS-01230
GAUSS-01231 -- GAUSS-01240
GAUSS-01241 -- GAUSS-01250
GAUSS-01251 -- GAUSS-01260
GAUSS-01261 -- GAUSS-01270
GAUSS-01271 -- GAUSS-01280
GAUSS-01281 -- GAUSS-01290
GAUSS-01291 -- GAUSS-01300
GAUSS-01301 -- GAUSS-01400
GAUSS-01301 -- GAUSS-01310
GAUSS-01311 -- GAUSS-01320
GAUSS-01321 -- GAUSS-01330
GAUSS-01331 -- GAUSS-01340
GAUSS-01341 -- GAUSS-01350
GAUSS-01351 -- GAUSS-01360
GAUSS-01361 -- GAUSS-01370
GAUSS-01371 -- GAUSS-01380
GAUSS-01381 -- GAUSS-01390
GAUSS-01391 -- GAUSS-01400
GAUSS-01401 -- GAUSS-01500
GAUSS-01401 -- GAUSS-01410
GAUSS-01411 -- GAUSS-01420
GAUSS-01421 -- GAUSS-01430
GAUSS-01431 -- GAUSS-01440
GAUSS-01441 -- GAUSS-01450
GAUSS-01451 -- GAUSS-01460
GAUSS-01461 -- GAUSS-01470
GAUSS-01471 -- GAUSS-01480
GAUSS-01481 -- GAUSS-01490
GAUSS-01491 -- GAUSS-01500
GAUSS-01501 -- GAUSS-01600
GAUSS-01501 -- GAUSS-01510
GAUSS-01511 -- GAUSS-01520
GAUSS-01521 -- GAUSS-01530
GAUSS-01531 -- GAUSS-01540
GAUSS-01541 -- GAUSS-01550
GAUSS-01551 -- GAUSS-01560
GAUSS-01561 -- GAUSS-01570
GAUSS-01571 -- GAUSS-01580
GAUSS-01581 -- GAUSS-01590
GAUSS-01591 -- GAUSS-01600
GAUSS-01601 -- GAUSS-01700
GAUSS-01601 -- GAUSS-01610
GAUSS-01611 -- GAUSS-01620
GAUSS-01621 -- GAUSS-01630
GAUSS-01631 -- GAUSS-01640
GAUSS-01641 -- GAUSS-01650
GAUSS-01651 -- GAUSS-01660
GAUSS-01661 -- GAUSS-01670
GAUSS-01671 -- GAUSS-01680
GAUSS-01681 -- GAUSS-01690
GAUSS-01691 -- GAUSS-01700
GAUSS-01701 -- GAUSS-01800
GAUSS-01701 -- GAUSS-01710
GAUSS-01711 -- GAUSS-01720
GAUSS-01721 -- GAUSS-01730
GAUSS-01731 -- GAUSS-01740
GAUSS-01741 -- GAUSS-01750
GAUSS-01751 -- GAUSS-01760
GAUSS-01761 -- GAUSS-01770
GAUSS-01771 -- GAUSS-01780
GAUSS-01781 -- GAUSS-01790
GAUSS-01791 -- GAUSS-01800
GAUSS-01801 -- GAUSS-01900
GAUSS-01801 -- GAUSS-01810
GAUSS-01811 -- GAUSS-01820
GAUSS-01821 -- GAUSS-01830
GAUSS-01831 -- GAUSS-01840
GAUSS-01841 -- GAUSS-01850
GAUSS-01851 -- GAUSS-01860
GAUSS-01861 -- GAUSS-01870
GAUSS-01871 -- GAUSS-01880
GAUSS-01881 -- GAUSS-01890
GAUSS-01891 -- GAUSS-01900
GAUSS-01901 -- GAUSS-02000
GAUSS-01901 -- GAUSS-01910
GAUSS-01911 -- GAUSS-01920
GAUSS-01921 -- GAUSS-01930
GAUSS-01931 -- GAUSS-01940
GAUSS-01941 -- GAUSS-01950
GAUSS-01951 -- GAUSS-01960
GAUSS-01961 -- GAUSS-01970
GAUSS-01971 -- GAUSS-01980
GAUSS-01981 -- GAUSS-01990
GAUSS-01991 -- GAUSS-02000
GAUSS-02001 -- GAUSS-02100
GAUSS-02001 -- GAUSS-02010
GAUSS-02011 -- GAUSS-02020
GAUSS-02021 -- GAUSS-02030
GAUSS-02031 -- GAUSS-02040
GAUSS-02041 -- GAUSS-02050
GAUSS-02051 -- GAUSS-02060
GAUSS-02061 -- GAUSS-02070
GAUSS-02071 -- GAUSS-02080
GAUSS-02081 -- GAUSS-02090
GAUSS-02091 -- GAUSS-02100
GAUSS-02101 -- GAUSS-02200
GAUSS-02101 -- GAUSS-02110
GAUSS-02111 -- GAUSS-02120
GAUSS-02121 -- GAUSS-02130
GAUSS-02131 -- GAUSS-02140
GAUSS-02141 -- GAUSS-02150
GAUSS-02151 -- GAUSS-02160
GAUSS-02161 -- GAUSS-02170
GAUSS-02171 -- GAUSS-02180
GAUSS-02181 -- GAUSS-02190
GAUSS-02191 -- GAUSS-02200
GAUSS-02201 -- GAUSS-02300
GAUSS-02201 -- GAUSS-02210
GAUSS-02211 -- GAUSS-02220
GAUSS-02221 -- GAUSS-02230
GAUSS-02231 -- GAUSS-02240
GAUSS-02241 -- GAUSS-02250
GAUSS-02251 -- GAUSS-02260
GAUSS-02261 -- GAUSS-02270
GAUSS-02271 -- GAUSS-02280
GAUSS-02281 -- GAUSS-02290
GAUSS-02291 -- GAUSS-02300
GAUSS-02301 -- GAUSS-02400
GAUSS-02301 -- GAUSS-02310
GAUSS-02311 -- GAUSS-02320
GAUSS-02321 -- GAUSS-02330
GAUSS-02331 -- GAUSS-02340
GAUSS-02341 -- GAUSS-02350
GAUSS-02351 -- GAUSS-02360
GAUSS-02361 -- GAUSS-02370
GAUSS-02371 -- GAUSS-02380
GAUSS-02381 -- GAUSS-02390
GAUSS-02391 -- GAUSS-02400
GAUSS-02401 -- GAUSS-02500
GAUSS-02401 -- GAUSS-02410
GAUSS-02411 -- GAUSS-02420
GAUSS-02421 -- GAUSS-02430
GAUSS-02431 -- GAUSS-02440
GAUSS-02441 -- GAUSS-02450
GAUSS-02451 -- GAUSS-02460
GAUSS-02461 -- GAUSS-02470
GAUSS-02471 -- GAUSS-02480
GAUSS-02481 -- GAUSS-02490
GAUSS-02491 -- GAUSS-02500
GAUSS-02501 -- GAUSS-02600
GAUSS-02501 -- GAUSS-02510
GAUSS-02511 -- GAUSS-02520
GAUSS-02521 -- GAUSS-02530
GAUSS-02531 -- GAUSS-02540
GAUSS-02541 -- GAUSS-02550
GAUSS-02551 -- GAUSS-02560
GAUSS-02561 -- GAUSS-02570
GAUSS-02571 -- GAUSS-02580
GAUSS-02581 -- GAUSS-02590
GAUSS-02591 -- GAUSS-02600
GAUSS-02601 -- GAUSS-02700
GAUSS-02601 -- GAUSS-02610
GAUSS-02611 -- GAUSS-02620
GAUSS-02621 -- GAUSS-02630
GAUSS-02631 -- GAUSS-02640
GAUSS-02641 -- GAUSS-02650
GAUSS-02651 -- GAUSS-02660
GAUSS-02661 -- GAUSS-02670
GAUSS-02671 -- GAUSS-02680
GAUSS-02681 -- GAUSS-02690
GAUSS-02691 -- GAUSS-02700
GAUSS-02701 -- GAUSS-02800
GAUSS-02701 -- GAUSS-02710
GAUSS-02711 -- GAUSS-02720
GAUSS-02721 -- GAUSS-02730
GAUSS-02731 -- GAUSS-02740
GAUSS-02741 -- GAUSS-02750
GAUSS-02761 -- GAUSS-02770
GAUSS-02771 -- GAUSS-02780
GAUSS-02781 -- GAUSS-02790
GAUSS-02791 -- GAUSS-02800
GAUSS-02801 -- GAUSS-02900
GAUSS-02801 -- GAUSS-02810
GAUSS-02811 -- GAUSS-02820
GAUSS-02821 -- GAUSS-02830
GAUSS-02831 -- GAUSS-02840
GAUSS-02841 -- GAUSS-02850
GAUSS-02851 -- GAUSS-02860
GAUSS-02861 -- GAUSS-02870
GAUSS-02871 -- GAUSS-02880
GAUSS-02881 -- GAUSS-02890
GAUSS-02891 -- GAUSS-02900
GAUSS-02901 -- GAUSS-03000
GAUSS-02901 -- GAUSS-02910
GAUSS-02911 -- GAUSS-02920
GAUSS-02921 -- GAUSS-02930
GAUSS-02931 -- GAUSS-02940
GAUSS-02941 -- GAUSS-02950
GAUSS-02951 -- GAUSS-02960
GAUSS-02961 -- GAUSS-02970
GAUSS-02971 -- GAUSS-02980
GAUSS-02981 -- GAUSS-02990
GAUSS-02991 -- GAUSS-03000
GAUSS-03001 -- GAUSS-03100
GAUSS-03001 -- GAUSS-03010
GAUSS-03011 -- GAUSS-03020
GAUSS-03021 -- GAUSS-03030
GAUSS-03031 -- GAUSS-03040
GAUSS-03041 -- GAUSS-03050
GAUSS-03051 -- GAUSS-03060
GAUSS-03061 -- GAUSS-03070
GAUSS-03071 -- GAUSS-03080
GAUSS-03081 -- GAUSS-03090
GAUSS-03091 -- GAUSS-03100
GAUSS-03101 -- GAUSS-03200
GAUSS-03101 -- GAUSS-03110
GAUSS-03111 -- GAUSS-03120
GAUSS-03121 -- GAUSS-03130
GAUSS-03131 -- GAUSS-03140
GAUSS-03141 -- GAUSS-03150
GAUSS-03151 -- GAUSS-03160
GAUSS-03161 -- GAUSS-03170
GAUSS-03171 -- GAUSS-03180
GAUSS-03181 -- GAUSS-03190
GAUSS-03191 -- GAUSS-03200
GAUSS-03201 -- GAUSS-03300
GAUSS-03201 -- GAUSS-03210
GAUSS-03211 -- GAUSS-03220
GAUSS-03221 -- GAUSS-03230
GAUSS-03231 -- GAUSS-03240
GAUSS-03241 -- GAUSS-03250
GAUSS-03251 -- GAUSS-03260
GAUSS-03261 -- GAUSS-03270
GAUSS-03271 -- GAUSS-03280
GAUSS-03281 -- GAUSS-03290
GAUSS-03291 -- GAUSS-03300
GAUSS-03301 -- GAUSS-03400
GAUSS-03301 -- GAUSS-03310
GAUSS-03311 -- GAUSS-03320
GAUSS-03321 -- GAUSS-03330
GAUSS-03331 -- GAUSS-03340
GAUSS-03341 -- GAUSS-03350
GAUSS-03351 -- GAUSS-03360
GAUSS-03361 -- GAUSS-03370
GAUSS-03371 -- GAUSS-03380
GAUSS-03381 -- GAUSS-03390
GAUSS-03391 -- GAUSS-03400
GAUSS-03401 -- GAUSS-03500
GAUSS-03401 -- GAUSS-03410
GAUSS-03411 -- GAUSS-03420
GAUSS-03421 -- GAUSS-03430
GAUSS-03431 -- GAUSS-03440
GAUSS-03441 -- GAUSS-03450
GAUSS-03451 -- GAUSS-03460
GAUSS-03461 -- GAUSS-03470
GAUSS-03471 -- GAUSS-03480
GAUSS-03481 -- GAUSS-03490
GAUSS-03491 -- GAUSS-03500
GAUSS-03501 -- GAUSS-03600
GAUSS-03501 -- GAUSS-03510
GAUSS-03511 -- GAUSS-03520
GAUSS-03521 -- GAUSS-03530
GAUSS-03531 -- GAUSS-03540
GAUSS-03541 -- GAUSS-03550
GAUSS-03551 -- GAUSS-03560
GAUSS-03561 -- GAUSS-03570
GAUSS-03571 -- GAUSS-03580
GAUSS-03581 -- GAUSS-03590
GAUSS-03591 -- GAUSS-03600
GAUSS-03601 -- GAUSS-03700
GAUSS-03601 -- GAUSS-03610
GAUSS-03611 -- GAUSS-03620
GAUSS-03621 -- GAUSS-03630
GAUSS-03631 -- GAUSS-03640
GAUSS-03641 -- GAUSS-03650
GAUSS-03651 -- GAUSS-03660
GAUSS-03661 -- GAUSS-03670
GAUSS-03671 -- GAUSS-03680
GAUSS-03681 -- GAUSS-03690
GAUSS-03691 -- GAUSS-03700
GAUSS-03701 -- GAUSS-03800
GAUSS-03701 -- GAUSS-03710
GAUSS-03711 -- GAUSS-03720
GAUSS-03721 -- GAUSS-03730
GAUSS-03731 -- GAUSS-03740
GAUSS-03741 -- GAUSS-03750
GAUSS-03751 -- GAUSS-03760
GAUSS-03761 -- GAUSS-03770
GAUSS-03771 -- GAUSS-03780
GAUSS-03781 -- GAUSS-03790
GAUSS-03791 -- GAUSS-03800
GAUSS-03801 -- GAUSS-03900
GAUSS-03801 -- GAUSS-03810
GAUSS-03811 -- GAUSS-03820
GAUSS-03821 -- GAUSS-03830
GAUSS-03831 -- GAUSS-03840
GAUSS-03841 -- GAUSS-03850
GAUSS-03851 -- GAUSS-03860
GAUSS-03861 -- GAUSS-03870
GAUSS-03871 -- GAUSS-03880
GAUSS-03881 -- GAUSS-03890
GAUSS-03891 -- GAUSS-03900
GAUSS-03901 -- GAUSS-04000
GAUSS-03901 -- GAUSS-03910
GAUSS-03911 -- GAUSS-03920
GAUSS-03921 -- GAUSS-03930
GAUSS-03931 -- GAUSS-03940
GAUSS-03941 -- GAUSS-03950
GAUSS-03951 -- GAUSS-03960
GAUSS-03961 -- GAUSS-03970
GAUSS-03971 -- GAUSS-03980
GAUSS-03981 -- GAUSS-03990
GAUSS-03991 -- GAUSS-04000
GAUSS-04001 -- GAUSS-04100
GAUSS-04001 -- GAUSS-04010
GAUSS-04011 -- GAUSS-04020
GAUSS-04021 -- GAUSS-04030
GAUSS-04031 -- GAUSS-04040
GAUSS-04041 -- GAUSS-04050
GAUSS-04051 -- GAUSS-04060
GAUSS-04061 -- GAUSS-04070
GAUSS-04071 -- GAUSS-04080
GAUSS-04081 -- GAUSS-04090
GAUSS-04091 -- GAUSS-04100
GAUSS-04101 -- GAUSS-04200
GAUSS-04101 -- GAUSS-04110
GAUSS-04111 -- GAUSS-04120
GAUSS-04121 -- GAUSS-04130
GAUSS-04131 -- GAUSS-04140
GAUSS-04141 -- GAUSS-04150
GAUSS-04151 -- GAUSS-04160
GAUSS-04161 -- GAUSS-04170
GAUSS-04171 -- GAUSS-04180
GAUSS-04181 -- GAUSS-04190
GAUSS-04191 -- GAUSS-04200
GAUSS-04201 -- GAUSS-04300
GAUSS-04201 -- GAUSS-04210
GAUSS-04211 -- GAUSS-04220
GAUSS-04221 -- GAUSS-04230
GAUSS-04231 -- GAUSS-04240
GAUSS-04241 -- GAUSS-04250
GAUSS-04251 -- GAUSS-04260
GAUSS-04261 -- GAUSS-04270
GAUSS-04271 -- GAUSS-04280
GAUSS-04281 -- GAUSS-04290
GAUSS-04291 -- GAUSS-04300
GAUSS-04301 -- GAUSS-04400
GAUSS-04301 -- GAUSS-04310
GAUSS-04311 -- GAUSS-04320
GAUSS-04321 -- GAUSS-04330
GAUSS-04331 -- GAUSS-04340
GAUSS-04341 -- GAUSS-04350
GAUSS-04351 -- GAUSS-04360
GAUSS-04361 -- GAUSS-04370
GAUSS-04371 -- GAUSS-04380
GAUSS-04381 -- GAUSS-04390
GAUSS-04391 -- GAUSS-04400
GAUSS-04401 -- GAUSS-04500
GAUSS-04401 -- GAUSS-04410
GAUSS-04411 -- GAUSS-04420
GAUSS-04421 -- GAUSS-04430
GAUSS-04431 -- GAUSS-04440
GAUSS-04441 -- GAUSS-04450
GAUSS-04451 -- GAUSS-04460
GAUSS-04461 -- GAUSS-04470
GAUSS-04471 -- GAUSS-04480
GAUSS-04481 -- GAUSS-04490
GAUSS-04491 -- GAUSS-04500
GAUSS-04501 -- GAUSS-04600
GAUSS-04501 -- GAUSS-04510
GAUSS-04511 -- GAUSS-04520
GAUSS-04521 -- GAUSS-04530
GAUSS-04531 -- GAUSS-04540
GAUSS-04541 -- GAUSS-04550
GAUSS-04551 -- GAUSS-04560
GAUSS-04561 -- GAUSS-04570
GAUSS-04571 -- GAUSS-04580
GAUSS-04581 -- GAUSS-04590
GAUSS-04591 -- GAUSS-04600
GAUSS-04601 -- GAUSS-04700
GAUSS-04601 -- GAUSS-04610
GAUSS-04611 -- GAUSS-04620
GAUSS-04621 -- GAUSS-04630
GAUSS-04631 -- GAUSS-04640
GAUSS-04641 -- GAUSS-04650
GAUSS-04651 -- GAUSS-04660
GAUSS-04661 -- GAUSS-04670
GAUSS-04671 -- GAUSS-04680
GAUSS-04681 -- GAUSS-04690
GAUSS-04691 -- GAUSS-04700
GAUSS-04701 -- GAUSS-04800
GAUSS-04701 -- GAUSS-04710
GAUSS-04711 -- GAUSS-04720
GAUSS-04721 -- GAUSS-04730
GAUSS-04731 -- GAUSS-04740
GAUSS-04741 -- GAUSS-04750
GAUSS-04751 -- GAUSS-04760
GAUSS-04761 -- GAUSS-04770
GAUSS-04771 -- GAUSS-04780
GAUSS-04781 -- GAUSS-04790
GAUSS-04901 -- GAUSS-04999
GAUSS-04921 -- GAUSS-04930
GAUSS-04931 -- GAUSS-04940
GAUSS-05101 -- GAUSS-05200
GAUSS-05151 -- GAUSS-05160
GAUSS-05161 -- GAUSS-05170
GAUSS-05171 -- GAUSS-05180
GAUSS-05201 -- GAUSS-05800
GAUSS-05751 -- GAUSS-05760
GAUSS-05801 -- GAUSS-05900
GAUSS-05841 -- GAUSS-05850
GAUSS-05851 -- GAUSS-05860
GAUSS-05901 -- GAUSS-05999
GAUSS-05971 -- GAUSS-05980
GAUSS-06101 -- GAUSS-06200
GAUSS-06121 -- GAUSS-06130
GAUSS-50000 -- GAUSS-50999
GAUSS-50000 -- GAUSS-50099
GAUSS-50100 -- GAUSS-50199
GAUSS-50200 -- GAUSS-50299
GAUSS-50300 -- GAUSS-50399
GAUSS-50400 -- GAUSS-50499
GAUSS-50500 -- GAUSS-50599
GAUSS-50600 -- GAUSS-50699
GAUSS-50800 -- GAUSS-50899
GAUSS-51000 -- GAUSS-51999
GAUSS-51000 -- GAUSS-51099
GAUSS-51100 -- GAUSS-51199
GAUSS-51200 -- GAUSS-51299
GAUSS-51300 -- GAUSS-51399
GAUSS-51400 -- GAUSS-51499
GAUSS-51500 -- GAUSS-51599
GAUSS-51600 -- GAUSS-51699
GAUSS-51700 -- GAUSS-51799
GAUSS-51800 -- GAUSS-51899
GAUSS-51900 -- GAUSS-51999
GAUSS-52000 -- GAUSS-52999
GAUSS-52100 -- GAUSS-52199
GAUSS-52200 -- GAUSS-52299
GAUSS-52300 -- GAUSS-52399
GAUSS-52400 -- GAUSS-52499
GAUSS-52500 -- GAUSS-52599
GAUSS-52600 -- GAUSS-52699
GAUSS-52700 -- GAUSS-52799
GAUSS-52800 -- GAUSS-52899
GAUSS-52900 -- GAUSS-52999
GAUSS-53000 -- GAUSS-53999
GAUSS-53000 -- GAUSS-53099
GAUSS-53100 -- GAUSS-53199
GAUSS-53200 -- GAUSS-53299
GAUSS-53500 -- GAUSS-53599
OE000
Technical White Paper
GaussDB(DWS)
Product Positioning
Application Scenario
GaussDB(DWS) Architecture and Advantages
Platforms and Technical Specifications Supported by GaussDB(DWS)
Technical Specifications
GaussDB(DWS) Core Technologies
Shared-Nothing Architecture
Data Distribution in a Distributed System
Distributed Data Storage
Data Partitioning
Parallel Data Import
Fully Parallel Query
Vectorized Executor and Hybrid Row-Column Storage Engine
Resource Monitoring and Management
Load Management
Space Control
Distributed Transactions
Online Scale-Out
SQL on Anywhere
SQL on Hadoop
Cluster Management and HA
SQL Self-Diagnosis
Transparent Data Encryption
Data Masking
Data Backup and Disaster Recovery
Backup and Restoration
Cluster DR
GaussDB(DWS) Tools
Client Tools
gsql
Data Studio
Database Schema Convertor
Compatibility with Third-Party Tools
External APIs