With the advent of CQL3 the terminology has changed slightly from the old thrift terms. Basically Create Table foo (a int , b int, c int, d int, PRIMARY KEY ((a,b),c)) Will make a CQL3 table. The information in a and b is used to make the partition key, this describes which node the information … Read more
The timeout is because Cassandra is taking longer than the timeout (default is 10 seconds) to return the data. For your query, Cassandra will attempt to fetch the entire dataset before returning. For more than a few records this can easily take longer than the timeout. For queries that are producing lots of data you … Read more
Answering my own question: Seeds From the FAQ: Seeds are used during startup to discover the cluster. Also from the DataStax documentation on “Gossip”: The seed node designation has no purpose other than bootstrapping the gossip process for new nodes joining the cluster. Seed nodes are not a single point of failure, nor do they … Read more
Wrong syntax. Here you are: insert into user_by_category (game_category,customer_id) VALUES (‘Goku’,’12’); or: insert into user_by_category (“game_category”,”customer_id”) VALUES (‘Kakarot’,’12’); The second one is normally used for case-sensitive column names.
EDIT The NoSQL Ecosystem by Adam Marcus (from the book The Architecture of open source applications): http://www.aosabook.org/en/nosql.html general thoughts and comparison http://www.thoughtworks.com/articles/nosql-comparison technical comparison http://kkovacs.eu/cassandra-vs-mongodb-vs-couchdb-vs-redis a Master’s Thesis – Analysis and Classification of NoSQL Databases http://scholar.googleusercontent.com/scholar?q=cache:rQlbiz6bojAJ:scholar.google.com/+comparison+of+nosql&hl=en&as_sdt=0,5&as_vis=1
To answer the original question you posed: a column family and a table are the same thing. The name “column family” was used in the older Thrift API. The name “table” is used in the newer CQL API. More info on the APIs can be found here: http://wiki.apache.org/cassandra/API If you need to use “group by,order … Read more
Spark is a distributed in memory processing engine. It does not need to be paired with Hadoop, but since Hadoop is one of the most popular big data processing tools, Spark is designed to work well in that environment. For example, Hadoop uses the HDFS (Hadoop Distributed File System) to store its data, so Spark … Read more
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 … Read more
You are likely getting this error because the Replication Factor of the keyspace the table you are querying belongs to has a Replication Factor of one, is that correct? If the partition you are reading / updating does not have enough available replicas (nodes with that data) to meet the consistency level, you will get … Read more