[
https://issues.apache.org/jira/browse/NIFI-4517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess updated NIFI-4517:
-------------------------------
Summary: Allow SQL results to be output as records in any supported format
(was: Create a processor to allow SQL results to be output as records in any
supported format (ExecuteSQLToRecord))
> 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
> 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)
