Gbase8a MPP使用sql方式查看节点信息

    在集群使用过程中会经常查看coordinator节点和node节点信息，可以通过gcadmin查看也可以通过sql方式查看，下面是通过sql的方式查询，具体如下：
1、查看coordinate节点信息：
gbase> show gcluster nodes;
+------------+--------------+--------------+--------+-----------+
| Id | ip | name | status | datastate |
+------------+--------------+--------------+--------+-----------+
| 1678379530 | 10.10.10.100 | coordinator1 | online | 0 |
| 1695156746 | 10.10.10.101 | coordinator2 | online | 0 |
| 1711933962 | 10.10.10.102 | coordinator3 | online | 0 |
+------------+--------------+--------------+--------+-----------+
3 rows in set (Elapsed: 00:00:00.00)
2、查看data节点信息：
gbase> show nodes;
+------------+--------------+-------+--------------+----------------+--------+-----------+
| Id | ip | name | primary part | duplicate part | status | datastate |
+------------+--------------+-------+--------------+----------------+--------+-----------+
| 1711933962 | 10.10.10.102 | node1 | n1 | n3 | online | 0 |
| 1678379530 | 10.10.10.100 | node2 | n2 | n1 | online | 0 |
| 1695156746 | 10.10.10.101 | node3 | n3 | n2 | online | 0 |
+------------+--------------+-------+--------------+----------------+--------+-----------+
3 rows in set (Elapsed: 00:00:00.00)