partition_column |
Any allowed by PARTITION BY clause |
[Column appears one time for each specified partition_column.] Column to which to partition input data. |
target_column |
CHAR,VARCHAR,BYTE,VARBYTE,BYTEINT,SMALLINT,INTEGER,BIGINT,FLOAT,REAL,DOUBLE PRECISION,DECIMAL,NUMBER,DATE,TIME,TIMESTAMP,TIME WITH TIME ZONE,TIMESTAMP WITH TIME ZONE,INTERVAL SECOND,INTERVAL MINUTE TO SECOND,INTERVAL MINUTE,INTERVAL HOUR TO SECOND,INTERVAL HOUR TO MINUTE,INTERVAL HOUR,INTERVAL DAY TO SECOND,INTERVAL DAY TO MINUTE,INTERVAL DAY TO HOUR,INTERVAL DAYINTERVAL MONTH,INTERVAL YEAR TO MONTH,INTERVAL YEAR |
Column to be pivoted. |
accumulate_column |
Any |
[Column appears one time for each specified partition_column.] Column to copy to output table from input table. |