[jira] [Assigned] (NIFI-8148) Selecting field from array with QueryRecord routes to failure
[ 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)
[jira] [Assigned] (NIFI-8148) Selecting field from array with QueryRecord routes to failure
[ 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)