Node Connectivity

There are 70 nodes that can be used as successor for a node with an output port of type DB Data.

DB Table Partitioner StreamableModern UI

The input table is split into two partitions (i.e. row-wise), e.g. train and test data.

DB Looping Streamable

This node runs SQL queries in the connected database restricted by the possible values given by the input table.

DB Reader Streamable

Executes the input query in the database and retrieves the result into a KNIME data table.

Parameterized DB Query Reader Streamable

This node runs SQL queries in the connected database restricted by the possible values given by the input KNIME data table.

DB Data Spec Extractor Modern UI

Extracts the column specification from a DB Data input port.

DB Query Extractor Modern UI

Extracts the SQL query from the input DB Data port.

DB Type Mapper StreamableModern UI

Enables you to change the database to KNIME type mapping for subsequent nodes.

DB Writer (DB Data) StreamableModern UI

Writes the input database table into a new database table.

DB to Spark 

Reads a database query/table into a Spark RDD/DataFrame

Hive to Spark 

Imports the result of an incoming Hive query into Spark as a DataFrame/RDD.