表计算函数
更新时间: 2021-11-29 15:50:22
阅读 236
- FIRST()
- INDEX()
- LAST()
- SIZE()
- LOOKUP(表达式,[偏移量])
- LOOKUPDATE(表达式, 日期表达式, 偏移量, 偏移单位) along [维度表达式]
- RUNNING_AVG(表达式) along [维度]
- RUNNING_COUNT(表达式) along [维度]
- RUNNING_MAX(表达式) along [维度]
- RUNNING_MIN(表达式) along [维度]
- RUNNING_SUM(表达式) along [维度]
- WINDOW_AVG(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_COUNT(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_MAX(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_MIN(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_SUM(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_VAR(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_VARP(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_STDEV(表达式, [开始位置, 结束位置]) along [维度]
- WINDOW_STDEVP(表达式, [开始位置, 结束位置]) along [维度]
- RANK(表达式, [“asc”|“desc”]) along [维度表达式]
- RANK_UNIQUE(表达式, [“asc”|“desc”]) along [维度表达式]
- RANK_MODIFIED(表达式, [‘asc’|‘desc’]) along [维度]
- RANK_DENSE(表达式, [“asc”|“desc”]) along [维度表达式]
文档反馈
以上内容对您是否有帮助?