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
1 answer

write like query using cassandra

How to write the like query in cassandra. select * from user where user_name like '%abcd%' How to write it into CQL(Cassandra query language) Because i have to search some content base on keyword.
user3359503
  • 31
  • 1
  • 7
0
votes
2 answers

How should I insert decimal values via cqlsh (DecimalSerializer.deserialize error when attempting)?

In cqlsh I'm trying to insert a record with: INSERT INTO data…
jcollum
  • 43,623
  • 55
  • 191
  • 321
0
votes
0 answers

cqlsh query on secondary indexed column rpc timeout

I am finding trouble in why my query in secondary indexed column in cassandra getting rpc timeout. Here is my details about the cassandra and table [cqlsh 4.1.1 | Cassandra 2.0.7 | CQL spec 3.1.1 | Thrift protocol…
Gagan
  • 4,278
  • 7
  • 46
  • 71
0
votes
1 answer

Comparison based on Dates

I have one table in Cassandra :- CREATE TABLE printerload ( gp_date timestamp, printed_cost float, printed_pages int, saved_cost float, saved_pages int, PRIMARY KEY (gp_date) ) I have inserted data in the table :- cqlsh>…
Nayan
  • 353
  • 3
  • 5
  • 16
0
votes
1 answer

Cassandra: rpc_timeout when inserting in a new table in a cluster

I am using Cassandra 2.0.3 and I drop and recreate a simple table via cqlsh by loading a file (source command). In the same file, I insert some rows in the newly created table. About once every 3-4 tries, I get rpc_timeout on some of the…
Benoit Thiery
  • 6,325
  • 4
  • 22
  • 28
0
votes
1 answer

Cassandra long row with different data types

I have read the following article about Cassandra CQL3 and Thrift API http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows In the article, they give an example on creating a scheme for gathering data from sensors. They show a…
Guy Wald
  • 599
  • 1
  • 10
  • 25
0
votes
1 answer

Cassandra 2.0.3 cqlsh Fail to start

I configured source code of Cassandra 2.0.3 in eclipse. JDK:jdk1.7.0_45 Win 7-32 bits, python 2.7.3 python but cqlsh just doesnt start. Please help me what can be the possible problem?
user1540371
  • 99
  • 2
  • 9
0
votes
1 answer

Can the Kundera API handle MyObj inside MyParentObj when used with Cassandra

I've seen a lot of Kundera examples where the object being store is fairly simple. You have something like a Car.class and it contains a couple String variables maybe an int mapped using the @Column annotation. I've even seen some List, Set and Map…
Justin
  • 859
  • 4
  • 15
  • 30
0
votes
1 answer

cassandra: get columns of a wide row in reverse order with some filtering

I understand that cassandra does not support order by with secondary indexes but I really do not want order by feature. All I want is an ability to get columns in ascending or descending order as stored in column family since cassandra already sorts…
user2903819
  • 180
  • 2
  • 12
0
votes
1 answer

Is it possible for cassandra cqlsh ORDER BY with out using composite and super column?

If i am using sing primary key in my table in that situation ORDER BY is possible in cassandra cqlsh query. Is there any solution for this.
Hari Haran
  • 1,543
  • 4
  • 13
  • 25
0
votes
2 answers

Column family created with phpcassa is not visible by cqlsh and vice versa

I just created Column family by phpcassa , Following is the code $sys = new SystemManager('127.0.0.1'); $sys->create_column_family('demo', 'Users'); $pool = new ConnectionPool('demo', array('localhost')); $users = new ColumnFamily($pool,…
HRK
  • 287
  • 2
  • 15
0
votes
1 answer

Cassandra Composite Column Family

I have a simple requirement in sql world i want to create CREATE TABLE event_tracking ( key text, trackingid timeuuid, entityId bigint, entityType text userid bigint PRIMARY KEY (key, trackingid) ) I need a cli create command which is…
plzdontkillme
  • 1,497
  • 3
  • 20
  • 38
-1
votes
1 answer

Datastax DevCenter, fail to connect to cassandra on CentOS7 at VMware 10

I installed cassandra 3.11.3 on VMware workstation 10. also installed CentOS7 in there. after that, i installed datastax DevCenter on windows host pc. the windows version is 10. but I can't connect to cassandra on VM. this is casasndra…
woojin park
  • 41
  • 1
  • 1
  • 5
-1
votes
1 answer

Cassandra - unable to start server

I have a cassandra server set up on Unix with Bash. I have made no changes to cassandra.yaml On the command cassandra -f , I get the following errors and exceptions - grep: illegal option -- A Usage:grep[-c|-l|-q][-bhinsvwx]pattern_list[file ...] I…
Vaneet Singh
  • 61
  • 1
  • 6
-1
votes
1 answer

retrieving data from cassandra database

I'm working on smart parking data stored in Cassandra database and i'm trying to get the last status of each device. I'm working on self-made dataset. here's the description of the table. table description select * from parking.meters need help…
Khalil Zemni
  • 11
  • 2
1 2 3
…
53
54