Aitozi created FLINK-28751: ------------------------------ Summary: 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 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=2346,height=996! 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)