hive 元数据信息修改

ALTER TABLE ddw_app_gindex.dau_type10 add columns(pkg string,dau int);

UPDATE TBLS T1,DBS T2,SDS T3,PARTITIONS T4,SDS T5

SET T5.CD_ID = T3.CD_ID

WHERE T2.NAME = 'dw_app_gindex'

AND T1.TBL_NAME = 'dau_type10'

AND T1.DB_ID = T2.DB_ID

AND T1.SD_ID = T3.SD_ID

AND T1.TBL_ID =T4.TBL_ID

AND T4.SD_ID = T5.SD_ID

;

select * from TBLS where TBL_NAME="gz_pkg_sdk_login_cnt";
select * from SDS where SD_ID="2299675";
select * from COLUMNS_V2 where CD_ID ="51788";