DB Partitioning

Manipulator

This node split rows from a database table. The dialog enables you to specify the number of rows to split and the splitting strategy.

The created partitions might overlap depending on the database and the selected sampling option. KNIME is not storing the data of the first partition in any way but is executing the query that represents the first partition also as part of the query to retrieve the second partition. If the query that defines the first partition returns a different result for each execution the two partitions might overlap. This is most likely the case for random sampling without a fixed seed.

Input Ports

  1. Type: DB Data
    Table in database to apply database sampling

Output Ports

  1. Type: DB Data
    Table in the database with sampled rows
  2. Type: DB Data
    Table in the database with remaining rows

Extension

This node is part of the extension

KNIME Database

v4.0.0

Short Link

Drag node into KNIME Analytics Platform