Icon

m_​001_​db_​h2_​join_​timestamp

use H2 and KNIME to realize a BETWEEN match of timestamps

use H2 and KNIME to realize a BETWEEN match of timestamps…


KNIME, Databases and SQL
https://medium.com/p/273e27c9702a

DROP TABLE IF EXISTS "PUBLIC"."result_01"; CREATE TABLE "PUBLIC"."result_01" ASSELECT measures."measure" as measure, measures."time" as time, intervals."entry_time" as entry_time, intervals."exit_time" as exit_time, intervals."v_random_id" as v_random_idFROM "PUBLIC"."intervals" intervalsINNER JOIN "PUBLIC"."measures" measures ON measures."time" BETWEEN intervals."entry_time" AND intervals."exit_time"ORDER BY intervals."v_random_id" ASC, measures."time" ASC; use H2 and KNIME to realize a BETWEEN match of timestampshttps://forum.knime.com/t/efficient-way-of-doing-a-join-where/27474/3?u=mlauber71 KNIME, Databases and SQLhttps://medium.com/p/273e27c9702a database.h2intervals../data/result_01.tableintervalsmeasuresmeasures"PUBLIC"."result_01""PUBLIC"."result_01"../data/measures.table../data/intervals.tablemeasuresintervals H2 Connector DB Writer Table Writer DB Table Remover DB Table Remover DB Writer DB SQL Executor DB Table Selector DB Reader Table Reader Table Reader DB Table Creator DB Table Creator DROP TABLE IF EXISTS "PUBLIC"."result_01"; CREATE TABLE "PUBLIC"."result_01" ASSELECT measures."measure" as measure, measures."time" as time, intervals."entry_time" as entry_time, intervals."exit_time" as exit_time, intervals."v_random_id" as v_random_idFROM "PUBLIC"."intervals" intervalsINNER JOIN "PUBLIC"."measures" measures ON measures."time" BETWEEN intervals."entry_time" AND intervals."exit_time"ORDER BY intervals."v_random_id" ASC, measures."time" ASC; use H2 and KNIME to realize a BETWEEN match of timestampshttps://forum.knime.com/t/efficient-way-of-doing-a-join-where/27474/3?u=mlauber71 KNIME, Databases and SQLhttps://medium.com/p/273e27c9702a database.h2intervals../data/result_01.tableintervalsmeasuresmeasures"PUBLIC"."result_01""PUBLIC"."result_01"../data/measures.table../data/intervals.tablemeasuresintervalsH2 Connector DB Writer Table Writer DB Table Remover DB Table Remover DB Writer DB SQL Executor DB Table Selector DB Reader Table Reader Table Reader DB Table Creator DB Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2020-09-18
On NodePit since: 2020-09-19
Last update: 2024-05-02
Created with KNIME version: v4.7.7
Tags: sqljointimetimestamph2database

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!