[jira] [Updated] (NIFI-2736) Allow arbitrary (non-hierarchical) columns to be used for max values in QueryDatabaseTable/GenerateTableFetch
[ https://issues.apache.org/jira/browse/NIFI-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joseph Witt updated NIFI-2736: -- Fix Version/s: (was: 1.1.0) > Allow arbitrary (non-hierarchical) columns to be used for max values in > QueryDatabaseTable/GenerateTableFetch > - > > Key: NIFI-2736 > URL: https://issues.apache.org/jira/browse/NIFI-2736 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Reporter: Jeff Storck >Priority: Minor > > To build on the functionality that NIFI-2712 adds to > QueryDatabaseTable/GenerateTableFetch, it would be beneficial to be able to > use max value columns that are non-hierarchical. > NIFI-2712 adds the capability to get data from tables based on a primary > column (which uses a > to find greater values) and partition/bucket columns > (which use >= to find equal or greater values) which are all ANDed together. > In the case where a user would want multiple max value columns that are not > considered hierarchical, max value columns would be ORed together with > > (greater than), so that any max value column that increased from the last > invocation would result in rows being returned. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (NIFI-2736) Allow arbitrary (non-hierarchical) columns to be used for max values in QueryDatabaseTable/GenerateTableFetch
[ https://issues.apache.org/jira/browse/NIFI-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeff Storck updated NIFI-2736: -- Summary: Allow arbitrary (non-hierarchical) columns to be used for max values in QueryDatabaseTable/GenerateTableFetch (was: Allow arbitrary (non-hierarchical) columns to be used for max values in QueryDatabaseTable//GenerateTableFetch) > Allow arbitrary (non-hierarchical) columns to be used for max values in > QueryDatabaseTable/GenerateTableFetch > - > > Key: NIFI-2736 > URL: https://issues.apache.org/jira/browse/NIFI-2736 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Reporter: Jeff Storck >Priority: Minor > Fix For: 1.1.0 > > > To build on the functionality that NIFI-2712 adds to > QueryDatabaseTable/GenerateTableFetch, it would be beneficial to be able to > use max value columns that are non-hierarchical. > NIFI-2712 adds the capability to get data from tables based on a primary > column (which uses a > to find greater values) and partition/bucket columns > (which use >= to find equal or greater values) which are all ANDed together. > In the case where a user would want multiple max value columns that are not > considered hierarchical, max value columns would be ORed together with > > (greater than), so that any max value column that increased from the last > invocation would result in rows being returned. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
