Stack Overflow
Stack Overflow

Questions tagged [cassandra-cli]

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

166 questions
3
votes
1 answer

Understanding the philosophy behind Cassandra

I am trying to get familiar with Apache Cassandra, for a particular PoC work. After going through various articles on the net, trying out various libraries/clients available, a particular question pops up in my mind. The initial reason why we…
sutanu dalui
  • 663
  • 7
  • 25
3
votes
1 answer

DROP COLUMN FAMILY from cassandra CLI will not drop the CF

We tried to drop CF's using cassandra cli DROP COLUMN FAMILY cfName And when we list the CF from CLI it was not there and when i tried to get the existing CF's via hector I still could see the CF name KeyspaceDefinition keyspaceDefinition =…
poohdedoo
  • 1,258
  • 1
  • 18
  • 42
3
votes
1 answer

Cassandra CLI create column family with primary key

I am trying to create a column family in Cassandra CLI Version 1.1.6, I am not sure how to specify primary key as movieid. CREATE COLUMN FAMILY movies WITH comparator = UTF8Type AND key_validation_class=UTF8Type AND column_metadata = [ {column_name:…
l0n3r4n83r
  • 1,271
  • 1
  • 14
  • 25
3
votes
3 answers

mismatched input ')' expecting EOF in CQL

created keyspace and using CQL but getting an Error CREATE KEYSPACE demodb WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' ... AND strategy_options:replication_factor='1'; cqlsh:demodb> CREATE TABLE users…
user2801682
  • 177
  • 2
  • 2
  • 12
3
votes
1 answer

Inserting same data to cassandra database

I have a question what if we try to insert same data to cassandra database . Here by same i mean a set of 100 rows is already present in cassandra database say in a test column family .Again if we try to insert the same 100 rows to cassandra…
user1278493
  • 165
  • 1
  • 3
  • 9
3
votes
1 answer

How can i retrieve data from two tables in Cassandra Database

I have to retrive the data from two tables, Here are my two tables in Cassandra DataBase. employee is keyspace, Two tables: emp:- "eno" is primay key,"username","password" Dept:-"dno" is primary key ,"eno","dname" Now i want to retrieve the data…
user1983299
  • 393
  • 1
  • 5
  • 16
2
votes
1 answer

In Cassandra, why dropping a column from tables defined with compact storage not allowed?

As per datastx documentation here, we cannot delete column from tables defined with COMPACT STORAGE option. What is the reason for this?
Manish Khandelwal
  • 2,260
  • 2
  • 15
  • 13
2
votes
1 answer

cassandra c# datastax client insert blob

hi I wonder if there is a more elegant way of inserting blob instead of converting the byte array into string like: string strblob = "0x00" + BitConverter.ToString(stream2.GetBuffer()).Replace("-", ""); ISession session =…
user5467599
2
votes
2 answers

Why and when to use Vnodes in Cassandra in real life production scenarios?

I understand that you don't have to rebalance the vnodes but when do we really use it in production scenarios? does it function the same way as a physical single token node? If so, then why use single token nodes at all? Does vnodes help if I have…
user1870400
  • 6,028
  • 13
  • 54
  • 115
2
votes
1 answer

How to set a consistency level to something other than one, two, three for reads and write in Cassandra?

Say I want my replication factor N=10 and I want my R=4 and W=7 such that R + W > N. How can I configure this in cassandra? I know what quorum does but thats not what I am looking for.
user1870400
  • 6,028
  • 13
  • 54
  • 115
2
votes
1 answer

What is the graveyard compaction in cassandra?

Cassandra noob here. While going through the documentation etc, I'm repetitevely finding references to graveyard compaction (and occasionally tombstones), example: $ cassandra-cli [default@unknown] help truncate; ... A snapshot of the data is…
Anshul Goyal
  • 73,278
  • 37
  • 149
  • 186
2
votes
2 answers

Import from .sql file to cassandra table

I am new to Cassandra database, I have created keyspace and table.Then, I would like to execute large number of queries that are saved inside a test.sql file ( I dont want to perform Importing from CSV ). My test.sql file content is looks like…
V A S
  • 3,338
  • 4
  • 33
  • 39
2
votes
2 answers

Altering keyspace to change strategy class is not working in cassandra-cli

I have tried to alter the keypace with strategy class and options using below command in cassandra-cli of version cassandra 1.1.6 but it says 'Syntax error at position 0: no viable alternative at input 'ALTER'. ALTER KEYSPACE system_auth WITH…
Dinesh Kumar
  • 141
  • 10
2
votes
1 answer

Cassandra throwing NoHostAvailableException after 5 minutes of high IOPS run

I'm using datastax cassandra 2.1 driver and performing read/write operations at the rate of ~8000 IOPS. I've used pooling options to configure my session and am using separate session for read and write each of which connect to a different node in…
Aneesh
  • 1,703
  • 3
  • 24
  • 34
2
votes
3 answers

Is update in place possible in Cassandra?

I have a table in Cassandra where I populate some rows with 1000s of entries (each row is with 10000+ columns). The entries in the rows are very frequently updated, basically just a field (which is an integer) is updated with different values. All…
Nipun Talukdar
  • 4,975
  • 6
  • 30
  • 42
1 2
3
…
11 12