Reading parquet files (qbit) with DuckDB under DBeaver

read example

• Official documentation: https://duckdb.org/docs/data/parquet

• DBeaver variable reading example, note that the variable function is DBeaver, not DuckDB's own

   @set path='C:/Users/qbit/Desktop/simple.parquet'
  
  SELECT * FROM :path;
  
  SELECT * FROM ${path};
  
  SELECT * FROM read_parquet('C:/Users/qbit/Desktop/simple.parquet');
  
  SELECT * FROM read_parquet(:path);

  

Supported compression formats

• The current (2022.9.11) version of DuckDB is 0.5.0, and the supported parquet compression formats are

   UNCOMPRESSED
  SNAPPY (default)
  ZSTD
  GZIP

  

• Look at the enumeration values of the source code on github , the following may be supported in the future

   UNCOMPRESSED
  SNAPPY
  GZIP
  LZO
  BROTLI
  LZ4
  ZSTD

  

This article is from qbit snap