Node Connectivity

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

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.

SQL Extract Deprecated

Extracts the SQL query from a database port.

SQL Inject Deprecated

Creates a database port from a database connection and a SQL query.

PIA Analysis 

PIA Analysis

Database DISTINCT (Legacy) 

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