This is an automated email from the ASF dual-hosted git repository. dkuzmenko pushed a commit to branch branch-4.0 in repository https://gitbox.apache.org/repos/asf/hive.git
commit b28367f5d1a2fddb3cbcfdf808dd24fc068b038b Author: seonggon <[email protected]> AuthorDate: Fri Dec 8 22:50:34 2023 +0900 HIVE-27856: Disable CTE materialization by default (Seonggon Namgung, reviewed by Denys Kuzmenko) Closes #4858 (cherry picked from commit 753136e036499dc68b4a8690f27b44e7186d8805) --- common/src/java/org/apache/hadoop/hive/conf/HiveConf.java | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java b/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java index 1fa63ae3821..c2ba7561259 100644 --- a/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java +++ b/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java @@ -2748,9 +2748,11 @@ public class HiveConf extends Configuration { + " provides an optimization if it is accurate."), // CTE - HIVE_CTE_MATERIALIZE_THRESHOLD("hive.optimize.cte.materialize.threshold", 3, + HIVE_CTE_MATERIALIZE_THRESHOLD("hive.optimize.cte.materialize.threshold", -1, "If the number of references to a CTE clause exceeds this threshold, Hive will materialize it\n" + - "before executing the main query block. -1 will disable this feature."), + "before executing the main query block. -1 will disable this feature.\n" + + "This feature is currently disabled by default due to HIVE-24167.\n " + + "Enabling this may cause NPE during query compilation."), HIVE_CTE_MATERIALIZE_FULL_AGGREGATE_ONLY("hive.optimize.cte.materialize.full.aggregate.only", true, "If enabled only CTEs with aggregate output will be pre-materialized. All CTEs otherwise." + "Also the number of references to a CTE clause must exceeds the value of " +
