New Features

MaxCompute - Supports Freeride and Analyze to Collect Metadata for Optimizers

Feb 08 2021

MaxCompute supports Freeride and Analyze to collect metadata for optimizers. Freeride is used for synchronous collection and Analyze for asynchronous collection. These tools optimize computing and query performance.

Target customers: developers and analysts. Features released: The MaxCompute SQL optimizer is a cost-based optimizer. It can accurately estimate the costs based on the metadata of tables. The metadata includes the number of rows and the average length of strings. If the optimizer cannot obtain accurate metadata, the optimizer may miscalculate the costs and generate inappropriate execution plans. Therefore, metadata collection is crucial for the optimizer. MaxCompute now provides two tools to collect the metadata of tables: Analyze for asynchronous collection: If you use Analyze, you must run commands to proactively and asynchronously collect table data. You are charged for table data scans. Freeride for synchronous collection: If you use Freeride, you must configure runtime parameters to enable Freeride and collection plans before you execute the CREATE TABLE...AS... or INSERT statement. Column statistics are automatically collected while data is generated. This method is more automated but may prolong your query. MaxCompute does not collect your sensitive information, such as business information.

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.