Re: How to find last inserted value using CQL3

2014-01-30 Thread DuyHai Doan
Hello Rahul 1) If your query pattern is to always request the last events, change your clustering order to "DESC": WITH CLUSTERING ORDER BY (*"eventTime"* DESC); 2) To get the last or N last events, use the LIMIT clause of CQL3: select* ... *ORDER BY* "eventTime"* DESC LIMIT 1; 3) I believ

How to find last inserted value using CQL3

2014-01-30 Thread Rahul Gupta
I am trying to find last value inserted in a Cassandra1.2 table using CQL3 but can't find a solution. There is WRITETIME() but that gives me time when that column was written. CREATE TABLE "dev"."eventTable" ( "eventName" text, "eventTime" timestamp, "rawEvent" text, PRIMARY KEY ("even