标准差函数stddev_samp在2.5.10 版本报错 order by not allowed with 'stddev_samp(`test_es`.`test_std`.`ts`)

💬 StarRocks 用户问答
#1

【详述】标准差函数stddev_samp在2.5.10 版本报错 order by not allowed with 'stddev_samp(test_es.test_std.ts)
【StarRocks版本】例如：2.5.10
【集群规模】例如：1fe + 4be
【执行过程】

建表语句：CREATE TABLE test_std( event_daydate NULL COMMENT "", user_idint(11) NULL COMMENT "", ts int(11) NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(event_day, user_id, ts) DISTRIBUTED BY HASH(user_id) BUCKETS 3 PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "storage_format" = "DEFAULT", "enable_persistent_index" = "false", "compression" = "LZ4" );

查询语句：select stddev_samp(ts) over (partition by user_id order by ts ) as std_rate from test_es.test_std where event_day = '2023-08-24';

报错信息：ERROR 1064 (HY000): order by not allowed with 'stddev_samp(test_es.test_std.ts)

#2

有专家帮忙看一下吗

#3

这个函数应该不支持order by吧，这个是算方差的，order by输入没啥意义

#4

感谢回复，是这样的，我们计算标准差指标时会用到窗口滑动，例如：stddev_samp(name_rate) over (partition by aid order by event_day rows between 7 preceding and 1 preceding) as std_7d_name_rate 所以需要order by

#5

暂时还不支持这个功能，后面可以考虑新加一下这个

京ICP备2022026421号-1