Cluster Explorer Guide

How to explore a Cluster through queries, schema and processes

Altinity.Cloud users have a range of options they can take on existing clusters. This page covers three important parts of the cluster explorer:

The query tool

The Query Tool page allows users to submit ClickHouse SQL queries directly to the cluster or a specific cluster node.

To use the Query Tool:

Select Explore from either the Clusters View or the Clusters Detail View.
Select Query from the top tab. This is the default view for the Explore page.
Select from the following:
1. Select which cluster to run a query against.
2. Select Run DDLs ON CLUSTER to run Distributed DDL Queries.
3. Select the following node options:
  1. Any: Any node selected from the Zookeeper parameters.
  2. All: Run the query against all nodes in the cluster.
  3. Node: Select a specific node to run the query against.
4. The Query History allows you to scroll through queries that have been executed.
5. Enter the query in the Query Textbox. For more information on ClickHouse SQL queries, see the SQL Reference page on ClickHouse.tech.
6. Select Execute to submit the query from the Query Textbox.
7. The results of the query will be displayed below the Execute button.

Additional tips and examples are listed on the Query page.

The Schema view allows you to view the databases, tables, and other details.

To access the Schema view:

Select Explore from either the Clusters View or the Clusters Detail View].
Select Schema from the top tab.
Select the following node options:
1. Any: Any node selected from the Zookeeper parameters.
2. All: Run the query against all nodes in the cluster.
3. Node: Select a specific node to run the query against.

To view details on a table, select the table name. The following details are displayed:

Table Description: Details on the table’s database, engine, and other details.
Table Schema: The CREATE TABLE command used to generate the table.
Sample Rows: A display of 5 selected rows from the table to give an example of the data contents.

The Processes view displays the currently running processes on a cluster or node.

To view the processes view:

Select Explore from either the Clusters View or the Clusters Detail Page.
Select Processes from the top tab.
Select the following node options:
1. Any: Any node selected from the Zookeeper parameters.
2. All: Run the query against all nodes in the cluster.
3. Node: Select a specific node to run the query against.

The following information is displayed: