Hub

75 results

Filter
Filter by tag
SQL
Database Education H2 Database preprocessing Life science SQLite Knime
  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
    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
  5. 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
  6. Workflow
    DuckDB - toy around with KNIME and SQL
    Sql Duckdb
    DuckDB - toy around with KNIME and SQL
    mlauber71 > Public > kn_example_db_duckdb_connection
    0
    mlauber71
  7. Workflow
    Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an embedded script editor. These nodes can be…
    knime > Examples > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    2
    knime
  8. 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
    andriyansyah > Public > kn_example_decision_tree
    0
    andriyansyah
  9. Workflow
    Titanic KNIME Beispiel (deutsch) - SQL Datenbanken mit KNIME
    Knime Titanic Einführung
    +6
    Titanic: Machine Learning from Disaster https://www.kaggle.com/c/titanic Einführung in KNIME (deutsch) - https://hub.knime.com/ml…
    mlauber71 > Public > knime_einfuehrung_beispiel_titanic > m_150_sql_database_titanic
    0
    mlauber71
  10. Workflow
    DB Looping Example
    DB Read/Write DB Loop
    +4
    This workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL query that uses the values f…
    knime > Examples > 01_Data_Access > 02_Databases > 24_DB_Looping
    0
    knime
  11. Workflow
    An example of combining SQL database, loop and case switch
    Case Switch Loop
    +2
    An example of combining SQL database, loop and case switch there are 10 chunks in the database. some of them have fault=1 lines s…
    mlauber71 > Public > kn_example_switch_case_store_file_sql
    0
    mlauber71
  12. Workflow
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
    Database Sql Hive
    +11
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark) KNIME as a powerful data anaylytics platfo…
    mlauber71 > Public > _db_sql_bigdata_hive_spark_meta_collection
    1
    mlauber71
  13. Workflow
    School of Hive - with KNIME's local Big Data environment (SQL for Big Data)
    Hive School Learn
    +12
    School of Hive - with KNIME's local Big Data environment (SQL for Big Data) Demonstrates a collection of Hive functions using KNI…
    mlauber71 > Public > kn_example_hive_school_of
    0
    mlauber71
  14. Workflow
    Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an embedded script editor. These nodes can be…
    haoran > Public > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    0
    haoran
  15. Workflow
    An overview of KNIME based functions to access big data systems (with KNIME's local big data environment)
    Knime Sql Db
    +5
    An overview of KNIME based functions to access big data systems (with KNIME's local big data environment) Use SQL with Impala/Hiv…
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_020_db_access_local_bigdata_tables
    0
    mlauber71
  16. Workflow
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment
    DB SQL Node
    +3
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment The…
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_100_db_create_bigdata_tables
    0
    mlauber71
  17. Workflow
    DB Looping Example
    DB Read/Write DB Loop
    +4
    This workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL query that uses the values f…
    haoran > Public > 01_Data_Access > 02_Databases > 24_DB_Looping
    0
    haoran
  18. Workflow
    add fields to Hive table
    Hive Sql Big data
    +2
    Use KNIME and Hive/SQL syntax to add columnd to a Big Data table (migrated to KNIME 4.0 and new DB nodes)
    mlauber71 > Public > kn_example_bigdata_hive_add_column_db_40
    0
    mlauber71
  19. Workflow
    Example how to use H2 database to create table with upload and from scratch
    H2 Sql Create
    +5
    Example how to use H2 database to create table with upload and from scratch H2 is an SQL database that 'lives' in a single file o…
    mlauber71 > Public > kn_example_db_h2_create_table_from_scratch
    0
    mlauber71
  20. Workflow
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment
    DB SQL Node
    +3
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment The…
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_001_db_create_local_bigdata_tables
    0
    mlauber71