Hub
NodeNode / Manipulator

Database SQL Executor (legacy)

DB Database (legacy) Utility (legacy)
Drag & drop
Like
Copy short link

This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migrate to the new database framework see the migration section of the database documentation .

This node allows custom SQL Statements to be executed on the input database. The output port can be used for flow control, to prevent subsequent nodes from executing if the execution of this Statement fails.

Node details

Input ports
  1. Type: Database Connection
    Database Connection
    Connection to the database.
Output ports
  1. Type: Database Connection
    Database Connection
    Same as input.

Extension

The Database SQL Executor (legacy) node is part of this extension:

Related workflows & nodes

  1. test 1
    liuzhang > Public > test 1
    liuzhang
  2. Model Deployment SQL Recoding
    Deployment File Database
    +7
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads ne…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
    iris
  3. add fields to Hive table
    Hive Sql Big data
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > kn_example_bigdata_hive_add_column
    mlauber71
  4. Hive - how to get from DB-Connectors to Hive (or Impala) tables - Legacy nodes up to vers. 3.7.x
    Big data Hive Impala
    +2
    Hive - how to get from DB-Connectors to Hive (or Impala) tables
    mlauber71 > Public > kn_example_hive_db_loader_37
    mlauber71