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

SQL: document the type of interval used by date_histogram #45502

Closed
astefan opened this issue Aug 13, 2019 · 3 comments
Closed

SQL: document the type of interval used by date_histogram #45502

astefan opened this issue Aug 13, 2019 · 3 comments
Assignees
@astefan
Labels
:Analytics/SQL SQL querying >docs General docs changes

Comments

@astefan
Copy link
Contributor

astefan commented Aug 13, 2019

In SQL we use date_histogram for groupings by a interval (YEAR, MONTH etc) and, also, for the HISTOGRAM grouping function. And for this we use the fixed_interval type of interval. This may not be so obvious at first, but it can lead to confusing results.

Related to #40162.
@astefan astefan added >docs General docs changes :Analytics/SQL SQL querying labels Aug 13, 2019
@astefan astefan self-assigned this Aug 13, 2019
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-docs

@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

@astefan
Copy link
Contributor Author

astefan commented Oct 9, 2019

A NOTE has been added to grouping functions, part of this PR.

@astefan astefan closed this as completed Oct 9, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@astefan astefan

Labels
:Analytics/SQL SQL querying >docs General docs changes
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@astefan @elasticmachine