[
https://issues.apache.org/jira/browse/CALCITE-7455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18068944#comment-18068944
]
Danylo Naumenko commented on CALCITE-7455:
------------------------------------------
[~zabetak] We have a query where we need to do an array aggregation where each
element is a JSON object so we used the JSON_OBJECT function. One of the fields
in that object is an array where each element is an object that has an
Optional<String> field. When trying to execute the query, we got an error
saying that serialization failed because there is an optional field.
> 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)
