Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ESQL: search-level count for a given field #99840

Closed
costin opened this issue Sep 23, 2023 · 2 comments · Fixed by #100122
Closed

ESQL: search-level count for a given field #99840

costin opened this issue Sep 23, 2023 · 2 comments · Fixed by #100122
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:QL (Deprecated) Meta label for query languages team

Comments

@costin
Copy link
Member

costin commented Sep 23, 2023

Description

Extension of #99602, to support counting a field when a filter/query already exists. This means creating an operator that extends the query and adds an exists clause for said field (to avoid counting nulls).
@elasticsearchmachine elasticsearchmachine added the Team:QL (Deprecated) Meta label for query languages team label Sep 23, 2023
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-ql (Team:QL)

@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)

@costin costin mentioned this issue Sep 23, 2023
Open
5 tasks
@costin costin mentioned this issue Oct 1, 2023
Merged
costin added a commit to costin/elasticsearch that referenced this issue Oct 1, 2023
@costin
ESQL: Pushdown count(field) to Lucene
f29cf83 
Use the LuceneCountOperator also for ungrouped count(field) queries

Fix elastic#99840
costin added a commit that referenced this issue Oct 3, 2023
@costin
ESQL: Pushdown count(field) to Lucene (#100122)
2e86d25 
Use the LuceneCountOperator also for ungrouped count(field) queries
Enhance the SearchStat class to indicate when a field is single or multi-value

Fix #99840
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:QL (Deprecated) Meta label for query languages team
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ESQL: Pushdown count(field) to Lucene costin/elasticsearch
2 participants
@costin @elasticsearchmachine