2024-01-12 09:56 回答问题

上述代码的重复值个数统计部可以直接使用 nunique 函数实现： select *,asof(cutPoints(int(factor_value*100000),3),factor_value*100000)+1 as factor_quantile from tb context by date csort factor_value having nunique(factor_value*100000)>3

2024-01-12 09:43 回答问题

可以使用 interval 填充达到上述效果，代码如下： t = table(`35412`35412`35412 as indCode, `H30356.SH`H30356.SH`H30356.SH as indexCode, `000001.SZ`000001.SZ`000001.SZ as code, 2014.06.30 2014.09.30 2014.12.31 as date, 0.0168 0.0153 0.0158 as weight, 1111