hive 取年差值,向下取整
select FLOOR(datediff('2020-12-07','2016-12-08')/365);
hive 实现分组拼接,concat_ws及collect_set的结合
select b.pid,
concat_ws('', collect_set(b.company_name))
from tmp_employee a join ods_rms_fb_talent_database_work b on a.id=b.pid group by pid limit 10;