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
1 answer

will composite partition & compound key affect perfomance in cassandra?

Given below, CQL for 3 tables. Both have same column structure, But difference in setting the PRIMARY KEY. tab1: NO compound primary key CREATE TABLE tab1 ( key1 text, key2 text, key3 text, key4 text, data1 text, data2 text, data3 int, PRIMARY…
kjk
  • 116
  • 1
  • 11
0
votes
1 answer

How to optimize Cassandra model while still supporting querying by contents of lists

I just switched from Oracle to using Cassandra 2.0 with Datastax driver and I'm having difficulty structuring my model for this big data approach. I have a Persons table with UUID and serialized Persons. These Persons have lists of addresses, names,…
jwalk
  • 31
  • 4
0
votes
1 answer

Cassandra long row with different data types

I have read the following article about Cassandra CQL3 and Thrift API http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows In the article, they give an example on creating a scheme for gathering data from sensors. They show a…
Guy Wald
  • 599
  • 1
  • 10
  • 25
0
votes
1 answer

DataStax Devcenter CQL3 version vs Cassandra vrs

Within DevCenter, I'm getting an error: [feature] is introduced in CQL 3.1.0, you're running CQL 3.0.5. This doesn't make sense as I'm using the absolute latest version of Cassandra (2.0.6); connecting through cqlsh shows it's using 3.1.1:…
guice
  • 976
  • 4
  • 11
  • 31
0
votes
1 answer

Storing CQL3 Map from Pig with CqlStorage

I have created a Table in Cassandra with CQL3 and I want to store some Data from Pig into it. I created the Table with CREATE TABLE test (firstname VARCHAR, surname VARCHAR, averagekm DOUBLE, firstyear INT, lastyear INT,…
stemeda
  • 11
  • 2
0
votes
1 answer

Cassandra - Import from CSV and create new table?

I am attempting to copy a csv file in a Cassandra table using so in cqlsh, something like: COPY mytable FROM 'test.csv' WITH header=TRUE; problem is that in practice, my CSV file has more than a hundred columns. Is it necessary to define each…
alexizydorczyk
  • 850
  • 1
  • 6
  • 25
0
votes
0 answers

CQL3:How does one avoid string being translated to ASCII?

I store my message and message id in cassandra database.I use https://github.com/matehat/cqerl client to work with ejabberd server for storing messages in cassandra database.I fetch records from cassandra database by select query using cqerl…
BABU K
  • 917
  • 13
  • 35
0
votes
1 answer

Alter table with COMPACT STORAGE

I had issues with reading a table from pycassa created with CQL3. So followed this post Reading Cassandra 1.2 table with pycassa Now trying to alter my table ALTER TABLE tweets with COMPACT STORAGE ; But getting an error. Bad Request: line 1:32…
M T
  • 4,099
  • 4
  • 21
  • 27
0
votes
1 answer

phpcassa: cassandra\NotFoundException when instantiating ColumnFamily class

I'm trying to query a Cassandra 2.0.2 server using the phpcassa libraray. I do the following:
Pankas
  • 127
  • 2
  • 12
0
votes
0 answers

Cassandra - Datamodel

i'm new to Cassandra and i'm not certain how to model my data. Lets assume the object i want to store look like this: C_ID, VALUE, TIMESTAMP, D_TYPE, E_ID Currently i'm storing the data in a RDBMS with C_ID and Timestamp as Primary Key. I'm aware…
Matthias
  • 164
  • 1
  • 7
0
votes
1 answer

Cassandra: can you add dynamic columns within existing column clustering?

I'm using Cassandra 1.2.12 with CQL 3, and am having trouble modeling my column family. I currently store snapshots of customer data at particular times. Works great: CREATE TABLE data ( cust_id varchar, time timeuuid, data_text text, …
Ben Kirby
  • 904
  • 2
  • 11
  • 29
0
votes
1 answer

Tracking and throttling failed sign in attempts in cassandra

Our existing application has some basic mechanisims to prevent abuses such as repeated password guessing, sending spam, and so on, using a MySQL table. Im looking at if it is practical to implment this in cassandra, but I am not yet familiar enough…
Jay
  • 19,649
  • 38
  • 121
  • 184
0
votes
0 answers

Need multiple Index in cassandra

We are migrating from oracle to cassandra. We have a requirement to do minimal changes to the application. Three questions came up when i am doing POC on cassandra. In a Oracle we have created multiple composite indexes but i don't find any…
suresh
  • 341
  • 2
  • 3
  • 13
0
votes
1 answer

I need some advice for my Cassandra model (time-series)

I'm a working on an API with nodejs and Cassandra (helenus module), and I have a cassandra model like the following one: CREATE TABLE IF NOT EXISTS events ( hour TIMESTAMP, type int, id timeuuid, created_at TIMESTAMP, invoice int, data…
mcKain
  • 437
  • 5
  • 16
0
votes
1 answer

Cassandra CQL: How to do WHERE-like queries on dynamic columns?

Consider the following simple table in Cassandra, with some values inserted via CQL3: CREATE TABLE sometable ( id varchar, name varchar, value varchar, PRIMARY KEY (id, name)); INSERT INTO sometable (id, name, value) VALUES ('Mary',…
Kevin D.
  • 911
  • 1
  • 6
  • 18
1 2 3
…
43 44