q
q copied to clipboard
harelba
q - Run SQL directly on delimited files and multi-file sqlite databases
…with "-d '|'" for example related to pipe-separated-values file I interpreted this filename (`myfile.delimited-file-with-pipes`) as a delimiter-separated-values file for which the delimiter is pipe ('|'). Given this section of the...
e.g. `$ q -d, -H -O "SELECT * FROM mycsv.csv mytable WHERE mytable.a IS DISTINCT FROM mytable.b"` `No files matching '/tmp/mytable.b' have been found` It seems It interprets `IS DISTINCT...
### What happened？ There are 1 security vulnerabilities found in certifi 2019.11.28 - [CVE-2022-23491](https://www.oscs1024.com/hd/CVE-2022-23491) ### What did I do？ Upgrade certifi from 2019.11.28 to 2022.12.07 for vulnerability fix ### What...
Fix for #301 This fixes the issue where you cannot install from `setup.py` by setting the package explicitly.
After installing q 3.1.6 on Ubuntu-20.04 with Python 3.8.10 and running `q "select * from my.csv" | less`, it logs this when exiting from less: ``` Exception ignored in: BrokenPipeError:...
### What happened？ There are 1 security vulnerabilities found in urllib3 1.25.8 - [CVE-2021-33503](https://www.oscs1024.com/hd/CVE-2021-33503) ### What did I do？ Upgrade urllib3 from 1.25.8 to 1.26.5 for vulnerability fix ### What...
Using TAB delimited header (-T) when running v3.1.6: A file with the header that I've attached is generating an error that makes it appear that it is parsing the header...
Since https://github.com/Homebrew/brew/pull/12493 trying to install q with homebrew returns: `Error: q has been disabled because it requires PyOxidizer, which is a disallowed dependency in homebrew/core!`
The warning displayed when `There seems to be a "no such column" error` incorrectly suggests: ``` Files that are encoded with UTF8 and contain a BOM can be read by...
I have a 10Gb TSV file that I'd like to read using SQL commands. As a TSV, tab-separated value file, it is a spreadsheet-like file in that it has headings/columns...
