ck数据库超50G表的删除方法-卸字段

## 获取表的所有字段放入del.txt
echo "desc db.test"|clickhouse-client -h 127.0.0.1|awk '{print $1}' > del.txt
## 逐一读取字段
for i in `cat del.txt`
do
    echo "ALTER table db.test drop column ${i}"|clickhouse-client -h 127.0.0.1
done