title: Clickhouse: is there any way to drop multi-partition in one `alter table drop partition ****` query?
body: <p>In clickhouse, the table is partitioned by day. Now I want to drop multi-partition in one <code>alter</code> query for convenience.</p>
  
  <p>I've done this by shell using while loop:</p>
  
  <pre><code>while [[ $startDate &lt; $endDate ]]
  do
      clickhouse-client --query="alter table db.table drop partition toYYYYMMDD(toDate($startDate))"
      startDate=`date -d "+1 day $startDate" +%Y-%m-%d`
  done
  </code></pre>
  
  <p>And I just want to find some way that can do this easily. Is there some way? Thanks~</p>