Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[CH] get_json_object can not parse string contains ctrl chars #3337

Closed
KevinyhZou opened this issue Oct 7, 2023 · 0 comments · Fixed by #3338
Closed

[CH] get_json_object can not parse string contains ctrl chars #3337

KevinyhZou opened this issue Oct 7, 2023 · 0 comments · Fixed by #3338
Labels
bug Something isn't working triage

Comments

@KevinyhZou
Copy link
Contributor

KevinyhZou commented Oct 7, 2023

Backend

CH (ClickHouse)

Bug description

get_json_object can not parse string contains ctrl chars, sometimes when ctrl chars(like ^\, ^A) are contained in json string, then it can not be parsed by get_json_object while do query by gluten, the result is
+-----+----------------------------------+
| id | get_json_object(name, $.header) |
+-----+----------------------------------+
| 1 | NULL |
+-----+----------------------------------+

And when do this query by spark, the result is
+-----+----------------------------------------------------+
| id | get_json_object(name, $.header) |
+-----+----------------------------------------------------+
| 1 | {"uid":")Qu001cڜ015 ~请001cƼ","ver":5} |
+-----+----------------------------------------------------+

Spark version

Spark-3.3.x

Spark configurations

No response

System information

No response

Relevant logs

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working triage
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant