Node Connectivity

There are 102 nodes that can be used as successor for a node with an output port of type Database Query.

Database Table Creator Deprecated

This node allows a user to create a new database table either manually or based on the data table spec of an input data table.

Database Table Selector Deprecated

Selects a table from a database using the input database JDBC connection.

Database Update Deprecated

Updates the selected rows in the database with the data values from the input tables.

Database Writer StreamableDeprecated

Establishes and opens a database access connection to which the entire input table is written to.

Hive Loader (legacy) Deprecated

Loads data from KNIME into Hive

Impala Loader (legacy) Deprecated

Loads data from KNIME into Impala

Model Writer Deprecated

Writes generic port objects to a file.

Parameterized Database Query Deprecated

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

Python Script (Hive) Deprecated

Allows execution of a Python script in a local Python installation.

Run R Model in Microsoft SQL Server Deprecated

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