[HIVE-11107] Support for Performance regression test suite with TPCDS

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Hari Sankar Sivarama Subramaniyan
• Created: 25/Jun/15 11:19
• Updated: 02/May/17 19:13
• Resolved: 15/Dec/15 22:17

Description

Support to add TPCDS queries to the performance regression test suite with Hive CBO turned on.

This benchmark is intended to make sure that subsequent changes to the optimizer or any hive code do not yield any unexpected plan changes. i.e. the intention is to not run the entire TPCDS query set, but just "explain plan" for the TPCDS queries.
As part of this jira, we will manually verify that expected hive optimizations kick in for the queries (for given stats/dataset). If there is a difference in plan within this test suite due to a future commit, it needs to be analyzed and we need to make sure that it is not a regression.

The test suite can be run in master branch from itests by

mvn test -Dtest=TestPerfCliDriver 

Issue Links

• links to: Review board