[IGNITE-14539] Calcite engine. Support DISTINCT ON expression

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Taras Ledkov
• Created: 14/Apr/21 11:52
• Updated: 22/Nov/21 13:48

Description

Now DISTINCT ON expression isn't supported.
e.g.:
SELECT DISTINCT ON (lastName) firstName, lastName FROM Person WHERE ...
Test:
aggregate/distinct/test_distinct_on.test_ignored
modules/calcite/src/test/sql/types/string/test_unicode.test_ignore

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities