## Start Cassandra CLI
./cassandra-cli -h 127.0.0.1
## Create, show and delete Cassandra keyspace
create keyspace store with replication_factor=1 and placement_strategy='org.apache.cassandra.locator.SimpleStrategy';
## Show Keyspaces
show keyspaces;
drop keyspace store;
use store;
## Create a Cassandra column family
create column family users with comparator = UTF8Type and
column_metadata = [{column_name: userName, validation_class:UTF8Type},
{column_name: email, validation_class:UTF8Type}];
create column family products with comparator = UTF8Type and
column_metadata = [{column_name: skid, validation_class:UTF8Type},
{column_name: inventory, validation_class:LongType}];
## Out of the box Cassandra column metadata type
## BytesType
## UTF8Type
## LexicalUUIDType
## TimeUUIDType
## AsciiType
## LongType
## Insert Cassandra Column
set users['Ercan CAN']['userName']='ercan';
set users['Ercan CAN']['email']='ercan@email.com';
## After ttl seconds, the column will be expired and ready to be deleted automatically
set users['Ercan CAN']['email']='ercan@email.com' with ttl=60;
## Retrieve Cassandra Columns
get users['Ercan CAN']['email'];
## => (column=email, value=ercan@email.com, timestamp=1304488164426000)
get users['Ercan CAN'];
## Define the column display type if it display the information as binary data
get users['Ercan CAN']['email'] as ascii;
## List All Cassandra Columns
list users;
## List columns limited to a max of 2
list users limit 2;
## Drop a Cassandra column family
drop column family users;
## Delete a row
del users['Ercan CAN'];
## Delete a column
del users['Ercan CAN']['email'];
######### Running a script for Cassandra CLI
./cassandra-cli -f conf/schema-sample.txt
#############################################schema-sample.txt#####################
create keyspace Keyspace1
with replication_factor = 1
and placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy';
use Keyspace1;
create column family Standard1
with comparator = BytesType
and keys_cached = 10000
and rows_cached = 1000
and row_cache_save_period = 0
and key_cache_save_period = 3600
and memtable_flush_after = 59
and memtable_throughput = 255
and memtable_operations = 0.29;
create column family Standard2
with comparator = UTF8Type
and read_repair_chance = 0.1
and keys_cached = 100
and gc_grace = 0
and min_compaction_threshold = 5
and max_compaction_threshold = 31;
create column family StandardByUUID1
with comparator = TimeUUIDType;
create column family Super1
with column_type = Super
and comparator = BytesType
and subcomparator = BytesType;
create column family Super2
with column_type = Super
and subcomparator = UTF8Type
and rows_cached = 10000
and keys_cached = 50
and comment = 'A column family with supercolumns, whose column and subcolumn names are UTF8 strings';
create column family Super3
with column_type = Super
and comparator = LongType
and comment = 'A column family with supercolumns, whose column names are Longs (8 bytes)'
;
create column family Indexed1
with comparator = UTF8Type
and default_validation_class = LongType
and column_metadata = [{
column_name : birthdate,
validation_class : LongType,
index_name : birthdate_idx,
index_type : 0}
];
#############################################schema-sample.txt finished#####################
Comments
Post a Comment