title: How to Config ScyllaDB for million rows: run simple query count(*) return error : timeout during read query at consistency
body: <p>I have table with simple table :</p>
  <pre class="lang-sql prettyprint-override"><code>create table if not exists keyspace_test.table_test
  (
      id          int,
      date          text,
      val float,
      primary key (id, date)
  )
      with caching = {'keys': 'ALL', 'rows_per_partition': 'ALL'}
       and compaction = {'class': 'SizeTieredCompactionStrategy'}
       and compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
       and dclocal_read_repair_chance = 0
       and speculative_retry = '99.0PERCENTILE'
       and read_repair_chance = 1;
  
  
  </code></pre>
  <p>After that i import 12 million rows. Than i want to run simple calculation count rows &amp; sum column val. With this query :</p>
  <pre><code>SELECT COUNT(*), SUM(val)
  FROM keyspace_test.table_test
  </code></pre>
  <p>but show error :</p>
  <pre><code>Cassandra timeout during read query at consistency ONE (1 responses were required but only 0 replica responded)
   
  </code></pre>
  <p>I am already add <code>USING TIMEOUT 180s;</code> but show error :</p>
  <pre><code> Timed out waiting for server response
  </code></pre>
  <p>Configuration server that i use are in 2 location datacenter.  Each datacenter has 4 server.</p>
  <pre class="lang-bash prettyprint-override"><code># docker exec -it scylla-120 nodetool status
  Datacenter: dc2
  ===============
  Status=Up/Down
  |/ State=Normal/Leaving/Joining/Moving
  --  Address          Load       Tokens       Owns    Host ID                               Rack
  UN  10.3.192.25  79.04 GB   256          ?       5975a143fec6  Rack1
  UN  10.3.192.24  74.2 GB    256          ?       61dc1cfd3e92  Rack1
  UN  10.3.192.22  88.21 GB   256          ?       0d24d52d6b0a  Rack1
  UN  10.3.192.23  63.41 GB   256          ?       962s266518ee  Rack1
  Datacenter: dc3
  ===============
  Status=Up/Down
  |/ State=Normal/Leaving/Joining/Moving
  --  Address          Load       Tokens       Owns    Host ID                               Rack
  UN  34.77.78.21    83.5 GB    256          ?       5112f248dd38  Rack1
  UN  34.77.78.20    59.87 GB   256          ?       e8db897ca33b  Rack1
  UN  34.77.78.48    81.32 GB   256          ?       cb88bd9326db  Rack1
  UN  34.77.78.47    79.8 GB    256          ?       562a721d4b77  Rack1
  
  Note: Non-system keyspaces don't have the same replication settings, effective ownership information is meaningless
  
  </code></pre>
  <p>And i create keyspace with :</p>
  <pre><code>CREATE KEYSPACE keyspace_test WITH replication = { 'class' : 'NetworkTopologyStrategy', 'dc2' : 3, 'dc3' : 3};
  </code></pre>
  <p>How realay config this scylla with million rows data ?</p>