Recent questions tagged cql

0 votes

593 views

1 answer

I want to copy selected rows from a columnfamily to a .csv file. The copy command is available just to dump ... help would be much appreciated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

428 views

1 answer

cql - How to copy data from a Cassandra table to another structure for better performance

In several places it's advised to design our Cassandra tables according to the queries we are going to perform on ... .0 | Native protocol v4] See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

621 views

1 answer

cql - Cassandra UPDATE primary key value

I understand that this is not possible using an UPDATE. What I would like to do instead, is migrate all rows ... simple ways of achieving this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

cql - Coordinator node timed out waiting for replica nodes in Cassandra Datastax while insert data

When I try to Insert data in Cassandra using the below query I am getting the below mentioned error cqlsh:assign> ... 0 | Native protoco l v3] See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

365 views

1 answer

cql - How to batch select data from Cassandra effectively?

I know Cassandra doesn't support batch query, and it also doesn't recommend to use IN, because it can degrade ... way can make it effectively? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

241 views

1 answer

cql - Cassandra: List 10 most recently modified records

I'm having trouble trying to model my data such that I can efficiently query Cassandra for the last 10 (any number ... like a non-starter to me. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

cql - SELECT in cassandra where id != null

How do I query in cassandra for != null columns. Select * from tableA where id != null; Select * from ... and insert these into different table. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

337 views

1 answer

cql - Querying Cassandra by a partial partition key

In Cassandra, I can create a composite partition key, separate from my clustering key: CREATE TABLE footable ( ... only on column1, here? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

394 views

1 answer

cql - Cassandra ByteOrderedPartitioner

I want to execute some range queries on a table that is structured like: CREATE TABLE table( num int, val1 int, ... can help me. Thank you! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

390 views

1 answer

cql - How do secondary indexes work in Cassandra?

Suppose I have a column family: CREATE TABLE update_audit ( scopeid bigint, formid bigint, time timestamp, ... intersect these two results? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

596 views

1 answer

cql - cassandra get all records in time range

I have to work with a column family that has (user_id, timestamp) as key. In my query I would like to fetch ... de we have to change the design? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags