SQLITE and Window Functions
Hi,
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:
https://www.sqlite.org/windowfunctions.html
Any guidance is highly appreciated!!
Thanks!!