[REVIEW] (HIVE-29217) Add configuration to choose materialization strategy for CTEs

[Stamatis Zampetakis]

Can someone please take a look:
https://github.com/apache/hive/pull/6092

Best,
Stamatis