starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

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

Open kaijianding opened this issue 1 year ago • 0 comments

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 avatar May 08 '24 06:05 kaijianding