title: ClickHouse - Inserting more than a hundred entries per query
body: <p>I do not figure out how to increase the max number of entries per query. I would like to insert a thousand entries per query, and the default value is 100.</p>
  
  <p>According to <a href="https://clickhouse.yandex/docs/en/changelog/#backward-incompatible-change" rel="nofollow noreferrer">the doc</a>, the parameter <code>max_partitions_per_insert_block</code> defines the limit of simultaneous entries.</p>
  
  <p>I've tried to modify it from the ClickHouse client, but my insertion still fails :</p>
  
  <pre><code>$ clickhouse-client
  my-virtual-machine :) set max_partitions_per_insert_block=1000
  
  *SET* max_partitions_per_insert_block = 1000
  
  Ok.
  
  0 rows in set. Elapsed: 0.001 sec. 
  </code></pre>
  
  <p>Moreover, this is no <code>max_partitions_per_insert_block</code> field in the <code>/etc/clickhouse-server/config.xml</code> file.</p>
  
  <p>After modifying <code>max_partitions_per_insert_block</code>, I've tried to insert my data, but I'm stuck with this error :</p>
  
  <pre><code>infi.clickhouse_orm.database.ServerError: Code: 252, e.displayText() = DB::Exception: Too many partitions for single INSERT block (more than 100). The limit is controlled by 'max_partitions_per_insert_block' setting. Large number of partitions is a common misconception. It will lead to severe negative performance impact, including slow server startup, slow INSERT queries and slow SELECT queries. Recommended total number of partitions for a table is under 1000..10000. Please note, that partitioning is not intended to speed up SELECT queries (ORDER BY key is sufficient to make range queries fast). Partitions are intended for data manipulation (DROP PARTITION, etc). (version 19.5.3.8 (official build))
  </code></pre>
  
  <p>EDIT: I'm still stuck with this. I cannot even manually set the parameter to the value I want with <code>SET max_partitions_per_insert_block = 1000</code>: the value is changed but goes back to 100 after exiting and reopening clickhouse-client (even with <code>sudo</code>, so it does not look like a permission problem).</p>