CCMPrepare Example - Teradata Vantage

Input

The input table, ccmprepare_input, is a collection of nine time series consisting of 10 values for each of three variables (expenditure, income, and investment).

SQL Call

This call splits the input sequences (column_id) into two partitions. The odd and even sequences that are partitioned are identified by column aster_ccm_id in the output.

DROP TABLE ccm_input;

CREATE MULTISET TABLE ccm_input DISTRIBUTE BY AS (
  SELECT * FROM CCMPrepare (
    ON ccmprepare_input PARTITION BY id
  ) AS dt
) WITH DATA;

Output

This query returns the following table:

SELECT * FROM ccm_input ORDER BY 1, 2, 3;