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
15
votes
2 answers

Apache Cassandra 3.7 CQLSH 'Unable to connect to any servers'

Apache cassandra version 3.7 is running on Ubuntu server 16.04 fine, all parts of apache cassandra started up no problem, the issue is, i go to connect using cqlsh: $ CQLSH (My IP Address) 9160 then it says: Connection error: ('Unable to connect to…
SteveB
  • 173
  • 1
  • 1
  • 10
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
15
votes
2 answers

cassandra - only superuser is allowed to perform CREATE USER queries

I'm logging in with on Ubuntu 14.10 on Cassandra 2.0.8 with Java 1.7.0_60-b19 cqlsh -u cassandra -p cassandra I'm running: CREATE USER a WITH PASSWORD 'a' NOSUPERUSER; I'm getting the error: Bad Request: Only superusers are allowed to perform…
hawkeye
  • 34,745
  • 30
  • 150
  • 304
14
votes
3 answers

Was cqlsh 5.0.1 broken in cassandra 3.11.2 release?

My OSX install of Cassandra seems to have been broken by yesterday's release. Cassandra seems to start OK. Jeremys-MacBook-Pro: fractal jeremy$ cqlsh --version cqlsh 5.0.1 Jeremys-MacBook-Pro:fractal jeremy$ cqlsh localhost Traceback (most recent…
Jerry Taylor
  • 161
  • 4
14
votes
4 answers

CQLSH client - module' object has no attribute 'parse_options

I'm trying to access my Cassandra server through a CQLSH client to import a huge CSV file. I'm getting a module' object has no attribute 'parse_options error. I run the follow command: cqlsh XXX.XXX.XX.XX XXXX --cqlversion="3.4.2" --execute="copy…
Andre Garcia
  • 894
  • 11
  • 30
14
votes
3 answers

How to connect to Cassandra(remotehost) using cqlsh

I cannot cqlsh to remote host ./cqlsh xx.xx.x.xxx 9042 Connection error: ('Unable to connect to any servers', {'10.101.33.163': ConnectionException(u'Did not get expected SupportedMessage response; instead, got:
mobileDev
  • 1,358
  • 2
  • 14
  • 34
14
votes
7 answers

Operation Time Out Error in cqlsh console of cassandra

I have a three nodes Cassandra Cluster and I have created one table which has more than 2,000,000 rows. When I execute this (select count(*) from userdetails) query in cqlsh, I got this error: OperationTimedOut: errors={},…
Kaushal
  • 3,237
  • 3
  • 29
  • 48
14
votes
1 answer

How do you insert a string or text as a blob in Cassandra (specifically CQLSH)?

I was trying to insert text or some string as a blob for testing purposes in CQLSH insert into test_by_score (commit, delta, test, score) values (textAsBlob('bdb14fbe076f6b94444c660e36a400151f26fc6f'), 0, textAsBlob('{"prefix":…
Charlie Parker
  • 5,884
  • 57
  • 198
  • 323
12
votes
3 answers

How to view all tables in CQL and CQLSH?

I'm trying to explore the database and want to see all tables that exist there. What's the command that's equivalent to SHOW TABLES; in SQL?
Ahmad Farid
  • 14,398
  • 45
  • 96
  • 136
12
votes
1 answer

How to change CQL version?

When i try to connect to cqlsh I get this error: Connection error: ('Unable to connect to any servers', {'127.0.0.1': ProtocolError("cql_version '3.3.1' is not supported by remote (w/ native protocol). Supported versions: [u'3.4.4']",)}) If I add…
Most31
  • 400
  • 4
  • 18
12
votes
4 answers

cassandra cql shell window got disappears after installation in windows

cassandra cql shell window got disappears after installation in windows? this was installed using MSI installer availalbe in planet cassandra. Why this happens ? please help me.. Thanks in advance.
Srinathji Kyadari
  • 221
  • 5
  • 15
11
votes
1 answer

CQLSH: Converting unix timestamp to datetime

I am performing a cql query on a column that stores the values as unix timestmap, but want the results to output as datetime. Is there a way to do this? i.e. something like the following: select convertToDateTime(column) from table;
DevOtts
  • 125
  • 1
  • 2
  • 5
11
votes
1 answer

Row Inserts having same primary key, are replacing previous writes in Cassandra

Created a table in Cassandra where the primary key is based on two columns(groupname,type). When I'm trying to insert more than 1 row where the groupname and type is same, then in such situation its not storing more than one row, subsequent writes…
Vikram
  • 817
  • 4
  • 22
  • 34
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
1 answer

Cassandra partition key for time series data

I'm testing Cassandra as time series database. I create data model as below: CREATE KEYSPACE sm WITH replication = { 'class': 'SimpleStrategy', 'replication_factor': 1 }; USE sm; CREATE TABLE newdata (timestamp timestamp, deviceid int, tagid…
Phuong Le
  • 377
  • 5
  • 16
1 2
3
…
53 54