The new Sqlite DB Query Reader doesn't support window function

I have a fairly simple Sqlite query that uses window functions row_number() and it works fine with the legacy Database Reader node but doesn’t work with the new DB Query Reader node.
The error I get is: Execute failed: [SQLITE_ERROR] SQL error or missing database (near "over": syntax error) See attachment
Fantasy-Premier-League Export.knwf (3.3 MB)

@ergest you can install the latest driver yourself. For H2 they will also support window functions

@tobias.koetter you could see if KNIME could update the default drivers


Works beautifully! Thank you.


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