Member since
08-24-2023
4
Posts
1
Kudos Received
0
Solutions
08-24-2023
07:53 AM
Changing decimal precision did not affect the results either. Could this be an issue with the writer by any chance? This is a postgress database. The casting into json is to create a column of type array with integer contents.
... View more
08-24-2023
06:59 AM
Hello @TimothySpann thank you for the reply, Unfortunately BIGINT yields the same results
... View more
08-24-2023
02:26 AM
Thank you very much!
... View more
08-24-2023
01:24 AM
1 Kudo
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.
... View more
Labels:
- Labels:
-
Apache NiFi