Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

请问如果mysql没有时间字段, 怎么办? #1

Open
xieren58 opened this issue Apr 11, 2019 · 3 comments
Open

请问如果mysql没有时间字段, 怎么办? #1

xieren58 opened this issue Apr 11, 2019 · 3 comments

Comments

@xieren58
Copy link

参数名 默认值 是否必填 参数描述
clickhouse.sink.date.columns 同步至 ClickHouse 的表的时间分区字段,个数应与 topic 一致
@ylltw01
Copy link
Contributor

ylltw01 commented Apr 11, 2019

这个字段是clickhouse的时间分区字段,clickhouse建表是必须有时间分区字段的。如下建表语句:CREATE TABLE realtime.login_info_local ( id Int64, name String, login_type Int8, partition_date Date) ENGINE = ReplacingMergeTree(partition_date, id, 8192)

@xieren58
Copy link
Author

clickhouse新版不用也能建表了

@ylltw01
Copy link
Contributor

ylltw01 commented Apr 12, 2019

clickhouse新版确实时间分区字段不是必须的,这可能需要做新版的兼容

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants