All tasks

Composite Distribution Key

Intermediate

Create a table order_items with columns: order_id (INTEGER), product_id (INTEGER), quantity (INTEGER), unit_price (DECIMAL(10,2)). Use the composite distribution key DISTRIBUTED BY (order_id, product_id).

Category
Greenplum DDL
Estimated time
~15 min
Databases
Greenplum
Tags
DDLCREATE TABLEDISTRIBUTED BYсоставной ключ

Sign in to solve

Start Solving