# 创建ClickHouse表
本章节介绍创建ClickHouse表样例代码。
通过on cluster语句在集群中创建[表1](https://support.huaweicloud.com/devg-lts-mrs/mrs_07_460007.html#mrs_07_460007__t1f1e4f1665bc49c69b5fcd7be4284233)中tableName参数值为表名的ReplicatedMerge表和Distributed表。
示例代片段参考如下：
```
private void createTable(String databaseName, String tableName, String clusterName) throws Exception { 
   String createSql = "create table " + databaseName + "." + tableName + " on cluster " + clusterName  + " (name String, age UInt8, date Date)engine=ReplicatedMergeTree('/clickhouse/tables/{shard}/" + databaseName + "." + tableName + "'," + "'{replica}') partition by toYYYYMM(date) order by age"; 
   String createDisSql = "create table " + databaseName + "." + tableName + "_all" + " on cluster " + clusterName + " as " + databaseName + "." + tableName + " ENGINE = Distributed(default_cluster," + databaseName + "," + tableName + ", rand());";    ArrayList<String> sqlList = new ArrayList<String>();   
   sqlList.add(createSql);   
   sqlList.add(createDisSql);  
   util.exeSql(sqlList);
}
```