clickhouse建表语句

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Demo {
	public static void main(String[] args) {
		Connection connection = null;
		try {
			Class.forName("com.github.housepower.jdbc.ClickHouseDriver");
			connection = DriverManager.getConnection("jdbc:clickhouse://localhost:9000");

			System.out.println("连接成功");
			Statement statement = connection.createStatement();
			ResultSet executeQuery = statement.executeQuery("create table info(id String,name String, phone String, location String) Engine=ReplacingMergeTree primary key id order by id");		

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}


	}

}