[ https://issues.apache.org/jira/browse/NIFI-4517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16528168#comment-16528168 ]
Matt Burgess commented on NIFI-4517: ------------------------------------ That's a good point, with precedence: The SiteToSiteMetricsReportingTask has a default (Ambari) output along with the option for a Record Writer. Will update the title to be less specific to implementation, good catch thanks! > Create a processor to allow SQL results to be output as records in any > supported format (ExecuteSQLToRecord) > ------------------------------------------------------------------------------------------------------------ > > Key: NIFI-4517 > URL: https://issues.apache.org/jira/browse/NIFI-4517 > Project: Apache NiFi > Issue Type: New Feature > Components: Extensions > Reporter: Matt Burgess > Priority: Major > > ExecuteSQL 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. > I propose an ExecuteSQLToRecord processor that can be configured with a > RecordSetWriter implementation, or to change the existing ExecuteSQL > processor (although that might be more invasive and disruptive to existing > flows). 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)