hard20 pts · first answer countslakehouseperformanceclustering

Clustering for two filter columns

Queries on a large lakehouse table filter by customer_id in some reports and by product_id in others. Sorting by customer_id alone makes the product queries scan almost everything. What helps both?

A.Partition by both columns, creating millions of foldersB.Convert the table to CSVC.Sort by product_id onlyD.Multi-dimensional clustering such as Z-ordering or liquid/Hilbert clustering on both columns, so file min/max ranges are tight for each

← Copy-on-write vs merge-on-read Choosing a Redshift DISTKEY →