SQLITE and Window Functions


I am unable to use WINDOW functions while querying a sqlite database.

Is there a way to check what version of sqlite KNIME is using?

Is it possible to update the SQLITE version on my KNIME installation?

The latest version of sqlite do support window functions:

Any guidance is highly appreciated!!


1 Like

@khatuaani welcome to the KNIME forum.

To find the sqlite version this command should help

select sqlite_version();


Unfortunately also the H2 SQL database implementation of a local database in KNIME is one version to old to support window functions:

The only way to use window functions in a local database with KNIME without installing MariaDB or Postgres or the like is using the Hive implementation in the local big data environment. But that is not suitable for permanent storage of data.

Of course the always is the rank node in KNIME itself:


Hello khatuaani,
the SQLite version that is shipped with KNIME Analytics Platform is 3.23.1. I have created a feature request to update the driver.
Until then you can also register a newer version of the driver and also the H2 driver. The SQLite JDBC drivers includes everything you need so simply download it from here and register it in KNIME as described in the DB documentation.


@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.

@khatuaani now you can benefit from the latest developments with H2 (and SQLite).


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.