Before You Start
Migrating DWS Data
- Data Migration to DWS
- Data Type Mapping
- Importing Data
- Full Database Migration
  - Using CDM to Migrate Data to DWS
  - Using DSC to Migrate SQL Scripts
- Metadata Migration
  - Using gs_dump and gs_dumpall to Export Metadata
  - Using gs_restore to Import Data
- Exporting Data
- Other Operations
DWS Development Design Proposal
- Overview
- DWS Connection Management Specifications
- DWS Object Design Specifications
- DWS SQL Statement Development Specifications
  - DDL Operations
  - INSERT Operation
  - UPDATE and DELETE Operations
  - SELECT Operation
- DWS Foreign Table Function Development Specifications
- DWS Stored Procedure Development Specifications
- Detailed Design Rules for DWS Objects
  - DWS Database Object Naming Rules
  - DWS Database Object Design Rules
    - DWS Database and Schema Design Rules
    - DWS Table Design Rules
    - DWS Column Design Rules
    - DWS Constraint Design Rules
    - Design Rules for DWS Views and Associated Tables
  - DWS JDBC Configuration Rules
  - DWS SQL Writing Rules
  - Rules for Using Custom DWS External Functions (pgSQL/Java)
  - Rules for Using DWS PL/pgSQL
Creating and Managing DWS Database Objects
- Creating and Managing DWS Databases
- Creating and Managing DWS Schemas
- Creating and Managing DWS Tables
- Selecting a DWS Table Storage Model
- Creating and Managing DWS Partitioned Tables
- Creating and Managing DWS Indexes
- Creating and Using DWS Sequences
- Creating and Managing DWS Views
- Creating and Managing DWS Scheduled Tasks
- Viewing DWS System Catalogs
Syntax Compatibility Differences Among Oracle, Teradata, and MySQL
DWS Database Security Management
- DWS User and Permissions Management
- DWS Sensitive Data Management
DWS Data Query
- Single Table Query
- Multi-Table Join Query
- Subquery Expressions
- WITH Expressions
- UNION Operators
- Data Reading/Writing Across Logical Clusters
- SQL on Hudi
DWS Sorting Rules
DWS Materialized Views
- Overview
- Asynchronous Materialized Views
DWS User-Defined Functions
- DWS PL/Java Functions
- DWS PL/pgSQL Functions
DWS Stored Procedures
- Overview
- Data Type Conversion for DWS Stored Procedures
- DWS Stored Procedure Array and Record
  - Arrays
  - record
- Declaration Syntax of DWS Stored Procedures
- Basic Statements of DWS Stored Procedures
- Dynamic Statements of DWS Stored Procedures
- Control Statements of DWS Stored Procedure
- Other Statements in DWS Stored Procedures
- DWS Stored Procedure Cursors
- Advanced Packages of DWS Stored Procedures
- DWS Stored Procedure Debugging
Using PostGIS Extension
- PostGIS
- Using PostGIS
- PostGIS Support and Constraints
- OPEN SOURCE SOFTWARE NOTICE (For PostGIS)
Using JDBC or ODBC for DWS Secondary Development
- Prerequisites
- JDBC-Based Development
- ODBC-Based Development
DWS Hot and Cold Data Management
DWS Resource Monitoring
- User Resource Monitoring
- Resource Pool Monitoring
- Monitoring Memory Resources
- Instance Resource Monitoring
- Real-time Top SQL
- Historical Top SQL
- Example for Querying for Top SQLs
DWS Performance Tuning
- Overview
- Performance Diagnosis
- System Optimization
- SQL Tuning
- SQL Tuning Examples
Hybrid Data Warehouse
- Introduction to Hybrid Data Warehouse
- Support and Constraints
- Hybrid Data Warehouse Syntax
- Hybrid Data Warehouse Functions
- Hybrid Data Warehouse Binlog
  - Subscribing to Hybrid Data Warehouse Binlog
  - Real-Time Binlog Consumption by Flink
DWS System Catalogs and Views
- Overview of System Catalogs and System Views
- System Catalogs
- System Views
GUC Parameters of the DWS Database
- 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
- HA Replication
  - Primary Server
- Query Planning
  - Optimizer Method Configuration
  - Optimizer Cost Constants
  - Genetic Query Optimizer
  - Other Optimizer Options
- Error Reporting and Logging
  - Logging Destination
  - Logging Time
  - Logging Content
- Runtime Statistics
  - 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
DWS Developer Terms
SQL Syntax Reference
- DWS SQL Overview
- DWS SQL Syntax
- Differences Between DWS and PostgreSQL
- Keyword
- Data Types
- Constant and Macro
- Functions and Operators
- Expressions
- Type Conversion
- Full Text Search
- System Operation
- Transaction Management
- DDL Syntax
- DML Syntax
- DCL Syntax
- DQL Syntax
- TCL Syntax
Change History

Importing Data