Hi all,

We have completed the Spark 3.0 Adaptive Query Execution(AQE) performance tests in 3TB TPC-DS on 5 node Cascade Lake cluster. 2 queries bring about more than 1.5x performance and 37 queries bring more than 1.1x performance with AQE.  There is no query has significant performance degradations. The detail performance results and key configurations are shown in here. Based on the performance result, we recommend users to turn on AQE in spark 3.0. If encounter any bug or improvement when enable AQE, please help to file related JIRAs. Thanks.

 

Regards,

Jia Ke