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.

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

The empty value in the query result needs to be filled #480

Open
xiangyu5632 opened this issue Feb 21, 2024 · 0 comments
Open

The empty value in the query result needs to be filled #480

xiangyu5632 opened this issue Feb 21, 2024 · 0 comments
Labels
difficulty ⭐ 1 star for difficulty level enhancement New feature or request

Comments

@xiangyu5632
Copy link
Member

xiangyu5632 commented Feb 21, 2024

Is your feature request related to a problem? Please describe.(如果该特性或者功能和已知某个问题相关,请描述问题是什么)

In the case of non-grouped aggregation, the empty value in the query result needs to be filled. The filling policy includes the filling of the specified value, previous value, and next value.

> select f1,f2 from tab
name: tab
time                f1  f2
----                --  --
1708309973145615335 1   2
1708309982273595148     2
1708498828793592694 111 
1708498857079672776     22
1708498877520925921 11  22
1708498890752021155     23
1708498899049189513 12 

need
1. Gaven a value to fill in

> select f1,f2 from tab fill(50)
name: tab
time                f1  f2
----                --  --
1708309973145615335 1   2
1708309982273595148 50  2
1708498828793592694 111 50
1708498857079672776 50  22
1708498877520925921 11  22
1708498890752021155 50  23
1708498899049189513 12  50

2. Use the previous value to fill in

> select f1,f2 from tab fill(previous)
name: tab
time                f1  f2
----                --  --
1708309973145615335 1   2
1708309982273595148 1   2
1708498828793592694 111 2
1708498857079672776 111 22
1708498877520925921 11  22
1708498890752021155 11  23
1708498899049189513 12  23
> 
@xiangyu5632 xiangyu5632 added enhancement New feature or request difficulty ⭐ 1 star for difficulty level labels Feb 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
difficulty ⭐ 1 star for difficulty level enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant