hive窗口函数报错

待理解
image

Error while compiling statement: FAILED: SemanticException Failed to breakup Windowing invocations into Groups.  At least 1 group must only depend on input columns.  Also check for circular dependencies.  Underlying error: Expecting right window frame boundary for function dense_rank() Window Spec=[PartitioningSpec=[partitionColumns=[(tok_table_or_col report_moth)]orderColumns=[(tok_table_or_col severity_rate) DESC NULLS_LAST]]window(type=ROWS, start=Unbounded PRECEDING, end=currentRow)] as dense_rank_window_0 to be unbounded.  Found : 2147483647
posted @ 2023-08-02 11:23  捷后愚生  阅读(376)  评论(0)  编辑  收藏  举报