Skip to content

[ES|QL] Round stddev tests more aggressively#135217

Merged
limotova merged 1 commit intoelastic:mainfrom
limotova:std-dev-more-rounding
Sep 24, 2025
Merged

[ES|QL] Round stddev tests more aggressively#135217
limotova merged 1 commit intoelastic:mainfrom
limotova:std-dev-more-rounding

Conversation

@limotova
Copy link
Copy Markdown
Contributor

@limotova limotova commented Sep 22, 2025

Adjust the rounding for std_dev CSV tests so they are less sensitive to the whims of fate

Hopefully:
Closes #135100
Closes #135101
Closes #135102
Closes #135103

@limotova limotova force-pushed the std-dev-more-rounding branch 2 times, most recently from fa3a3ee to 45b326e Compare September 23, 2025 04:32
@github-actions
Copy link
Copy Markdown
Contributor

ℹ️ Important: Docs version tagging

👋 Thanks for updating the docs! Just a friendly reminder that our docs are now cumulative. This means all 9.x versions are documented on the same page and published off of the main branch, instead of creating separate pages for each minor version.

We use applies_to tags to mark version-specific features and changes.

Expand for a quick overview

When to use applies_to tags:

✅ At the page level to indicate which products/deployments the content applies to (mandatory)
✅ When features change state (e.g. preview, ga) in a specific version
✅ When availability differs across deployments and environments

What NOT to do:

❌ Don't remove or replace information that applies to an older version
❌ Don't add new information that applies to a specific version without an applies_to tag
❌ Don't forget that applies_to tags can be used at the page, section, and inline level

🤔 Need help?

@limotova limotova force-pushed the std-dev-more-rounding branch 2 times, most recently from c863ca0 to 9f4ffe9 Compare September 24, 2025 04:51
@limotova limotova force-pushed the std-dev-more-rounding branch from 94923e9 to 1ff1e85 Compare September 24, 2025 05:22
@limotova limotova added >test Issues or PRs that are addressing/adding tests :StorageEngine/ES|QL Timeseries / metrics / PromQL / logsdb capabilities in ES|QL labels Sep 24, 2025
@limotova limotova marked this pull request as ready for review September 24, 2025 06:39
@elasticsearchmachine
Copy link
Copy Markdown
Collaborator

Pinging @elastic/es-storage-engine (Team:StorageEngine)

Copy link
Copy Markdown
Contributor

@astefan astefan left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM from my side. Thank you for the quick reaction to these CI failures.

But, I trust your judgement that the aggressive rounding we are adopting is not detrimental to the correctness of the STD_DEV function results and that doing so will not hide bugs regarding the results accuracy of this function.

@limotova
Copy link
Copy Markdown
Contributor Author

limotova commented Sep 24, 2025

Standard deviation appears to be reported on the level of about 3 significant figures at most typically, and while some of these tests now only have 5, there's at least one test for each supported type that have 7+, which I think is more than a safe amount

@limotova limotova merged commit 40f3a1c into elastic:main Sep 24, 2025
34 checks passed
@limotova limotova deleted the std-dev-more-rounding branch September 24, 2025 08:07
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

:StorageEngine/ES|QL Timeseries / metrics / PromQL / logsdb capabilities in ES|QL Team:StorageEngine >test Issues or PRs that are addressing/adding tests v9.2.0

Projects

None yet

3 participants