Cassandra General Induction

Clear all the data in the table

Truncate Falcon_gps;

TRUNCATEAccepts a argument for the column family name, and permanently removes all data from said column family.

Query Cassandra a table an empty how many rows of records

Select COUNT (*) from Falcon_gps;

Bulk Import data

BEGIN BATCH USING Consistency QUORUM and TTL 8640000 INSERT into users (KEY, password, name) VALUES (' User2 ', ' [email prot Ected] ', ' second user ') UPDATE users SET password = ' Ps22dhds ' WHERE KEY = ' user2 ' INSERT into users (KEY, password) VALUE S (' User3 ', ' [email protected] ') DELETE name from the users WHERE key = ' User2 ' INSERT into users (key, password, name) VALUES (' User4 ', ' [email protected] ', ' Andrew ') APPLY BATCH;

Cassandra General Induction