[
https://issues.apache.org/jira/browse/NIFI-6878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ZhangCheng updated NIFI-6878:
-----------------------------
Description: 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.But it will be easy if ConvertJSONToSQL supports dynamical
Statement Type . It is easy to implement this feature just like
PutDatabaseRecord. In practice, I did use PutDatabaseRecord instead of
ConvertJSONToSQL. (was: 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.But it will be easy if ConvertJSONToSQL supports dynamical
Statement Type . It is easy to implement this feature just like
PutDatabaseRecord. In practice, I did use PutDatabaseRecord instead of
ConvertJSONToSQL )
> 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
> Priority: Minor
>
> 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.But it will be easy if ConvertJSONToSQL supports dynamical
> Statement Type . 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)
