hive的基本操作（一）

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;