Hi, Team ! I have a problem with ingestion from CS...
# troubleshooting
а
Hi, Team ! I have a problem with ingestion from CSV file, which contains STRING values in column, such a "#1082;аБ...." I get ERROR Caused by: java.lang.IllegalArgumentException: Cannot read single-value from Object[]: [Б, а, р,......] for column: ext_id The parser reading this as array, but I want to load this to Pinot as is as STRING. How to fix this ? Another problem with parsing STRING as " Text , text text", parser reasing it as Object[]
m
You need to specify the right delimiter in the record reader spec. I think currently
;
is being treated as delimiter.
а
Oh, no, I have a
Copy code
,
As I know - it is default, but I additionally specified it in job, and had the same problem. I change the format of file to JSON and loaded it.
👍 1
HI ! I could open an issue in repo about symbols '&' which corrupt the normal parsing of STRING with default delimiter ? @Mayank
m
Can you check if it is a valid CSV? I feel like it might either not be, or need escaping, or specify some version. The latter two have configuration in Pinot