[IGNITE-9355] Document new system views (nodes, node attributes, baseline nodes, node metrics)

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.7
• Component/s: documentation, sql
• Assignee: Artem Budnikov
• Reporter: Vladimir Ozerov
• Created: 23/Aug/18 08:22
• Updated: 23/Nov/18 10:48
• Resolved: 23/Nov/18 10:48

Description

We need to document three new SQL system views.

1. Explain users that new system SQL schema appeared, named "IGNITE", where all views are stored
2. System view NODES - list of current nodes in topology. Columns: ID, CONSISTENT_ID, VERSION, IS_LOCAL, IS_CLIENT, IS_DAEMON, NODE_ORDER, ADDRESSES, HOSTNAMES
3. System view NODE_ATTRIBUTES - attributes for all nodes. Columns: NODE_ID, NAME, VALUE
4. System view BASELINE_NODES - list of baseline topology nodes. Columns: CONSISTENT_ID, ONLINE (whether node is up and running at the moment)
5. System view NODE_METRICS - node metrics. Columns - see org.apache.ignite.internal.processors.query.h2.sys.view.SqlSystemViewNodeMetrics class
6. Explain limitations: views cannot be joined with user tables; it is not allowed to create other objects (tables, indexes) in "IGNITE" schema.

Issue Links

• relates to: IGNITE-7700 SQL system view for list of nodes
• relates to: IGNITE-7701 SQL system view for node attributes
• relates to: IGNITE-9318 SQL system view for list of baseline topology nodes
• relates to: IGNITE-9366 SQL system view for node metrics
• mentioned in: Page Loading...