Updated on 2023-10-23 GMT+08:00

GS_WLM_EC_OPERATOR_STATISTICS

GS_WLM_EC_OPERATOR_STATISTICS displays operators of the Extension Connector jobs that are being executed by the current user. Only the user with sysadmin permission can query this view. The current feature is a lab feature. Contact Huawei technical support before using it.

Table 1 GS_WLM_EC_OPERATOR_STATISTICS columns

Name

Type

Description

queryid

bigint

Internal query ID used for Extension Connector statement execution

plan_node_id

integer

Plan node ID of the execution plan of an Extension Connector operator

start_time

timestamp with time zone

Time when the Extension Connector operator starts to process the first data record

ec_status

text

Status of the Extension Connector job

  • EC_STATUS_INIT: initialized.
  • EC_STATUS_CONNECTED: connected.
  • EC_STATUS_EXECUTED: executed.
  • EC_STATUS_FETCHING: fetching.
  • EC_STATUS_END: ended.

ec_execute_datanode

text

Name of the DN executing the Extension Connector job

ec_dsn

text

DSN used by the Extension Connector job

ec_username

text

Username used by the Extension Connector job to access the remote cluster (null if the remote cluster type is SPARK)

ec_query

text

Statement sent by the Extension Connector job to a remote cluster

ec_libodbc_type

text

Type of the unixODBC driver used by the Extension Connector job

  • Type 1: corresponds to libodbc.so.1.
  • Type 2: corresponds to libodbc.so.2.

ec_fetch_count

bigint

Number of data records processed by the Extension Connector job