[
https://issues.apache.org/jira/browse/IGNITE-9355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov updated IGNITE-9355:
------------------------------------
Description:
We need to document three new SQL system views.
# Explain users that new system SQL schema appeared, named "IGNITE", where all
views are stored
# System view NODES - list of current nodes in topology. Columns: ID,
CONSISTENT_ID, VERSION, IS_LOCAL, IS_CLIENT, IS_DAEMON, NODE_ORDER, ADDRESSES,
HOSTNAMES
# System view NODE_ATTRIBUTES - attributes for all nodes. Columns: NODE_ID,
NAME, VALUE
# System view BASELINE_NODES - list of baseline topology nodes. Columns:
CONSISTENT_ID, ONLINE (whether node is up and running at the moment)
# System view NODE_METRICS - node metrics. Columns - see
\{{org.apache.ignite.internal.processors.query.h2.sys.view.SqlSystemViewNodeMetrics}}
class
# Explain limitations: views cannot be joined with user tables; it is not
allowed to create other objects (tables, indexes) in "IGNITE" schema.
was:
We need to document three new SQL system views.
# Explain users that new system SQL schema appeared, named "IGNITE", where all
views are stored
# System view NODES - list of current nodes in topology. Columns: ID,
CONSISTENT_ID, VERSION, IS_LOCAL, IS_CLIENT, IS_DAEMON, NODE_ORDER, ADDRESSES,
HOSTNAMES
# System view NODE_ATTRIBUTES - attributes for all nodes. Columns: NODE_ID,
NAME, VALUE
# System view BASELINE_NODES - list of baseline topology nodes. Columns:
CONSISTENT_ID, ONLINE (whether node is up and running at the moment)
# Explain limitations: views cannot be joined with user tables; it is not
allowed to create other objects (tables, indexes) in "IGNITE" schema.
> Document new system views (nodes, node attributes, baseline nodes, node
> metrics)
> --------------------------------------------------------------------------------
>
> Key: IGNITE-9355
> URL: https://issues.apache.org/jira/browse/IGNITE-9355
> Project: Ignite
> Issue Type: Task
> Components: documentation, sql
> Reporter: Vladimir Ozerov
> Priority: Major
> Fix For: 2.7
>
>
> We need to document three new SQL system views.
> # Explain users that new system SQL schema appeared, named "IGNITE", where
> all views are stored
> # System view NODES - list of current nodes in topology. Columns: ID,
> CONSISTENT_ID, VERSION, IS_LOCAL, IS_CLIENT, IS_DAEMON, NODE_ORDER,
> ADDRESSES, HOSTNAMES
> # System view NODE_ATTRIBUTES - attributes for all nodes. Columns: NODE_ID,
> NAME, VALUE
> # System view BASELINE_NODES - list of baseline topology nodes. Columns:
> CONSISTENT_ID, ONLINE (whether node is up and running at the moment)
> # System view NODE_METRICS - node metrics. Columns - see
> \{{org.apache.ignite.internal.processors.query.h2.sys.view.SqlSystemViewNodeMetrics}}
> class
> # Explain limitations: views cannot be joined with user tables; it is not
> allowed to create other objects (tables, indexes) in "IGNITE" schema.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
