[FLINK-33266] Support plan cache for DQL in SQL Gateway

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.19.0
• Labels: pull-request-available
• Assignee: Dan Zou
• Reporter: Dan Zou
• Created: 13/Oct/23 03:28
• Updated: 07/Dec/23 06:15
• Resolved: 07/Dec/23 06:15

Description

In OLAP scenarios, running a single query typically cost hundreds of milliseconds or a few seconds, of which it takes about tens of milliseconds to parse, validate, optimize, and translate it to Flink transformations. Adding cache to cache the transformations corresponding to queries is meaningful for scenarios where certain queries are often executed repeatedly.

We focus on submitting DQL through SQL gateway in this ticket.

Issue Links

• links to: GitHub Pull Request #23849