[jira] [Commented] (DRILL-2881) count( col ) fails to plan when streamagg is disabled

["Aman Sinha (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14513136#comment-14513136 ] 

Aman Sinha commented on DRILL-2881:
-----------------------------------

This is expected behavior.  Plain aggregates (no group-by) are implemented with streaming aggregate only, not hash aggregate since there are no keys to hash, although it could be implemented by using a constant key.   However, we don't expect certain aggregate mode to be disabled in practice so I don't see this as a problem.  

> count( col ) fails to plan when streamagg is disabled
> -----------------------------------------------------
>
>                 Key: DRILL-2881
>                 URL: https://issues.apache.org/jira/browse/DRILL-2881
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Sean Hsuan-Yi Chu
>
> For example,
> After disabling streamagg, we run query like this:
> select count(n_nationkey) as mycnt from cp.`tpch/nation.parquet` 
> Calcite will fail to plan while this one works :
> select count(*) as mycnt from cp.`tpch/nation.parquet` 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)