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)
