Hub

453 results

Filter
Database SQL Spark Big data Education Hive Best practices Data engineer Data engineering Tools & Services
+8
  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
    knime
  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
    knime
  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
    knime
  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
    knime
  5. 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
    ana_ved
  6. 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
    knime
  7. Component
    SQL Set Operator
    iris > Public > components > SQL Set Operator
    0
    iris
  8. 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
    ana_ved
  9. Workflow
    SQL Set Operation (UNION) (migrated)
    iris > Public > SQL Set Operation (UNION) (migrated)
    0
    iris
  10. Component
    SQL Set Operator (4ports)
    iris > Public > components > SQL Set Operator (4ports)
    0
    iris
  11. 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
    takbb
  12. 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
    knime
  13. 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
    knime
  14. Workflow
    Decision Tree with all its exports
    Machine learning Decision tree Sql
    +3
    A simple decision tree with all the possibilities to store the results (as PMML or Ruleset or SQL Code) and evaluation (ROC curve
    mlauber71 > Public > kn_example_decision_tree
    1
    mlauber71
  15. 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
    knime
  16. 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
    knime
  17. 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
    knime
  18. 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
    knime
  19. 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
    knime
  20. Node / Source
    DB Remove SQL From connection
    Community Nodes Vernalis Databases
    +1
    The node strips the empbedded SQL statement(s) out of a database connection, leaving only the authenticated database connection T…
    0
    vernalis