csvq

csvq copied to clipboard

Support compressed files.

1

### From [Discussions 73](https://github.com/mithrandie/csvq/discussions/73) Load data directly from compressed files. ``` $ csvq 'select * from `data.csv.gzip`' ``` Compressed files will be read-only and not updatable.

mithrandie

interactive shell problem - gibberish characters, backspace not working

2

version 1.17.10, windows 7 sp1 x64 Hi. Thanks for the effors. The project seems to answer some of my needs, but I'm having serious issues with the shell. When typing...

githubuser181226

Bumps [golang.org/x/crypto](https://github.com/golang/crypto) from 0.7.0 to 0.17.0. Commits 9d2ee97 ssh: implement strict KEX protocol changes 4e5a261 ssh: close net.Conn on all NewServerConn errors 152cdb1 x509roots/fallback: update bundle fdfe1f8 ssh: defer channel...

dependabot[bot]

--stats, -x should perhaps go to STDERR

2

If I run `-x` and redirect the stats go to the pipe, which of course messes it up. Would it therefor not be better to send that output to STDERR...

ondohotola

Do we need 8 decimal precision for seconds?

ondohotola

Column update from one Table to another based on a ID match

2

How can I Column update from one Table to another based on a ID match? I have one equery: csvq 'update nullbatches join file on nullbatches.Inv_date=file.Inv_date set nullbatches.Btc_no = file.Btc_no...

ahmedmohiduet

odd negative sign in modulo results

7

Hi! firstly, thank you so much for this tool. It's been amazingly helpful for me 🙇 . I wanted to file an issue about seeing **negative values** in the modulo...

kelvintaywl

Support fully qualified file names in CREATE TABLE and INSERT commands

3

In SELECT statements, i can specify a fully qualified file to be queried, e. g. `SELECT a, b, c FROM file:/foo/bar` However, in CREATE TABLE and INSERT statements (and probably...

KayKursawe

index out of range error when doing GROUP BY on empty table

1

If you have an empty table, and try to group by on it, then this error will occur. For example: ```bash touch oops.csv # Maybe a previous step gave an...

nijssen

Insert rewrites valid escaped entries wrong

2

Situation: We have a valid file, with newlines in a string, we can query: file: ``` ID,Username,Text,Counter 1,Laura Bow,"What a nice newline",0 ``` query: ``` csvq 'SHOW FIELDS FROM `new.csv`'...

derphilipp