- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Nifi Bulk Ingestion
- Labels:
-
Apache NiFi
Created on
‎03-19-2021
09:42 AM
- last edited on
‎03-19-2021
11:13 AM
by
ask_bill_brooks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi guys, I'm really new whit this technology. I'm trying to get multiple records from oracle Database then merge them in one file and put in other oracle table, but I'm stuck with this error "Put Database Record [id] due to none of the fields in the record map to the columns defined by the tablename1 table."
This is my structure
This are the headers from Query Database Table's flow file output
Objavro.schemaÅŸ
{"type":"record","name":"tablename","namespace":"any.data",
"fields":[
{"name":"UPPERCOL0","type":["null",{"type":"bytes","logicalType":"decimal","precision":10,"scale":0}]},
{"name":"UPERCOL11","type":["null",{"type":"long","logicalType":"timestamp-millis"}]},
{"name":"UPPERCOL2","type":["null","string"]},
{"name":"UPPERCOL3","type":["null","string"]},
{"name":"UPPERCOL4","type":["null","string"]},
{"name":"UPPERCOL5","type":["null","string"]},
{"name":"UPPERCOL6","type":["null",{"type":"bytes","logicalType":"decimal","precision":3,"scale":0}]},
{"name":"UPPERCOL7","type":["null","string"]},
{"name":"UPPERCOL8","type":["null","string"]},
{"name":"UPPERCOL9","type":["null","string"]},
{"name":"UPPERCOL10","type":["null",{"type":"long","logicalType":"timestamp-millis"}]}
]}avro.
This are the headers from Merge Record's flow file output
Objavro.schemaÅŸ
{"type":"record","name":"tablename","namespace":"any.data",
"fields":[
{"name":"UPPERCOL0","type":["null",{"type":"bytes","logicalType":"decimal","precision":10,"scale":0}]},
{"name":"UPPERCOL1","type":["null",{"type":"long","logicalType":"timestamp-millis"}]},
{"name":"UPPERCOL2","type":["null","string"]},
{"name":"UPPERCOL3","type":["null","string"]},
{"name":"UPPERCOL4","type":["null","string"]},
{"name":"UPPERCOL5","type":["null","string"]},
{"name":"UPPERCOL6","type":["null",{"type":"bytes","logicalType":"decimal","precision":3,"scale":0}]},
{"name":"UPPERCOL7","type":["null","string"]},
{"name":"UPPERCOL8","type":["null","string"]},
{"name":"UPPERCOL9","type":["null","string"]},
{"name":"UPPERCOL10","type":["null",{"type":"long","logicalType":"timestamp-millis"}]}
]}avro.
This is my Avro schema
{"type":"record","name":"tablename","namespace":"any.data",
"fields":[
{"name":"UPPERCOL0","type":["null",{"type":"bytes","logicalType":"decimal","precision":10,"scale":0}]},
{"name":"UPPERCOL1","type":["null",{"type":"long","logicalType":"timestamp-millis"}]},
{"name":"UPPERCOL2","type":["null","string"]},
{"name":"UPPERCOL3","type":["null","string"]},
{"name":"UPPERCOL4","type":["null","string"]},
{"name":"UPPERCOL5","type":["null","string"]},
{"name":"UPPERCOL6","type":["null",{"type":"bytes","logicalType":"decimal","precision":3,"scale":0}]},
{"name":"UPPERCOL7","type":["null","string"]},
{"name":"UPPERCOL8","type":["null","string"]},
{"name":"UPPERCOL9","type":["null","string"]},
{"name":"UPPERCOL10","type":["null",{"type":"long","logicalType":"timestamp-millis"}]}
]}
Could you please help me with this problem?
Created ‎03-21-2021 11:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As the error suggested, check the target table column definition
