×
Open Data Processing Service

ODPS SQL - Transpose Column to Row or Row to Column

This article describes how to use TRANS_ARRAY and LATERAL VIEW EXPLODE functions to transpose columns to rows in MaxCompute.

MaxCompute Unleashed - Part 13: Global Zorder

This article introduces the support of Global Z-Order in MaxCompute.

MaxCompute Unleashed - Part 10: IF ELSE Branch Statement

Part 10 of the "Unleash the Power of MaxCompute" series introduces the script mode and parameterized views of MaxCompute.

MaxCompute Unleashed - Part 7: Grouping Set, Cube and Rollup

Part 7 of the "Unleash the Power of MaxCompute" series introduces MaxCompute's support for GROUPING SETS.

MaxCompute Unleashed - Part 3: Complex Type Functions

Part 3 of the “Unleash the Power of MaxCompute” series describes the complex type functions of MaxCompute.

MaxCompute Unleashed - Part 2: Basic Data Types and Built-in Functions

Part 2 of the “Unleash the Power of MaxCompute” series describes the basic data types and built-in functions of MaxCompute.

MaxCompute Unleashed - Part 5: SELECT TRANSFORM

Part 5 of the "Unleash the Power of MaxCompute" series introduces the support of MaxCompute for other scripting languages - SELECT TRANSFORM.

MaxCompute Unleashed - Part 4: CTE, VALUES, SEMIJOIN

Part 4 of the "Unleash the Power of MaxCompute" series describes the improvements of MaxCompute in the SQL DML.

MaxCompute Unleashed - Part 6: User Defined Type

Part 6 of the "Unleash the Power of MaxCompute" series describes a new feature called User Defined Type (UDT).

MaxCompute Unleashed - Part 1: Harnessing Compiler Errors and Warnings Effectively

Part 1 of the “Unleash the Power of MaxCompute” series describes the improvements of MaxCompute in usability.