Hub

4 results

Filter
H2
Sql
Rank
Database Function Window SQLite Cloudera
  1. 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
  2. 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
  3. Workflow
    remove duplicates with condition and add the last date
    H2 SQL Rank
    +1
    remove duplicates with condition and add the last date
    mlauber71 > Forum > 2022 > kn_forum_38543_rank_deduplicate
    0
    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