[NIFI-7824] GenerateTableFetch Improvement

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: Extensions
• Assignee: ZhangCheng
• Reporter: ZhangCheng
• Created: 21/Sep/20 03:03
• Updated: 17/Jul/21 00:06

Description

‘Custom ORDER BY Column’ should have a higher priority than 'Maximum-value Columns' for genarating query sqls when using 'order by'.
For example: we usually use timestamp column as the 'Maximum-value Columns' , and Many values of timestamp are often the same. In this case, querying data often results in duplicate data because of 'order by timestamp '.So if we use timestamp as 'Maximum-value Columns' ,and use a unique column as ‘Custom ORDER BY Column’, and use 'order by unique column ', we would not query duplicate data.

Issue Links

• links to: GitHub Pull Request #4539