Data Warehouse Service
Data Warehouse Service (DWS) is a real-time, simple, secure, and reliable enterprise-class converged data warehouse service. It is compatible with the standard ANSI SQL 99/2003 and PostgreSQL/Oracle ecosystems, providing state of the art PB-level big data analysis across a variety of industries.
Progressive Knowledge
DWS knowledge for users from beginner level to expert level
01

Understand
DWS architecture, functions, and application scenarios are provided to help you quickly select your desired type to match services. This facilitates easier data analysis.
Service Overview
03

Start
This document demonstrates how to create a data warehouse cluster, connect to a sample database, import sample data from OBS, and query and analyze the data, helping you quickly use DWS.
Getting Started
Initializing Data Disks
05

Excellent Practices
During table design, data import, and query design, comprehensively consider the factors to work out a proper solution. This chapter introduces key principles with necessary examples and usage suggestions.
Excellent Practices
07

Tools
DWS provides several database tools to facilitate database management and data import and export.
Tool Guide
08

APIs
DWS provides Representational State Transfer (REST) APIs. You can make API calls over HTTPS to manage clusters and snapshots. This document details DWS APIs, parameters, examples, and calling methods.
API Reference
02

Purchase
DWS supports two billing modes: pay-per-use (billed based on the actual duration) and yearly/monthly package (discount obtained by upfront payment).
Billing Mode
Quick Purchase
Billing FAQs
04

Be a Power User
DWS provides an easy-to-use management console, allowing you to quickly create clusters and easily manage data warehouses.
Common Operations
Connecting to a Cluster
O&M and Monitoring
06

Access the Database
The database developer guide is intended for database designers, application developers, and database administrators (DBAs), and provides information required for designing, building, querying, and maintaining data warehouses.
Common Operations
Data Import and Export
Performance Tuning
Resource Load Management
FAQs
Learn more about common issues and solutions.
Typical Cases
What Scenarios Do Data Warehouses Apply To?
What Should I Do If I Fail to Create a DWS Cluster?
What Are the Differences Between Data Warehouses and the Hadoop Big Data Platform?
What Should I Do If I Cannot Connect to a DWS Cluster?
Troubleshooting
What Are the Differences Between DWS and Hive in Functions?
Can I Access Nodes in a DWS Cluster in SSH Mode?
Should I Choose DWS or RDS on Public Cloud?
How Can I Store Data to DWS?
Is My Data Secure in DWS?
How Can I Clear and Reclaim the Storage Space?
Database Connection
Database Performance
A DWS Cluster Becomes Read-Only and Is Locked, so Data Cannot be Written to It
Slow Response to a Query Statement
Forcibly Terminating a Session
It Takes a Long Time to Execute SQL Statements That Could be Executed Quickly Before
Error LOCK_WAIT_TIMEOUT Is Reported During SQL Execution
Memory Cannot be Allocated or Is Temporarily Unavailable
Error LOCK_WAIT_TIMEOUT Is Reported When VACUUM FULL Is Executed
Table Size Does not Change After VACUUM FULL Is Executed on the Table
Data Import and Export
Database Use
How to Change a Database's Default Time Zone When the Database Time Is Different from the System Time
Grant The Permission On The Tables to Be Created In The Schema To A Specified User
Is a Field Name Case-sensitive?
- How Many Bytes Does a Chinese Character Occupy?
Content of Fields in the SQL Query Result Is Truncated
Failed to Delete a Database Because a Session Is Connected to the Database
DROP TABLE Fails to Be Executed
Technical Topics
Technologies, expert opinions, and courses
