drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-6175) Windowing functions don't allow aggregates in over clause (incorrectly)
Date Wed, 21 Feb 2018 21:54:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-6175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Khurram Faraaz closed DRILL-6175.
---------------------------------
    Resolution: Duplicate

> 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
>            Priority: Minor
>
> 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)

Mime
View raw message