q
q copied to clipboard
harelba
q - Run SQL directly on delimited files and multi-file sqlite databases
Customer's use case: Example: File a.csv: Name;Val A;1 B;2 C;3 File b.csv: Name;Val A;10 B;11 select f1.name , ifnull(f2.val,0) as val from e:\a.csv f1 left join e:\b.csv f2 on f1.name...
Column types are autodetected and handled properly. However, there are some cases where it is possible that a numeric column will be treated as text, depending on the actual sample...
Couldn't find a good sql parser in python, so there are some ugly hacks there. If anyone knows a good sql parser for python, i'll be glad to integrate it.
Currenty, only in memory sqlite is being used. The tool could be used in more situations if data could be written using an external database.
I would like to use q in a cluster environment. However, the cluster does not support brew but it supports conda (there are ways of making q work but it's...
I'm upgrading to 3.1.6 from 2.1.x after brew's version of this stopped working. And I can't get it to run successfully at all even on a very basic file such...
### TLDR When installing `q` as a python package from the source, calling `q` fails because the `bin` package is not found (essentially because installation fails). ### Reproduce the error...
First of all, I want to say that I really liked this tool. This is an amazing, I have one question. Why **q** is slow about two times on production?...
