[ https://issues.apache.org/jira/browse/NIFI-8148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jon Kessler reassigned NIFI-8148: --------------------------------- Assignee: Jon Kessler > Selecting field from array with QueryRecord routes to failure > ------------------------------------------------------------- > > Key: NIFI-8148 > URL: https://issues.apache.org/jira/browse/NIFI-8148 > Project: Apache NiFi > Issue Type: Bug > Components: Extensions > Reporter: Mark Payne > Assignee: Jon Kessler > Priority: Major > > Given the following JSON document coming into QueryRecord: > {{ {}} > {{ "name": "John Doe",}} > {{ "try": [}} > {{ {}} > {{ "workAddress": {}} > {{ "number": "123",}} > {{ "street": "5th Avenue",}} > {{ "city": "New York",}} > {{ "state": "NY",}} > {{ "zip": "10020"}} > {{ },}} > {{ "homeAddress": {}} > {{ "number": "456",}} > {{ "street": "116th Avenue",}} > {{ "city": "New York",}} > {{ "state": "NY",}} > {{ "zip": "11697"}} > {{ }}} > {{ }}} > {{ ]}} > {{}}} > When using a JSON Reader (inferred schema) and JSON Writer (inherit record > schema), we should be able to use the query: > SELECT RPATH(try, '/*/zip') AS zip > FROM FLOWFILE > The result should be two records, each consisting of a single field named > 'zip' that is of type String. > Currently, it throws an Exception and routes to failure. -- This message was sent by Atlassian Jira (v8.3.4#803005)