Stack Overflow
Stack Overflow

Questions tagged [cqlsh]

cqlsh is a python-based command line client for executing Cassandra Query Language (CQL)

cqlsh is 'a python-based command line client for executing Cassandra Query Language (CQL) commands'1. It provides a quick and easy way to run simple CQL commands interactively. It has been available in the DataStax Community version of Cassandra since version 1.0.1.

The reference manual associated with CQL specification is here. Instructions for using cqlsh with Cassandra 1.0 can be found here.

803 questions
0
votes
2 answers

Cannot change timezone in Cassandra 2.1.11 to IST

I am inserting the data from C# to Cassandra cluster in IST ('2015-12-28') format. But when i query the same data using cqlsh. It gives me in '2015-12-27 18:30:00+0000' format. So, to change the format i have tried some of the suggestion but…
Naresh
  • 5,073
  • 12
  • 67
  • 124
0
votes
0 answers

Cassandra and cqlsh in docker on Travis or Circle CI

I have been testing cassandra (2.2.4) in docker (1.9.1) for a while locally on my machine but on Travis CI and Circle CI I always have the same issue: Connection error: ('Unable to connect to any servers', {'db': error(111, "Tried connecting to…
eftov
  • 11
  • 1
  • 3
0
votes
0 answers

How the starting command execution time is accessed by the use of tracing command in CQLSH

I want to get the starting command execution time using cqlsh, I have used the tracing on in cqlsh, but my table has about 50,000 records so tracing logs report is very long and is passed away so that's why I can't get the starting time of the query…
Bilal Ehsan
  • 107
  • 1
  • 5
0
votes
2 answers

facing connection error when trying to open cqlsh prompt

Can some help me why i'm facing the below issue and how to fix when I'm trying to start my cqlsh (cassandra). Connection error: ('Unable to connect to any servers', {'127.0.0.1': error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error:…
bigdata123
  • 453
  • 2
  • 8
  • 24
0
votes
0 answers

Cassandra cqlsh create keyspace hangs

I have a single node cassandra of version 2.1.2. I use cqlsh to connect to cassandra and type some commands to experiment. At first all commands work until create keyspace hanging. These are my operations. myuser@myhost:~/s/kuankr-feed-api$ cqlsh…
gzc
  • 8,180
  • 8
  • 42
  • 62
0
votes
0 answers

Secondary index on cassandra column family returns 0 rows

To start with i am new to Cassandra or rather nosql. I have a column family with couple of primary keys and some columns i would like to query on. create table destination ( destid int, destDesc text, phone text, destphone text, primary…
chetank
  • 392
  • 3
  • 17
0
votes
0 answers

cqlsh not connecting when configuring a two node cluster on windows server

I am trying to configure a two node cluster with cassandra in windows r2 2008 So i installed cassandra community version in one server (10.xxx.0.1,10.xxx.0.2) And then I stopped the service and then edited the configuraton.yaml file in the conf…
Kate Spade
  • 47
  • 3
  • 12
0
votes
1 answer

cqlsh giving OperationTimedOut

I have a 3-3 node Cassandra cluster on 4-core 16GB Ram EC2 m4.xlarge instances spread across two regions in AWS (US and Singapore, each with replication factor of two with NetworkReplicationStrategy). When I try to connect to it using cqlsh, I get…
Rahul
  • 1
0
votes
1 answer

cannot drop table with cassandra and cqlsh

I'm setting a bigdata environment. I'm trying to use Cassandra database, but I'm ignoring something apparently. I need to change the 'caching' property of the table 'system_trace.events' to fix a 'spark-connector' issue. It crash when handle a…
alejandro
  • 15
  • 4
0
votes
1 answer

How to upload/insert binary (blob) data to Cassandra 2.2 database (using DevCenter or cqlsh)

Hi I'm new to Cassandra/CQL but have SQL/relational database experience. I have a very simple key space and table setup for testing purposes and need to add some very basic data - some of which is in BLOB format. CREATE TABLE file_share ( key…
Nena
  • 681
  • 1
  • 10
  • 27
0
votes
2 answers

Frequent rpc_timeouts of the query SELECT count(*) FROM Keyspace1.Standard1 limit 5; in cassandra

I have a 5 node cassandra cluster with 3 nodes on a private DC & the other 2 on AWS. Select * requests are timing out even when it is limited to 5. I understand if they are timing out for high numbers but timing out for single digits looks strange…
iamtrk
  • 63
  • 1
  • 6
0
votes
1 answer

Unable to connect cqlsh in Cassandra 2.2.0

I am trying to launch cqlsh for the first time but I am getting the following error. ./cqlsh us01u256 9160 File "./cqlsh.py", line 625 ssl_options=sslhandling.ssl_settings(hostname, CONFIG_FILE) if ssl else None, …
Ramesh Vadlamani
  • 1
  • 1
0
votes
2 answers

Is there a way to get a diff of data stored in 2 column families in Cassandra?

The use case is that we are migrating data from one column family to the other and hence it would be required to verify that the target column family has exactly the same data as the source column family. That means the diff of these CFs would be…
schatter
  • 151
  • 1
  • 11
0
votes
1 answer

Cqlsh describe is missing a column visible in system.schema_columns

After playing with Cassandra (many DROP KEYSPACE, CREATE KEYSPACE, ALTER TABLE, CREATE TABLE operations), for the second time I've ended up with following strange situation: Describe x.logs: System.schema_columns: Alter table: Nodetool repair…
piotrwest
  • 2,098
  • 23
  • 35
0
votes
0 answers

Cassandra node getting killed

I am having 6 cassandra nodes with around 6GB data on each except one which is having around 45GB of data. This is because this node keeping hints which is around 39GB. My all nodes are up and fully functional I dint get why this node keeping huge…
Aftab
  • 938
  • 1
  • 9
  • 20
1 2 3
…
53 54