[jira] [Commented] (CALCITE-2708) In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function come from a single pattern variable
[
https://issues.apache.org/jira/browse/CALCITE-2708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16700063#comment-16700063
]
Dawid Wysakowicz commented on CALCITE-2708:
---
Hi [~julianhyde]
It sounds like a good idea to have some common tests set, I will try to
contribute back some tests that we use. Any pointers to some explanation what
is the format of the {{match.iq}}?
> In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined
> aggregate function come from a single pattern variable
> -
>
> Key: CALCITE-2708
> URL: https://issues.apache.org/jira/browse/CALCITE-2708
> Project: Calcite
> Issue Type: Bug
>Reporter: Dawid Wysakowicz
>Assignee: Julian Hyde
>Priority: Major
> Labels: match
>
> In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined
> aggregate function (UDAF) come from a single pattern variable.
> Query:
> {code:java}
> SELECT *
> FROM Ticker
> MATCH_RECOGNIZE (
> ORDER BY proctime
> MEASURES
> udagg(A.price + B.tax) AS taxedPrice
> PATTERN (A B)
> DEFINE
> A AS A.symbol = 'a'
> ) AS T
> {code}
> should fail with ValidationException, because udagg is applied to different
> pattern variables.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (CALCITE-2708) In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function come from a single pattern variable
[
https://issues.apache.org/jira/browse/CALCITE-2708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16700171#comment-16700171
]
Julian Hyde commented on CALCITE-2708:
--
{{match.iq}} is in [Quidem|https://github.com/julianhyde/quidem] format. You
can run {{CoreQuidemTest}} in a debugger with arguments {{sql/match.iq}}.
> In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined
> aggregate function come from a single pattern variable
> -
>
> Key: CALCITE-2708
> URL: https://issues.apache.org/jira/browse/CALCITE-2708
> Project: Calcite
> Issue Type: Bug
>Reporter: Dawid Wysakowicz
>Assignee: Julian Hyde
>Priority: Major
> Labels: match
>
> In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined
> aggregate function (UDAF) come from a single pattern variable.
> Query:
> {code:java}
> SELECT *
> FROM Ticker
> MATCH_RECOGNIZE (
> ORDER BY proctime
> MEASURES
> udagg(A.price + B.tax) AS taxedPrice
> PATTERN (A B)
> DEFINE
> A AS A.symbol = 'a'
> ) AS T
> {code}
> should fail with ValidationException, because udagg is applied to different
> pattern variables.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
