New Features

MaxCompute - Enhanced SQL nested column pruning

Jul 30 2026

MaxCompute
Nested column pruning is a MaxCompute performance optimization for queries on complex types. When a table contains nested types such as STRUCT, ARRAY, MAP, or multi-layer composite nested types, queries typically access only a small subset of fields. When enhanced nested column pruning is enabled, MaxCompute scans only the actually needed subfields when reading data, avoiding unused nested fields. This reduces storage I/O, lowers memory overhead, and improves query performance.
Content

Target customers: All customers. New features /specifications: Nested column pruning is a MaxCompute performance optimization for queries on complex types. When a table contains nested types such as STRUCT, ARRAY, MAP, or multi-layer composite nested types, queries typically access only a small subset of fields. When enhanced nested column pruning is enabled, MaxCompute scans only the actually needed subfields when reading data, avoiding unused nested fields. This reduces storage I/O, lowers memory overhead, and improves query performance.

7th Gen ECS Is Now Available

Increase instance computing power by up to 40% and Fully equipped with TPM chips.
Powered by Third-generation Intel® Xeon® Scalable processors (Ice Lake).

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.