hive使用
创建数据表
create table wp_user_1 (id int,post_date timestamp,post_content strin,post_title string,post_status string,guid string) row format delimited fields terminated by ‘,’;
导入本地数据
load data local inpath ‘/root/input/students.txt’ overwrite into table students;
修改表名字
alter table students rename to student;
添加表字段
alter table student add columns (phone string);
表的删除
dfs -rmr /user/hive/warehouse/my_table;