I'm new in cassandra, and I have to export the result of a specific query to a csv file.
I found the COPY
command, but (from what I understand) it allows you only to copy an already existing table to a csv file, and what I want is to copy directly the stdout of my query to the csv file. is there any way to do it with COPY
command or with another way ?
My command is style (select column1, column2 from table where condition = xy
) and I'm using cqlsh
.
Best Answer
If you don't mind your data using a pipe ('|') as a delimiter, you can try using the
-e
flag on cqlsh. The-e
flag allows you to send a query to Cassandra from the command prompt, where you could redirect or even perform a grep/awk/whatever on your output.Older versions of cqlsh don't have the
-e
flag. For older versions of cqlsh, you can put your command into a file, and use the-f
flag.From here, doing a
cat
on output.txt should yield the same rows as above.