Creating a ClickHouse Database

Function Description

In the following example, the on cluster statement is used to create a database on all Server nodes in the cluster.

The database name is specified by the databaseName field in the clickhouse-example.properties file.

Sample Code

private void createDatabase(String databaseName, String clusterName) throws Exception  {
          String createDbSql = "create database if not exists " + databaseName + " on cluster " + clusterName;
          util.exeSql(createDbSql);
}