CODEWITHSUNDEEP
postgresqlcsvapache-nifi
Sachith Muhandiram
Sachith Muhandiram

Reputation: 2972

PutDatabaseRecord failed with Index header CSVRecord

We are trying to insert data to postgresql based database.

We use PutDatabaseRecord processor with following configurations :

Record Reader

But we get an warning and data is not inserted to database and records are not inserted.

Is this apache commoncsv related issue?

How can I solve this issue?

Edit :

After @matt's initial answer : I found intersting thing with data, in address field it has :

"No 60, Marine Drive,"

CSVReader in PutDatabaseRecord uses , value separator. So address must be read as 3 different column values.

Upvotes: 0

Views: 632

Answers (1)

mattyb
mattyb

Reputation: 12093

The error seems to indicate you have more columns in the header than in (some lines of) data. If that's not the case, I suspect there's either a bug when handling empty columns, or Infer Schema doesn't work as expected with an empty column in the first row (how would it be able to guess the type of "nothing"?).

Upvotes: 1

Related Questions