[
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 & 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)
