Help! Does IMPORT CSV support compressed files?

Hello everyone
Just wondering if the IMPORT statement supports compressed files, e.g. table.csv.gz
I have some fairly large tables (~20 GB) to import and it would make it easier if they could be compressed.

Also is there a way to specify a different column order? It seems like the CSV has to be in the same order as the create table statement.
Thanks.

not yet, but it’s on our radar: https://github.com/cockroachdb/cockroach/issues/25149

as is re-mapping/re-ordering columns: https://github.com/cockroachdb/cockroach/issues/24426

I think if you are in a hurry, you can write a script to decompression these files.
For example, if you are using Java,you can use Apache Commons Compress™, this library is powerful.
I think there are many useful decompression tools in other language.
And then you can import the CSV files :))