[
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)
