[NIFI-626] ExecuteSQL processor for executing arbitrary SQL queries

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.2.0
• Fix Version/s: 0.2.0
• Labels: patch
• Flags: Patch
• Assignee: Toivo Adams
• Reporter: Toivo Adams
• Created: 21/May/15 19:29
• Updated: 10/Jul/15 18:58
• Resolved: 17/Jun/15 17:41

Description

For example query can be:
SELECT * FROM orders WHERE orderId = '${order.id}'

where ${order.id} is FlowFile attribute.
Result will serialized using Avro.
Avro gives as possibility to have query Resultset metadata (column name and types) included in FlowFile.
Also Avro should allow streaming.

Issue Links

• is blocked by: NIFI-676 DBCPService throws NPE if using OtherDB
• is blocked by: NIFI-677 DBCPService should allow user to specify Connection URL
• is duplicated by: NIFI-293 Add a JDBC Processor for executing arbitrary SQL queries