Hub

27 results

Filter
Filter by tag
H2
SQL Database Databse Create Update From Rank
  1. 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
  2. Workflow
    H2O AutoML on Spark
    Spark H2o Automl
    +4
    This workflow trains classification models for the Airlines Delay dataset using H2O AutoML on Spark. The dataset is expected to b…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 13_H2O_AutoML_on_Spark
    0
    knime
  3. 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
  4. 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
  5. Workflow
    use H2 and KNIME to realize a BETWEEN match of timestamps
    Sql Join Time
    +3
    use H2 and KNIME to realize a BETWEEN match of timestamps… KNIME, Databases and SQL https://medium.com/p/273e27c9702a
    mlauber71 > Public > kn_example_db_h2_join_by_timestamp > m_001_db_h2_join_timestamp
    0
    mlauber71
  6. Workflow
    Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
    H2 Sql Create
    +5
    Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
    mlauber71 > Public > kn_example_db_h2_primary_key
    0
    mlauber71
  7. Workflow
    School of duplicates - and how to deal with them - H2 version
    Sql Duplicates Remove
    +7
    Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easienst ways to deal with…
    mlauber71 > Public > kn_example_duplicates_school_of_db_h2
    0
    mlauber71
  8. Workflow
    Prepare the Northwind database into a consistant H2 db to provide a database environment to play with
    H2 SQLIte Northwind
    +3
    These tables are included in the local database
    mlauber71 > Public > kn_example_db_h2_prepare_northwind_db_small > m_001_prepare_northwind_db_h2
    0
    mlauber71
  9. Workflow
    forum 44727 - 01 Practicing with Traditional Databases
    Big data Database H2
    +3
    forum 44727 - 01 Practicing with Traditional Databases
    mlauber71 > Forum > 2022 > kn_forum_44727_l4_bd_course_practice_db_tables
    0
    mlauber71
  10. Workflow
    H2 java based database example
    H2 Database Sql
    H2 is a free database you can use with KNIME either as a file on your drive or as an in memory DB
    mlauber71 > Public > kn_example_h2_database > m_001_h2_db
    0
    mlauber71
  11. Workflow
    Insert update with KNIME only nodes by an ID
    H2 Refernce Row
    +4
    Insert update with KNIME only nodes by an ID
    mlauber71 > Public > forum > kn_forum_32016_insert_on_duplicate
    0
    mlauber71
  12. Workflow
    H2 do an UPDATE on the server using a VIEW of the existing and the new data
    H2 Update Append
    +2
    H2 do an UPDATE on the server using a VIEW of the existing and the new data
    mlauber71 > Public > kn_example_db_h2_update_in_databse
    0
    mlauber71
  13. Workflow
    use H2 to produce a Position / Rank number within a group variable (window functions)
    Position Rank Nulls
    +6
    use H2 to produce a Position / Rank number within a group variable (window functions) use custom JDBC driver - THX tobias.koetter…
    mlauber71 > Public > forum > kn_forum_31608_h2_group_rank_window_function
    0
    mlauber71
  14. Workflow
    s_605 - use the stored rules and lists to actually prepare the data
    Spark H2o Data
    +4
    s_605 - apply the label encoding and other transformations stored in SQL code and the selected final column as RegEx string Get t…
    mlauber71 > Public > kn_example_bigdata_h2o_automl_spark_46 > s_605_spark_prepare_data
    0
    mlauber71
  15. Workflow
    Example how to use H2 database with a uuid unique identifier
    H2 Sql Create
    +6
    Example how to use H2 database with a uuid unique identifier
    mlauber71 > Forum > 2021 > kn_forum_36064_db_h2_use_uuid_unique_identifier
    1
    mlauber71
  16. Workflow
    Transform a MySQL dump to H2 (local) database using KNIME
    Mysql Dump H2
    +5
    OK, I built something since the mentioned examples are not straightforward (if you want to play around with them further in a sub…
    mlauber71 > Public > forum > kn_forum_mysqldump_import
    0
    mlauber71
  17. Workflow
    MERGE an existing database and insert new rows with H2 - use the Northwind DB
    H2 Update Append
    +3
    MERGE an existing database and insert new rows with H2 - use the Northwind DB
    mlauber71 > Public > kn_example_db_h2_merge
    0
    mlauber71
  18. Workflow
    convert Long value to string to use it in DB query (forum 44798)
    Db Database Long
    +4
    convert Long value to string to use it in DB query (forum 44798)
    mlauber71 > Forum > 2022 > kn_forum_44798_database_long_value
    0
    mlauber71
  19. Workflow
    create table in MySQL and create a dynamic WHERE clause with integers and strings
    Mysql Sql Db
    +2
    create table in MySQL and create a dynamic WHERE clause with integers and strings
    mlauber71 > Public > kn_example_db_mysql_where_clause
    0
    mlauber71
  20. Workflow
    DB_vs_KNIME
    Database H2 Database preprocessing
    Comparing data processing with DB nodes vs KNIME nodes.
    hayasaka > Public > DB_vs_KNIME
    0
    hayasaka