q
q copied to clipboard
harelba
q - Run SQL directly on delimited files and multi-file sqlite databases
See http://harelba.github.io/q/examples.html What is `clicks.csv`? What is it supposed to look like so that I can reproduce these examples?
The tool q is useful but has limitations. I think the following features can be really useful additions to it. 1. Smart auto detection of (best) field delimiters. It's appealing...
Hello. When I run q on Windows (version from installer) it prints Python warning at the end of the generated csv. `WARNING: file already exists but should not: C:\Users\836D~1\AppData\Local\Temp\1\_MEI26442\include\pyconfig.h` Commands...
Hey there, just a quick heads up. I just tried installing using the Windows installer on a corporate machine running Trend Micro OfficeScan, and i flags the installer as malicious....
Hi, I have lot of csv file without header, so I thought to add an header file but I get something like this: ``` $ echo f1,f2 > h.csv $...
I want to compare values from 2 seperate csv files , for instance a trivial query like this , but I get an error that the column doesn't exist ```...
Hi: I have a column like 1000247787770076600034, and it output 1.00024778777e+21. How can I output the column as a string? Thank you.
I have been testing **q** and I've found something that could be an issue. **Issue** When I'm doing something like `round(avg(c3),3)` when querying, is rounding this **32655,5265** to this **32655,526**...
I think it's a good idea to create a mapping of headers (to unique valid field identifiers). The reason is that the header of a structured text is not always...
I used sample data from https://support.spatialkey.com/spatialkey-sample-csv-data/ Under Company Funding Record (TechCrunchcontinentalUSA.csv) I had to change the to first in the text file. I do not know what to pass to...
