Comment Comment by dmoura Things you can do with SPyQL CLI that you can't with clickhouse local (AFAIK, top of my mind, not exhaustive):- use python code in your queries- import python libs (just install them with pip/conda)- write your one UDFs in Python- run OS commands from within the query (using os.system)- have guaranty of row order (like in grep, sed, etc)And there is more, please take a look at: https://spyql.readthedocs.io/en/latest/distinctive.html parent dmoura 4 years ago
- use python code in your queries
- import python libs (just install them with pip/conda)
- write your one UDFs in Python
- run OS commands from within the query (using os.system)
- have guaranty of row order (like in grep, sed, etc)
And there is more, please take a look at: https://spyql.readthedocs.io/en/latest/distinctive.html