clickhouse无法建mergetree表，centos环境，50元赏金

Question

clickhouse-client --port 9000 -u default --password default --multiline -n
进入客户端后，无法建表，语句如下：
CREATE TABLE xxx (
xxx String,
ip String,
created_at Date,
updated_at Date
) ENGINE=MergeTree()
order by created_at
PARTITION BY toYYYYMMDD(created_at);
一直报Expected end of query错误，错误字符定位在order的o上，似乎ENGINE之后不允许再跟变量了。
1.求解决建表问题。centos。
2.clickhouse的删除、更新问题。

Answer 1

sql

CREATE TABLE If Not Exists user (`ip` String,
`created_at` Date,
`updated_at` Date) ENGINE = MergeTree() PARTITION BY toYYYYMMDD(created_at)
ORDER BY
(created_at) SETTINGS index_granularity = 8192;

执行结果