mysql表结构转clickhouse

原创

已于 2022-12-19 16:07:40 修改 · 483 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #clickhouse #java

于 2021-06-03 11:53:30 首次发布

    public static String changeMysqlTableToClickHouse(String createTable) {
        String tables = createTable;
        String[] rows = tables.split("\n");
        String replaceTables = "";
        int i = 0;
        String partition = "";
        String orderBy = "";
        for (String row : rows) {
            if (row.contains("KEY")) {
                continue;
            }
            if (row.contains("AUTO_INCREMENT,")) {
                continue;
            }
            if (row.contains(") ENGINE=InnoDB")) {
                row = ") ENGINE = MergeTree";
            }
            String changeRow = row.replaceAll("NOT NULL", "")
                    .replaceAll("AUTO_INCREMENT", "")
                    .replaceAll("CHARACTER SET utf8mb4", "")
                    .replaceAll("CHARACTER SET utf8", "")
                    .replaceAll("ON UPDATE CURRENT_TIMESTAMP", "")
                    .replaceAll("CURRENT_TIMESTAMP", "")
                    .r