cql3 Questions
3
Solved
In SQL, I am able to do:
select getdate(), getdate() - 7
Which returns the current date as well as current date - 7 days. I want to achieve the same in Cassandra CQL. I tried:
select dateof(now...
4
Solved
I used USE billKeyspace; to enter a keyspace and start using it. Now I want to exit this keyspace and enter another keyspace. How to do that?
If I use exit; or quit; it exits out of cql session it...
Torsk asked 4/1, 2017 at 16:31
7
Solved
I am wondering how can I achieve pagination using Cassandra.
Let us say that I have a blog. The blog lists max 10 posts per page. To access next posts a user must click on pagination menu to acces...
Troublous asked 5/11, 2014 at 12:31
3
Solved
We are using Cassandra as the data historian for our fleet management solution. We have a table in Cassandra , which stores the details of journey made by the vehicle. The table structure is as giv...
2
Solved
Question to all Cassandra experts out there.
I have a column family with about a million records.
I would like to query these records in such a way that I should be able to perform a Not-Equal-To...
5
Solved
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)...
Thermoluminescence asked 19/4, 2013 at 1:57
2
Solved
I'm trying to do a simple select in Cassandra CQL3 containing a hardcoded value (constant) under a constant column name and I simply can't get it working
Here's the query
SELECT 1 as "id"
Works ...
2
Solved
There's some patchy information on the interwebs about some examples when column type can't be changed. For example, on the DataStax site there's a mention:
Changing the type of a clustering colu...
3
Is it possible to create a table that has a default TTL for all rows that are inserted into it, or do you have to always remember to set the TTL when you do an insert/update?
Cant see anything on ...
3
Solved
I have a column family with primary key definition like this:
...
PRIMARY KEY ((website_id, item_id), user_id, date)
which will be queried using queries such as:
SELECT * FROM myCF
WHERE websit...
3
I am trying to create a WIDE Column Table, 20,000+ columns
Initially I was thinking I would use:
CREATE TABLE details (
key TEXT,
detail map<TEXT, TEXT>
PRIMARY KEY (KEY)
);
Inserting...
2
I have a table structure like
create table file(id text primary key, fname text, mimetype text, isdir boolean, location text);
create index file_location on file (location);
and following is th...
4
I want to copy selected rows from a columnfamily to a .csv file. The copy command is available just to dump a column or entire table to a file without where clause. Is there a way to use where clau...
2
I am new to NoSQL database and have just started using apache Cassandra. I created a simple table "emp" with primary key on "empno" column. This is a simple table as we always get in Oracle's defau...
3
Solved
As shown in the picture querying with exact timestamp(2013-08-01 15:02:56) is not returning any result though a row with that timestamp exists but it returns results with that row when queried for ...
3
Solved
For my Cassandra Database, I need to set a value in column for all rows in my table.
I see in SQL, we can do :
UPDATE table SET column1= XXX;
but in CQL (in cqlsh), It doesn't work !
I don't w...
3
Solved
4
Solved
I'm wondering if there is a query in CQL3 that allows you to get column names of a specific columnfamily that has a static schema?
Thanks in advance :)
4
Solved
How can I get list of all column families in keyspace in Cassandra using CQL 3?
Overscore asked 29/3, 2014 at 17:15
2
Solved
I attempted to create a table with counter as one of the column type in cassandra but getting the following error:
ConfigurationException: ErrorMessage code=2300 [Query invalid because
of confi...
2
create ROLE testROLE with PASSWORD = 'test';
create ROLE testROLE with PASSWORD = 'test';
list ROLES shows the roles successfully.
DROP ROLE testROLE;
InvalidRequest: code=2200 [Invalid query] ...
3
Solved
I have created a table as follows in Cassandra:
CREATE TABLE sp.status(
ams text,
load_start_time timestamp,
file_path text,
file_timestamp timestamp,
host text,
load_end_time timestamp,
records_i...
Okun asked 22/1, 2016 at 13:45
3
Solved
I have heard repeatedly that secondary indexes (in cassandra) is only for convenience but not for better performance. The only case where it is recommended to use secondary indexes when you have lo...
Luanaluanda asked 4/8, 2014 at 18:15
2
Solved
How can I check if a non-primary key field's value is either 'A' or 'B' with a Cassandra CQL query? (I'm using Cassandra 2.0.1)
Here's the table definition:
CREATE TABLE my_table (
my_field text...
1
I have a simple question about using Cassandra as a key-value data store.
I am stil new to Casandra concepts and I have searched for an answer for this question in several places but, I could not f...
Ancestress asked 14/3, 2018 at 14:23
1 Next >
© 2022 - 2024 — McMap. All rights reserved.