unpivot [name_column: const string]?, [value_column: const string]?, [name_value: col storable]+

The unpivot verb rotates a table by transforming a list of columns into rows.

This verb can be used to turn a wide table (e.g. timestamp, percent_load, percent_mem, percent_disk) into a narrower table (e.g. timestamp, op, percent). unpivot is not the exact reverse of pivot as it cannot undo the aggregations done in pivot.

The arguments are as follows:

• name_column: Specifies the name of the name column which stores the name of the column a value comes from. Must be a constant string. Optional. Default value is name.
• value_column: Specifies the name of the value column which stores values from each of the name_value columns passed in. Must be a constant string. Optional. Default value is value.
• name_value_0, ..., name_value_n: List of columns to generate rows from.

Additional details:

• The name_column and value_column arguments, if specified, need to be specified together
• The name and value columns will be inserted where the first name_value column used to be
• unpivot is not supported for resource datasets
• unpivot will drop the primary key and any candidate keys
• group_by and order_by specifications are not allowed

Categories

• Aggregate

Accelerable

unpivot is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

unpivot percent_load, percent_mem, percent_disk

Consider the following input table A:

The above statement transforms table A to:

unpivot "op", "percent", percent_load, percent_mem, percent_disk

The above statement transforms table A to: