Queries Acceleration -Tuning- Tuning Execution 学习笔记
1 Adjustment of RuntimeFilter Wait Time
1.1 Case: Too Short RuntimeFilter Wait Time
1.1.1 没有看懂,好像是等待时间过小也会导致性能下降
1.1.2 set runtime_filter_wait_time_ms = 3000;
2 Data Skew Handling
2.1 Case 1: Bucket Data Skew Leading to Suboptimal Shuffle Method
2.1.1 skew data can use shuffle hint to tuning
JOIN [broadcast]
2.1.2 To solve this performance bottleneck, refer to the tuning techniques mentioned in the “Using Hint to Control Join Shuffle Method” section and specify the broadcast/shuffle join hint
2.2 Case 2: Column Data Sk