hive新增字段：

alter table dwa.A_DS_INACTIVE_MODEL_D add columns (model5lr_prob double COMMENT model5lr_prob);
alter table dwa.A_DS_INACTIVE_MODEL_D add columns (model5lr_decile double COMMENT model5lr_decile);
alter table dwa.A_DS_INACTIVE_MODEL_D add columns (model5lr_seg double COMMENT model5lr_seg);

hive修改字段类型：

Alter table dwa.A_DS_INACTIVE_MODEL_D  change column  model5lr_prob   model5lr_prob  double;
 Alter table dwa.A_DS_INACTIVE_MODEL_D  change column  model5lr_decile   model5lr_decile  int;
 Alter table dwa.A_DS_INACTIVE_MODEL_D  change column  model5lr_seg   model5lr_seg  int;

pg库新增字段：

ALTER TABLE fi_dwa.a_ds_inactive_model_d ADD model5lr_prob numeric(20,2);
ALTER TABLE fi_dwa.a_ds_inactive_model_d ADD model5lr_decile int;
ALTER TABLE fi_dwa.a_ds_inactive_model_d ADD model5lr_seg int;

pg库修改字段类型：

alter table fi_dwa.a_ds_inactive_model_d alter column model5lr_prob type numeric(50,0) USING model5lr_prob :: numeric(50,0);
alter table fi_dwa.a_ds_inactive_model_d alter column model5lr_decile type numeric(50,0) USING model5lr_decile :: numeric(50,0);
alter table fi_dwa.a_ds_inactive_model_d alter column model5lr_seg type numeric(50,0) USING model5lr_seg :: numeric(50,0);