检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Preparations Before Using Hudi Prerequisites You have created an OBS agency and OBS data source. For details, see Managing OBS Data Sources.
Preparations Before Using Hudi Prerequisites You have created an OBS agency and OBS data source. For details, see Managing OBS Data Sources.
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
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.
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.
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 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
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.