[IGNITE-15550] Calcite engine. Support collections constuction from the query

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.14
• Labels: calcite
• Release Note: SQL Calcite: implemented ARRAY, ARRAY_AGG, ARRAY_CONCAT_AGG and MAP support
• Assignee: Ivan Daschinsky
• Reporter: Aleksey Plekhanov
• Created: 21/Sep/21 13:07
• Updated: 20/Apr/23 13:27
• Resolved: 07/Jun/22 09:35

Description

Currently, queries like:

 

SELECT MAP(SELECT 'a', 1)
SELECT ARRAY(SELECT 1)

Can't be executed, since logical plan contains Collect relational operator and there is no rule and no physical operator to convert this logical operator. 

 

Issue Links

• fixes: IGNITE-15620 Calcite. Support for ARRAY_AGG function.
• incorporates: IGNITE-15620 Calcite. Support for ARRAY_AGG function.
• is cloned by: IGNITE-19332 Sql. Support collections constuction from the query
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #10059