feduss
March 12, 2021, 6:50pm
1
Hi, how can i use OVER clause in a query? It gives me an error
@feduss welcome to the KNIME forum.
If you want to use OVER like in an SQL code you might use a database node but this would depend on the implementation of window functions in your database.
@chanoufi_marwa one way to do it is to use a Hive environment and a RANK function. Other SQL databases should also support RANK like H2 (Window Functions ).
Hint: the KNIME implementation of H2 currently has the version 1.4.196. Unfortunately with H2 the RANK etc functions are only supported with version 1.4.198 or later … @ScottF might be an interesting case to update that version
One example of using OVER just with KNIME resources is shown in this thread using a local big data environment.
Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easiest ways to deal with them is SQL’s GROUP BY or DISTINCT. Just get rid of them and be done. But as this examples might demonstrate this might not always be the best option. Even if your data provider swears your combined IDs are unique especially in Big Data scenarios there might still be lurking some muddy duplicates and you should still be able to deal with them.
And you should be able t…
You might want to add some further details about what you are looking for.
5 Likes
feduss
March 13, 2021, 5:28pm
3
Thanks for the fast reply and the welcome :)! I’m just testing Knime for a possible future implementation
1 Like
system
Closed
March 20, 2021, 5:29pm
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.