[
https://issues.apache.org/jira/browse/ASTERIXDB-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871689#comment-17871689
]
ASF subversion and git services commented on ASTERIXDB-3473:
------------------------------------------------------------
Commit 0b4fcae6d717af1a3fbc8d99830fc020d9705c69 in asterixdb's branch
refs/heads/master from brianyen
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=0b4fcae6d7 ]
[ASTERIXDB-3473][FUN] Add support for COUNTN() aggregate function
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Add support for COUNTN() aggregate function that counts only numeric
values.
Ext-ref: MB-33422
Change-Id: Ib1f4ff498a0718439417c3e3fa786bc566653fef
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18564
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> Add support for COUNTN() aggregate function
> -------------------------------------------
>
> Key: ASTERIXDB-3473
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3473
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: FUN - Functions
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Labels: triaged
>
> COUNTN() is an aggregate function that only counts numbers. Any non-numeric
> value is ignored including NULL/MISSING.
> The STRICT_COUNTN() version also counts only numbers. However, it returns
> NULL if NULL/MISSING value is encountered.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
