Clickhouse客户端语法错误kafka集成
关注此博客文章-https://altinity.com/blog/2020/5/21/clickhouse-kafka-engine-tutorial
ClickHouse 客户端版本 18.16.1,我在创建表时
CREATE TABLE readings (
readings_id Int32 Codec(DoubleDelta, LZ4),
time DateTime Codec(DoubleDelta, LZ4),
date ALIAS toDate(time),
temperature Decimal(5,2) Codec(T64, LZ4)
) Engine = MergeTree
PARTITION BY toYYYYMM(time)
ORDER BY (readings_id, time);
我正在使用此语法,并且我收到一条错误消息
“” 代码:62,e.displayText() = DB::Exception:语法错误:在位置 76 处失败(第 2 行,第 23 列):编解码器(DoubleDelta,LZ4), 时间日期时间编解码器(DoubleDelta,LZ4), 日期别名 toDate(时间), 温度 十进制(5,2) 编解码器(T64, LZ4) ) 引擎=合并Tr。需要以下之一:令牌、ClosingRoundBracket、逗号、DEFAULT、MATERIALIZED、ALIAS、COMMENT、e.what() = DB::Exception “”“
让我知道我做错了什么,谢谢。
ClickHouse client version 18.16.1 and I'm following this blog post-https://altinity.com/blog/2020/5/21/clickhouse-kafka-engine-tutorial
when creating a table I'm using this syntex
CREATE TABLE readings (
readings_id Int32 Codec(DoubleDelta, LZ4),
time DateTime Codec(DoubleDelta, LZ4),
date ALIAS toDate(time),
temperature Decimal(5,2) Codec(T64, LZ4)
) Engine = MergeTree
PARTITION BY toYYYYMM(time)
ORDER BY (readings_id, time);
and I'm getting an error that says
"""
Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 76 (line 2, col 23): Codec(DoubleDelta, LZ4),
time DateTime Codec(DoubleDelta, LZ4),
date ALIAS toDate(time),
temperature Decimal(5,2) Codec(T64, LZ4)
)
ENGINE = MergeTr. Expected one of: token, ClosingRoundBracket, Comma, DEFAULT, MATERIALIZED, ALIAS, COMMENT, e.what() = DB::Exception
"""
let me know what I'm doing wrong thanks.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论