title: Error creating table in cassandra - Bad Request: Only clustering key columns can be defined in CLUSTERING ORDER directiv
body: <p>I get the above error when I try to use following cql statement, not sure whats wrong with it.</p>
  
  <pre><code>CREATE TABLE Stocks(
    id uuid,
    market text,
    symbol text,
    value text,
    time timestamp,
    PRIMARY KEY(id)
  ) WITH CLUSTERING ORDER BY (time DESC);
  Bad Request: Only clustering key columns can be defined in CLUSTERING ORDER directive
  </code></pre>
  
  <p>But this works fine, can't I use some column which is not part of primary key to arrange my rows ?</p>
  
  <pre><code>CREATE TABLE timeseries (
           ...   event_type text,
           ...   insertion_time timestamp,
           ...   event blob,
           ...   PRIMARY KEY (event_type, insertion_time)
           ... )
           ... WITH CLUSTERING ORDER BY (insertion_time DESC);
  </code></pre>