You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2020/12/04 12:40:00 UTC
[jira] [Commented] (NIFI-6878) ConvertJSONToSQL Improvement.
Statement Type Support "Use statement.type Attribute" or Supports
Expression Language
[ https://issues.apache.org/jira/browse/NIFI-6878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17243973#comment-17243973 ]
ASF subversion and git services commented on NIFI-6878:
-------------------------------------------------------
Commit 71d5162965cc8c7aa23d675240f5e75b1c86d3fd in nifi's branch refs/heads/main from Matt Burgess
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=71d5162 ]
NIFI-6878: Added 'Use statement.type Attribute' to ConvertJSONToSQL
This closes #3893
Signed-off-by: Mike Thomsen <mt...@apache.org>
> ConvertJSONToSQL Improvement. 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
> Assignee: Matt Burgess
> Priority: Minor
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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)