[CALCITE-5621] Support UDT declarations from root of JSON schema model

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: TJ Banghart
• Reporter: TJ Banghart
• Created: 29/Mar/23 19:41
• Updated: 27/Jul/23 10:22
• Resolved: 03/May/23 19:58

Description

Related to CALCITE-5346.

This change would allow for declaring user-defined types at the root of a schema model and allows for easy type alias mapping.

These data types are shared by all schema in the model so cast and DDL expressions do not need to scope data type references to a particular sub-schema.

For example:

...
  "inline":{
    "version":"1.0",
    "types":[
      {
        "name":"BOOL",
        "type":"BOOLEAN"
      },
      {
        "name":"BYTES",
        "type":"VARBINARY"
      }
    ]
...

Would allow for CAST("true" as BOOL)

Issue Links

• is related to: CALCITE-5346 Support for type aliases
• links to: GitHub Pull Request #3135