1、创建新表
create table student_hive (name string, sex string ,age int) row format delimited fields terminated by '\t';
2、导入数据student_hive.txt到student_hive表
load data local '/home/hairui/student_hive.txt' overwrite into table student_hive;
3、正则匹配表明
show tables 'student';
4、增加一个字段
alter table student_hive add columns (new score int);
5、重命令表名
alter table student_hive rename to student_hivehive;
6、从HDFS加载数据
load data inpath '/home/hairui/warehouse/student/student_hive.txt' overwrite into table student_hivehive;
7、从其他表导入数据
insert overwrite table student_hive select * from student;
8、创建表并从其他表导入数据
create table student_hive as select *from student;
9、仅复制表结构不导入数据
create table student_hive like student;
10、通过hive导出到本地文件系统
insert overwrite local directory '/tmp/student_hive' select * from student;
11、hive查询HiveQL
from (select name,sex as sex from student_hive) student select student.name, student.sex;
select name,sex from hive limit 2;