hive的常用操作
1.查看数据库
show databases;
2.使用(进入)数据库;
use db_hive;(db_hive是数据库名)
3.查看数据库内的数据表
show tables;
4.查看表结构
desc extended student;
5.查看表数据
select * from student;
6.向表中添加数据
insert into student values(2,'daqiao',12),(3,'xiaoqiao',13);
7.创建分区表
create external table stu1(name string,age int) partitioned by (dt string) row format delimited fields terminated by ' ';
导入数据
load data local inpath '/root/1.txt' into table stu1 partition (dt="2020-10-09");
8.创建二级分区表
create external table stu(name string,age int) partitioned by (year string,month string)
row format delimited fields terminated by ' ';
查看二级分区表结构
desc extended stu;
二级分区表添加数据
load data local inpath '/root/1.txt' into table stu partition (year='2020',month='10');
load data local inpath '/root/1.txt' into table stu partition (year='2020',month='11');
查看数据
select * from stu;