Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

PutDatabaseRecord fields don't map database colums

avatar
Contributor

Hi, im trying to upload a CSV to a RedShift database using GetFile->PutDatabaseRecord

 

i'm getting this error:

Captura3.PNG

 

PutDatabaseRecord:

Captura1.PNG

CSVReader (my file got headers, this way and not hardcoding the schema makes everything more easily scalable):

Captura2.PNG

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!

 

 

1 ACCEPTED SOLUTION

avatar
Contributor

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.

View solution in original post

1 REPLY 1

avatar
Contributor

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.