The output table schema depends on whether you specify the syntax element NumberOfRows or PivotColumn.
Output Table Schema, NumberOfRows
Column |
Data Type |
Description |
partition_column
|
Same as in input table
|
[Column appears once for each specified partition_column.] Column by which input data is partitioned. |
value_i
|
Any |
[Column appears number_of_rows times.] Value in ith target column, where i is in range [0, number_of_rows-1]. Columns appear in order specified by ORDER BY clause. |
Output Table Schema, PivotColumn
Column |
Data Type |
Description |
partition_column
|
Any |
[Column appears once for each specified partition_column.] Column by which input data is partitioned. |
value_target_column
|
Any |
[Column appears once for each pivot_key.] Values for pivot_key that are associated with partitions in row. |