Node Connectivity

There are 40 nodes that can be used as predessesor for a node with an input port of type DB Data.

DB Query Injector 

Creates a DB Data port from the input DB Connection and a string variable with the SQL query to use.

DB Type Mapper 

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

Spark to DB 

Writes a Spark DataFrame/RDD into a database table

Spark to Hive 

Writes an incoming Spark DataFrame/RDD into a Hive table.

Spark to Impala 

Writes an incoming Spark DataFrame/RDD into a Impala table.

Run R Model in Microsoft SQL Server 

Run R code with a pre-trained R model on a Microsoft SQL Server in a database.

DB DISTINCT 

This node performs a 'DISTINCT' operation on the selected column(s)

DB Insert Column Header 

This node renames the output columns of a database connection based on the values in a reference table. The underlying database is not affected

DB Numeric Range 

This node performs MIN() and MAX() operations on the selected numeric column(s)

DB Select Table (Interactive) 

This node allows the user to select a table via dropdowns rather than knowing the exact table / schema name