Import and export schema in cassandra

database cassandra schema database-schema cqlsh
vpggopal picture vpggopal · May 8, 2013 · Viewed 47.7k times · Source

How to import and export schema from Cassandra or Cassandra cqlsh prompt?

Answer

Raman Yelianevich picture Raman Yelianevich · Mar 3, 2015

To export keyspace schema:

cqlsh -e "DESC KEYSPACE user" > user_schema.cql

To export entire database schema:

cqlsh -e "DESC SCHEMA" > db_schema.cql

To import schema open terminal at 'user_schema.cql' ('db_schema.cql') location (or you can specify the full path) and open cqlsh shell. Then use the following command to import keyspace schema:

source 'user_schema.cql'

To import full database schema:

source 'db_schema.cql'

Related questions

MongoDB vs. Cassandra

I am evaluating what might be the best migration option. Currently, I am on a sharded MySQL (horizontal partition), with most of my data stored in JSON blobs. I do not have any complex SQL queries (already migrated away after …

Read More
Difference between partition key, composite key and clustering key in Cassandra?

I have been reading articles around the net to understand the differences between the following key types. But it just seems hard for me to grasp. Examples will definitely help make understanding better. primary key, partition key, composite key clustering …

Read More
When NOT to use Cassandra?

There has been a lot of talk related to Cassandra lately. Twitter, Digg, Facebook, etc all use it. When does it make sense to: use Cassandra, not use Cassandra, and use a RDMS instead of Cassandra.

Read More