ZhangCheng created NIFI-6878:
--------------------------------
Summary: ConvertJSONToSQL Statement Type Support "Use
statement.type Attribute" or Supports Expression Language
Key: NIFI-6878
URL: https://issues.apache.org/jira/browse/NIFI-6878
Project: Apache NiFi
Issue Type: Improvement
Components: Extensions
Reporter: ZhangCheng
ConvertJSONToSQL Statement Type provides fixed options : UPDATE,INSERT,DELETE.
Usually, it can meet our needs. But in actual application,I think It's not
flexible enough. In some cases, we need to dynamically indicate the Statement
Type. For example,the data from CpatureChangeMysql owns the attribute of
statement type（cdc.event.type, we need to convert the data to sql(DML)
orderly; And we now have to use RouteOnAttribute to transfer data to three
branches , Build SQL statement separately ,finally,we have to use EnforceOrder
to ensure the order of SQL statements. And It is easy to implement this
feature just like PutDatabaseRecord. in practice, I did use PutDatabaseRecord
instead of ConvertJSONToSQL
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
