embulk-output-bigquery icon indicating copy to clipboard operation
embulk-output-bigquery copied to clipboard

Published 20 hours ago • verified publisher icon embulk

Error: Bad character (ASCII 0) encountered.

Open Bagavathyshopf opened this issue 3 years ago • 1 comments

While loading the data to embulk bigquery, the following error is showing up "Caused by: org.jruby.exceptions.RaiseException: (Error) failed during waiting a Load job, get_job(bagavathy-embulk, embulk_load_job_d5ff4495-1921-4e15-8e1d-bcdec541cfa5), errors:[{:reason=>"invalid", :message=>"Error while reading data, error message: Error detected while parsing row starting at position: 46994450. Error: Bad character (ASCII 0) encountered."},"

I used encoding:UTF-8 in the out section of the yml config file. I tried with various other encoding options like 'utf-16', 'ISO-8859-1', and it doesn't solve the problem. Kindly help to solve this issue. Screenshot 2021-04-22 at 9 31 59 AM

Bagavathyshopf avatar Apr 22 '21 04:04 Bagavathyshopf

Hello, @Bagavathyshopf If you use CSV format, could you try JSON format? https://github.com/embulk/embulk-output-bigquery#formatter-performance-issue

hiroyuki-sato avatar Apr 27 '21 13:04 hiroyuki-sato

I close this issue but feel free to reopen if you need.

hiroyuki-sato avatar Mar 01 '24 13:03 hiroyuki-sato