All tasks

List Partitioning

Intermediate

Create a customers table with columns: customer_id (INTEGER), customer_name (VARCHAR(100)), region (VARCHAR(50)), created_at (DATE). Partition by list of regions: Moscow, Saint Petersburg, Other.

Category
Greenplum DDL
Estimated time
~20 min
Databases
Greenplum
Tags
DDLPARTITION BY LISTпартиционированиерегионы

Sign in to solve

Start Solving