You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Aitozi (Jira)" <ji...@apache.org> on 2022/07/30 07:49:00 UTC

[jira] [Updated] (FLINK-28751) Poor performance of the built in json_value function

     [ 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 purpose 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=2346,height=996!

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 purpose to use a different cache to replace the current one for better performance.



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