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.