You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "vojin53 (via GitHub)" <gi...@apache.org> on 2023/02/16 13:56:18 UTC
[GitHub] [doris] vojin53 opened a new issue, #16845: [Bug] 窗口函数last_value窗口不生效
vojin53 opened a new issue, #16845:
URL: https://github.com/apache/doris/issues/16845
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
doris-1.2.2
### What's Wrong?
表数据如下

------------------------------------------------------------------
执行sql为
select
u_id,
u_city,
u_salary,
last_value(u_salary) over (partition by u_city order by u_id rows between unbounded preceding and 1 preceding) last_value_test
from example_window_tb;
------------------------------------------------------------------
此SQL使用SPARK的返回结果为

以上是我期望的结果,根据u_city 分区,在两个分区内分别计算last_value。
------------------------------------------------------------------
而在Doris中的返回结果为:

partition by u_city 没有生效,sz分区的第一行不是null,而是gz分区的最后一行。
### What You Expected?

### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] zhangstar333 commented on issue #16845: [Bug] 窗口函数last_value窗口不生效
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on issue #16845:
URL: https://github.com/apache/doris/issues/16845#issuecomment-1441644343
https://github.com/apache/doris/pull/17084
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] yiguolei closed issue #16845: [Bug] 窗口函数last_value窗口不生效
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei closed issue #16845: [Bug] 窗口函数last_value窗口不生效
URL: https://github.com/apache/doris/issues/16845
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org