Stack Overflow
Stack Overflow

Questions tagged [cql3]

Cassandra Query Language (CQL) is a SQL (Structured Query Language)-like language for querying Cassandra.

Cassandra Query Language (CQL) is a SQL (Structured Query Language)-like language for querying Cassandra.

Although CQL has many similarities to SQL, there are some fundamental differences.

For example, the CQL adaptation to the Cassandra data model and architecture, doesn't support operations, such as JOINs, which make no sense in a non-relational database.

657 questions
0
votes
3 answers

Examples for output_query with PIG and Cassandra CqlStorage

I am trying to write data to Cassandra CQL 3 Table using: STORE G INTO 'cql://keyapse/col_family?output_query=not sure what goes here' USING CqlStorage(); What does the output_query look like: UPDATE col_family SET col1=$0, col2=$3 WHERE KEY=$2
e90jimmy
  • 272
  • 1
  • 2
  • 11
0
votes
2 answers

Insertion and retrieval of timestamp into Cassandra CQL3 based table in Python

I have the following table created using CQL3 in Cassandra: CREATE TABLE user_log ( user_id text, zone_id text, freq int, time timestamp, PRIMARY KEY (user_id, zone_id) ) I insert some values into…
Sayed Jalil Hassan
  • 2,535
  • 7
  • 30
  • 42
0
votes
2 answers

Is it possible to update one value and delete another one by a single Cassandra CQL query?

Given a table: CREATE TABLE t ( k text, v1 int, v2 int, PRIMARY KEY (k) ) Is it possible to set v1 to some value and delete (set to null) v2 with a single query? Something like: UPDATE t SET v1=100, v2=NULL WHERE k='somekey'; I…
Wildfire
  • 6,358
  • 2
  • 34
  • 50
0
votes
1 answer

Error in Cassandra system.log: java.io.IOException: Permission denied

I am getting the following exception on a completely blank cluster on all nodes. There is absolutely nothing in there. There is no reason that I could gather. INFO [FlushWriter:5] 2013-07-18 03:20:05,250 Memtable.java (line 495) Completed flushing…
user2579873
  • 1
  • 1
0
votes
2 answers

Cassandra: How to model column family to perform intersect-like queries

Basically I have three attributes: partId, measurementDef and value. Each part (partId) consists of multiple measures (value) of a certain type (measurementDef). Formatted as a tree it would look something like this: -part 1 |- measurementDef 1 ->…
Thomas Fischer
  • 126
  • 1
  • 6
0
votes
1 answer

Cassandra CQL3 Composite keys return duplicate values

I am new to CQL & composite keys (I previously used CLI) I am looking to implement my old super-column-family with composite keys instead. In short, my look-up model is: blocks[file_id][position][block_id]=size I have the folowing CQL table with…
eshalev
  • 3,033
  • 4
  • 34
  • 48
0
votes
2 answers

"Cannot create index on PRIMARY KEY part" error in Apache Cassandra with CQL3

I am following "CQL3 for Cassandra experts" (http://www.datastax.com/dev/blog/cql3-for-cassandra-experts#comment-259613) article. Executing CREATE TABLE playlists ( id uuid, title text, album text, artist text, song_id uuid, PRIMARY KEY…
Leon
  • 41
  • 4
0
votes
2 answers

Cassandra Schema

I've currently designed a schema in Cassandra but I'm wondering if there's a better way to do things. Basically, the issue is that most, if not all of the reads are dynamic. I've constructed a segmentation system as an application service that reads…
Daniel
  • 1,692
  • 2
  • 13
  • 19
0
votes
1 answer

Tracing error "object is not iterable"

Cassandra writes to a table are slow(the write latency was 38ms per insertion). I was trying to find out why by turning tracing on. However I get this error, which I don't understand. Note that the inserts themselves do succeed. I am using cassandra…
Ravi
  • 661
  • 6
  • 17
0
votes
1 answer

CREATE TABLE failing (wrong CQL version)

Creating tables failing with inet, multiple primary keys, and collections. Syntax was correct. Error messages don't make sense with the primary key (unmatched parens). remove that, I learned that inet won't work except in some cases. Anything I'm…
Jonathan Hendler
  • 1,239
  • 1
  • 17
  • 23
0
votes
0 answers

CQL3 Query is returning a row with null key

I'm very new to Cassandra and trying out Astyanax/CQL3 for some simple use cases. I am attempting to retrieve data from a simple table using Astyanax and CQL3 on Cassandra version 1.2 from a Groovy application. I have the following column family…
dotariel
  • 1,584
  • 12
  • 23
0
votes
1 answer

Using Hector with CQL3 in java

I'm running Cassandra 1.2.0 (CQL3) and I'm using Hector 1.0.5. Here's my table definition: CREATE TABLE group_profiles ( profile_id text, time timeuuid, document text, PRMARY KEY (profile_id, time) ) WITH COMPACT STORAGE; I can't…
Mark J Miller
  • 4,751
  • 5
  • 44
  • 74
0
votes
2 answers

Collection of embedded objects using Cassandra CQL

I am trying to put my domain model into Cassandra using CQL. Let's say I have USER_FAVOURITES table. Each favourites has ID as a PRIMARY KEY. I want to store the list of up to 10 records of multiple fields, field_name, field_location and so on in…
i.petruk
  • 1,276
  • 1
  • 13
  • 18
0
votes
1 answer

How CQL3 differs from CQL2 and Thrift?

"Compact storage stores an entire row in a single column on disk instead of storing each non-primary key column in a column that corresponds to one column on disk. Using compact storage prevents you from adding new columns that are not part of the…
Salamander
  • 33
  • 3
0
votes
1 answer

Upsert/Read into/from Cassandra database using Datastax API (using new Binary protocol)

I have started working with Cassandra database. I am planning to use Datastax API to upsert/read into/from Cassandra database. I am totally new to this Datastax API (which uses new Binary protocol) and I am not able to find lot of documentations as…
arsenal
  • 23,366
  • 85
  • 225
  • 331
1 2 3
…
43
44