16.20 - Example: Defining the Partition to Which a Row is Assigned - Advanced SQL Engine - Teradata Database

Here is an example that uses CASE_N and the value of the totalorders column to define the partition to which a row is assigned:

   CREATE TABLE orders 
    (storeid INTEGER NOT NULL
    ,productid INTEGER NOT NULL
    ,orderdate DATE FORMAT 'yyyy-mm-dd' NOT NULL
    ,totalorders INTEGER)
    PRIMARY INDEX (storeid, productid) 
     PARTITION BY CASE_N(totalorders < 100, totalorders < 1000,
                         NO CASE, UNKNOWN);

In the example, CASE_N specifies four partitions to which a row can be assigned, based on the value of the totalorders column.