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
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