检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
----------------- 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
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.
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.
-----+-----------------+-------+---------------------------+------------+--------- asciiword | Word, all ASCII | Paris | {my_synonym,english_stem} | my_synonym | {pari} (1 row) The full name of the synonym dictionary file is my_synonyms.syn, and the dictionary is stored in the obs
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.
Local disks are used as the query cache of OBS data. Row-store data is still stored in local disks of compute nodes. Advantage Data is stored locally on compute nodes, providing high performance.
Use the default OBS tablespace.
