[jira] [Updated] (NIFI-7824) GenerateTableFetch Improvement

["Matt Burgess (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-7824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Burgess updated NIFI-7824:
-------------------------------
    Status: Patch Available  (was: Open)

> GenerateTableFetch Improvement
> ------------------------------
>
>                 Key: NIFI-7824
>                 URL: https://issues.apache.org/jira/browse/NIFI-7824
>             Project: Apache NiFi
>          Issue Type: Improvement
>          Components: Extensions
>            Reporter: ZhangCheng
>            Assignee: ZhangCheng
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> ‘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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)