You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Artem Budnikov (JIRA)" <ji...@apache.org> on 2018/10/01 08:52:00 UTC
[jira] [Commented] (IGNITE-9355) Document new system views (nodes,
node attributes, baseline nodes, node metrics)
[ https://issues.apache.org/jira/browse/IGNITE-9355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16633727#comment-16633727 ]
Artem Budnikov commented on IGNITE-9355:
----------------------------------------
[~vozerov] I created a page about the IGNITE schema. Please review: https://apacheignite-sql.readme.io/v2.6/docs/system-views
> 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)