Member since
03-19-2021
2
Posts
0
Kudos Received
0
Solutions
03-19-2021
09:42 AM
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?
... View more
Labels:
- Labels:
-
Apache NiFi