Update: 1. Query 2, 71: Resolved in HIVE-27006 [1]; 2. Query 97: Under review in HIVE-27269 [2]; Thanks, Seonggon for providing a reproduce qfile.
3. Query 14: Reported in HIVE-24167 [3]; set hive.optimize.cte.materialize.threshold to -1 by default in Hive 4 and fix it in the next versions 4. HIVE-26986 [4] is a performance improvement that is nice to have, but not a blocker for the release. Be advised, next week we plan to cut 4.0.0 release branch from master and start testing. Thanks, Denys [1] https://issues.apache.org/jira/browse/HIVE-27006 [2] https://issues.apache.org/jira/browse/HIVE-27269 [3] https://issues.apache.org/jira/browse/HIVE-24167 [4] https://issues.apache.org/jira/browse/HIVE-26986