title: Cassandra : Select records based on "timeuuid where conditions"
body: <p>I created one table in Cassandra and want to select data based on where condition of the column which has timeuuid type.</p>
  
  <pre><code>CREATE TABLE shahid.stock_ticks(
  symbol varchar,
  date int,
  trade timeuuid,
  trade_details text,
  PRIMARY KEY (  (symbol, date), trade   )
  ) WITH CLUSTERING ORDER BY (trade DESC) ;
  
  INSERT INTO shahid.stock_ticks (symbol, date, trade, trade_details) VALUES ('NFLX', 1, now(), 'this is 10' );
  INSERT INTO shahid.stock_ticks (symbol, date, trade, trade_details) VALUES ('NFLX', 1, now(), 'this is 2' );
  INSERT INTO shahid.stock_ticks (symbol, date, trade, trade_details) VALUES ('NFLX', 1, now(), 'this is 3' );
  </code></pre>
  
  <p>Above query has inserted records and one record has value '2045d660-9415-11e5-9742-c53da2f1a8ec' in trade column.</p>
  
  <p>I want to select like this but it is giving error </p>
  
  <pre><code>select * from shahid.stock_ticks  where symbol = 'NFLX' and date = 1 and trade &lt; '2045d660-9415-11e5-9742-c53da2f1a8ec';
  </code></pre>
  
  <p>It is giving below error</p>
  
  <p><code>InvalidQueryException: Invalid STRING constant (2045d660-9415-11e5-9742-c53da2f1a8ec) for "trade" of type timeuuid</code></p>
  
  <p>I tried below queries also with no luck</p>
  
  <pre><code>select * from shahid.stock_ticks  where symbol = 'NFLX' and date = 1 and trade &lt; maxTimeuuid('2045d660-9415-11e5-9742-c53da2f1a8ec');
  select * from shahid.stock_ticks  where symbol = 'NFLX' and date = 1 and trade &lt; dateOf('2045d660-9415-11e5-9742-c53da2f1a8ec');
  select * from shahid.stock_ticks  where symbol = 'NFLX' and date = 1 and trade &lt; unixTimestampOf('2045d660-9415-11e5-9742-c53da2f1a8ec');
  </code></pre>