Create cassandra table Archives - Hadoop Online Tutorials

Cassandra query language (CQL) and Cassandra Java Client Example

This entry was posted in Cassandra and tagged Cassandra java client Cassandra JDBC Cassandra Pooling options Copy table content from table to csv file in cassandra CQL Commands Create cassandra table Create index for column in cassandra Delete data in cassandra table Describe cassandra table get size of table in cassandra Insert data into cassandra table keyspace Limitations in CQL list of key spaces list of tables in a keyspaces Update data into cassandra table on January 28, 2016 by ravi

Cassandra Table structure/Terminology Before going to learn CQL commands, we just need to know terminology in cassandra. RDBMS Cassandra Terminology Database Keyspace Table Column Family Primary key Row Key Column name Column name Column value column value CQL Commands Creating a key-space


CREATE keyspace demodb WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'datacenter1' : 3 };

CREATE keyspace simpledb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 };

CREATE keyspace demodb WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'datacenter1' : 3 };

CREATE keyspace simpledb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 };

Use the keyspace (will use that key space)


USE demodb;

1 2	USE demodb;

Note: key spaces are equivalent to database/schema in RDBMS Get list of key spaces


DESCRIBE keyspaces;

1 2	DESCRIBE keyspaces;

Create table


CREATE TABLE users (user_name varchar, password varchar, gender varchar, session_token varchar, state varchar, birth_year bigint, PRIMARY KEY (user_name));

1 2	CREATE TABLE users (user_name varchar, password varchar, gender varchar, session_token varchar, state varchar, birth_year bigint, PRIMARY KEY (user_name));

Get list […]