Chris created DRILL-6175:
----------------------------
Summary: Windowing functions don't allow aggregates in over clause
(incorrectly)
Key: DRILL-6175
URL: https://issues.apache.org/jira/browse/DRILL-6175
Project: Apache Drill
Issue Type: Bug
Components: SQL Parser
Affects Versions: 1.12.0
Reporter: Chris
Windowing functions should allow aggregate functions in the over() clause, but
do not.
This query:
select pay_period, sum(money) as sum_money
, rank() over(order by sum(money)) as rnk
from (values (1,200), (1,40), (2,30), (2, 239), (3,1)) base(pay_period, money)
group by pay_period
should work, but does not, and returns this error:
SYSTEM ERROR: AssertionError: Internal error: invariant violated: conversion
result not null
[Error Id: 8df6f6f1-41af-42b3-95d5-b2117b49bec5 on <host>:31010]
This should be allowed in standards, and doable.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
