Knime H2 query DISTINCT ON problem

[89trunks]

Hi,

I have problem with query DISTINCT ON in H2.

I am using H2 connector (in-memory).

My test table looks like

My query using DB Query

SELECT DISTINCT ON (“Product”) * FROM #table# “t1” ORDER BY “Product”, “Date” DESC;

But I get error

The result of my query should be

Thanks in advace for help.

[AlexanderFillbrunn]

Hi,
It works for me like this:

SELECT DISTINCT ON (t1."Product") * FROM #table# t1 ORDER BY t1."Product", t1."Date" DESC;

Kind regards,
Alexander