clickhouse删除数据常见报错

clickhouse 删除数据常见异常

• Expected one of: DATABASE, TEMPORARY, TABLE

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