DuckDB Study Flashcards
In-process analytical database engine built for lightning-fast vectorized SQL queries over local files. Click any card to flip and test your knowledge.
What is DuckDB?
An embedded columnar analytical database engine (often called the SQLite for Analytics).
What is vectorized execution in DuckDB?
Queries process vectors of data values in CPU cache lines using SIMD instructions for maximum throughput.
Can DuckDB read Parquet files directly?
Yes, DuckDB can execute SQL queries directly against local or remote Parquet and CSV files without importing them into tables.
How does DuckDB integrate with Python Pandas/Polars?
DuckDB can query Pandas DataFrames, Polars DataFrames, and Arrow tables directly zero-copy.
Does DuckDB support the QUALIFY clause?
Yes, DuckDB supports Snowflake-style QUALIFY clauses to filter window function outputs directly.
Is DuckDB single-threaded or multi-threaded?
DuckDB automatically parallelizes query execution across all available CPU cores.
What is read_parquet('s3://...')?
A function allowing direct HTTP/S3 querying of remote Parquet data lakes.
How does DuckDB handle memory limits?
DuckDB gracefully spills intermediate data to disk when query memory usage exceeds RAM limits.
What is COPY TO in DuckDB?
Exports query results directly into Parquet, CSV, or JSON files on disk.
Does DuckDB support ACID transactions?
Yes, DuckDB features full ACID transactional semantics using Multi-Version Concurrency Control (MVCC).
Need practical SQL queries for DuckDB?
Explore our ready-to-use copy-paste query recipes in the Cookbook.