hive、pg库：新增字段、修改字段类型 alter table

最新推荐文章于 2024-09-12 18:25:04 发布

置顶秋天の

最新推荐文章于 2024-09-12 18:25:04 发布

阅读量2.9k

点赞数 1

文章标签： hive 数据库

本文链接：https://blog.csdn.net/weixin_42342968/article/details/126759162

版权

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);