检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
It is ideal when the volume of OBS data storage or data transfer surpasses the purchased package.
By default, the OBS path of a storage-compute decoupled table is displayed as a relative path. To use the disk cache, enable the asynchronous I/O parameter.
table does not support deferrable index. level:ERROR GS_213100048 errmsg:index %s is not valid. errhint: Cannot change table with invalid index. level:ERROR GS_213100054 errmsg:parition not support to specify TABLESPACE. errhint: Cold data partition of multi-temperature table or OBS
RPO = 0 and RTO < 60s in intra-cluster HA scenarios; RTO < 30s in POC scenarios SQL on HDFS Supported ORC data export using OBS foreign tables. Supported XML function parsing. Supported XML function parsing. Modified distribution columns. Modified distribution columns.
Column-store data is stored in Huawei Cloud Object Storage Service (OBS). Local disks of compute nodes are used as the query cache of OBS data. Row-store data is still stored in local disks of compute nodes.
Currency Unit Minute (m) Hour (H) Day (d) primary_cluster_id Yes String ID of the primary cluster standby_cluster_id Yes String ID of the standby cluster primary_obs_bucket No String OBS bucket of the primary cluster standby_obs_bucket No String OBS bucket of the standby cluster Response
Automatic snapshots work with OBS to implement intra-region disaster recovery (DR).
TEMPLATE = thesaurus, DictFile = thesaurus_astro, Dictionary = pg_catalog.english_stem, FILEPATH = 'obs://bucket_name/path accesskey=ak secretkey=sk region=rg' ); The full name of the thesaurus dictionary file is thesaurus_astro.ths, and the dictionary is stored in the obs
It is ideal when the volume of OBS data storage or data transfer surpasses the purchased package. For details, see Billing Modes. You can also change the billing mode later if it no longer meets your needs. For details, see Billing Mode Change.
----------------- hdfs_server_8f79ada0_d998_4026_9020_80d6de2692ca | 16476 | 13685 | | | | {"address=192.168.1.245:9820,192.168.1.218:9820",hdfscfgpath=/MRS/8f79ada0-d998-4026-9020-80d6de2692ca,type=hdfs} (1 row) Creating a Foreign Table Create an OBS
Because the ANALYZE performance of the OBS foreign table and HDFS foreign table is poor, you are not advised to perform ANALYZE on these tables.
You can enable the Log Dump function to dump audit logs to OBS (you need to create an OBS bucket for storing audit logs first). For details about how to view the dumped logs, see Enabling Audit Log Dumps.
Figure 1 Cluster Status The OBS usage details are displayed in storage-compute decoupled cluster information. Alarms In the Alarms area, you can view all the uncleared alarms of the current cluster and the alarms generated in the last seven days.
Enter the database table and try again later. 400 DWS.5180 Invalid path for OBS file loading. Invalid path for OBS file loading. Enter a correct OBS loading path and try again later. 400 DWS.5181 Failed to load data. The error information is #failedReason#. Failed to load data.
The unit is ms. req_count Long Number of OBS requests during the 10 minutes before logtime. log_time Timestamp Time when the delay information is recorded. business_obs_read_traffic OBS bucket read traffic ctime Timestamp Collection time virtual_cluster_id Integer Virtual cluster
For details, see the syntax CREATE FOREIGN TABLE (SQL on Hadoop or OBS).
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.
Input parameter: obs_server: OBS server name. The value is of the text type. file_path: OBS file path. The value is of the text type. Return type: record Example: -- Create an OBS server.
Residualfiles 118 HA Data page Replication 121 Log Replication 122 Build 123 Primary-standby DN Switchovers 124 Replication Slot 125 Log flow Control 126 Catchup 127 Synchronous Submission 128 SQL on Anywhere SQL on paequet 131 SQL on orc 132 SQL on Hudi 133 SQL on carbondata 134 OBS
Example: 1 2 3 4 5 SELECT * FROM pg_obs_cold_refresh_time('lifecycle_table', '06:30:00'); pg_obs_cold_refresh_time -------------------------- SUCCESS (1 row) pg_refresh_storage() Description: Switches hot data to cold data on all hot and cold tables (in OBS).
