[HIVE-23940] Add TPCH tables (scale factor 0.001) as qt datasets

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 27/Jul/20 17:20
• Updated: 17/Nov/22 08:48
• Resolved: 10/Aug/20 14:11

Description

Currently there are only two TPCH tables (lineitem, part) in qt datasets and the data do not reflect an actual scale factor.

TPC-H schema is quite popular and having all tables is useful to create meaningful and understandable queries.

Moreover, keeping the standard proportions allows to have query plans that are going to be meaningful when the scale factor changes and makes it easier to compare the correctness of the results against other databases.

The goal of this issue is to add all TPCH tables with their data at scale factor 0.001 as qt datasets.

Issue Links

• Is contained by: HIVE-21196 Support semijoin reduction on multiple column join
• links to: GitHub Pull Request #1325