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

STREAMING_CONT_QUERY

STREAMING_CONT_QUERY records the metadata of all CONTVIEW objects.

Table 1 STREAMING_CONT_QUERY columns

Name

Type

Description

id

integer

Unique identifier of the CONTVIEW object.

type

"char"

CONTVIEW type.

  • c indicates that the CONTVIEW is based on the column-store model.
  • r indicates that the CONTVIEW is based on the row-store model.
  • p indicates that the CONTVIEW is based on the partitioned column-store model.

relid

oid

CONTVIEW object ID.

defrelid

oid

ID of the continuous computing rule view corresponding to CONTVIEW.

active

boolean

Determines whether the CONTVIEW is in the continuous computing state.

  • t (true): yes
  • f (false): no

streamrelid

oid

ID of STREAM corresponding to CONTVIEW.

matrelid

oid

ID of the materialized table corresponding to CONTVIEW.

lookupidxid

oid

ID of GROUP LOOK UP INDEX corresponding to CONTVIEW. This column is for internal use and is available only in row-store tables.

step_factor

smallint

CONTVIEW step mode. The main values are 0 (no overlapping window) and 1 (sliding window, with one step).

ttl

integer

Value of ttl_interval set by CONTVIEW.

ttl_attno

smallint

Number of a time column corresponding to the TTL function set by CONTVIEW.

dictrelid

oid

ID of the dictionary table corresponding to CONTVIEW.

grpnum

smallint

Number of dimension columns in the CONTVIEW continuous computing rule. This column is for internal use.

grpidx

int2vector

Index of the dimension column in TARGET LIST in the CONTVIEW continuous computing rule. This column is for internal use.