medium10 pts · first answer countsdata-warehousinglakehouseperformance
Filtering on a non-partition column
A Delta table is partitioned by date, but most queries also filter on customer_id, and every file in a date must be read. What layout feature helps skip files?
Discussion 0
Join free to post in the discussion.
Related questions
- Partitioning a big tableData Engineer
- Kimball versus InmonData Engineer
- Bronze, silver and gold layersData Engineer
- Schema on read versus schema on writeData Engineer
- OLTP and OLAP workloadsData Engineer
- Why warehouses store columnsData Engineer
- Facts and dimensionsData Engineer
- Star versus snowflake schemaData Engineer