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

import json data with routine load can't success if json data contains unescaped character #45273

Open
kaijianding opened this issue May 8, 2024 · 2 comments
Labels
type/bug Something isn't working

Comments

@kaijianding
Copy link
Contributor

Steps to reproduce the behavior (Required)

  1. CREATE routine load to ingest json data
  2. unescaped character in json
    img_v3_02am_88bbf69b-9bcb-4347-8c0a-f0c9044049fg

Expected behavior (Required)

  1. task success with this row skipped
  2. errorRows increases

Real behavior (Required)

routine load tasks failed repeatly:

2024-05-08 09:24:04,644 WARN (thrift-server-pool-667203|857580) [RoutineLoadJob.executeTaskOnTxnStatusChanged():1048] routine load task [job name xxxx, task id 36869260-d0ce-4ebd-bec8-423d6d78e08f] aborted because of Failed to iterate document stream as object. error: Within strings, some characters must be escaped, we found unescaped characters, remove old task and generate new one

StarRocks version (Required)

  • 2.5.20
@kaijianding kaijianding added the type/bug Something isn't working label May 8, 2024
@rickif
Copy link
Contributor

rickif commented May 8, 2024

Thanks. I'll look into this issue.

@jaogoy
Copy link
Contributor

jaogoy commented May 23, 2024

We need to support auto escape in JSON string.

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

No branches or pull requests

3 participants