q
q copied to clipboard
harelba
q - Run SQL directly on delimited files and multi-file sqlite databases
Reusing a file that has already been loaded in the past should be faster. Can be that by some form of caching the loaded data.
First of, q is a great product. It allows me to read a huge file, 5GB, without Out of Memory errors. I'm missing around 20K lines between what `wc -l`...
Hi, Is there a limit to the number of columns. THis file had columns uptil "N" $ q "select * from .\Extractor\xxx.csv" WARNING: file already exists but should not: C:\Users\pstep\AppData\Local\Temp\_MEI10122\include\pyconfig.h...
[Feature request] Release AUR package. Or are there Build instructions around? Unfortunately I failed to find them. Thanks you in advance for guidance.
Running `q` with `-e utf-9-sig` results in: Encoding utf-9-sig could not be found The `-e` flag is necessary when a CSV file starts with a byte order mark (BOM). Update...
I am developing on a mac, q version on mac: ``` q version 2.0.19 Python: 3.9.4 (default, Apr 5 2021, 01:50:46) // [Clang 12.0.0 (clang-1200.0.32.29)] ``` and delivering on windows,...
There is a typo in the help text if a column can't be found. This outputs the correct encoding help text.
q is a marvelous tool, thank you! One thing that would be very useful is an option to emit column headers in the output, analogous to `-H` for input. These...
Please add documentation about the encodings supported. I tried `iso-8859` and was given `Encoding iso-8859 could not be found`. What is the list of encodings?
I wish to use q with some very large TSV files, the header line of each of which has trailing tabs corresponding to certain deliberately unnamed columns. It would of...
