可以将工资由numeric转换成varchar类型,最好另起一张表:
create table lianxi3 as select 部门,number,工资::varchar from lianxi distributed by(number);
可以将工资由numeric转换成varchar类型,最好另起一张表:
create table lianxi3 as select 部门,number,工资::varchar from lianxi distributed by(number);