cql3 Questions
3
Solved
I am trying to run the following query
SELECT edge_id, b_id FROM booking_by_edge WHERE edge_id IN ?
I bind Java list of Long's as a parameter and I get an exception
SyntaxError: line 0:-1 mism...
Begrime asked 4/6, 2013 at 13:14
4
Solved
What is the difference between UPDATE and INSERT when executing CQL against Cassandra?
It looks like there used to be no difference, but now the documentation says that INSERT does not support cou...
1
I'm new to NoSQL; so, I'm trying to understand some of the Cassandra concepts that I can't really get from the dozens of sources that I have studied.
Should I consider wide row, and dynamic colum...
Stocky asked 19/6, 2017 at 15:51
2
Solved
I was going through the tutorial where the instructor says that the default ordering of columns with in a row is UTF8-tye. But he does not touch upon it further.
I don't understand what it means....
Fisc asked 1/8, 2014 at 18:41
3
This may sound silly as there are no null values in SQL's composite primary key. But just want to confirm if we can have the same in CQL3?
So, we have a table like this to store wide rows:
CREATE...
2
If is use this code in a CQL shell , I get all the names of table(s) in that keyspace.
DESCRIBE TABLES;
I want to retrieve the same data using ResulSet . Below is my code in Java.
String query ...
4
Solved
I am trying to remodel a SQL database Cassandra such that, I can find the Cassandra equivalent for the SQL queries. I use CQL 3 and Cassandra v1.2. I modeled the db design in cassandra so that it s...
Amphibiotic asked 27/6, 2013 at 11:40
2
Solved
I'm developing a little web application for studying Apache Cassandra and Java EE 6.
Cassandra version is 1.1.6.
Have a problem driving me mad...
I created a table with a counter (using cqlsh v. 3...
3
Solved
In several places it's advised to design our Cassandra tables according to the queries we are going to perform on them. In this article by DataScale they state this:
The truth is that having many ...
2
Solved
Hello I was reading the Cassandra documentation on Token Function,
I am trying to achieve pagination for a Cassandra table, I am unable to understand the lines highlighted. The document speaks a...
Polson asked 3/10, 2016 at 19:36
4
Solved
I am using a single node Cassandra and I intend to run some queries in order to check the response time. In some queries, after 10s of execution occurs to me the following error:
OperationTimedOut...
Trivet asked 23/10, 2015 at 16:1
1
Solved
I am using Cassandra 2.0 with python CQL.
I have created a column family as follows:
CREATE KEYSPACE IF NOT EXISTS Identification
WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy',
'DC1...
Blackthorn asked 30/5, 2014 at 19:0
2
Solved
I'm in a situation where I need to change the the composite primary key as follows:
Old Primary Key: (id, source, attribute_name, updated_at);
New Primary Key I want: (source, id, attribute_name,...
Rung asked 3/3, 2014 at 6:4
2
Solved
I am trying to connect to cassandra, which is running on local desktop, via cassandra-driver for python using this simple code.
from cassandra.cluster import Cluster
cluster = Cluster()
sessio...
2
Solved
I have this table
create table constants_values
(
key_name_1 text,
key_name_2 text,
values map<text, frozen<nav_tag_values>>,
PRIMARY KEY(key_name_1, key_name_2)
);
UDT:
CREA...
Quipster asked 17/1, 2016 at 13:21
3
Solved
I'm trying to run the following example from here
CREATE TYPE address (
street text,
city text,
zip int
);
CREATE TABLE user_profiles (
login text PRIMARY KEY,
first_name text,
last_name...
2
Solved
Is there any way to prettify the results of cql commands in the Linux terminal while using the cqlsh utility (cql version of Mongo .pretty())? It becomes quite difficult to read the results when th...
0
I have a strange problem here. I have a cassandra table called events_prime and I want to request the DB to get elements from this table with a WHERE clause.
I am using the python cassandra-driver...
2
Solved
I use the following code for creating table:
CREATE KEYSPACE mykeyspace
WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
USE mykeyspace;
CREATE TABLE users (
user_id i...
1
Solved
I have this table:
CREATE TABLE custumer_events_service.events_by_websiteId_time(
"event_id" text,
"currentTime" timestamp,
"websiteId" varchar,
OTHER COLUMNS ...
PRIMARY KEY(event_id, webs...
3
Solved
I am using cassandra 2.1.10.
So First I will clear that I know secondary index are anti-pattern in cassandra.But for testing purpose I was trying following:
CREATE TABLE test_topology1.tt (
a tex...
Chui asked 1/3, 2016 at 10:8
1
Solved
I'm new in Cassandra. I can't understand what is the advantage of using counter in a table (or even in a different table if the non-counter columns are not part of the composite PRIMARY KEY)? Why w...
4
Solved
I am writing an application and I need to be able to tell if an inserts and updates succeed. I am using "INSERT ... IF NOT EXISTS" to get the light weight transaction behavior and noticed that the ...
1
Solved
I have a table that is roughly like
create table mytable (
id uuid,
something text,
primary key (id)
);
I'm trying to create a prepared statement that has a bound in-clause:
PreparedStateme...
Jez asked 28/1, 2016 at 18:28
1
Solved
if someone has some experience in using UDT (User Defined Types), I would like to understand how the backward compatibility would work.
Say I have the following UDT
CREATE TYPE addr (
street1 t...
Medorra asked 15/12, 2015 at 21:55
© 2022 - 2024 — McMap. All rights reserved.