AetheWu commented on issue #61095:
URL: https://github.com/apache/doris/issues/61095#issuecomment-4009203164
补充一个复现条件，当去掉sql结尾的ts（datetime类型字段）排序后，查询语句能正常执行
```sql
WITH RankedData AS (
SELECT
ts,
bank_id,
rack_no,
Vrack,
ROW_NUMBER() OVER (
PARTITION BY SECOND_FLOOR(ts, 10), bank_id, rack_no
ORDER BY ts DESC
) as rn
FROM v_rack_dataset
)
SELECT
ts,
bank_id,
rack_no,
Vrack
FROM RankedData
WHERE rn = 1
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
