[
https://issues.apache.org/jira/browse/NIFI-6950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ZhangCheng updated NIFI-6950:
-----------------------------
Description:
See Also https://issues.apache.org/jira/browse/NIFI-5840
When the Max-Value column has many of the same values,there may be duplicate
data when paging database.
When I'm in this situation, I usually use the ReplaceText Processor to add the
table's pk behind 'order by Max-Value-Column '
Maybe we can add the primary key behind the 'order by' if the pk exists in
DatabaseAdapter's getSelectStatement() automatically.
Or just like https://issues.apache.org/jira/browse/NIFI-6348 ,we allow
GenerateTableFetch to order on a column behind the Max-Value column.We could
add a 'ORDER BY PK Column',which will be used only if Max-Value Column is set
.And we can add the PK manually.
was:
See Also https://issues.apache.org/jira/browse/NIFI-5840
When the Max-Value column has many of the same values,there may be duplicate
data when paging database.
When I'm in this situation, I usually use the ReplaceText Processor to add the
tahle's pk behind 'order by Max-Value-Column '
Maybe we can add the primary key behind the 'order by' if the pk exists in
DatabaseAdapter's getSelectStatement() automatically.
Or just like https://issues.apache.org/jira/browse/NIFI-6348 ,we allow
GenerateTableFetch to order on a column behind the Max-Value column.We could
add a 'PK ORDER BY Column',which will be used only if Max-Value Column is set
.And we can add the PK manually.
> GenerateTableFetch Improvement
> -------------------------------
>
> Key: NIFI-6950
> URL: https://issues.apache.org/jira/browse/NIFI-6950
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Affects Versions: 1.9.2
> Reporter: ZhangCheng
> Priority: Major
>
> See Also https://issues.apache.org/jira/browse/NIFI-5840
> When the Max-Value column has many of the same values,there may be duplicate
> data when paging database.
> When I'm in this situation, I usually use the ReplaceText Processor to add
> the table's pk behind 'order by Max-Value-Column '
> Maybe we can add the primary key behind the 'order by' if the pk exists in
> DatabaseAdapter's getSelectStatement() automatically.
> Or just like https://issues.apache.org/jira/browse/NIFI-6348 ,we allow
> GenerateTableFetch to order on a column behind the Max-Value column.We could
> add a 'ORDER BY PK Column',which will be used only if Max-Value Column is set
> .And we can add the PK manually.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
