Apache Doris 中文技术论坛
Questions Tags Users Badges

【已解决】Doris 2.0.5,窗口函数 LEAD() 方法不支持变量

Asked Mar 14, 2024 Modified May 27, 2024
Viewed 89
2.0

image.png

edited May 27, 2024
Jasonf21
asked Mar 14, 2024
2 Answers

LEAD() 方法,参数 2 和参数 3 应该使用常量,相同 SQL 我在 2.0.5 测试变量也是行不通的

image.png

edited May 27, 2024
阿渊@SelectDB6720
answered Mar 14, 2024

之前是变量也能使用

edited Jan 1, 1970
Jasonf21
answered Mar 14, 2024
Related Questions
官方镜像gdb使用报错
left join 报错
doris2.0.15 unique表部分更新出现副本数据不一致
1 answers
doris 2.0.4 某tablet持续base compaction失败重试
1 answers
执行insert into select语句,偶发be与fe连接错误,[THRIFT_RPC_ERROR]Couldn't open transport for 10.1.0.23:9020 (open() timed out)
1 answers
doris 中be节点交替false是什么原因呢
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.