Hive常见错误

开窗函数执行问题

select
    mid_id,
    dt,
    rank() over (partition by mid_id order by dt) rk
from
(
    select
        mid_id,
        dt
    from dws_uv_detail_daycount
    where dt>=date_add('2020-06-25',-6)
    group by mid_id,dt
);

运行报错：

org.apache.hadoop.hive.ql.parse.ParseException:line 13:1 cannot recognize input near ‘’ ‘’ ‘’ in subquery source

解决方案

在DG中加一个别名t1就可以执行进行测试

select
    mid_id,
    dt,
    rank() over (partition by mid_id order by dt) rk
from
(
    select
        mid_id,
        dt
    from dws_uv_detail_daycount
    where dt>=date_add('2020-06-25',-6)
    group by mid_id,dt
)t1;

未完待续！