You can use the timeuuid functions now() and dateof() (or in later versions of Cassandra, toTimestamp()), e.g., INSERT INTO TEST (ID, NAME, VALUE, LAST_MODIFIED_DATE) VALUES (‘2’, ‘elephant’, ‘SOME_VALUE’, dateof(now())); The now function takes no arguments and generates a new unique timeuuid (at the time where the statement using it is executed). The dateOf function takes … Read more
To remove all rows from a CQL Table, you can use the TRUNCATE command: TRUNCATE keyspace_name.table_name; Or if you are already using the keyspace that contains your target table: TRUNCATE table_name; Important to note, but by default Cassandra creates a snapshot of the table just prior to TRUNCATE. Be sure to clean up old snapshots, … Read more
There is a lot of confusion around this, I will try to make it as simple as possible. The primary key is a general concept to indicate one or more columns used to retrieve data from a Table. The primary key may be SIMPLE and even declared inline: create table stackoverflow_simple ( key text PRIMARY … Read more