[IMPALA-5872] Implement a SQL test case builder for gathering query diagnostics

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 3.2.0
• Component/s: Frontend
• Labels: supportability
• Epic Link: SupportabilityRoadMap
• Target Version: Product Backlog
• Epic Color: ghx-label-7
• Assignee: Bharath Vissapragada
• Reporter: Bharath Vissapragada
• Created: 31/Aug/17 07:04
• Updated: 07/Feb/23 01:22
• Resolved: 14/Mar/19 14:15

Description

The idea is to implement a test case builder for collecting enough diagnostics for a given SQL query so that it can be reproduced/recreated on another cluster easily.

Input: A valid SQL query
Expected output: A .sql file that can be run using impala-shell -f and has all the schema/table/view definitions required to run the query on a target cluster.

An example:

EXPORT TESTCASE INTO OUTFILE 'file:///tmp/repro.sql' select * from view

Issue Links

• causes: IMPALA-8772 Import Testcase failed for SQL without table refs
• is duplicated by: IMPALA-7346 Capture locality data for debug
• is related to: IMPALA-11901 COPY TESTCASE is broken in LocalCatalog mode
• is related to: IMPALA-11885 Support COPY TESTCASE statement for kudu tables
• is related to: IMPALA-7346 Capture locality data for debug
• is related to: IMPALA-6858 Add type information to query profiles

Sub-Tasks

• Automatically capture test cases for queries.: Open