Stack Overflow
Stack Overflow

Questions tagged [cassandra-cli]

The Cassandra CLI is a holdover from the pre-CQL Thrift API.

166 questions
6
votes
1 answer

Cassandra 3.0 updated SSTable format

According to this issue, Cassandra's storage format was updated in 3.0. If previously I could use cassandra-cli to see how the SSTable is built, to get something like this: [default@test] list phonelists; ------------------- RowKey: scott =>…
experimenter
  • 878
  • 1
  • 11
  • 27
6
votes
0 answers

Cassandra: How to get a list of processes?

Hello Cassandra Experts, How can I get a list of processes in Cassandra cluster (similiar to the show processlist command of MySQL)? Im puzzled as to why I cannot find any posts anywhere about this topic. Thanks.
user3448124
  • 173
  • 1
  • 6
6
votes
1 answer

thrift_max_message_length_in_mb not recognized Cassandra

I am having problems trying to query a wide row in Cassandra 1.2.4 When I tried to query the row using the Cassandra-cli, I obtain this error: Frame size (75209759) larger than max length (15728640)! org.apache.thrift.transport.TTransportException:…
ftrujillo
  • 1,172
  • 1
  • 16
  • 30
5
votes
2 answers

Unbalanced Cassandra cluster

Update - Short version: The PropertyFileSnitch cassandra-topology.properties for the first 3 nodes (Rack 1-3) states that only these nodes are in DC1 and the others are in DC2 by specifying the default value default=DC2:r1. When the cluster was…
alien5
  • 76
  • 6
5
votes
1 answer

Cassandra - Write doesn't fail, but values aren't inserted

I have a cluster of 3 Cassandra 2.0 nodes. My application I wrote a test which tries to write and read some data into/from Cassandra. In general this works fine. The curiosity is that after I restarted my computer, this test will fail, because after…
Julia
  • 123
  • 1
  • 6
4
votes
3 answers

Run cassandra queries from command line

I want to execute cql queries from bash command. [cqlsh 3.1.8 | Cassandra 1.2.19 | CQL spec 3.0.5 | Thrift protocol 19.36.2] [root@hostname ~]# /opt/apache-cassandra-1.2.19/bin/cqlsh -k "some_keyspace" -e "SELECT column FROM Users where…
4EACH
  • 2,132
  • 4
  • 20
  • 28
4
votes
2 answers

Cassandra cqlsh Connection error : 'Unable to connect to any servers',.cql_version '3.4.0' is not supported by remote

I was trying to connect to my remote cassandra DB via cqlsh , Connection error: ('Unable to connect to any servers', {'XX.XX.XX.XX': ProtocolError("cql_version '3.4.0' is not supported by remote (w/ native protocol). Supported versions:…
Sujith PS
  • 4,776
  • 3
  • 34
  • 61
4
votes
1 answer

cassandra-Hector :how to fetch column family with composite key

I am newbie in cassandra,and my data storage structure is list test RowKey: key1 => (column=colkey1:colkey2, value=amitdubey, timestamp=1381832571947000) => (column=colkey1:colkey3, value=amitdubey, timestamp=1381832571947000) =>…
user2348014
4
votes
2 answers

Cassandra 1.2: how to get the real load on each virtual node

I have a Cassandra 1.2 cluster and I'm using virtual nodes and the ByteOrderedPartitioner. I know this is not recommended because I need to make sure the keys of the data is evenly distributed across the keyspace so the load on each physical node is…
Sergio Ayestarán
  • 5,590
  • 4
  • 38
  • 62
4
votes
4 answers

Error when starting Cassandra prevents launching

I am trying to run Cassandra. But, I am getting this error: [root@SudeepMangu bin]# ./cassandra -f xss = -ea -javaagent:/home/sudeep/apache-cassandra-1.2.5-src/lib/jamm-0.2.5.jar- XX:+UseThreadPriorities -XX:ThreadPriorityPolicy=42 -Xms930M…
Mahesh Muni
  • 51
  • 2
  • 7
3
votes
1 answer

No SQL Shema Design/Backup Strategy

We are using cassandra for IOT based application. Currently we are receiving 10 GB data in every day. We are storing all data into single table in Cassandra in the way of time series model. What is the best approach keeping the data in single table…
kannadhasan
  • 339
  • 4
  • 17
3
votes
1 answer

cassandra-cli 'list' in cassandra 3.0

I want to view the "rowkey" with its stored data in cassandra 3.0. I know, the depreciated cassandra-cli had the 'list'-command. However, in cassandra 3.0, I cannot find the replacement for the 'list'-command. Anyone knows the new cli-command for…
nimo23
  • 5,170
  • 10
  • 46
  • 75
3
votes
3 answers

How to insert a newline(\n) inside a String(text) into Cassandra by CQLSH command?

Update: Newline is working if I insert the same line by python driver script. session.execute("INSERT INTO ctable" + " (cid, cstring) VALUES (%s, %s)", ('2', 'row1\nrow2')) Still don't understand why the CQLSH command doesn't work. Original…
Haifeng Zhang
  • 30,077
  • 19
  • 81
  • 125
3
votes
2 answers

Understanding internal data storing by cassandra

I have this table create table comment_by_post ( postId uuid, userId uuid, cmntId timeuuid, cmntTxt text, cmntBy text, time bigint, primary key ((postId, userId),cmntId) ) here is internal data in this table RowKey:…
Manish Kumar
  • 10,214
  • 25
  • 77
  • 147
3
votes
1 answer

ALLOW FILTERING implementation @Cassandra

I have a table like below: CREATE TABLE tab( categoryid text, id text, name text, author text, desc text, PRIMARY KEY (categoryid , id) ) WITH CLUSTERING ORDER BY (id ASC); CREATE INDEX ON tab (name); CREATE INDEX ON tab…
Cys
  • 137
  • 3
  • 13
1
2
3
…
11 12