Hub

405 results

Filter
Database SQL Big data Hive Spark
+13
  1. Workflow
    Spark SQL meets Hive SQL
    Spark Hive Hadoop
    +3
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In particular, wo…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 3_Spark > 4_Examples > 07_SparkSQL_meets_HiveQL
    0
  2. Workflow
    Spark SQL meets Hive SQL
    Spark Hive Hadoop
    +4
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In particular, wo…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 07_SparkSQL_meets_HiveQL
    0
  3. Workflow
    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, reads the…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
    0
  4. Workflow
    In-Database Processing on SQL Server
    ETL KNIME Microsoft
    +3
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It starts with a dedicated SQL Server Connector…
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)
    0
  5. Node / Other
    PMML to SQL
    KNIME Labs PMML PMML Translation
    Generates SQL queries from PMML models. The following model types are currently supported: Regression (linear, polynomial, logist…
    0
  6. Component
    SQL Lag
    Compute the LAG() function in a DB table in a Azure Database or Microsoft SQL server Database
    ana_ved > T-SQL Components > SQL Lag
    0
  7. Component
    SQL Set Operator
    iris > Public > components > SQL Set Operator
    0
  8. Workflow
    SQL Set Operation (UNION) (migrated)
    iris > Public > SQL Set Operation (UNION) (migrated)
    0
  9. Workflow
    Dynamic SQL and parameter passing
    Parameterized DB Query Reader DB Query Dynamic SQL
    +2
    Demonstration of Parameterized DB Query Reader and DB Query Reader, dynamically passing parameters and also dynamically specifyin…
    takbb > Public > Demo Workflows > Dynamic SQL and Parameter Passing
    0
  10. Component
    SQL Column Names
    Get the column names of a table in a Azure Database or Microsoft SQL server Database as flow variables
    ana_ved > T-SQL Components > SQL Column Names
    0
  11. Workflow
    Taxi demand prediction deployment
    Demand prediction Random forest Time series prediction
    +5
    In this use case, we will use the NYC taxi dataset and a Random Forest to train a simple time series prediction model to predict …
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 11_Taxi_Demand_Prediction > Deployment_workflow
    2
  12. Node / Other
    SQL Inject (legacy)
    DB Database (legacy) Utility (legacy)
    This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migr…
    0
  13. Component
    SQL Set Operator (4ports)
    iris > Public > components > SQL Set Operator (4ports)
    0
  14. Workflow
    Recommending Restaurants Using Association Rules
    Recommendation engine Retail Supply chain
    +3
    In this workflow we demonstrate how to use the KNIME Spark nodes for giving locality recommendations. For this we are using the Y…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 08_Learning_Asociation_Rule_for_Next_Restaurant_Prediction
    0
  15. Node / Other
    SQL Extract (legacy)
    DB Database (legacy) Utility (legacy)
    This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migr…
    0
  16. Node / Manipulator
    DB SQL Executor
    DB Utility
    This node allows custom SQL statements to be executed on the input database. The output port can be used for flow control, to pre…
    0
  17. Node / Other
    Spark SQL Query
    Tools & Services Apache Spark Misc
    Executes a Spark SQL query statement. Use #table# as table name placeholder. Press Ctrl+SPACE for code completion. See Spark SQL …
    0
  18. Node / Source
    Microsoft SQL Server Connector
    DB Connection
    This node creates a connection to a Microsoft SQL Server, an Azure SQL Database or Azure Synapse SQL pool via its JDBC driver. Yo…
    0
  19. Workflow
    Taxi Demand Prediction on Spark Deployment
    Demand prediction Random forest Time series prediction
    +4
    This workflow applies a time series prediction model (Random Forest) to the NYC taxi dataset to predict taxi demand in the next h…
    knime > Codeless Time Series Analysis with KNIME > Chapter 12 > 02 Taxi Demand Prediction on Spark Deployment
    0
  20. Workflow
    Seasonality removal
    Spark Time Series
    This workflow uses a subset of the popular NYC taxi dataset and Spark Random Forest node to train a simple time series prediction…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 11_Taxi_Demand_Prediction > Seasonality_Removal
    0