检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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
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.
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.
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.
----------------- 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
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.
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.
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.
Snapshots will occupy your OBS quotas. Project Projects are used to group and isolate OpenStack resources (computing resources, storage resources, and network resources). A project can be a department or a project team. Multiple projects can be created for one account.
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).
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.
