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 删除 修改 格式 #13

Open
qiujunlin opened this issue Sep 10, 2021 · 0 comments
Open

clickhouse 删除 修改 格式 #13

qiujunlin opened this issue Sep 10, 2021 · 0 comments

Comments

@qiujunlin
Copy link
Owner

qiujunlin commented Sep 10, 2021

clickhosue 删除修改的 的格式为 ;

ALTER TABLE [db.]table UPDATE column1 = expr1 [, ...] WHERE filter_expr

ALTER TABLE [db.]table [ON CLUSTER cluster] DELETE WHERE filter_expr

原来的框架如果不修改,按照原来的方式进行解析,生成的是标准的以 UPDATE 或 DELETE 开头的语句,而clickhouse中支持的是以 ALTER TABLE 开头的语句 ,并且UPDATE没有 SET 这个关键字。

错误
同时clickhosue 的修改和删除 不支持 在最后使用 LIMIT 关键字 ,会报错 。

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

1 participant