Stack Overflow
Stack Overflow

Questions tagged [cassandra-cli]

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

166 questions
240
votes
17 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
  • 11,438
  • 36
  • 130
  • 186
39
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,905
  • 5
  • 22
  • 26
19
votes
4 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,709
  • 16
  • 69
  • 112
15
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,586
  • 2
  • 30
  • 49
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
10
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
  • 165
  • 1
  • 3
  • 9
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,645
  • 27
  • 39
9
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…
Praful Bagai
  • 16,684
  • 50
  • 136
  • 267
9
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
8
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
  • 205
  • 3
  • 11
7
votes
3 answers

What are the maximum number of columns allowed in Cassandra

Cassandra published its technical limitations but did not mention the max number of columns allowed. Is there a maximum number of columns? I have a need to store 400+ fields. Is this possible in Cassandra?
Luke101
  • 63,072
  • 85
  • 231
  • 359
7
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,776
  • 3
  • 34
  • 61
7
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,509
  • 12
  • 46
  • 87
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,703
  • 6
  • 35
  • 57
6
votes
2 answers

No appropriate python interpreter found. Cassandra

I am a java developer and am very new to Linux and Cassandra. I am using CentOS6. I am trying to install Cassandra3.4 in the Linux machine. I have followed the steps mentioned in here. Looks like the Linux machine already has Python installed. When…
Andy
  • 5,433
  • 6
  • 31
  • 38
1
2 3
…
11 12