- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
functions =min(),=max(),=intsum() not giving expected result.
- Labels:
-
Apache NiFi
Created 09-13-2022 04:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI
while using the JoltTransformJSON , found some limitation of methods like (=min(),=max(),=intsum()). Not getting the expected result. Please add suggestions if we have a solution for this issue. thanks.
Json Input=========================================
{
"NUMBER": {
"array1": [
9223372036854775807
],
"array2": [
4294967295
],
"array3": [
2147483646
]
}
}
Jolt Spec===========================
[
{
"operation": "modify-overwrite-beta",
"spec": {
"NUMBER": {
"sumArray1": "=intSum(@(1,array1))",
"maxArray1": "=max(@(1,array1))",
"minArray1": "=min(@(1,array1))",
"sumArray2": "=intSum(@(1,array2))",
"maxArray2": "=max(@(1,array2))",
"minArray2": "=min(@(1,array2))",
"sumArray3": "=intSum(@(1,array3))",
"maxArray3": "=max(@(1,array3))",
"minArray3": "=min(@(1,array3))"
}
}
}
]
{
"NUMBER": {
"array1": [9223372036854775807],
"array2": [4294967295],
"array3": [2147483646],
"sumArray1": -1,
"maxArray1": 9223372036854775807,
"minArray1": 2147483647,
"sumArray2": -1,
"maxArray2": 4294967295,
"minArray2": 2147483647,
"sumArray3": 2147483646,
"maxArray3": 2147483646,
"minArray3": 2147483646
}
}
