mysql 查詢 n,clickhouse怎么替換mysql?
ClickHouse支持mysql大多數語法,遷移成本低,可以使用建表同時導入數據來實現從MySQL遷移到ClickHouse: CREATE TABLE [IF NOT EXISTS] [db.]table_name ENGINE = Mergetree AS SELECT * FROM mysql('host:port', 'db', 'database', 'user', 'password')
ClickHouse支持mysql大多數語法,遷移成本低,可以使用建表同時導入數據來實現從MySQL遷移到ClickHouse: CREATE TABLE [IF NOT EXISTS] [db.]table_name ENGINE = Mergetree AS SELECT * FROM mysql('host:port', 'db', 'database', 'user', 'password')