You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Matt Burgess (JIRA)" <ji...@apache.org> on 2018/08/07 16:41:00 UTC

[jira] [Commented] (NIFI-4517) Allow SQL results to be output as records in any supported format

    [ https://issues.apache.org/jira/browse/NIFI-4517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16571948#comment-16571948 ] 

Matt Burgess commented on NIFI-4517:
------------------------------------

[~patricker] Are you actively working this? If not, I'd be happy to take over, I had started working on it before I checked the Jira and saw that it was assigned to you :)

> Allow SQL results to be output as records in any supported format
> -----------------------------------------------------------------
>
>                 Key: NIFI-4517
>                 URL: https://issues.apache.org/jira/browse/NIFI-4517
>             Project: Apache NiFi
>          Issue Type: New Feature
>          Components: Extensions
>            Reporter: Matt Burgess
>            Assignee: Peter Wicks
>            Priority: Major
>
> ExecuteSQL and QueryDatabaseTable currently only outputs Avro, and the schema is only available as embedded within the flow file, not as an attribute such as record-aware processors can handle.
> ExecuteSQL and QueryDatabaseTable processors should be updated with a RecordSetWriter implementation. This will allow output using any writer format (Avro, JSON, CSV, Free-form text, etc.), as well as all the other features therein (such as writing the schema to an attribute, and will avoid the need for a ConvertAvroToXYZ or ConvertRecord processor downstream.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)