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.
DWS knowledge for users from beginner level to expert level
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.
Initializing Data Disks
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.
DWS supports two billing modes: pay-per-use (billed based on the actual duration) and yearly/monthly package (discount obtained by upfront payment).
Be a Power User
DWS provides an easy-to-use management console, allowing you to quickly create clusters and easily manage data warehouses.
Connecting to a Cluster
O&M and Monitoring
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.
Data Import and Export
Resource Load Management
Learn more about common issues and solutions.
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?
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?
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
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
Technologies, expert opinions, and courses