[HIVE-25668] Support database reuse when using qt:database option

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Testing Infrastructure
• Assignee: Unassigned Assign to me
• Reporter: Stamatis Zampetakis
• Created: 03/Nov/21 11:32
• Updated: 03/Jun/22 12:45

Description

With HIVE-25594 it is possible to initialize and use various types of databases in tests. At the moment all the supported databases rely on docker containers which are initialized/destroyed in per test basis. This is good in terms of test isolation but it brings a certain performance overhead slowing down tests. At the moment it is fine since the feature it is not widely used  but it would be good to have a way to reuse a database in multiple qfiles. 

The developper could specify in the qfile if they want to reuse a container (if it is possible) by passing certain additional options. The declaration could look like below:

--!qt:database:type=mysql;script=q_test_country_table.sql;reuse=true

Issue Links

• depends upon: HIVE-25594 Setup JDBC databases in tests via QT options