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 Page.
-
Select Query from the top tab. This is the default view for the Explore page.
-
Select from the following:
-
Select which cluster to run a query against.
-
Select Run DDLs ON CLUSTER to run Distributed DDL Queries.
-
Select the following node options:
- Any: Any node selected from the Zookeeper parameters.
- All: Run the query against all nodes in the cluster.
- Node: Select a specific node to run the query against.
-
The Query History allows you to scroll through queries that have been executed.
-
Enter the query in the Query Textbox. For more information on ClickHouse SQL queries, see the SQL Reference page on ClickHouse.tech.
-
Select Execute to submit the query from the Query Textbox.
-
The results of the query will be displayed below the Execute button.
-
Additional tips and examples are listed on the Query page.