MySQL - DB Partitioning

[mlauber71]

@hhkim the databases supported and their functions in this case would depend on the DB driver not the KNIME node. In this examples you can change the driver and access new functions. You could check if this is possible in your case. You although might loose compatibility in some cases of KNIME dB nodes.

SQLITE and Window Functions

@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver. [image] [image] @khatuaani now you can benefit from the latest developments with H2 (and SQLite).