apache / apache/druid

Missing Native Query documentation for Window Functions

Open
#18,872 0 comments 0 reactions 0 assignees View on GitHub
Feature/Change Description
Dominant language
Java
Stars
14.1k
Forks
3.8k
Avg merge
2d 58m
Merged PRs (30d)
233

Description

### Description

Window functions have been GA in druid since October 2024, but the [current documentation](https://druid.apache.org/docs/latest/querying/sql-window-functions) only covers druid SQL.

It would be great to extend the documentation to cover the `windowOperator` query type in native queries.

### Motivation

The native query syntax is much friendly for programatically generating queries, we'd like to use window functions but the lack of documentations means we need to figure out the syntax by `EXPLAIN`'ing queries or reading the druid source.

Contributor guide

Open the contributing guide

Research direction

Start with the existing SQL window functions documentation at docs.druid.apache.org/docs/latest/querying/sql-window-functions and compare its coverage with the native windowOperator query type. Use EXPLAIN queries or the Druid source to verify the native syntax, then extend the documentation so users can understand how to generate window-function native queries.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.