[IMPALA-8673] Add query option to force plan hints for insert queries

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 3.3.0
• Fix Version/s: Impala 3.3.0
• Component/s: Backend, Frontend
• Labels: performance ramp-up regression
• Epic Color: ghx-label-1
• Assignee: Abhishek Rawat
• Reporter: Lars Volker
• Created: 18/Jun/19 18:06
• Updated: 07/Feb/23 11:14
• Resolved: 03/Jul/19 17:55

Description

In Impala 3.0 we turned on insert clustering by default (IMPALA-5293). This can lead to performance regressions from 2.x for highly skewed data sets. To help with those cases, we should add a way to force plan hints for insert queries through a query option.