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

Can someone help me point my cql shell to my apache database

Can someone help me point my cql shell to my apache database instead of my localhost? I need to be able to change it with the cql shell at the cqlsh prompt. I have the address.
On The Fly
  • 1
  • 1
-1
votes
1 answer

Cassandra: epoch time retrieval issues

I am storing epoch time ( number of millis) in C* db, but when it comes to retrieving the row data back, i am getting data in following format. starts: { low: 1753507485 high: 330 unsigned: false } My table structure looks like following: CREATE…
Gaurav Gupta
  • 4,586
  • 4
  • 39
  • 72
-1
votes
2 answers

How to connect to Apache Cassandra with JDBC?

I'm trying to connect to Cassandra from Java code using JDBC connection. Here are the jars I'm using Now this is the code which I found in the Stackoverflow to do this: String serverIP = "localhost"; String keyspace = "mykeyspace"; Cluster cluster…
Abhinab Kanrar
  • 1,532
  • 2
  • 20
  • 46
-1
votes
1 answer

copy table in cassandra

i am using below commands for coping data COPY events.standardevents (uuid, data, name, time, tracker, type, userid) TO 'temp.csv'; truncate standardevents; COPY event.standardeventstemp (uuid, data, name, time, tracker, type, userid) FROM…
Helping Hand..
  • 2,430
  • 4
  • 32
  • 52
-2
votes
2 answers

Can we use COPY command to load files from FTP server?

We have a scenario where we need to run a Cassandra COPY command get file from FTP server and load data in to Cassandra Tables?
kumar bharath
  • 31
  • 1
  • 2
-2
votes
1 answer

Accessing data from Cassandra using java

I have multi-lingual text crawled from various websites using apache nutch in Cassandra database. I have also defined a Java class for translation using the bing client. But can anyone tell me how to connect to Cassandra and translate the…
Akhilesh Reddy
  • 13
  • 1
  • 2
-2
votes
1 answer

Importing csv file in Cassandra Database throws error Record #0 (line 1) has the wrong number of fields 1 instead of 7

AM using the copy method for copying the CSV file into the Cassandra tables.. But am getting records error of has wrong number of fields . Query is ---COPY activity FROM 'Detail.csv' with HEADER=TRUE i have my activity as column family with 7…
Kunal
  • 57
  • 2
  • 11
-3
votes
1 answer

Cassandra Java driver Performance : CQL Queries with IN Clause having high no of values

We are using Datastax Cassandra java driver (version 3.x). There is a logged batch Select statement with 'IN' clause, having a high number of values. Due to which we are facing a serious issue of low performance. Following is the format of query…
Himanshu Singh
  • 199
  • 3
  • 15
1 2 3
…
53
54