[CASSANDRA-7172] cqlsh: Accept and execute CQL statement(s) from command-line parameter

• Type: New Feature
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.9, 2.1 rc1
• Component/s: Legacy/Tools
• Labels: cqlsh
• Assignee: Mikhail Stepura
• Reporter: PJ

Authors

Mikhail Stepura

Reviewers

Brandon Williams

• Created: 06/May/14 12:27
• Updated: 16/Apr/19 09:31
• Resolved: 08/May/14 22:38

Description

I don't know if there is a workaround for this, but currently, if I want to dump the output of a statement into a file, I need to save the statements into another file and pass it as input to cqlsh. Something like:

$ cqlsh -f [statement_file] > [output_file]

I am aware of the existence of the cqlsh CAPTURE command but it doesn't work for everything (particularly, for cqlsh-only commands like DESCRIBE)

To solve this, I propose that you add an "-e" parameter to cqlsh that accepts a valid CQL statement to execute. This is exactly the same as MySQL CLI's "-e" parameter: http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_execute