有A表时
insert into A select * from B;
没有A表时
create table A as select * from B;
没有A表且B表为另一个用户C时
create table A as select * from C.B;
有A表时
insert into A select * from B;
没有A表时
create table A as select * from B;
没有A表且B表为另一个用户C时
create table A as select * from C.B;