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 IF EXISTS ccm_input; CREATE TABLE ccm_input DISTRIBUTE BY hash(aster_ccm_id) AS SELECT * FROM CCMPrepare ( ON ccmprepare_input PARTITION BY id );