truonglac2603 opened a new issue, #23437: URL: https://github.com/apache/doris/issues/23437
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Git : git://VM-10-6-centos@96bb9a7d0881cabf114c3618585fa18549d7b2ea Version : doris-2.0.0-rc04 BuildInfo : VM-10-6-centos BuildTime : Sun, 06 Aug 2023 16:25:12 UTC ### What's Wrong? I had a TEXT column named _airbyte_data, each row contained a JSON string with backslashes. {\"totalTestsViralIncrease\":0,\"positiveScore\":0,\"inIcuCumulative\":null,\"deathProbable\":null,\"positiveCasesViral\":66330.0,\"totalTestsAntibody\":null,\"recovered\":null,\"totalTestsPeopleViralIncrease\":0,\"positiveTestsPeopleAntibody\":null,\"date\":\"2020-08-12\",\"totalTestEncountersViral\":1254514.0,\"hospitalizedCurrently\":480.0,\"death\":1716.0,\"negativeTestsAntibody\":null,\"totalTestsAntigen\":null,\"onVentilatorCurrently\":59.0,\"positiveTestsAntigen\":null,\"deathConfirmed\":1716.0,\"totalTestsPeopleAntibody\":null,\"positiveTestsPeopleAntigen\":null,\"totalTestResults\":1254514.0,\"onVentilatorCumulative\":null,\"totalTestResultsIncrease\":16612,\"positiveTestsViral\":null,\"hospitalizedIncrease\":53,\"negativeTestsPeopleAntibody\":null,\"positiveTestsAntibody\":null,\"totalTestsViral\":null,\"negativeTestsViral\":null,\"state\":\"WA\",\"inIcuCurrently\":null,\"hospitalized\":6102.0,\"totalTestsPeopleAntigen\":null,\"deathIncrease\":19,\"negative\":null,\"tota lTestEncountersViralIncrease\":16612,\"negativeIncrease\":0,\"positiveIncrease\":824,\"hospitalizedCumulative\":6102.0,\"totalTestsPeopleViral\":null,\"positive\":66630.0} When i ran SELECT json_unquote(_airbyte_data) from <table_name>, it didn't change anything and returned the table Then i pasted the JSON string within json_unquote(), it returned this error  But when i shortened the JSON string to this, it worked perfectly {\"totalTestsViralIncrease\":0,\"positiveScore\":0,\"inIcuCumulative\":null,\"deathProbable\":null,\"positiveCasesViral\":66330.0,\"totalTestsAntibody\":null}  ### What You Expected? json_unquote() will unquote the JSON string of the column by removing backslashes and return no error ### How to Reproduce? using json_unquote with a long JSON string with backslashes. ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
