检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
If data stored in the OBS is no longer used, you can delete it to avoid further expenditures. Configure the Balance Alert function on the Billing Center > Overview page.
Manual cluster snapshots can be backed up to OBS or NFS. To create a manual snapshot of a cluster, the cluster state must be Available, To be restarted, or Unbalanced. In cluster versions earlier than 8.1.3.101, you can also create a snapshot of a cluster in the Read-only state.
TEMPLATE = ispell, DictFile = nn_no, AffFile = nn_no, FilePath = 'obs://bucket01/obs.example.com accesskey=xxxxx secretkey=xxxxx region=ap-southeast-1' ); The full name of the Ispell dictionary file is nn_no.dict and nn_no.affix, and the dictionary is stored in the obs
It is used when the amount of OBS data to be stored or the data volume exceeds the package capacity.
However, if you use more space than the free-of-charge storage space, the exceeded part is charged according to OBS billing rules. For details, see the OBS pricing details. The amount of free space you have is equal to the total storage capacity of your cluster.
OBS Path: Find the product_info.txt file in the created OBS bucket and click Yes. HDFS Path: Select /user/hive/warehouse/demo.db/product_info/ and click Yes. Click OK to import the product_info table data. Create an ORC table and import data to the table.
Each region has its own shared public services (ECS, EVS, OBS, VPC, EIP, and IMS). Regions are either common or dedicated. A common region provides common cloud services available to all tenants.
It is ideal when the volume of OBS data storage or data transfer surpasses the purchased package.
Only the tables stored in OBS can be used to restore data to the original cluster. Currently, only cluster- and schema-level snapshots can be used for such restoration. Restoration can be performed only if the snapshot and the cluster are both in the Available state.
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).
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
Manual schema snapshots can be backed up to OBS or NFS. Schema snapshots can be created only for clusters in Available or Unbalanced state. Prerequisites Manually enable the fine-grained snapshot. Choose Management > Snapshots.
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
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.
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.
Automatic snapshots work with OBS to implement intra-region disaster recovery (DR).
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.
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.
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
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