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. To query the view, you must have the sysadmin permission. 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 an Extension Connector job

ec_dsn

text

DSN used by an Extension Connector job

ec_username

text

Username used by the Extension Connector job to access a remote database instance (the value is null if the remote database instance is SPARK.)

ec_query

text

Statement sent by an Extension Connector job to a remote database instance

ec_libodbc_type

text

Type of the unixODBC driver used by an 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 an Extension Connector job