You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Gautam Kumar Parai (JIRA)" <ji...@apache.org> on 2016/07/28 02:27:20 UTC
[jira] [Comment Edited] (DRILL-4797) Partition by aggregate
function in a window query results in IllegalStateException
[ https://issues.apache.org/jira/browse/DRILL-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15396800#comment-15396800 ]
Gautam Kumar Parai edited comment on DRILL-4797 at 7/28/16 2:27 AM:
--------------------------------------------------------------------
[~khfaraaz] Is this a Drill-2330 specific issue? I see the same for window aggregates
{code}select avg(l_quantity) over (partition by min(l_quantity)) from cp.`tpch/lineitem.parquet`;
Error: SYSTEM ERROR: IllegalStateException: This generator does not support mappings beyond{code}
Can you please confirm?
was (Author: gparai):
[~khfaraaz] Is this Drill-2330 specific issue? I see the same for a window aggregates
{code}select avg(l_quantity) over (partition by min(l_quantity)) from cp.`tpch/lineitem.parquet`;
Error: SYSTEM ERROR: IllegalStateException: This generator does not support mappings beyond{code}
Can you please confirm?
> Partition by aggregate function in a window query results in IllegalStateException
> ----------------------------------------------------------------------------------
>
> Key: DRILL-4797
> URL: https://issues.apache.org/jira/browse/DRILL-4797
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.8.0
> Reporter: Khurram Faraaz
> Assignee: Gautam Kumar Parai
>
> Use of aggregate function in the partitioning column in a windowed query results in an IllegalStateException
> {noformat}
> 0: jdbc:drill:zk=local> select avg(sum(l_quantity)) over (partition by min(l_quantity)) from cp.`tpch/lineitem.parquet`;
> Error: SYSTEM ERROR: IllegalStateException: This generator does not support mappings beyond
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)