0 ×

Database Sampling (legacy)

KNIME Base Nodes version 4.3.2.v202103021015 by KNIME AG, Zurich, Switzerland

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

This node extracts a sample (a bunch of rows) from the input data of a database. The dialog enables you to specify the sample size. The following options are available in the dialog:

Options

Absolute: Specify the absolute number of rows in the sample. If there are less rows than specified here, all rows are used.
Relative: The percentage of the number of rows in the sample. Must be between 0 and 100, inclusively.
Take from top: This mode selects the top most rows of the table. Note that this depends on the implementation of the connected database.
Draw randomly: Random sampling of all rows if connected database will support random sampling. Note that this method might be very slow for large database tables.
Stratified sampling: Check this button if you want stratified sampling, i.e. the distribution of values in the selected column is (approximately) retained in the output table.

Input Ports

: Table in database to apply database sampling

Output Ports

: Table in the database with sampled rows

Best Friends (Incoming)

Best Friends (Outgoing)

Database Connection Table Reader (legacy) (22 %)
Database Connection Table Writer (legacy) (21 %)
Database GroupBy (legacy) (18 %)
SQL Extract (legacy) (6 %)
Database Joiner (legacy) (5 %)
Show all 31 recommendations

Workflows

kn_forum_sqlite_skip_missing_column (KNIME Hub)

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.