clickhouse 批量删除表

#!/bin/bash

re='test_table%'
sql="SELECT name FROM system.tables where name like '$re'"
tables=`clickhouse client --port 9000 -q "$sql"`

for t in $tables
do
   sql="drop table if exists default.$t"
   echo $sql
   clickhouse client --port 9000 -q "$sql"
done