System Views

GridGain provides a number of built-in SQL views that provide information on the cluster’s state and provide real-time insight into the status of its components. These views are available in the SYSTEM schema.

Getting Data

You access system views in GridGain by using SQL and selecting data from the system view like you would from any other table. For example, you can get a list of all available system views in the following way:

SELECT * FROM system.system_views

You can also use joins to combine data from multiple views. The example below returns all columns of a view that was found in the SYSTEM_VIEWS view:

SELECT svc.*
  FROM system.system_view_columns svc
  JOIN system.system_views sv ON svc.view_id = sv.id
 WHERE sv.name = 'SYSTEM_VIEWS'

Available Views

GLOBAL_PARTITION_STATES

Column Data Type Description

Column	Data Type	Description
ZONE_NAME	STRING	The name of the distribution zone the partition belongs to.
TABLE_NAME	STRING	The name of the table stored in the partition.
TABLE_ID	INT32	The ID of the table stored in the partition.
SCHEMA_NAME	STRING	The name of the schema the table belongs to.
PARTITION_ID	INT32	The unique identifier of the partition.
STATE	STRING	Partition status. Possible values: `AVAILABLE`, `DEGRADED`, `READ_ONLY`, `UNAVAILABLE`. See Disaster Recovery documentation for more information.

ZONE_NAME

STRING

The name of the distribution zone the partition belongs to.

TABLE_NAME

STRING

The name of the table stored in the partition.

TABLE_ID

INT32

The ID of the table stored in the partition.

SCHEMA_NAME

STRING

The name of the schema the table belongs to.

PARTITION_ID

INT32

The unique identifier of the partition.

STATE

STRING

Partition status. Possible values: AVAILABLE, DEGRADED, READ_ONLY, UNAVAILABLE. See Disaster Recovery documentation for more information.

INDEXES

Column Data Type Description

Column	Data Type	Description
INDEX_ID	INT32	Unique index identifier.
INDEX_NAME	STRING	The name of the index.
TABLE_ID	INT32	Unique table identifier.
TABLE_NAME	STRING	The name of the table.
SCHEMA_ID	INT32	Unique schema identifier.
SCHEMA_NAME	STRING	The name of the schema.
TYPE	STRING	The type of the index. Possible values: `HASH`, `SORTED`.
IS_UNIQUE	BOOLEAN	If the index is unique.
COLUMNS	STRING	The list of indexed columns.
STATUS	STRING	Current status of the index. Possible values: `REGISTERED` - Index has been registered and is awaiting the start of building, `BUILDING` - Index is being built, `AVAILABLE` - Index is built and is ready to use, `STOPPING` - DROP INDEX command has been executed, index is waiting for running transactions to finish.

INDEX_ID

INT32

Unique index identifier.

INDEX_NAME

STRING

The name of the index.

TABLE_ID

INT32

Unique table identifier.

TABLE_NAME

STRING

The name of the table.

SCHEMA_ID

INT32

Unique schema identifier.

SCHEMA_NAME

STRING

The name of the schema.

TYPE

STRING

The type of the index. Possible values: HASH, SORTED.

IS_UNIQUE

BOOLEAN

If the index is unique.

COLUMNS

STRING

The list of indexed columns.

STATUS

STRING

Current status of the index. Possible values:

REGISTERED - Index has been registered and is awaiting the start of building,
BUILDING - Index is being built,
AVAILABLE - Index is built and is ready to use,
STOPPING - DROP INDEX command has been executed, index is waiting for running transactions to finish.

LICENSES

Column	Data Type	Description
EDITION	STRING	License edition.
ID	STRING	The license ID.
INFOS	STRING	A list of key-value pairs providing information about the license requester/owner.
LIMITS	STRING	A list of key-value pairs providing information about the license validity period, cores and heap size limits, etc.
FEATURES	STRING	A list of GridGain features the license grants to the user.

Column

Data Type

Description

EDITION

STRING

License edition.

STRING

The license ID.

INFOS

STRING

A list of key-value pairs providing information about the license requester/owner.

LIMITS

STRING

A list of key-value pairs providing information about the license validity period, cores and heap size limits, etc.

FEATURES

STRING

A list of GridGain features the license grants to the user.

LOCAL_PARTITION_STATES

Column Data Type Description

Column	Data Type	Description
ZONE_NAME	STRING	The name of the distribution zone the partition belongs to.
TABLE_NAME	STRING	The name of the table stored in the partition.
TABLE_ID	INT32	The ID of the table stored in the partition.
SCHEMA	STRING	The name of the schema the table belongs to.
PARTITION_ID	INT32	The unique identifier of the partition.
STATE	STRING	Partition status. Possible values: `AVAILABLE`, `DEGRADED`, `READ_ONLY`, `UNAVAILABLE`. See Disaster Recovery documentation for more information.

ZONE_NAME

STRING

The name of the distribution zone the partition belongs to.

TABLE_NAME

STRING

The name of the table stored in the partition.

TABLE_ID

INT32

The ID of the table stored in the partition.

SCHEMA

STRING

The name of the schema the table belongs to.

PARTITION_ID

INT32

The unique identifier of the partition.

STATE

STRING

Partition status. Possible values: AVAILABLE, DEGRADED, READ_ONLY, UNAVAILABLE. See Disaster Recovery documentation for more information.

SEQUENCES

Column	Data Type	Description
ID	INT32	The ID of the sequence.
NAME	STRING	The name of the sequence.
SCHEMA_ID	INT32	The id of the schema used by the sequence.
SCHEMA_NAME	STRING	The name of the schema used by the sequence.
DATA_TYPE	STRING	The sequence data type.
INCREMENT	INT64	How much the sequence is incremented by each time.
MINIMUM_VALUE	INT64	Minimum sequence value.
MAXIMUM_VALUE	INT64	Maximum sequence value.
START_VALUE	INT64	The starting value of the sequence.
CACHE_VALUE	INT64	The amount of sequence numbers that are pre-allocated and stored in memory.

Column

Data Type

Description

INT32

The ID of the sequence.

NAME

STRING

The name of the sequence.

SCHEMA_ID

INT32

The id of the schema used by the sequence.

SCHEMA_NAME

STRING

The name of the schema used by the sequence.

DATA_TYPE

STRING

The sequence data type.

INCREMENT

INT64

How much the sequence is incremented by each time.

MINIMUM_VALUE

INT64

Minimum sequence value.

MAXIMUM_VALUE

INT64

Maximum sequence value.

START_VALUE

INT64

The starting value of the sequence.

CACHE_VALUE

INT64

The amount of sequence numbers that are pre-allocated and stored in memory.

SQL_QUERIES

Column	Data Type	Description
INITIATOR_NODE	STRING	The name of the node that initiated the query.
PHASE	STRING	The query phase: INITIALIZATION - query registration and parsing OPTIMIZATION - query validation and plan optimization EXECUTION - query plan execution
TYPE	STRING	The query type: DDL, DML, QUERY, or SCRIPT.
ID	STRING	The query ID.
PARENT_ID	STRING	ID of the script that initiated the query (NULL if the query was not initiated by a script).
SQL	STRING	The SQL query’s expression.
START_TIME	TIMESTAMP	The date/time the query started.
SCHEMA	STRING	The name of the default schema that was used to execute the query.
TRANSACTION_ID	STRING	The ID of the transaction in which the query was executed.

Column

Data Type

Description

INITIATOR_NODE

STRING

The name of the node that initiated the query.

PHASE

STRING

The query phase:

INITIALIZATION - query registration and parsing
OPTIMIZATION - query validation and plan optimization
EXECUTION - query plan execution

TYPE

STRING

The query type: DDL, DML, QUERY, or SCRIPT.

STRING

The query ID.

PARENT_ID

STRING

ID of the script that initiated the query (NULL if the query was not initiated by a script).

SQL

STRING

The SQL query’s expression.

START_TIME

TIMESTAMP

The date/time the query started.

SCHEMA

STRING

The name of the default schema that was used to execute the query.

TRANSACTION_ID

STRING

The ID of the transaction in which the query was executed.

SYSTEM_VIEWS

Describes available system views.

Column Data Type Description

Column	Data Type	Description
ID	INT32	System view ID.
SCHEMA	STRING	Name of the schema used. Default is `SYSTEM`.
NAME	STRING	System view name.
TYPE	STRING	System view type. Possible values: NODE - The view provides node-specific information. Data will be collected from all nodes, and represented in the view. CLUSTER - The view provides cluster-wide information. Data will be collected from one node, chosen to represent the cluster.

INT32

System view ID.

SCHEMA

STRING

Name of the schema used. Default is SYSTEM.

NAME

STRING

System view name.

TYPE

STRING

System view type. Possible values:

NODE - The view provides node-specific information. Data will be collected from all nodes, and represented in the view.
CLUSTER - The view provides cluster-wide information. Data will be collected from one node, chosen to represent the cluster.

SYSTEM_VIEW_COLUMNS

Describes available system view columns.

Column	Data Type	Description
VIEW_ID	INT32	System view ID.
NAME	STRING	Column name.
TYPE	STRING	Column type. Can by any of the supported types.
NULLABLE	BOOLEAN	Defines if the column can be empty.
PRECISION	INT32	Maximum number of digits.
SCALE	INT32	Maximum number of decimal places.
LENGTH	INT32	Maximum length of the value. Symbols for string values or bytes for binary values.

Column

Data Type

Description

VIEW_ID

INT32

System view ID.

NAME

STRING

Column name.

TYPE

STRING

Column type. Can by any of the supported types.

NULLABLE

BOOLEAN

Defines if the column can be empty.

PRECISION

INT32

Maximum number of digits.

SCALE

INT32

Maximum number of decimal places.

LENGTH

INT32

Maximum length of the value. Symbols for string values or bytes for binary values.

TRANSACTIONS

Column	Data Type	Description
COORDINATOR_NODE	STRING	The name of the transaction’s coordinator node.
STATE	STRING	The transaction state. For read-only transactions, the value is always null (empty). For read-write transactions, the possible values are PENDING - the transaction is in progress - and FINISHING - the transaction is in the process of being finished.
ID	STRING	The transaction ID.
START_TIME	TIMESTAMP	The transaction’s start time.
TYPE	STRING	The transaction type: READ_ONLY or READ_WRITE.
PRIORITY	STRING	The transaction priority, which is used to resolve conflicts between transactions. Currently, this value cannot be explicitly set by the user. Possible values are LOW and NORMAL (default).

Column

Data Type

Description

COORDINATOR_NODE

STRING

The name of the transaction’s coordinator node.

STATE

STRING

The transaction state. For read-only transactions, the value is always null (empty). For read-write transactions, the possible values are PENDING - the transaction is in progress - and FINISHING - the transaction is in the process of being finished.

STRING

The transaction ID.

START_TIME

TIMESTAMP

The transaction’s start time.

TYPE

STRING

The transaction type: READ_ONLY or READ_WRITE.

PRIORITY

STRING

The transaction priority, which is used to resolve conflicts between transactions. Currently, this value cannot be explicitly set by the user. Possible values are LOW and NORMAL (default).

ZONES

Column	Data Type	Description
NAME	STRING	The name of the distribution zone.
PARTITIONS	INT32	The number of partitions in the distribution zone.
REPLICAS	STRING	The number of copies of each partition in the distribution zone.
DATA_NODES_AUTO_ADJUST_SCALE_UP	INT32	The delay in seconds between the new node joining and the start of data zone adjustment.
DATA_NODES_AUTO_ADJUST_SCALE_DOWN	INT32	The delay in seconds between the node leaving the cluster and the start of data zone adjustment.
DATA_NODES_FILTER	STRING	The filter that specifies what nodes will be used by the distribution zone.
IS_DEFAULT_ZONE	BOOLEAN	Defines if the data zone is used by default.

Column

Data Type

Description

NAME

STRING

The name of the distribution zone.

PARTITIONS

INT32

The number of partitions in the distribution zone.

REPLICAS

STRING

The number of copies of each partition in the distribution zone.

DATA_NODES_AUTO_ADJUST_SCALE_UP

INT32

The delay in seconds between the new node joining and the start of data zone adjustment.

DATA_NODES_AUTO_ADJUST_SCALE_DOWN

INT32

The delay in seconds between the node leaving the cluster and the start of data zone adjustment.

DATA_NODES_FILTER

STRING

The filter that specifies what nodes will be used by the distribution zone.

IS_DEFAULT_ZONE

BOOLEAN

Defines if the data zone is used by default.

© 2024 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.

Last updated on Dec 02, 2024