[HIVE-23950] [Umbrella] Support PREPARE and EXECUTE statements

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Planning
• Target Version/s: 4.0.0
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 29/Jul/20 20:22
• Updated: 29/Jul/20 20:26

Description

PREPARE and EXECUTE statements provide an ability to create a parameterized query and re-use it to execute with different parameters.

e.g.

PREPARE pcount from 
    select count(*) from src where key > ?;
EXECUTE pcount using 200;

-- execute with different value
EXECUTE pcount using 101;


PREPARE pquery2 from 
   select count(*) from daysales where dt=? and customer=?;
EXECUTE pquery2 using '2001-01-01',1;

Sub-Tasks

• Support parameterized queries in WHERE/HAVING clause: Closed
• Allow 'expressions' instead of 'constant literal' for EXECUTE: Open
• Stats annotation/collection for EXECUTE statements: Open
• Reduce memory footprint of cached plan: Open
• Support dynamic expressions/params in SELECT clause: Open
• Support for EXECUTE/PREPARE operation authorization: Open
• Improve Explain plan output for EXECUTE queries: Open
• Support partition pruning and other physical transformations for EXECUTE statement: Closed
• Support physical transformations for EXECUTE statement: Open
• Throw error for parameterized query containing parameters in group by: Open
• NullPointerException with parameterized query: Open