Connecting to ClickHouse with ClickHouse Client
In this example we will be using the ClickHouse client maintained by the ClickHouse team.
First install the clickhouse-client using the command below:
|
1 |
curl https://clickhouse.com/ | sh |
After installing, connect to the cluster using the CLI command below. You can find the host domain name and the password for the icclickhouse user on the Connection Info page on the console:
|
1 |
./clickhouse client \ --host <host-of-a-node> \ --port 9440 \ --secure \ --user icclickhouse \ --password '<icclickhouse-user-password>' |
After connecting to the cluster, you could run queries using the CLI interface, for example:
|
1 |
SHOW CLUSTERS; |
By Instaclustr Support
Need Support?
Experiencing difficulties on the website or console?
Already have an account?
Need help with your cluster?
Contact Support
Why sign up?