title: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed)
body: <p>Below is my script</p>
  
  <pre><code>CREATE TABLE alrashed.tbl_alerts_details (
      alert_id int,
      action_required int,
      alert_agent_id int,
      alert_agent_type_id int,
      alert_agent_type_name text,
      alert_definer_desc text,
      alert_definer_name text,
      alert_source text,
      alert_state text,
      col_1 text,
      col_2 text,
      col_3 text,
      col_4 text,
      col_5 text,
      current_escalation_level text,
      date_part date,
      device_id text,
      driver map&lt;text, text&gt;,
      is_processed int,
      is_real_time int,
      location map&lt;text, text&gt;,
      seq_no int,
      severity text,
      time_stamp timestamp,
      transporter map&lt;text, text&gt;,
      transporter_name text,
      trip_id int,
      updated_on timestamp,
      vehicle map&lt;text, text&gt;,
      vehicle_type_name text,
      PRIMARY KEY (alert_id)
      ) WITH read_repair_chance = 0.0
      AND dclocal_read_repair_chance = 0.1
      AND gc_grace_seconds = 864000
      AND bloom_filter_fp_chance = 0.01
      AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }
      AND comment = ''
      AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold' : 32, 'min_threshold' : 4 }
      AND compression = { 'chunk_length_in_kb' : 64, 'class' : 'org.apache.cassandra.io.compress.LZ4Compressor' }
      AND default_time_to_live = 0
      AND speculative_retry = '99PERCENTILE'
      AND min_index_interval = 128
      AND max_index_interval = 2048
      AND crc_check_chance = 1.0;  
  </code></pre>
  
  <p>when I'm running this query I'm getting </p>
  
  <blockquote>
    <p>Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed) error</p>
  </blockquote>
  
  <p>Here is my cassandra query in Java:</p>
  
  <pre><code>select
    count( * )
  from
    tbl_alerts_details
  where
    alert_state = 'ACKNOWLEDGE'
    and date_part &gt;= '2017-10-01'
    and date_part &lt;= '2017-10-31'
    and is_real_time = 1
    and alert_agent_type_name = 'VEHICLE' ALLOW FILTERING
  </code></pre>