[jira] [Created] (NIFI-8148) Selecting field from array with QueryRecord routes to failure

["Mark Payne (Jira)" <ji...@apache.org>]

Mark Payne created NIFI-8148:
--------------------------------

             Summary: 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


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)