You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Andrew M. Lim (Jira)" <ji...@apache.org> on 2022/09/14 18:25:00 UTC

[jira] [Updated] (NIFI-10503) GenerateTableFetch processor has multiple references to "flow file" instead of "FlowFile"

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

Andrew M. Lim updated NIFI-10503:
---------------------------------
    Description: 
The property "Output Empty FlowFile on Zero Results" has the description:

Depending on the specified properties, an execution of this processor may not result in any SQL statements generated. When this property is true, an empty *flow file* will be generated (having the parent of the incoming *flow file* if present) and transferred to the 'success' relationship. "When this property is false, no output *flow files* will be generated.

Additionally, the usage docs has this in the description:

"Generates SQL select queries that fetch "pages" of rows from a table. The partition size property, along with the table's row count, determine the size and number of pages and generated FlowFiles. In addition, incremental fetching can be achieved by setting Maximum-Value Columns, which causes the processor to track the columns' maximum values, thus only fetching rows whose columns' values exceed the observed maximums. This processor is intended to be run on the Primary Node only. This processor can accept incoming connections; the behavior of the processor is different whether incoming connections are provided: - If no incoming connection(s) are specified, the processor will generate SQL queries on the specified processor schedule. Expression Language is supported for many fields, but no *flow file* attributes are available. However the properties will be evaluated using the Variable Registry. - If incoming connection(s) are specified and no *flow file* is available to a processor task, no work will be performed. - If incoming connection(s) are specified and a *flow file* is available to a processor task, the *flow file's* attributes may be used in Expression Language for such fields as Table Name and others. However, the Max-Value Columns and Columns to Return fields must be empty or refer to columns that are available in each specified table."

and this in the Additional Details:

"GenerateTableFetch uses its properties and the specified database connection to generate *flow files* containing SQL statements that can be used..."

  was:
The property "Output Empty FlowFile on Zero Results" has the description:

Depending on the specified properties, an execution of this processor may not result in any SQL statements generated. When this property is true, an empty flow file will be generated (having the parent of the incoming flow file if present) and transferred to the 'success' relationship. "When this property is false, no output flow files will be generated.

Additionally, the usage docs has this in the description:

"GenerateTableFetch uses its properties and the specified database connection to generate flow files containing SQL statements that can be used..."


> GenerateTableFetch processor has multiple references to "flow file" instead of "FlowFile"
> -----------------------------------------------------------------------------------------
>
>                 Key: NIFI-10503
>                 URL: https://issues.apache.org/jira/browse/NIFI-10503
>             Project: Apache NiFi
>          Issue Type: Improvement
>          Components: Core UI, Documentation &amp; Website
>            Reporter: Andrew M. Lim
>            Priority: Trivial
>
> The property "Output Empty FlowFile on Zero Results" has the description:
> Depending on the specified properties, an execution of this processor may not result in any SQL statements generated. When this property is true, an empty *flow file* will be generated (having the parent of the incoming *flow file* if present) and transferred to the 'success' relationship. "When this property is false, no output *flow files* will be generated.
> Additionally, the usage docs has this in the description:
> "Generates SQL select queries that fetch "pages" of rows from a table. The partition size property, along with the table's row count, determine the size and number of pages and generated FlowFiles. In addition, incremental fetching can be achieved by setting Maximum-Value Columns, which causes the processor to track the columns' maximum values, thus only fetching rows whose columns' values exceed the observed maximums. This processor is intended to be run on the Primary Node only. This processor can accept incoming connections; the behavior of the processor is different whether incoming connections are provided: - If no incoming connection(s) are specified, the processor will generate SQL queries on the specified processor schedule. Expression Language is supported for many fields, but no *flow file* attributes are available. However the properties will be evaluated using the Variable Registry. - If incoming connection(s) are specified and no *flow file* is available to a processor task, no work will be performed. - If incoming connection(s) are specified and a *flow file* is available to a processor task, the *flow file's* attributes may be used in Expression Language for such fields as Table Name and others. However, the Max-Value Columns and Columns to Return fields must be empty or refer to columns that are available in each specified table."
> and this in the Additional Details:
> "GenerateTableFetch uses its properties and the specified database connection to generate *flow files* containing SQL statements that can be used..."



--
This message was sent by Atlassian Jira
(v8.20.10#820010)