You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "thuy le (JIRA)" <ji...@apache.org> on 2019/07/25 15:33:00 UTC
[jira] [Commented] (NIFI-6483) Apache Nifi (version 1.9.2) error
when update data in a table (SQL server, MySQL, Postgresql) (it is running
well with insert and update operations)
[ https://issues.apache.org/jira/browse/NIFI-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16892883#comment-16892883 ]
thuy le commented on NIFI-6483:
-------------------------------
I've test with version 1.8.0, it has the same issue
!image-2019-07-25-11-32-19-469.png|width=726,height=224!
> Apache Nifi (version 1.9.2) error when update data in a table (SQL server, MySQL, Postgresql) (it is running well with insert and update operations)
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: NIFI-6483
> URL: https://issues.apache.org/jira/browse/NIFI-6483
> Project: Apache NiFi
> Issue Type: Bug
> Components: Configuration
> Affects Versions: 1.9.2
> Environment: error when update data in a table (SQL server, MySQL, Postgresql) (it is running well with insert and update operations)
> Reporter: thuy le
> Priority: Major
> Attachments: image-2019-07-25-11-32-19-469.png
>
>
> Apache Nifi (version 1.9.2) error when update data in a table (SQL server, MySQL, Postgresql) (it is running well with insert and update operations)
>
> !https://community.hortonworks.com/storage/attachments/110025-1563909312644.png|width=736,height=242!
>
> _With Delete they do correct_
> !https://community.hortonworks.com/storage/attachments/110007-1563910599280.png|width=932,height=127!
> !https://community.hortonworks.com/storage/attachments/110013-1563910653675.png|width=828,height=156!
>
>
> *+with Update+*_: They automatic change Primarykey from_ *product_key* _to PRODUCTKEY (_I tested with *_PutSQL_* and *_PutDatabaseRecord_* it have the same issue)
> !https://community.hortonworks.com/storage/attachments/110006-1563910561236.png|width=703,height=94!!https://community.hortonworks.com/storage/attachments/110005-1563910541777.png|width=605,height=83!
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)