search

xo / usql

Universal command-line interface for SQL databases
MIT License
8.81k stars 346 forks source link

Is there any plan to support parquet or orc format? #433

Closed lij55 closed 7 months ago

lij55 commented 7 months ago

usql is a good tool for data migration and I used it a lot! Thanks for the great job.

Parquet and orc has embedded schema information and better compression rate compared with csv and json. they can be 'queried' by sql as well (https://github.com/apache/arrow, https://github.com/apache/arrow-datafusion)

could usql support parquet as a source and target?

kenshaw commented 7 months ago

I believe DuckDB supports parquet files, as such I think usql already supports it?

lij55 commented 7 months ago

yeah, seems so...thanks. let me try it.