[
https://issues.apache.org/jira/browse/FLINK-28751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aitozi updated FLINK-28751:
---------------------------
Description:
When I use the JSON_VALUE function, I found the performance is very poor. It's
mainly affected by the heavy lock operation in jsonpath inner LRUCache which is
also observed by other systems, eg:
[https://github.com/apache/pinot/pull/7409|https://github.com/apache/pinot/pull/7409*]
!image-2022-07-30-15-47-34-788.png|width=567,height=341!
So I proposal to use a different cache to replace the current one for better
performance.
was:
When I use the JSON_VALUE function, I found the performance is very poor. It's
mainly affected by the heavy lock operation in jsonpath inner LRUCache which is
also observed by other systems, eg:
[https://github.com/apache/pinot/pull/7409|https://github.com/apache/pinot/pull/7409*]
!image-2022-07-30-15-47-34-788.png|width=567,height=341!
So I purpose to use a different cache to replace the current one for better
performance.
> Poor performance of the built in json_value function
> ----------------------------------------------------
>
> Key: FLINK-28751
> URL: https://issues.apache.org/jira/browse/FLINK-28751
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Runtime
> Reporter: Aitozi
> Priority: Major
> Attachments: image-2022-07-30-15-47-34-788.png
>
>
> When I use the JSON_VALUE function, I found the performance is very poor.
> It's mainly affected by the heavy lock operation in jsonpath inner LRUCache
> which is also observed by other systems, eg:
> [https://github.com/apache/pinot/pull/7409|https://github.com/apache/pinot/pull/7409*]
> !image-2022-07-30-15-47-34-788.png|width=567,height=341!
> So I proposal to use a different cache to replace the current one for better
> performance.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
