q icon indicating copy to clipboard operation
q copied to clipboard

q - Run SQL directly on delimited files and multi-file sqlite databases

Results 122 q issues
Sort by recently updated
recently updated
newest added

When I try to pass a relative link to q it complains that there is no file matching the path. However, if I immediately `stat` the path it complains about,...

The first query works: ``` `$ q -H -d"," "SELECT * FROM JGI_strains.csv WHERE Platform='Illumina'" 1,Hernandeziana,sp.,ATA11-4-KO1,Illumina 2,Aetokthonos,hydrillicola,B3-Florida,Illumina 3,Aphanocapsa,lilacina,HA4352-LM1,Illumina 4,Aphanocapsa,sp.,GSE-SYN-MK-11-07L,Illumina 5,Aphanothece,saxicola,GSE-SYN-MK-01-06B,Illumina 6,Aphanothece,sp.,CMT-3BRIN-NPC111,Illumina 7,Brasilonema,angustatum,HA4187-MV1,Illumina ... ` ``` But if I try an...

``` echo "x,1;y,2;z,3" | q -d "," "select * from -" ``` will produce `x,1;y,2;z,3` is it possible to perceive another character at the end of the line?

It's a minor request, but would be nice to have a URI always pointing for the latest stable version, thus people could use it for installing q in automated scripts....

Please can we have an apk of this project. It is in Arch already, an """ apk add q """ would be good .

First off, thanks for creating `q`. It's wonderful. One thing that seems like it would be really useful is if there was a REPL that allowed you to pass the...

I'm working with zip files with multiple csv bundled. It will be great if I can join multiple csv in a zip as if they are multiple tables.

When doing a select on a CSV that has a numeric column, "3873194.8699999987" gets rounded to "3873194.87". Please prevent this or introduce a parameter to control it. Thanks!

Maybe consider adding an option to parse pretty printed _input_, to complement `-b` for pretty printed output. I use `q` on `kubectl` output, but when one of the values has...