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