NodeNode / Manipulator

Database SQL Executor (legacy)

This node is part of the legacy database framework. 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.

Input ports
  1. Database Connection Type: Database Connection
    Connection to the database.
Output ports
  1. Database Connection Type: Database Connection
    Same as input.
  1. 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
  2. Model Deployment SQL Recoding
    Deployment File Database +7
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from a database,…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
  3. 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