检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
For more information about the node flavors supported by GaussDB(DWS) and their prices, see the GaussDB(DWS) pricing details.
(20) , product_type2 char(10) , product_monthly_sales_cnt integer , product_comment_time date , product_comment_num integer , product_comment_content varchar(200) ) SERVER
For more information about the node flavors supported by GaussDB(DWS) and their prices, see the GaussDB(DWS) pricing details.
Using GDS to Import Table Data from a Remote Server to a GaussDB(DWS) Cluster Overview This practice demonstrates how to use General Data Service (GDS) to import data from a remote server to GaussDB(DWS). GaussDB(DWS) allows you to import data in TXT, CSV, or FIXED format.
integer , product_comment_content varchar(200) ) SERVER hdfs_server_8f79ada0_d998_4026_9020_80d6de2692ca OPTIONS ( format 'orc', foldername '/user/hive/warehouse/product_info_orc/', compression 'snappy', version '0.12' ) Write Only;
varchar(200), product_type1 varchar(20), product_type2 char(10), product_monthly_sales_cnt integer, product_comment_time date, product_comment_num integer, product_comment_content varchar(200) ) SERVER gsmpp_server OPTIONS ( LOCATION'obs://OBS bucket name/input_data/
In this case, log messages generated by Java Logger are all redirected to the GaussDB(DWS) backend. Then, the log messages are written into server logs or displayed on the user interface. MPPDB server logs record information at the LOG, WARNING, and ERROR levels.
This section describes how to optimize table performance in GaussDB(DWS) by properly designing the table structure (for example, by selecting the table model, table storage mode, compression level, distribution mode, distribution column, partitioned tables, and local clustering).
When enabled, it merges and rewrites (where a in (list1) or a in (list2)) to support inlist2join.
Status Code Status Code Description 200 The cluster has been successfully created. 400 Request error. 401 Authentication failed. 403 You do not have required permissions. 500 Internal server error 503 Service unavailable. Parent Topic: Cluster Management
char(30) , product_time date , product_level char(10) , product_name varchar(200) , product_type1 varchar(20) , product_type2 char(10)
Status Code Status Code Description 200 The ring node information of the cluster topology is queried. 400 Request error. 401 Authentication failed. 403 You do not have required permissions. 404 No resources found. 500 Internal server error. 503 Service unavailable.
varchar(200) ) SERVER obs_server OPTIONS ( format 'orc', foldername '/mybucket/demo.db/product_info_orc/', encoding 'utf8', totalrows '10' ) DISTRIBUTE BY ROUNDROBIN; Create an OBS foreign table that contains partition columns.
Status Code Status Code Description 200 The cluster node information is queried. 400 Request error. 401 Authentication failed. 403 You do not have required permissions. 404 No resources found. 500 Internal server error. 503 Service unavailable. Parent Topic: Cluster Management
(Optional) Public network bandwidth When a yearly/monthly cluster is configured with an EIP billed by bandwidth, the bandwidth is billed by the Elastic Cloud Server (ECS) service in yearly/monthly mode.
varchar(200), product_type1 varchar(20), product_type2 char(10), product_monthly_sales_cnt integer, product_comment_time date, product_comment_num integer, product_comment_content varchar(200) ) SERVER gsmpp_server OPTIONS ( LOCATION'obs://OBS bucket name/input_data/
Status Code Status Code Description 200 The node type is queried successfully. 400 Request error 401 Authentication failed. 403 You do not have required permissions. 404 No resources found. 500 Internal server error. 503 Service unavailable. Parent Topic: Cluster Management
Status Code Status Code Description 202 The cluster node is deleted. 400 Request error. 401 Authentication failed. 403 You do not have required permissions. 404 No resources found. 500 Internal server error. 503 Service unavailable. Parent Topic: Cluster Management
You can query the cluster flavor by referring to Querying Node Types. Response Parameters None Example Request Expand the cluster disk capacity to 200 GB on a single node.
Node A GaussDB(DWS) cluster can have 3 to 256 nodes. A storage-compute coupled data warehouse (standalone) can only have one node. Each node can store and analyze data. For details, see GaussDB(DWS) Technical Specifications.
