Stack Overflow
Stack Overflow

Questions tagged [cassandra-cli]

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

167 questions
201
votes
16 answers

How to list all the available keyspaces in Cassandra?

I am newbie in Cassandra and trying to implement one toy application using Cassandra. I had created one keyspace and few column families in my Cassandra DB but I forgot the name of my cluster. I am trying to find if there is any query which can list…
Shekhar
  • 10,233
  • 31
  • 116
  • 179
33
votes
6 answers

What's the difference between creating a table and creating a columnfamily in Cassandra?

I need details from both performance and query aspects, I learnt from some site that only a key can be given when using a columnfamily, if so what would you suggest for my keyspace, I need to use group by, order by, count, sum, ifnull, concat,…
kumar
  • 2,335
  • 5
  • 18
  • 26
18
votes
3 answers

How to select data from a table and insert into another table?

I want to select specific fields of a table in cassandra and insert them into another table. I do this in sql server like this: INSERT INTO Users(name,family) SELECT name,family FROM Users How to to this in cassandra-cli or cqlsh?
ehsan shirzadi
  • 4,138
  • 12
  • 57
  • 99
13
votes
3 answers

How to configure cassandra for remote connection

I am trying to configure Cassandra Datastax Community Edition for remote connection on windows, Cassandra Server is installed on a Windows 7 PC, With the local CQLSH it connects perfectly to the local server. But when i try to connect with CQLSH…
Obama
  • 2,406
  • 2
  • 27
  • 47
11
votes
1 answer

Alter cassandra column family primary key using cassandra-cli or CQL

I am using Cassandra 1.2.5. After creating a column family in Cassandra using cassandra-cli, is it possible to modify the primary key on the column family using either cassandra-cli or CQL? Specifically, I currently have the following table (from…
Justin Sweeney
  • 133
  • 1
  • 1
  • 7
9
votes
1 answer

Cassandra cli: Convert hex values into a human-readable format

Im starting with cassandra, and when I run list or get commands in cassandra-cli, I get results like this: [default@usersdatabase] list users; Using default limit of 100 ------------------- RowKey: boby => (column=6e616d65, value=426f62,…
Edmhs
  • 3,213
  • 23
  • 37
9
votes
3 answers

cassandra copy data from one columnfamily to another columnfamily

I am newbie to cassandra . I need to copy data from one columnFamily to another columnFamily in same keyspace in cassandra .Say for ex we have a A1 columnFamily in keyspace K1 , so now i need to create columnFamily A2 in the same keyspace K1 .Here i…
user1278493
  • 155
  • 1
  • 3
  • 8
8
votes
1 answer

Cassandra rack concept and database structure

I am new to Cassandra and I would like to learn more about Cassandra's racks and structure. Suppose I have around 70 column families in Cassandra and two AWS2 instances. How many Data Centres will be used? How many nodes will each rack have? Is it…
user2348014
7
votes
2 answers

how to get value from counter Column in cassandra with multiple row keys?

I have one column family that has multiple counter columns. Now I want to get their value behalf of different row keys, Means like RangeSlicesQuery or MultigetSliceQuery, I want to apply on counter column please give me way in counter column.
Rohit Sharma
  • 195
  • 2
  • 11
7
votes
1 answer

in cassandra-cli how to get all column names in a table and how to get it using hector in java?

I'm trying to get column names but could not get way to get only column names. In cli I executed command describe table nodes, it returned the result: CREATE TABLE nodes ( key text PRIMARY KEY, id text, scores text, topic1 text, topic2…
N D Thokare
  • 1,541
  • 5
  • 33
  • 56
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
  • 768
  • 10
  • 23
6
votes
2 answers

Cassandra query making - Cannot execute this query as it might involve data filtering and thus may have unpredictable performance

I'd the following Cassandra Model:- class Automobile(Model): manufacturer = columns.Text(primary_key=True) year = columns.Integer(index=True) model = columns.Text(index=True) price = columns.Decimal(index=True) I needed the…
PythonEnthusiast
  • 14,299
  • 33
  • 103
  • 218
6
votes
2 answers

Add columns dynamically in cassandra

I have a table like this in CQL3 create table product_info ( key text, value text, Primary key (key) ); It is a vertical table . Since I can insert new rows with (key , value ) pair. Sample data will be : product_info key | …
Sujith PS
  • 4,447
  • 3
  • 29
  • 59
6
votes
1 answer

Cassandra read timeout

I am pulling big amount of data from cassandra 2.0, but unfortunately getting timeout exception. My table: CREATE KEYSPACE StatisticsKeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 }; CREATE TABLE…
Wild Goat
  • 3,239
  • 9
  • 36
  • 76
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,072
  • 1
  • 14
  • 30
1
2 3
…
11 12