Stamatis Zampetakis created HIVE-29224:
------------------------------------------
Summary: Move TPC-DS CTE suggestion tests in new test suite
Key: HIVE-29224
URL: https://issues.apache.org/jira/browse/HIVE-29224
Project: Hive
Issue Type: Task
Components: Tests
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis
HIVE-28259 introduced a new experimental feature for finding and materializing
common table expressions (CTEs) using CBO. The effect of the suggester on
TPC-DS queries was tested using the TestTezTPCDS30TBPerfCliDriver.
As it is right now we cannot easily fine-tune other CTE related configurations
(e.g., hive.optimize.cte.materialize.threshold) without affecting existing
query plans and doing so may decrease test coverage for certain parts of the
engine.
I propose to move the suggester based ("hive.optimize.cte.suggester.class")
tests under a new test suite (new TestTPCDSCteCliDriver) relying on the TPC-DS
30TB stats focusing on CTE materialization/suggestion features.
*Pros*
* Increase in test coverage
* No coupling of experimental features with main plan regression suite
*Cons*
* Increase in test runtime
* Redundancy in golden files (*.q.out)
Once the CTE feature(s) are stabilized and become part of the default
configuration it will no longer be necessary to maintain a separate suite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
