NodeDatabase Row Filter (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 filtered from the input database table while the SQL result will only contain the remaining rows. Within the dialog, an SQL WHERE clause is interactively created by selecting a column, an operator, and a filter value.

Input ports

  1. Database Connection Type: Database Query
    Table in database to apply row filter

Output ports

  1. Database Connection Type: Database Query
    Table in the database with filtered rows

  1. Big Data Analytics - Model Selection to Predict Flight Departure Delays on Hive & Spark

    data blending data science machine learning Hadoop Spark model selection data preparation ETL airline data set flight delay
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData

  2. Will they blend? Twitter and PostGreSQL Database

    data blending database PostGreSQL Twitter
    This is a mini-workflow for Data WareHousing, in particular it archiviates daily tweets.History is saved in a PostGreSQL…
    knime > Examples > 08_Other_Analytics_Types > 04_Social_Media > 01_Twitter_meets_PostgreSQL

  3. 01_Bioactivity_Prediction_Load_Pull_Data

    This workflow is the first one executed by the model factory. It pulls the data from the ChEMBLdb (https://www.ebi.ac.uk…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data

  4. 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

  5. Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.

    BlobStorage ETL KNIME Microsoft Azure In database Processing SQL Server
    This workflow reads CENSUS data from a SQL Server database; it then performs some In-Database Processing on SQL Server; …
    knime > Examples > 40_Partners > 01_Microsoft > 02_SQLServer_BlobStorage_andKNIMEModels

  6. 01_Guided_Analytics

    Having such a big competition on the market, companies face the problem of defining and implementing right pricing strat…
    mrameez > 01_Guided_Analytics

  7. Databases - Advanced Usage

    Shows a KNIME workflow with a number of database nodes that directly work inside a database. Note, this flow uses the sq…
    knime > Examples > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example

  8. 01_Guided_Analytics

    Having such a big competition on the market, companies face the problem of defining and implementing right pricing strat…
    knime > Examples > 50_Applications > 44_Price_Benchmarking > 01_Guided_Analytics

  9. Advanced Row Filtering

    row filter advanced row filter
    Not only simple filtering with the Row Filter node, but also: filtering according to more complex rules with Nominal Val…
    knime > Examples > 02_ETL_Data_Manipulation > 01_Filtering > 04_Advanced_Row_Filters

  10. Spark SQL meets Hive SQL. Age distribution for Men and Women in Maine (US) over the last 5 years.

    Spark Hive Hadoop Big Data SQL in-database
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In parti…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 07_SparkSQL_meets_HiveQL