检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
An Error Message Is Displayed When a Common User Executes the Statement for Creating or Deleting a GDS or OBS Foreign Table, Indicating that the User Does Not Have the Permission or the Permission Is Insufficient Symptom An administrator can execute the statement for creating a GDS
Preparations Before Using Hudi Prerequisites You have created an OBS agency and OBS data source. For details, see Managing OBS Data Sources.
GS_OBS_LATENCY GS_OBS_LATENCY records the average latency of OBS during the 10 minutes before logtime. The latency is estimated based on OBS operations. This view is supported only by clusters of version 8.2.0 or later.
To query information about OBS/GDS foreign tables such as OBS paths, run the following statement: 1 SELECT * FROM pg_get_tabledef ('foreign_table_name') The following uses table traffic_data.GCJL_OBS as an example: 1 SELECT * FROM pg_get_tabledef('traffic_data.GCJL_OBS'); Parent
To query information about OBS/GDS foreign tables such as OBS paths, run the following statement: 1 SELECT * FROM pg_get_tabledef ('foreign_table_name') The following uses table traffic_data.GCJL_OBS as an example: 1 SELECT * FROM pg_get_tabledef('traffic_data.GCJL_OBS'); Parent
GaussDB(DWS) accesses Hudi data on OBS through foreign tables. For details, see section CREATE FOREIGN TABLE (SQL on OBS or Hadoop). Compared with OBS foreign tables, you only need to set format to hudi for Hudi foreign tables.
PG_OBSSCANINFO PG_OBSSCANINFO defines the OBS runtime information scanned in cluster acceleration scenarios. Each record corresponds to a piece of runtime information of a foreign table on OBS in a query.
PG_OBSSCANINFO PG_OBSSCANINFO defines the OBS runtime information scanned in cluster acceleration scenarios. Each record corresponds to a piece of runtime information of a foreign table on OBS in a query.
GS_OBSSCANINFO GS_OBSSCANINFO defines the OBS runtime information scanned in cluster acceleration scenarios. Each record corresponds to a piece of runtime information of a foreign table on OBS in a query.
GS_OBSSCANINFO GS_OBSSCANINFO defines the OBS runtime information scanned in cluster acceleration scenarios. Each record corresponds to a piece of runtime information of a foreign table on OBS in a query.
Column Type Description nodename TEXT Cluster node hostname TEXT Server node traffic_mb float8 OBS write traffic statistics during the 10 minutes before logtime bandwidth_mb_per_s float8 Average bandwidth, in MB/s reqcount Bigint Number of OBS writes during the 10 minutes before logtime
Column Type Description nodename TEXT Cluster node hostname TEXT Server node traffic_mb float8 OBS read traffic statistics during the 10 minutes before logtime bandwidth_mb_per_s float8 Average bandwidth, in MB/s reqcount Bigint Number of OBS reads during the 10 minutes before logtime
<obs_bucket_name> indicates the OBS bucket name. Only some regions are supported. For details about the supported regions and OBS bucket names, see Supported Regions.
<obs_bucket_name> indicates the OBS bucket name. Only some regions are supported. For details about the supported regions and OBS bucket names, see Supported Regions.
Overview In the storage-compute decoupling architecture, user data is stored in OBS to reduce storage costs. Each query generates network I/Os to retrieve data from OBS.
PGXC_OBS_IO_SCHEDULER_PERIODIC_STATS PGXC_OBS_IO_SCHEDULER_PERIODIC_STATS provides statistics on the number of requests and flow control information for different types of OBS I/O Scheduler requests, including read, write, and file operations.
PGXC_OBS_IO_SCHEDULER_STATS PGXC_OBS_IO_SCHEDULER_STATS displays the latest real-time statistics about read/write requests of the OBS I/O Scheduler. This system view is supported only by clusters of version 9.1.0 or later.
If the data source is OBS, set this parameter to the OBS agency name. user_pwd No String Password This parameter is mandatory when the data source is MRS. description No String Description.
Possible Causes The source file stored on OBS contains non-UTF-8 data. Handling Procedure Check whether the source file contains non-UTF-8 data, for example, Chinese characters.
Table 2 OPTIONS parameters Parameter Description Value Range address Specifies the IP address of the OBS service endpoint or HDFS cluster. OBS: Specifies the endpoint of the OBS service.
