Using find -name "songs.csv" to find out that the csv file was exported to the directory where I ran cqlsh command.
find -name "songs.csv"
csv
cqlsh