Is the source table a JdbcStorageHandler table? Please provide the DDL of the source table, the query used, and any sample data if possible. This information will help us understand the problem better. Also, validate the set -v command, especially configurations like hive.tez.container.size. ... View more

Thank you @MattWho @linssab for the help. The Groovy script with the ExecuteScript processor is working fine to convert JSON file content to flow file attributes. ... View more

Ok, now that makes sense. I downloaded from the official repository Index of /dist/nifi (apache.org) and I'm using version 1.13.2 (due to some project requirements) ... View more

Ok, I understand now what you are doing. The problem is that you are trying to merge information from one FlowFile to another, and this can't be done in the way you designed. Two FlowFiles mean two separate processes, they don't communicate with one another.   You have to use one single FlowFile for the entire process if you need information from both the JSON and XML. I suggest putting the EvaluateXPath after the UpdateAttributes processor, setting the Destination property to "flowfile-attribute" in a way you will have all the attributes in the same flowfile (titlefromXML, guid, Contact Name, caseno, and docno) to use in the JOLT specification.   -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button. ... View more

Idk if it is much of a help, but you can try checking the Jolt Transform quick reference There's this link to test JOLT specifications. You can try starting with something like  [{ "operation": "shift", "spec": { "*": "&" } }, { "operation": "default", "spec": { "*": { "id": "&(1,0)" } } }] ... View more

You can try modifying the Record Reader avro schema to something like this: {"name": "xxx", "type": "string"], "default": ""} ... View more

@linssab ,   You are probably running into this issue described in NIFI-9241, which has been fixed on NiFi 1.15.   Cheers, André   ... View more