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 Streamable

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 

Extracts the data specification from the input DB Data port.

DB Query Extractor 

Extracts the SQL query from the input DB Data port.

DB Type Mapper Streamable

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

DB Writer (DB Data) Streamable

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.