[
https://issues.apache.org/jira/browse/NIFI-8148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jon Kessler reassigned NIFI-8148:
---------------------------------
Assignee: (was: 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
> 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)
