hive
1.创建BigData数据库
create database BigData;
2、查看数据库
show databases;
3、显示当前使用的数据库
set hive.cli.print.current.db=true;
4、删除数据库
drop database BigData;
5、创建userinfo表,字段是id、name、age,字段类型是int、string、int
create table userinfo(id int,name string,age int) //创建表userinfo,三个字段
row format delimited //一行是一条数据
fields terminated by '\t' //字段之间分隔符是\t ,键盘上的tab键
lines terminated by '\n' ; //行分隔符是\n ,键盘上的回车键
6、把上表的name改为userName
alter table userinfo change name userName string;
7、显示表的详细信息
desc extended userinfo;
8、创建phoneBook表,把数据加载到此表
数据文件a.txt内容如下,位置在/opt/data下
1 William 13388923592
2 Daniel 13345345235
3 James 13423314513
4 Sophia 12323342342
创建表:
create table phoneBook(id int,name string,phone string)
row format delimited
fields terminated by '\t'
lines terminated by '\n'
加载数据:
load data local inpath '/opt/data/a.txt' overwrite into table phoneBook;
查询数据:
select * from phoneBook;
9、创建分区表t_user,字段id、username、birthmonth,以出生年月作为分区字段
create table t_user(id int,username string)
patitioned by(birthmonth string)
row format delimited
fields terminated by '\t'
lines terminated by '\n';
10、加载数据到分区表
alter table t_user add partition(birthmonth='201708');
load data local inpath '/opt/data/b.txt' overwrite into table t_user
partition(birthmonth='201708');