hive创建表

注：hive -e ‘’（临时查看） 可不用进入hive 就对hive进行操作__
hive -S 只显示结果_________________
1.查看数据库 创建数据库 使用数据库 创建表
hive> show databases;

hive> create database myhive;

hive> use myhive;

page472
hive> create table student(sno string,name string ,age int)
> row format delimited fields terminated by ‘,’; （放的时候是按列分割，分割符自己可指定）

2.webUI查看数据仓库位置:已创建表

3.在另一个节点slave1中上传数据，按照规则以逗号分格内容
$> vim t1.txt
$> cat t1.txt
1201212112,zhangsan,23
2334342342,lisi,24
2323232323,zhaoliu,22

4.查看hdfs —>hadoop fs -ls -R /user
drwxr-xr-x - crx supergroup 0 2019-05-23 14:10 /user
drwxr-xr-x - crx supergroup 0 2019-05-23 14:10 /user/hive
drwxr-xr-x - crx supergroup 0 2019-05-23 16:24 /user/hive/warehouse
drwxr-xr-x - crx supergroup 0 2019-05-23 16:25 /user/hive/warehouse/myhive.db
drwxr-xr-x - crx supergroup 0 2019-05-23 16:25 /user/hive/warehouse/myhive.db/student

***注意，直接在warehouse下的表是default数据库
[crx@master Desktop]$ hadoop fs -ls -R /user
drwxr-xr-x - crx supergroup 0 2020-12-13 13:38 /user/hive
drwxr-xr-x - crx supergroup 0 2020-12-14 17:03 /user/hive/warehouse
drwxr-xr-x - crx supergroup 0 2020-12-14 17:03 /user/hive/warehouse/myhive.db
drwxr-xr-x - crx supergroup 0 2020-12-14 17:03 /user/hive/warehouse/myhive.db/student
drwxr-xr-x - crx supergroup 0 2020-12-14 17:01 /user/hive/warehouse/student
drwxr-xr-x - crx supergroup 0 2020-12-13 13:40 /user/hive/warehouse/test
-rwxr-xr-x 3 crx supergroup 11 2020-12-13 13:40 /user/hive/warehouse/test/000000_0
drwxr-xr-x - crx supergroup 0 2020-12-14 16:35 /user/hive/warehouse/test1
-rwxr-xr-x 3 crx supergroup 13 2020-12-14 16:35 /user/hive/warehouse/test1/000000_0
***注意，直接在warehouse下的表是default数据库

5.将文件上传到表下面
$> hadoop fs -put t1.txt /user/hive/warehouse/myhive.db/student

6.查看hive表
hive> select * from student;
OK
1201212112 zhangsan 23
2334342342 lisi 24
2323232323 zhaoliu 22

7. 重复 5 6