SQL
insert overwrite table <new_table> (
select <字段>
from (
select <字段>, row_number() over(distribute by <去重的字段> sort by <排列字段>) as row_num
from <old_table>
) t where t.row_num=1
);
SQL
insert overwrite table <new_table> (
select <字段>
from (
select <字段>, row_number() over(distribute by <去重的字段> sort by <排列字段>) as row_num
from <old_table>
) t where t.row_num=1
);