[GitHub] [doris] lsy3993 commented on issue #14699: [Bug] explode_json_array_sting 无法解析复杂json

[GitBox <gi...@apache.org>]

lsy3993 commented on issue #14699:
URL: https://github.com/apache/doris/issues/14699#issuecomment-1372282174

   when we use 'explode_json_array_string', we should give an array string which element is still string.
   For example, your case is '[{"k1":"v1","k2":"v2"},{"k1":"v11","k2":"v22"}]', the first element of array is **{"k1":"v1","k2":"v2"}**, it is not a string because there is no quotation marks.
   So, this string can meet your needs : '["{\\'k1\\':\\'v1\\',\\'k2\\':\\'v2\\'}","{\\'k1\\':\\'v11\\',\\'k2\\':\\'v22\\'}"]'
   
    


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org