Help Center> Data Warehouse Service (DWS)> 3.0 Developer Guide> Support and Constraints
Updated on 2023-11-30 GMT+08:00
View PDF

Support and Constraints

The differences between operations supported by GaussDB(DWS) 3.0 lie in the Huawei Cloud management console and database operations.

For details about the operation differences supported on the management console, see Table 1. For details about the supported database capabilities, see Table 2.

Table 1 Console Operation

Module

Function

DWS 2.0

DWS 3.0

Navigation menu

Dashboard

Yes

Yes

Cluster Management

Yes

Yes

DR management

Yes

No

Snapshot management

Yes

Yes

Parameters

Yes

Yes

Incident management

Yes

Yes

Alarm management

Yes

Yes

Connection management

Yes

Yes

Dashboard

Resources

Yes

Yes

Alarms

Yes

Yes

Recent events

Yes

Yes

Cluster monitoring metrics (DMS)

Yes

Yes

Cluster management

Monitoring panel (DMS)

Yes

Yes

Monitoring metrics (Cloud Eye)

Yes

Yes

Restart

Yes

Yes

Scaling

Yes

Yes

Redistributing data

Yes

Yes

Viewing redistribution details

Yes

Yes

Resetting passwords

Yes

Yes

Creating snapshots

Yes

Yes

Canceling read-only status

Yes

Yes

Deletion

Yes

Yes

Managing CNs

Yes

Yes

Storage space scaling

Yes

Yes

Basic Information

Basic information

Yes

Yes

ELB

Yes

Yes

Resource pool

Yes

Yes

Logical cluster

Yes

Yes

Snapshot

Yes

Yes

Parameter modifications

Yes

Yes

Security settings

Yes

Yes

MRS data sources

Yes

Yes

Monitoring Panel

Yes

Yes

Tags

Yes

Yes

Node management

Yes

Yes

DR management

DR management

Yes

No

Snapshot management

Restoration

Yes

Yes

Deletion

Yes

Yes

Copy

Yes

Yes

Incident management

Event management (general)

Yes

Yes

Alarm management

Alarm management

Yes

Yes

Connection management

Connection management

Yes

Yes

Others

Inspection

Yes

Yes

Intelligent O&M

Yes

Yes

Node restoration

Yes

Yes

Warm backup on the tenant side

Yes

Yes

OpenApi

Yes

No
Table 2 Database operations

Type

Syntax

Supported

Basic functions

CREATE TABLE

Yes

CREATE TABLE LIKE

Yes

DROP TABLE

Yes

INSERT

Yes

COPY

Yes

SELECT

Yes

TRUNCATE

Yes

EXPLAIN

Yes

ANALYZE

Yes

VACUUM

Yes

ALTER TABLE DROP PARTITION

Yes

ALTER TABLE ADD PARTITION

Yes

ALTER TABLE SET WITH OPTION

Yes

ALTER TABLE DROP COLUMN

Yes

ALTER TABLE ADD COLUMN

Yes

ALTER TABLE ADD NODELIST

Yes

ALTER TABLE CHANGE OWNER

Yes

ALTER TABLE RENAME COLUMN

Yes

ALTER TABLE TRUNCATE PARTITION

Yes

Other ALTER TABLE syntax

Yes

CREATE INDEX

Yes

DROP INDEX

Yes

DELETE

Yes

ALTER INDEX

Yes

MERGE

Yes

SELECT INTO

Yes

UPDATE

Yes

CREATE TABLE AS

Yes

Webhook

No

PRIMARY KEY

Yes

UNIQUE CONSTRAINT

Yes

UNLOG tables

Yes

Custom types

No

Explicit cursors

Yes

Transaction capability

Sub-transactions

Yes

Transaction Isolation Levels

Yes

Advanced functions

Materialized views

No

Stored procedures

N

AUTO VACUUM

Yes

AUTO ANALYZE

Yes
Table 3 Data types supported by column-store tables

Category

Data Type

Length

Supported

Numeric types

smallint

2

Yes

integer

4

Yes

bigint

8

Yes

decimal

Variable length

Yes

numeric

Variable length

Yes

real

4

Yes

double precision

8

Yes

smallserial

2

Yes

serial

4

Yes

bigserial

8

Yes

Monetary types

money

8

Yes

Character types

character varying(n), varchar(n)

Variable length

Yes

character(n), char(n)

n

Yes

character, char

1

Yes

text

Variable length

Yes

nvarchar2

Variable length

Yes

name

64

No

Date/time types

timestamp with time zone

8

Yes

timestamp without time zone

8

Yes

date

4

Yes

time without time zone

8

Yes

time with time zone

12

Yes

interval

16

Yes

Large objects

clob

Variable length

Yes

blob

Variable length

No

Others

...

...

No