New Features

MaxCompute - Dynamic Filter Feature Released

Apr 07 2021

MaxCompute releases the Dynamic Filter feature, an intelligent optimization feature that makes job execution more efficient.

Target customers: developers, analysts, and users who want to optimize SQL operations. Features released: JOIN is a common operation in distributed systems. If you perform a JOIN operation on a large amount of data, the operation is both time-consuming and resource-consuming. MaxCompute now releases the Dynamic Filter feature to accelerate JOIN operations. This feature uses the equi-join attribute of JOIN operations and the filter that is dynamically generated during execution to filter data before the data is shuffled or joined. This accelerates queries. This feature is ideal for the scenarios in which JOIN operations are performed on dimension tables and fact tables. You can use flags to forcibly or intelligently enable the Dynamic Filter feature for a session. You can also specify hints in SQL statements to enable this feature for a session. In addition, you can use the dynamic partition pruning method to filter partitions before you use dynamic filters.

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.