[
https://issues.apache.org/jira/browse/DRILL-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15397026#comment-15397026
]
Khurram Faraaz commented on DRILL-4797:
---------------------------------------
Yes, this is not related to DRILL-2330
{noformat}
0: jdbc:drill:schema=dfs.tpcds_sf1_parquet_vi> select avg(col0) OVER (
PARTITION BY min(col0) ) from `allTypsUniq.parquet`;
Error: SYSTEM ERROR: IllegalStateException: This generator does not support
mappings beyond
Fragment 0:0
[Error Id: 57381770-419c-4897-958d-b45220f72afa on centos-01.qa.lab:31010]
(state=,code=0)
{noformat}
> 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)
