[
https://issues.apache.org/jira/browse/NIFI-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16994242#comment-16994242
]
ZhangCheng commented on NIFI-5840:
----------------------------------
add primary key in 'order by' can solve this issue
> GenerateTableFetch--repeated record
> -----------------------------------
>
> Key: NIFI-5840
> URL: https://issues.apache.org/jira/browse/NIFI-5840
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Flow Versioning
> Affects Versions: 1.8.0
> Reporter: qingbo li
> Priority: Trivial
> Labels: GenerateTableFetch
>
> when GenerateTableFetch processor assign aximum-value Columns value,such as
> "created_date" col, There may be duplicate data when paging database because
> of the "created_date" col has same value.So，I recommend sql statement order
> by part plus primary key field to avoid this problem.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
