[NIFI-9781] When selecting an array column in QueryRecord, it may return an array of STRINGs when it should be an array of records

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: Extensions
• Assignee: Mark Payne
• Reporter: Mark Payne
• Created: 09/Mar/22 16:02
• Updated: 11/Mar/22 15:27
• Resolved: 09/Mar/22 18:08

Description

Given the following input:

{
              "name": "John Doe",
              "title": "Software Engineer",
              "age": 40,
              "addresses": [{
                  "streetNumber": 4820,
                  "street": "My Street",
                  "apartment": null,
                  "city": "New York",
                  "state": "NY",
                  "country": "USA",
                  "label": "work"
              }, {
                  "streetNumber": 327,
                  "street": "Small Street",
                  "apartment": 309,
                  "city": "Los Angeles",
                  "state": "CA",
                  "country": "USA",
                  "label": "home"
              }],
              "project": {
                  "name": "Apache NiFi",
                  "maintainer": {
                        "id": 28302873,
                        "name": "Apache Software Foundation"
                   },
                  "debutYear": 2014
              }
            } 

If I use the following query:

SELECT addresses FROM FLOWFILE 

I expect to get the output:

{
  "addresses" : [ {
    "streetNumber" : 4820,
    "street" : "My Street",
    "apartment" : null,
    "city" : "New York",
    "state" : "NY",
    "country" : "USA",
    "label" : "work"
  }, {
    "streetNumber" : 327,
    "street" : "Small Street",
    "apartment" : 309,
    "city" : "Los Angeles",
    "state" : "CA",
    "country" : "USA",
    "label" : "home"
  } ]
} 

But instead the addresses field is something like MapRecord[streetNumber=4820, street=My Street...]

Issue Links

• links to: GitHub Pull Request #5853