检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Configuration Type Configuration Name Basic settings Region, billing modeAZ, node flavor, cluster name, database port, VPC, subnet, security group, public access, and enterprise project Advanced settings If Custom is selected, configure the following parameters: Backup devices: Select OBS
This section describes how to import sample data from OBS to a data warehouse cluster and perform querying and analysis operations on the sample data. The sample data is generated based on the standard TPC-DS benchmark test.
This section describes how to import sample data from OBS to a data warehouse cluster and perform querying and analysis operations on the sample data. The sample data is generated based on the standard TPC-DS benchmark test.
The sample data is stored in an OBS bucket accessible to all authenticated cloud users. Note that <obs_bucket_name> in the following statement indicates the OBS bucket name. Only some regions are supported.
Notes and Constraints Manually created snapshots can be backed up to OBS or NFS. To create a snapshot of a cluster, ensure that the cluster is in Available, To be restarted, or Unbalanced state.
Default value: off acceleration_with_compute_pool Parameter description: Specifies whether to use the computing resource pool for acceleration when OBS is queried.
pg_total_relation_size can specify the OID or name of a table or compressed table, and then return the data in bytes and the sizes of all related indexes and compressed tables. pg_obs_file_size(regclass) Description: This function obtains the CU file size, file name, and bucket ID stored on OBS
Excellent query performance High-quality query plans and efficient execution engines Precise load management methods Real-Time Write DWS 3.0 utilizes the HStore storage engine to store micro-batch data locally and syncs it to OBS at regular intervals.
Use the default OBS tablespace.
Data masking policies can be created for regular tables and non-EXTERNAL-SCHEMA foreign tables (such as OBS, HDFS, GDS, and foreign tables for coordinated analysis), but not for system catalogs, EXTERNAL SCHEMA foreign tables, temporary tables, UNLOGGED tables, views, or functions
If the manual snapshots are still retained after the cluster is deleted and the total snapshot size exceeds the free space, the excess part will be billed based on the OBS billing rate.
cluster_id String Cluster ID count Integer Total number Table 3 AuditDumpRecord Parameter Type Description cluster_id String Cluster ID exector_time String Execution time begin_time String Start time end_time String End time bucket_name String Bucket name location_prefix String OBS
- Cold Data Store data in separate OBS buckets, which are billed on a pay-per-use basis. - Nodes Specify the number of nodes in the cluster. The number of nodes ranges from 3 to 256. 3 Total Display the cluster's total capacity.
The cold_tablespace and storage_policy parameters of ALTER RESET cannot be used in OBS multi-temperature tables, and COLVERSION cannot be changed to 1.0 for such tables. You can change a column-store table whose COLVERSION parameter is 2.0 to an OBS multi-temperature table.
* 2,3,4,5,6,7", "backup_type": "increment", "backup_level": "cluster", "next_fire_time": "1667213760000", "update_time": "2022-10-31T02:54:54" } ], "device_name": "obs", "server_ips": null, "server_port": null, "backup_param": "" } SDK Sample
Snapshots are stored in the storage space of Object Storage Service (OBS). snapshot restoration A snapshot can be used to restore a cluster to a newly created one that has the same specifications. Currently, you can restore a cluster only to a new one.
Use cstore_buffers to specify the cache of ORC, Parquet, or CarbonData metadata and data for OBS or HDFS foreign tables. The metadata cache size should be 1/4 of cstore_buffers and not exceed 2 GB.
Type: USERSET Value range: enumerated values 0: The size of the database is directly estimated based on the OBS bucket. 1: The size of the entire database is normally calculated in regular mode.
status String Status of the DR cluster restoring: DCS instance restoration is in progress. stopped: The task has been stopped. waiting: The task is being executed in the next period. abnormal progress String DR progress last_success_time String Last DR time obs_bucket_name String OBS
Backup Device Select OBS or NFS from the drop-down list. NFS Backup File System Address (NFS) NFS shared IP address. To mount the SFS shared path, enter its IP address.
