[ https://issues.apache.org/jira/browse/IGNITE-9355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Prachi Garg reassigned IGNITE-9355: ----------------------------------- Assignee: Artem Budnikov (was: Prachi Garg) > 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 > Assignee: Artem Budnikov > 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)