当前位置:   article > 正文

hive中窗口函数rows between(简略)_rows between unbounded preceding and unbounded fol

rows between unbounded preceding and unbounded following

rows between …… and ……

unbounded preceding 起始行
unbounded following 结尾行
current row 当前行
1 preceding 前1行
1 following 后1行

示例:
rows between unbounded preceding and unbounded following
表示起始行到末尾行

rows between unbounded preceding and 1 preceding
表示起始行到前一行

声明:本文内容由网友自发贡献,转载请注明出处:【wpsshop】
推荐阅读
相关标签
  

闽ICP备14008679号