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

clickhouse的createTable语句报错 #4106

Closed
wangjxian opened this issue Dec 21, 2020 · 3 comments
Closed

clickhouse的createTable语句报错 #4106

wangjxian opened this issue Dec 21, 2020 · 3 comments
Milestone

Comments

@wangjxian
Copy link

可以支持clickhouse的建表语句吗。
看代码发现parseCreate的实现只有mysql的
这样一句clickhouse的建表语句。
create table topic_ch_list_2(timestamp UInt64,level String,message String) engine = MergeTree() ORDER BY timestamp SETTINGS index_granularity = 8192

Exception in thread "main" com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'String) engine = MergeTree() ORDER BY , pos 81, line 1, column 76, token IDENTIFIER engine

用的是最新的1.2.4

@wenshao
Copy link
Member

wenshao commented Dec 22, 2020

在什么场景使用,可以说下么?

@wenshao wenshao added this to the 1.2.5 milestone Dec 22, 2020
@wangjxian
Copy link
Author

在什么场景使用,可以说下么?

你好,我们公司有个产品。有点类似sql的可视化管理工具。需要在界面上输入sql。后台根据输入的sql的类型,做不同的策略。因此需要解析sql。但是目前的版本的parseCreate 不支持clickhouse的create 语句。

@wenshao
Copy link
Member

wenshao commented Feb 17, 2021

https://github.com/alibaba/druid/releases/tag/1.2.5
问题已修复,请用新版本

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

No branches or pull requests

2 participants