Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
Impala 2.8.0, Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
-
ghx-label-3
Description
The analysis of statements with big VALUES clauses like INSERT INTO <tbl> VALUES is slow due to expression rewrites like constant folding. The performance of such statements has regressed since the introduction of expr rewrites and constant folding in IMPALA-1788.
We should skip expr rewrites for VALUES altogether since it mostly provides no benefit but can have a large overhead due to evaluation of expressions in the backend (constant folding). These expressions are ultimately evaluated and materialized in the backend anyway, so there's no point in folding them during analysis.
Similarly, there is no point in doing codegen for these exprs in the backend union node.
Workaround
SET ENABLE_EXPR_REWRITES=FALSE; SET DISABLE_CODEGEN=TRUE;
Attachments
Issue Links
- is duplicated by
-
IMPALA-5277 Lower-latency DML w/ VALUES stmts to Kudu
- Resolved
- split to
-
IMPALA-8041 Migrate rewrite rules to occur during expression analysis
- Open