Hi Sungwoo, Thank you for bringing this up again.
Based on HIVE-26654, it looks like we have 3 PR pending review: 1. HIVE-26986 - Query 71 2. HIVE-27006 - Query 2 3. HIVE-27269 - Query 97 (is that ready to be reviewed?) We'll prioritize those. For query 14, as you suggested, we might set `hive.optimize.cte.materialize.threshold to -1` by default for now and fix it in the following releases. Thanks, Denys