[IGNITE-16075] Calcite engine. Support UUID data type

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Vladimir Steshin
• Reporter: Aleksey Plekhanov
• Created: 08/Dec/21 06:33
• Updated: 23/Feb/23 12:30
• Resolved: 17/Mar/22 07:42

Description

Currently, UUID columns can be selected or even filtered if a table containing such a column is created not by the Calcite-based SQL engine (for example via cache API using @QuerySqlField field annotation).
But we cannot use it in DDL:

CREATE TABLE t (id UUID)

Or cast:

SELECT CAST(id AS UUID)

Issue Links

• Blocked: IGNITE-18415 SQL. Cannot use UUID class as parameters for query
• blocks: IGNITE-15436 Calcite engine. Merge Calcite SQL Engine to Ignite 2.x
• is blocked by: IGNITE-16376 Sql. Add UUID custom data type.
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #9826
• links to: GitHub Pull Request #9826