HIve常用语法记录

hive 增加表名和修改字段位置

alter table dim_ug_course_dic add columns (KCLB_ID string comment '课程类别ID'); 
alter table dim_ug_course_dic change KCLB_ID KCLB_ID string after CJPDFS;

hive修改表名

 ALTER TABLE ods__oracle__iw_jcsj_kclbdmb_df RENAME TO ods__oracle__jw_jcsj_kclbdmb_df;

beeline连接

!connect jdbc:hive2://web01:2181,manager01:2181,manager02:2181/;serviceDiscoveryMode=zookeeper;zooKeeperNamespace=hiveserver2;principal=hive/xxxxx

Hadoop查看datanode是否健康

hdfs dfsadmin -report