Cassandra Connector Demo
Info!
When running the demo a default keyspace(demo_keyspace) and a default table(demo_table(id-INT,name-TEXT,event-TEXT)) in this keyspace are created in order to be further used by some operations.
Create Keyspace
Keyspace
Replication Strategy class
Replication Factor
Create Table
Table Name
Keyspace
Columns
Required
ASCII
BIGINT
BLOB
BOOLEAN
COUNTER
DECIMAL
DOUBLE
FLOAT
INET
INT
TEXT
TIMESTAMP
UUID
VARCHAR
VARINT
TIMEUUID
SMALLINT
TINYINT
DATE
TIME
Partition key
True
False
Add column
Get tables from keyspace
Keyspace
Alter Table - Add new column
Keyspace Name
Table Name
Column Name
Column Type
Required
ASCII
BIGINT
BLOB
BOOLEAN
COUNTER
DECIMAL
DOUBLE
FLOAT
INET
INT
TEXT
TIMESTAMP
UUID
VARCHAR
VARINT
TIMEUUID
SMALLINT
TINYINT
DATE
TIME
Alter Table - Remove column
Keyspace Name
Table Name
Column Name
Alter Table - Rename column
Keyspace Name
Table Name
Old Column Name
New Column Name
Alter Table - Change column type
Keyspace Name
Table Name
Column Name
New Column Type
Required
ASCII
BIGINT
BLOB
BOOLEAN
COUNTER
DECIMAL
DOUBLE
FLOAT
INET
INT
TEXT
TIMESTAMP
UUID
VARCHAR
VARINT
TIMEUUID
SMALLINT
TINYINT
DATE
TIME
Insert into demo_table table
Id
Name
Event
Select all from demo_table table
Query that is being executed
Update into demo_table table
Columns
Name
Event
Where
Ids
Delete rows from demo_table table
Where
Ids
Delete columns from demo_table table
Columns
Name
Event
Where
Ids
Execute CQL query(Select from demo_table)
Query
Parameters
Drop Table
Table Name
Keyspace
Drop Keyspace
Keyspace