[jira] [Commented] (CALCITE-5349) RelJson should support non-standard operators

["TJ Banghart (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17624788#comment-17624788 ] 

TJ Banghart commented on CALCITE-5349:
--------------------------------------

A solution could be adding a new instance variable of type {{EnumSet}} which is the set of {{SqlLibrary}} entries to use for operator lookups. By default this would be set to {{{}EnumSet.of(SqlLibrary.STANDARD){}}}.

This would also entail adding a new constructor to take this new variable, a {{withSqlLibraries}} builder method, and an overloaded {{RelJson#readExpression}} method that would allow for specifying libraries.

> RelJson should support non-standard operators
> ---------------------------------------------
>
>                 Key: CALCITE-5349
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5349
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: TJ Banghart
>            Assignee: TJ Banghart
>            Priority: Major
>
> I am attempting to deserialize {{RexNodes}} that contain non-standard operators but {{RexJson#toOp}} only considers operators found in {{{}SqlStdOperatorTable{}}}: [https://github.com/apache/calcite/blob/c945b7f49b99538748c871557f6ac80957be2b6e/core/src/main/java/org/apache/calcite/rel/externalize/RelJson.java#L780]
> For example, attempting to deserialize a JSON RexCall that includes the BigQuery only `DATE_FROM_UNIX_DATE` operator raises {{CalciteException: No operator for 'DATE_FROM_UNIX_DATE' with kind: 'OTHER_FUNCTION', syntax: 'FUNCTION' during JSON deserialization}}
> Unless I am missing something, I don't believe the operator lookup is configurable or overridable.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)