Create Partition Column

0 ×

Options

Number of partitions (Fixed Partitions) or Number of rows per partition (Variable Partitions)

If FIXED partitions - Specify the number of partitions required.Depending on the number of rows, the resulting partitions may be fewer than this number.%%00010if VARIABLE partitions - specify the maximum number of rows per partition

Partition creation strategy

Decide if the number of partitions is fixed, or variable%%00010%%00010Fixed (specify number of partitions) - define a fixed number of partitions based on the number specified%%00010%%00010Variable (specify rows per partition) - a variable number of partitions based on a maximum number of rows per partition

Row Partition Strategy

Decide how the partition for each row should be determined.%%00010%%00010Chunks - rows are assigned in chunks, so that a chunk of rows is assigned to partition 1, then a chunk is assigned to partition 2, until the n partitions have been allocatyed. Not all partitions will be the same size, and the number of rows in any given chunk will be determined by dividing the number of rows in the table by the number of required chunks. Where the number of rows is not exactly divisible by the number of tables, the "surplus" rows (if any) will be spread arbitrarily across the partitions.%%00010%%00010Rotation - the first row is partition 1, the second row partition 2, up to n rows in n partitions, at which point the n+1th row is assigned partition 1 and the next is partition 2 and so on repeatedly until all rows have been assigned partitions. in mathematical terms, the rows are allocated to "modulo(rownumber, n)+1"

Partition Column Name

Enter a name for the partition column

Nodes

• Math Formula2 ×
• Math Formula (Variable)2 ×
• Single Selection Configuration2 ×
• Component Input1 ×
• Component Output1 ×
• Show all 9 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms

Links

• No links available