- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PutDatabaseRecord fields don't map database colums
- Labels:
-
Apache NiFi
Created ‎01-15-2020 01:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, im trying to upload a CSV to a RedShift database using GetFile->PutDatabaseRecord
i'm getting this error:
PutDatabaseRecord:
CSVReader (my file got headers, this way and not hardcoding the schema makes everything more easily scalable):
Null string: NULL
CSV:
A,B,C,D,E,F,G,H,I
2020-01-15,AX,COD245,NO,PASS,R,,,
2020-01-15,AX,COD235,YES,PASS,R,,,
Table with same fields names.
Any idea what i'm doing wrong? Is there any way to look for the query it's making, that will make this more easy to debug.
Thank you!
Created ‎01-15-2020 01:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Solved, PutDatabaseRecord gives you mapping error if the table doesn't exists or if you don't have permissions, hours fighting against the columns names and it was a database problem.
Created ‎01-15-2020 01:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Solved, PutDatabaseRecord gives you mapping error if the table doesn't exists or if you don't have permissions, hours fighting against the columns names and it was a database problem.
