[
https://issues.apache.org/jira/browse/DRILL-1619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14200484#comment-14200484
]
Aman Sinha commented on DRILL-1619:
-----------------------------------
The error message is :
+ throw new RuntimeException("Boolean type does not support aggregate
functions");
But count(bool) is supported, so should this be something like : "Only COUNT
aggregate function supported for Boolean type"
> count(boolean) always returns 'true'
> ------------------------------------
>
> Key: DRILL-1619
> URL: https://issues.apache.org/jira/browse/DRILL-1619
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 0.7.0
> Reporter: Chun Chang
> Assignee: Mehant Baid
> Attachments: DRILL-1619.patch
>
>
> #Wed Oct 29 09:57:56 PDT 2014
> git.commit.id.abbrev=2871c3b
> count a boolean column always return the value 'true':
> 0: jdbc:drill:schema=dfs.drillTestDirMondrian> select count(t.bool) from
> `complex.json` t where t.bool = true;
> +------------+
> | EXPR$0 |
> +------------+
> | true |
> +------------+
> 1 row selected (0.145 seconds)
> 0: jdbc:drill:schema=dfs.drillTestDirMondrian> select count(t.bool) from
> `complex.json` t where t.bool = false;
> +------------+
> | EXPR$0 |
> +------------+
> | true |
> +------------+
> 1 row selected (0.169 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
