db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

List and hash

LIST partitions match listed values. HASH partitions spread rows by hash of the key. Build one of each.

task

Create cp(customer_id, country) partitioned by LIST of country with cp_eu (DE, FR, ES, PT) and a default partition, and ch(customer_id) partitioned by HASH with 4 partitions.

hints