title: Cassandra 3.11.4 CQL GROUP BY Not working
body: <p>I might be missing something very basic, or there is something very wrong;
  I am using <code>Apache Cassandra 3.11.4</code>. Version details are as follows:</p>
  
  <pre><code>Connected to Test Cluster at 127.0.0.1:9042.
  [cqlsh 5.0.1 | Cassandra 3.7.0 | CQL spec 3.4.2 | Native protocol v4]
  </code></pre>
  
  <p>I have the following table and I want to get the count of individual citizen-ship status. </p>
  
  <pre><code>CREATE TABLE population.residents (
  residentId bigint,
  name varchar,
  office varchar,
  dob date,
  citizen text,
  PRIMARY KEY((residentId), dob)
  );
  
  CREATE MATERIALIZED VIEW population.residents_citizen AS
      SELECT citizen, dob, residentid, name, office
      FROM population.residents
      WHERE citizen IS NOT NULL AND residentid IS NOT NULL AND dob IS NOT NULL
      PRIMARY KEY (citizen, dob, residentid);
  </code></pre>
  
  <p>The following error is obtained when I try to query:</p>
  
  <pre><code>cqlsh&gt; select citizen, count(residentId) from population.residents_citizen GROUP BY citizen;
  SyntaxException: line 1:68 missing EOF at 'GROUP' (...(residentId) from population.residents_citizen [GROUP] BY...)
  cqlsh&gt; select citizen, count(residentId) from population.residents_citizen_1 
  GROUP BY citizen, residentId;
  SyntaxException: line 1:70 missing EOF at 'GROUP' (...(residentId) from population.residents_citizen_1 [GROUP] BY...)
  cqlsh&gt; select citizen, count(residentId) from population.residents_citizen_1 GROUP BY residentId, citizen;
  SyntaxException: line 1:70 missing EOF at 'GROUP' (...(residentId) from population.residents_citizen_1 [GROUP] BY...)
  cqlsh&gt; select citizen, count(residentId) from population.residents_citizen_1 GROUP BY citizen, dob, residentId;
  SyntaxException: line 1:70 missing EOF at 'GROUP' (...(residentId) from population.residents_citizen_1 [GROUP] BY...)
  </code></pre>
  
  <p>My Data looks like as below:</p>
  
  <pre><code>cqlsh&gt; select * from population.residents;
  
   residentid | dob        | citizen | name              | office
  ------------+------------+---------+-------------------+----------------------------------------
        25966 | 2019-01-04 |       N |        Carl Sykes |              Leo Cras Vehicula Limited
       921412 | 2018-12-13 |       N |    Brady Harrison |          Nulla In Tincidunt Consulting
       521367 | 2019-11-18 |       Y |      Aaron Norton |      Pharetra Sed Hendrerit Associates
       843096 | 2020-02-03 |       N |      Preston Leon |                        A Felis Limited
       460162 | 2019-01-17 |       N |      Neville Good |                   Odio Aliquam Company
       187360 | 2018-12-09 |       Y |     Emery Pittman |                Arcu Ac Orci Foundation
  </code></pre>
  
  <p>Some advice is really appreciated!</p>