Node Connectivity

There are 69 nodes that can be used as successor for a node with an output port of type DB 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 Connection Table Writer 

Writes the input database table into a new database 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 

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

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.

Impala to Spark 

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