Executing CQL through Shell Script?

cassandra cql cassandra-2.0 cqlsh
Immadisetty picture Immadisetty · Aug 13, 2014 · Viewed 37.2k times · Source

I am trying to execute the CQL commands from shell script. I am able to connect to the cqlsh (CQL version i'm using is 1.1.18) but unable to send the queries to cql.

Any ideas or suggestion how to proceed on this? Do I need to connect to Cassandra and execute few commands (select/update ) with shell script ??

Answer

zqhxuyuan picture zqhxuyuan · Nov 2, 2015 
cqlsh -e "select * from ks.table limit 1;" > ~/output

Related questions

Trying to login to cassandra's console (cqlsh) and it rejects me

I was trying to set up the user authentication for cassandra when I had the following problem. First I have updated the cassandra.yaml with: authenticator: PasswordAuthenticator then created the system_auth keyspace with a replication_factor of 3 as: CREATE …

Read More
How to run cql files (.cql) from within cqlsh?

The problem that I am having is that I want to run the following command (and I can't): cqlsh < cql_directory/cql_create_stuff.cql Because I have not logged in to cqlsh. So I logged in: cqlsh -u …

Read More
How do secondary indexes work in Cassandra?

Suppose I have a column family: CREATE TABLE update_audit ( scopeid bigint, formid bigint, time timestamp, record_link_id bigint, ipaddress text, user_zuid bigint, value text, PRIMARY KEY ((scopeid, formid), time) ) WITH CLUSTERING ORDER BY (time DESC) With two …

Read More