cql3 Questions
1
Solved
I have a table that has a column of list type (tags):
CREATE TABLE "Videos" (
video_id UUID,
title VARCHAR,
tags LIST<VARCHAR>,
PRIMARY KEY (video_id, upload_timestamp)
) WITH CLUSTERING...
2
Solved
What is the canonical way to model many-to-many relations with CQL3 ?
Let's say I have to tables
CREATE TABLE actor (
id text PRIMARY KEY,
given text,
surname text,
)
CREATE TABLE fan (
id te...
Arrowy asked 26/10, 2014 at 13:0
1
Cassandra CQL: Table created with composite key and cluster key. When I try to execute select * from partition key then I able to retrieve all data and it works for relational operator ( < or > ...
Davedaveda asked 7/10, 2014 at 14:5
1
Solved
I want to verify that rows are getting added to the table. What cql statement would show the last n rows from the table below?
Table description below:
cqlsh:timeseries> describe table option...
1
Solved
I need to insert a new column into an existing column family via a CQL script.
I want to do something like:
alter COLUMNFAMILY rules ADD rule_template text IF NOT EXISTS;
How can I achieve this...
Plainsong asked 8/9, 2014 at 16:32
2
Solved
I want to use Cassandra in a .Net application. My objective is to store some data in a column family, but each row of data will have varying schema.
Example (A very simple one) I want to have a 'T...
2
Solved
CREATE TABLE users (
userID uuid,
firstname text,
lastname text,
state text,
zip int,
age int,
PRIMARY KEY (userID)
);
I want to construct the following queries:
select * from users where ...
Aam asked 26/7, 2014 at 7:47
1
Solved
I have installed cassandra 2.0 successfully. When I try to start cql 3 I get no such option:
cassandra -v
2.0.9
./cqlsh -3
Usage: cqlsh [options] [host [port]]
cqlsh: error: no such option: -3
Bremsstrahlung asked 25/7, 2014 at 21:20
3
Solved
consider this example:
create table bite (
id varchar PRIMARY KEY,
feedid varchar,
score bigint,
data varchar
);
create index bite_feedid on bite (feedid);
create index bite_score on bite (s...
Pe asked 25/7, 2014 at 22:27
2
I use python script, that passes to cassandra batch query, like this:
query = 'BEGIN BATCH ' + 'insert into ... ; insert into ... ; insert into ...; ' + ' APPLY BATCH;'
session.execute(query)
...
1
Solved
I have been reading this section of the Cassandra docs and found the following a little puzzling:
Determine column overhead:
regular_total_column_size = column_name_size + column_value_size + 15
c...
Pavis asked 30/5, 2014 at 15:44
1
1
Solved
I'm trying to get a Double value from a Cassandra table with a double type column. I've created the table in CQL3 syntax:
CREATE TABLE data_double (
datetime timestamp,
value double,
primary ke...
Rhoden asked 9/5, 2014 at 20:39
1
Solved
So, my original problem was using the token() function to page through a large data set in Cassandra 1.2.9, as explained and answered here: Paging large resultsets in Cassandra with CQL3 with varch...
1
Solved
I’m working on updating an old thrift-based code to CQL3.
One part of the code is walking through the entire dataset of a table consisting of 20M+ rows. This part was initially crashing the progr...
1
Lets assume I have a Column Family with following schema:
CREATE TABLE users (
user_id timeuuid,
name varchar,
last_name varchar,
children list,
phone_numbers map,
PRIMARY KEY(user_id)
);
...
Heidelberg asked 5/3, 2014 at 14:45
1
Solved
What is the problem with this CQL query
cqlsh> create table citybizz.notifications(
... userId varchar,
... notifId UUID,
... notification varchar,
... time bigint,read boolean,
... primar...
3
Solved
I am evaluating cassandra. I am using the datastax driver and CQL.
I would like to store some data with the following internal structure, where the names are different for each update.
+-------+...
Xantha asked 14/2, 2014 at 11:52
4
Solved
I've just had a crash course of Cassandra over the last week and went from Thrift API to CQL to grokking SuperColumns to learning I shouldn't use them and user Composite Keys instead.
I'm now tryi...
1
My Usecase
I want to order by timestamp DESC for the results. But I don't want timestamp to be the second column in the primary key as that will take of my querying capability
for example
create...
3
Solved
Is it possible to use a table in cassandra as a queue, I don't think the strategy I use in mysql works, ie given this table:
create table message_queue(id integer, message varchar(4000), retries i...
2
Can I create a secondary index on multiple columns in cassandra?
like can I do
create index my_composite_index on my_column_family (id,name)
CQL throws error
:2:Bad Request: line 1:73 mism...
2
Solved
I have problem with presenting complex data structure in cassandra.
JSON example of data :
{
"A": {
"A_ID" : "1111"
"field1": "value1",
"field2": "value2",
"field3": [
{
"id": "id1",
"name...
Selfwinding asked 12/11, 2013 at 10:38
2
Solved
I have below table in CQL-
create table test (
employee_id text,
employee_name text,
value text,
last_modified_date timeuuid,
primary key (employee_id)
);
I inserted couple of records in t...
3
I'm attempted to execute the following CQL 3 statement
CREATE TABLE summary (
id uuid,
"client" bigint,
"campaign" text,
"unit" bigint,
"view" counter,
PRIMARY KEY ("client", "campaign", ...
© 2022 - 2024 — McMap. All rights reserved.