分区表:devin 分区字段:op_day(8位格式日期:20181112)
select t2.*
from
(select max(op_day) as latest_op_day from devin) t1
join devin t2
on
t1.latest_op_day = t2.op_day;
hive获取分区表最新分区的数据
最新推荐文章于 2024-08-01 04:39:02 发布
分区表:devin 分区字段:op_day(8位格式日期:20181112)
select t2.*
from
(select max(op_day) as latest_op_day from devin) t1
join devin t2
on
t1.latest_op_day = t2.op_day;