[IGNITE-19748] Calcite engine. Support queries timeout

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.16
• Labels: calcite important ise
• Release Note: SQL Calcite: Added queries timeout support
• Ignite Flags: Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 15/Jun/23 13:56
• Updated: 25/Oct/23 11:27
• Resolved: 18/Jul/23 10:34

Description

We can set timeout for SQL queries:

• Using SqlFieldsQuery.timeout property (for certain query)
• Using "sql.defaultQueryTimeout" distributed property (default for all queries)

But Calcite-based SQL query engine ignore these timeouts. Only possible timeout supported by the new engine is planning timeout. We should support execution timeouts too.

Issue Links

• links to: GitHub Pull Request #10827