clickhouse删除数据常见报错

原创

于 2021-06-30 16:07:24 发布 · 4k 阅读

CC 4.0 BY-SA版权

文章标签：

clickhouse 删除数据常见异常

truncate login_log_struct;

Syntax error: failed at position 10:

truncate login_log_struct;

Expected one of: DATABASE, TEMPORARY, TABLE

解决方案

drop table login_log_struct;

Code: 359. DB::Exception: Received from localhost:9000. DB::Exception: Table or Partition in 库.表 was not dropped.

drop table login_log_struct;

# 分区删除，不超过50GB, 表删除，不超过200GB
Received exception from server (version 19.15.3):
Code: 359. DB::Exception: Received from loc

200万优质内容无限畅学