doris jsonpath syntax parsing error: $.images[?(@.Type='11')].url[0] #50692
Unanswered
myklass
asked this question in
A - General / Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The Routine Load task in Doris can be created, which shows that the syntax is acceptable during the task definition phase. However, it fails when actual data is being imported. This might be due to issues with the JSONPath expression used for parsing the data, preventing it from correctly extracting the data. Additionally, when using the JSON_EXTRACT function with the expression json_extract(jsonobject, '$.images[?(@.Type='11')].url[0]'), a syntax error occurs, indicated by the error message: org.apache.doris.common.AnalysisException: errCode=2,detailMessage= Syntax error.How to solve it, or achieve the effect in another way?
Beta Was this translation helpful? Give feedback.
All reactions