方式一:全新表的生成
insert overwrite table cl.test_auto01 select ROW_NUMBER () over(order by 1) as auto_increment_id,user_id uid,course_name uname from test01
方式二:在表已有的基础上进行增加
insert into table cl.test_auto01 select (row_number() over(order by 1) + auto01.max_id) auto_increment_id, t1.user_id uid,t1.course_name uname
from test01 t1 cross join (select max(auto_increment_id) max_id from test_auto01) auto01;