【Hive】报错FAILED: SemanticExceptionFailed to breakup Windowing invocations into Groups.
今天使用Hive时候,由于自己的大意,使得代码报错,报错如下:FAILED: SemanticException Failed to breakup Windowing invocations into Groups.At least 1 group must only depend on input columns.Also check for circular dependencies.我的代
·
今天使用Hive时候,由于自己的大意,使得代码报错,报错如下:
FAILED: SemanticException Failed to breakup Windowing invocations into Groups.
At least 1 group must only depend on input columns.
Also check for circular dependencies.
我的代码如下(这里举个例子,没有用源代码):
select
id,
settle_month,
rate,
rank() over(partition by settle_day order by rate desc) as flag
from
tableTest
where
....
就是上面这段代码,报错了,刚开始粗略的检查了一下代码,然后没发现问题,就去百度了,结果百度了十来分钟都没找到合适的解决方法,就当无语的时候,发现原来是因为我窗口函数里面partition by后面的字段写错了,应该是settle_month,而我写成了settle_day,改了之后就好了。
希望可以帮到你,码字不易,喜欢请点赞!!!
更多推荐




所有评论(0)