发现hive插入表一直无法把列字段添加进去或者修改列字段类型,需要思考是否被锁住了。
查询表是否被锁住了:show locks IDL.I_ALL_DAY_UID_FEATURE
对HIVE表进行解锁: unlock table IDL.I_ALL_DAY_UID_FEATURE
HIVE查询语句:
select mgm_laxin_act_succ_amt,* from IDL.I_ALL_DAY_UID_FEATURE
HIVE插入语句:
INSERT INTO IDL.I_ALL_DAY_UID_FEATURE(unified_id,self_addr_prov)VALUES('UID0000000001089','重庆市')
INSERT INTO IDL.I_ALL_DAY_UID_FEATURE(unified_id,self_addr_city)VALUES('UID0000000001089','重庆市')
网友评论