[
https://issues.apache.org/jira/browse/IGNITE-28924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18099991#comment-18099991
]
Ignite TC Bot commented on IGNITE-28924:
----------------------------------------
{panel:title=Branch: [pull/13405/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13405/head] Base: [master] : New Tests
(2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
2|https://ci2.ignite.apache.org/viewLog.html?buildId=9234713]]
* {color:#013220}IgniteCalciteTestSuite3:
OperatorsExtensionIntegrationTest.testCustomAggregateUsesDefaultDistinctHandling
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
OperatorsExtensionIntegrationTest.testCustomAggregateHandlesDistinct -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9234746&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9234746
rerunBuildIds=9236449,9236451,9236453,9236455,9236457{color}
> SQL Calcite: Add the ability to implement a custom DistinctAccumulator
> ----------------------------------------------------------------------
>
> Key: IGNITE-28924
> URL: https://issues.apache.org/jira/browse/IGNITE-28924
> Project: Ignite
> Issue Type: Improvement
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
> Labels: ignite-2
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently, we can add our own
> *org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.Accumulator*
> via a
> {*}org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorFactoryProvider{*}.
> However, for *DISTINCT* operations, we cannot define a custom accumulator
> that independently tracks unique values.
> For example, if we were to implement an aggregate function like
> {*}AVG_WITH_KEEP(DISTINCT salary, 'FIRST') WITHIN GROUP (ORDER BY
> COALESCE(priority, 99) ASC, sale DESC){*}, we would need to get a unique
> value based on the group rather than the column; to achieve this, we would
> need to define our own {*}DistinctAccumulator{*}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
