NodeDatabase Sorter (legacy)

Manipulator

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 rows to be sorted from the input database table. Within the dialog, an SQL ORDER BY clause is interactively created by selecting the columns and sort directions.

Input ports
  1. Database Connection Type: Database Query
    Table in database to apply sorter
Output ports
  1. Database Connection Type: Database Query
    Table in the database with sorted rows
  1. Basic RESTful Web Services Example 1
    Demonstrates how to create a REST-based web service that can be deployed via the KNIME Server.
    knime > Examples > 09_Enterprise > 01_Server > 01_RESTful_Services > 01_Create_basic_service
  2. Big Data Preprocessing
    Hive Hadoop Big Data SQL in-database
    This workflow demonstrates the usage of the database nodes in conjunction with the Hive Connector node, which is part of…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example
  3. In-Database Processing on SQL Server
    ETL KNIME Microsoft Azure In database Processing SQL Server
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It starts with a dedicated SQL Server …
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)