UDFs: Input to JavaScript UDTFs Grouped Into a Single Partition

Attention

This behavior change is in the 2023_04 bundle.

For the current status of the bundle, refer to Bundle History.

For a JavaScript UDTF with an empty OVER clause, the behavior of the grouping of input rows is as follows:

Previously:

In a JavaScript UDTF with an empty OVER clause, input is partitioned as if the OVER clause is absent. In contrast, documentation states that input rows belong to a single partition.

Currently:

JavaScript Table function input rows will be grouped into a single partition. This is as previously documented.

To discover impact from this change, confirm whether you’ve used a JavaScript UDTF with an explicit empty OVER clause and whether the results have more per-partition rows than you expect (there should be one or zero such rows).

Ref: 595

Language: English