[
https://issues.apache.org/jira/browse/CALCITE-7455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18070868#comment-18070868
]
Stamatis Zampetakis commented on CALCITE-7455:
----------------------------------------------
[~danylonaumenko] If you can put the SQL query in the description of the Jira
ticket that would help to understand better the motivation. Maybe as part of
the solution you should add some tests using JSON_OBJECT in the Quidem files
(agg.iq is possible not the best place but it uses JSON_OBJECT so that's why I
cite as an example).
> Allow configuring ObjectMapper for JSON functions
> -------------------------------------------------
>
> Key: CALCITE-7455
> URL: https://issues.apache.org/jira/browse/CALCITE-7455
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Danylo Naumenko
> Priority: Minor
>
> JsonFunctions currently uses a hardcoded JacksonJsonProvider with the default
> ObjectMapper, so any Jackson module not registered by default is unavailable.
> For example, passing a Java object with Optional fields to JSON_OBJECT fails
> since serialization of Optional fields is not enabled by default. Registering
> Jdk8Module on the ObjectMapper fixes this, but it looks like there's no way
> to do that today.
> *Proposed solution:* provide a way to configure an ObjectMapper used by JSON
> functions.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
