方案1:alter table my_table set tblproperties(‘retention’ = ‘7’) 方案2: create event if not exists cleanup_event on schedule every 1 hour do delete from my_table where dt < date_sub(current_date,30) 文章导航 1.注册hive-udf函数的方法 Hive中的UDF函数注册方法和步骤