Top "Cql" questions

Cassandra order and clustering key

I have this table: CREATE TABLE custumer_events_service.events_by_websiteId_time( "event_id" text, "currentTime" timestamp, "websiteId" varchar, …

database cassandra cql cql3

Cassandra CQL Select count with LIMIT

I created a simple tabe: CREATE TABLE test ( "type" varchar, "value" varchar, PRIMARY KEY(type,value) ); I inserted 5 rows into …

cassandra cql datastax

Clustering Order using timeuuid CQL

My Usecase I want to order by timestamp DESC for the results. But I don't want timestamp to be the …

cassandra cql cql3

cassandra - only superuser is allowed to perform CREATE USER queries

I'm logging in with on Ubuntu 14.10 on Cassandra 2.0.8 with Java 1.7.0_60-b19 cqlsh -u cassandra -p cassandra I'm running: CREATE USER …

cassandra cql cqlsh

Comparing Cassandra's CQL vs Spark/Shark queries vs Hive/Hadoop (DSE version)

I would like to hear your thoughts and experiences on the usage of CQL and in-memory query engine Spark/Shark. …

cassandra hive cql apache-spark shark-sql

Cassandra selective copy

I want to copy selected rows from a columnfamily to a .csv file. The copy command is available just to …

cassandra cql cql3

Inserting arbitrary columns in Cassandra using CQL3

Prior to CQL3 one could insert arbitrary columns such as columns that are named by a date: cqlsh:test>…

cassandra cql cql3

Trying to login to cassandra's console (cqlsh) and it rejects me

I was trying to set up the user authentication for cassandra when I had the following problem. First I have …

cassandra cql cassandra-2.0 cqlsh

How can we convert com.datastax.driver.core.LocalDate to java.util.Date?

I am working with dates. Datastax's CQL cassandra API Row.getDate() returns a com.datastax.driver.core.LocalDate. I want …

java cassandra cql datastax cql3

CASSANDRA CQL3 : Set value to entire column

For my Cassandra Database, I need to set a value in column for all rows in my table. I see …

database cassandra cql cql3 cqlsh