Support skewness(x) in Aggregation function

Is your feature request related to a problem or challenge?

Returns the skewness value calculated from values of a group.

Describe the solution you'd like

D SELECT skewness(col) FROM VALUES (-10), (-20), (100), (1000), (1000) AS tab(col);
┌────────────────────┐
│   skewness(col)    │
│       double       │
├────────────────────┤
│ 0.5745116147533554 │
└────────────────────┘

Describe alternatives you've considered

No response

Additional context

https://docs.databricks.com/en/sql/language-manual/functions/skewness.html
https://duckdb.org/docs/sql/functions/aggregates#skewnessx

take

Referring : https://github.com/duckdb/duckdb/blob/main/src/core_functions/aggregate/distributive/skew.cpp

Given #12357 we may want to move this function to some other repo rather than the core

@alamb

thanks for the update @alamb

Suggestion: #12254 (comment)

We are going to implement these in a different repository so closing this ticket to avoid confusion: #12254 (comment)

Navigation Menu

Repository navigation

Support `skewness(x)` in Aggregation function #12249

Is your feature request related to a problem or challenge?

Describe the solution you'd like

Describe alternatives you've considered

Additional context

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Support skewness(x) in Aggregation function #12249

Description

Is your feature request related to a problem or challenge?

Describe the solution you'd like

Describe alternatives you've considered

Additional context

Activity

dharanad commented on Aug 30, 2024

dharanad commented on Sep 2, 2024

alamb commented on Sep 9, 2024

dharanad commented on Sep 11, 2024

alamb commented on Sep 16, 2024

alamb commented on Sep 25, 2024

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions

Support `skewness(x)` in Aggregation function #12249