Is there any way to prettify the results of cql commands in the Linux terminal while using the cqlsh utility (cql version of Mongo .pretty())? It becomes quite difficult to read the results when the output is displayed normally, especially when there are nested documents and arrays
Best How To :
cqlsh is a python script that uses the datastax python-driver to make queries to cassandra. You can modify the script to meet your needs (see: Why does cqlsh right-align strings? for an example), or you can write a program using the python-driver or another library to do what you need.
Since mongo is document-oriented, it makes sense that pretty-printing is an available option. However cassandra is more columnar / row-oriented so you don't typically look at result sets like documents, instead you look at them more like rows, although I do see the utility in a 'pretty-print' like function.