JsonRecordSetWriter 1.22.0 issues with elements in array

7 replies
4746 views
Translate All

While working with JsonRecordSetWriter 1.22.0 on an ExecuteSQLRecord 1.22.0 processor, we have noticed that when selecting columns with arrays such as the below example:

the writer has the below output:

However, if I select a smaller number in the array:

I seem to get the correct result:

This seems to be an overflow of some kind that did not seem to exist on our previous version of nifi when working with nifi 1.11.4

I am providing below both the settings of the ExecuteSQLRecord processors and the JsonRecordSetWriter. Please advise if this is a bug or If there might be something I am overlooking. Thank you.

Apache NiFi

VidyaSargur

Community Manager

@SteliosCh, Welcome to our community! To help you get the best possible answer, I have tagged in our NiFi experts @cotopaul @SAMSAL @TimothySpann @MattWho may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Translate

Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.