cql3 Questions
1
Solved
I tried reading up on datastax blogs and documentation but could not find any specific on this
Is there a way to keep 2 tables in Cassandra to belong to same partition?
For example:
CREATE TYPE a...
Saltire asked 15/12, 2015 at 16:46
5
Solved
As there are two ways to support wide rows in CQL3..One is to use composite keys and another is to use collections like Map, List and Set. The composite keys method can have millions of columns (tr...
2
Solved
This behavior in Cassandra seems counter-intuitive and I want to know why this is happening, and possibly work around this.
Imagine I have a table with three columns: pk, the primary key, a text...
Witchcraft asked 3/12, 2014 at 19:50
2
I have a CQL table defined like this:
CREATE table primary_key_only(
row_key varchar,
clustered_key varchar,
primary key(row_key, clustered_key)
)
Assuming I insert values like this:
INSERT ...
Platinize asked 30/9, 2013 at 15:25
2
I have a CQL table (cql 3, cassandra 2.0.*) that looks something like:
CREATE TABLE IF NOT EXISTS user_things (
user_id bigint,
thing_id bigint,
created_at timeuuid,
PRIMARY KEY (user_id, thin...
2
Solved
In Cassandra, I'm using the cql:
select msg from log where id in ('A', 'B') and filter1 = 'filter'
(where id is the partition key and filter1 is a secondary index and filter1 cannot be used as ...
1
Solved
Which is the best python ORM based on Flask framework for Apache Cassandra 2.x?
The ORM you are sugesting, should have best features, like that of pycassa or even more. It will be most useful, if ...
Telford asked 10/9, 2015 at 14:41
2
Solved
Suppose I have a column family:
CREATE TABLE update_audit (
scopeid bigint,
formid bigint,
time timestamp,
record_link_id bigint,
ipaddress text,
user_zuid bigint,
value text,
PRIMARY KEY (...
Alberic asked 17/4, 2015 at 7:19
3
Is it possible in cassandra map to input different data types like if I have a table like
(id int, value map<text,text>)
Now I want to insert values in this table like
(1,{'test':'test1'}...
4
Solved
Just learning cassandra, is there a way to insert a UUID using CQL, ie
create table stuff (uid uuid primary key, name varchar);
insert into stuff (name) values('my name'); // fails
insert into stu...
4
Solved
I am trying to export data from cassandra using CQL client. A column family has about 100000 rows in it. when i am copying dta into csv file using COPY TO command i get following rpc_time out error...
4
Solved
How can I pull in a range of Composite columns with CQL3?
Consider the following:
CREATE TABLE Stuff (
a int,
b text,
c text,
d text,
PRIMARY KEY (a,b,c)
);
In Cassandra what this effectiv...
1
I have a batch statement of Cassandra that contains a delete and an insert statement of same partition key, where delete is the first statement and insert is the second. How the batch statement exe...
2
Solved
How to drop all keyspace in cassandra, I have requirement where I have to delete all keyspaces created by some test scripts.
Thanks
2
Solved
I am trying to understand the fundamentals of Cassandra data model. I am using CQL. As per I know the schema must be defined before anyone can insert into new columns. If someone needs to add any c...
Lamarckian asked 25/3, 2015 at 8:14
1
Solved
How would I write the CQL to get the most recent set of data from each row?
I'm investigating transitioning from MSSQL to Cassandra and am starting to grasp the concepts. Lots of research has help...
Playback asked 19/3, 2015 at 13:58
3
Solved
I have a simple table distributed by userId:
create table test (
userId uuid,
placeId uuid,
visitTime timestamp,
primary key(userId, placeId, visitTime)
) with clustering order by (placeId asc...
2
Solved
Prior to CQL3 one could insert arbitrary columns such as columns that are named by a date:
cqlsh:test>CREATE TABLE seen_ships (day text PRIMARY KEY)
WITH comparator=timestamp AND default_valid...
1
Solved
I am trying to get familiar with Apache Cassandra, for a particular PoC work. After going through various articles on the net, trying out various libraries/clients available, a particular question ...
Amena asked 13/2, 2015 at 7:46
2
I am new to Cassandra cql (cqlsh 4.1.1, Cassandra 2.0.8.39, CQL spec 3.1.1, Thrift protocol 19.39.0) - using the cql COPY command to a table from a CSV formatted file and I get the following error:...
2
Solved
I have a Cassandra 1.2 cluster and I'm using it from Python using the cql library. Now I need to implement some paging functionality that seems pretty straightforward using get_slice, but I can't f...
1
Solved
Im using a DataStax Community v 2.1.2-1 (AMI v 2.5) with preinstalled default settings.
And i have a table :
CREATE TABLE notificationstore.note (
user_id text,
real_time timestamp,
insert_time...
Overcurious asked 7/12, 2014 at 7:57
1
Solved
Im using a DataStax Community v 2.1.2-1 (AMI v 2.5) with preinstalled default settings+ increased read time out to 10sec here is the issue
create table simplenotification_ttl (
user_id varchar,...
Ortega asked 9/12, 2014 at 10:33
1
Solved
My table looks like this
create table Notes(
user_id varchar,
real_time timestamp,
insertion_time timeuuid,
read boolean PRIMARY KEY (user_id,real_time,insertion_time)
);
create index read_in...
4
Solved
I'm working on a distributed data base. I'm trying to generate a unique ID that will serve as a column family primary key in cassandra.
I read some articles about doing this with Java using UUID b...
© 2022 - 2024 — McMap. All rights reserved.