Database Sampling (legacy)
KNIME Base Nodes version 4.1.3.v202005112252 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
Output Ports
Best Friends (Incoming)
- Database Table Selector (legacy) (18 %)
- Database Joiner (legacy) (12 %)
- Database Row Filter (legacy) (11 %)
- Database Query (legacy) (9 %)
- Database Table Connector (legacy) (9 %)
- Database Connector (legacy) (5 %)
- Database Column Filter (legacy) (4 %)
- Database SQL Executor (legacy) (4 %)
- Database Sorter (legacy) (4 %)
- Database GroupBy (legacy) (4 %)
- Java Edit Variable (4 %)
- Read Variables (2 %)
- Table Row To Variable Loop Start (2 %)
- Database Auto-Binner (legacy) (2 %)
- Database Numeric-Binner (legacy) (2 %)
- Database Pivot (legacy) (2 %)
- Database Table Creator (legacy) (2 %)
- Amazon Redshift Connector (legacy) (2 %)
- MySQL Connector (legacy) (2 %)
- SQLite Connector (legacy) (2 %)
- Microsoft SQL Server Connector (legacy) (2 %)
- String Input (2 %)
- Show all 22 recommendations
Best Friends (Outgoing)
- Database Connection Table Reader (legacy) (61 %)
- Database Joiner (legacy) (10 %)
- Database GroupBy (legacy) (7 %)
- Database Connection Table Writer (legacy) (3 %)
- Database Query (legacy) (3 %)
- Database Reader (legacy) (3 %)
- Hive to Spark (1 %)
- Inject Variables (Database) (1 %)
- Database Column Filter (legacy) (1 %)
- Database Row Filter (legacy) (1 %)
- Database SQL Executor (legacy) (1 %)
- Database Writer (legacy) (1 %) Streamable
- SQL Extract (legacy) (1 %)
- Database Pivot (legacy) (1 %)
- Hive to Spark (1 %)
- Show all 15 recommendations
Workflows
Installation
To use this node in KNIME, install KNIME Core from the following update site:
A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.
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.