-
Notifications
You must be signed in to change notification settings - Fork 25.8k
ESQL: INLINE STATS null grouping/joining #139887
Copy link
Copy link
Closed
Labels
:Analytics/ES|QLAKA ESQLAKA ESQL>bugTeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)Meta label for analytical engine team (ESQL/Aggs/Geo)
Description
Description
There's a difference between how STATS behaves compared to INLINE STATS caused by null grouping/joining that we should look into:
ROW x = 1
| STATS c = COUNT(*) BY n = null
| KEEP c, n
| LIMIT 1
yields:
c | n
---------------+---------------
1 |null
However,
ROW x = 1
| INLINE STATS c = COUNT(*) BY n = null
| KEEP c, n
| LIMIT 1
yields:
c | n
---------------+---------------
null |null
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
:Analytics/ES|QLAKA ESQLAKA ESQL>bugTeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)Meta label for analytical engine team (ESQL/Aggs/Geo)
Type
Fields
Give feedbackNo fields configured for issues without a type.