Questions tagged [cassandra-cli]

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

166 questions
2
votes
1 answer

What does adding nodes in Cassandra generally means?

Hi I have a cassandra DB with a huge amount of data and I am using only one node to store it.So someone suggested me to use multiple nodes . So what will happen if I add a new node , will the data get replicated to the other node or it will…
JavaRookie
  • 225
  • 1
  • 2
  • 9
2
votes
1 answer

How to Configure multiple node cluster with Cassandra on Windows 7 64 bit?

Hi I am trying to setup multiple node for my cluster in windows machine , I have found various tutorials regarding Configuring multiple nodes for Ubuntu, but I am not able to find a proper step by step tutorial for setting up multiple node for my…
JavaRookie
  • 225
  • 1
  • 2
  • 9
2
votes
1 answer

Cassandra + Java Spring connection trouble

I tried to install and run Apache Cassandra on the amazon instance. On the instance all work fine. Also i can to connect from remote machine via cassandra-cli --host PUBLIC_IP --port 9160. But when i try to connect via spring-data-cassandra…
Yuriy Aizenberg
  • 373
  • 9
  • 28
2
votes
1 answer

Select write time of collection column cassandra

How to select WRITETIMEof a column of type list in Cassandra. I get the following exception when I try this SELECT WRITETIME (column_name) from TABLE_NAME WHERE ID='1';Exception com.datastax.driver.core.exceptions.InvalidQueryException:…
l0n3r4n83r
  • 1,271
  • 1
  • 14
  • 25
2
votes
3 answers

Cassandra Error :Invalid method name "describe local ring"

I am developing one project in hadoop using java. When i run my code(jar) on local cluster its working fine but when i run its on amazon multi cluster then it will give exception... my code for mapreduce …
Rishi Dwivedi
  • 908
  • 5
  • 19
2
votes
2 answers

CqlStorage() not working with Higher Records in PIG(CqlStorage() in pig throws an exception)

I am using DSE 3.1.2 I am using Pig to store some of the pre-processing results into cql, I have create a table and started my script it worked for few amount of data, when increased few more records its not storing into cassandra, only 90% or the…
2
votes
1 answer

How to export data from Hive to Cassandra?

Is there a way to export data from Hortonworks Hive to Apache Cassandra without using ETL tools?
2
votes
3 answers

Datastax driver limit option

I construct a select query using datastax java driver. I set the limit using limit option. But i see another property that can be set too setFetchSize(int size) DEFAULT_FETCH_SIZE- 5000 according to the…
Ananth
  • 971
  • 9
  • 23
2
votes
1 answer

me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(mismatched input '(' expecting ')')

I am trying to insert some values in table 'standardevents'. This is the query that is executed. UUID uuid=new UUID(); CqlQuery cqlQuery = new CqlQuery(keyspace, stringSerializer, stringSerializer,…
Sanil GK
  • 31
  • 4
2
votes
2 answers

how to use sstableloader with CQL 3.0

I am trying to use the sstableloader for a table that has been created with CQL 3.0 I have created a table in Cassandra with CQL 3 as follows: CREATE TABLE users1 ( id text PRIMARY KEY, firstname text, lastname text, )…
eldho
  • 255
  • 1
  • 2
  • 13
2
votes
1 answer

new column added to columnfamily in cassandra-cli is not visible from cqlsh (cql3)

I defined a table in cql3. Describing it returns the following: CREATE TABLE results ( id uuid PRIMARY KEY, casename text, result text, run int, user text ) WITH ... I try to use the fact that this is should not limit the…
zeller
  • 4,904
  • 2
  • 22
  • 40
2
votes
1 answer

Setting cassandra column as set gives InvalidRequestException

I am new to the cassandra world. I created a cassandra table using cqlsh like the following: CREATE TABLE "userRecommendations" (uid text PRIMARY KEY, app set); Now, when I use the cassandra-cli, and do a describe keySpace;, I…
alienzee
  • 43
  • 1
  • 6
1
vote
1 answer

unconfigured table schema_columnfamilies

I am new to cassandra and I am using cassandra version 2.1.17 which supports cassandra-cli . I created a keyspace using the following command create keyspace employee with placement_strategy='org.apache.cassandra.locator.SimpleStrategy' and…
Amogh Huilgol
  • 1,252
  • 3
  • 18
  • 25
1
vote
3 answers

stubbed cassandra for data storage

I need an embedded cassandra for my project and I was wondering if I can use Stubbed Cassandra for data storage. Because I need a system to simulate CQL requests and responses. Thanks everyone.
M. Afathi
  • 65
  • 1
  • 4
1
vote
0 answers

Cassandra: How to read schemaless columns in cqlsh or why it is not possible?

We use Cassandra as a database with most of the tables having schema (and created via CQL), but also some old tables defined via Thrift API, i.e. using COMPACT STORAGE and having quite a number of dynamic columns. A typical example would be an…
Artem
  • 776
  • 5
  • 18