34.导入student表

[01].加载学生表

• 启动hive

  cd apache-hive-2.3.9-bin/bin

  cd apache-hive-2.3.9-bin/bin

  

• 使用默认数据库

  hive> use default;
  OK
  Time taken: 7.218 seconds

• 查看表

  hive> show tables;
  OK
  student
  Time taken: 0.249 seconds, Fetched: 1 row(s)

• 创建表格(使用制表符分割)

  hive> create table stu(id string,name string,stature int)row format delimited fields terminated by '\t';
  OK
  Time taken: 1.049 seconds

• 将清洗过的数据加载入表中

  hive> load data inpath 'hdfs://master:8020/hiveoutput/part-r-00000' overwrite into table stu;
  Loading data to table default.student
  OK
  Time taken: 1.662 seconds

• 查询一下

  hive> select * from stu;
  OK
  1012    160    NULL
  10012    Abel    170
  1008    Kate    168
  1007    Alice    163
  1006    John    192
  1005    Rob    177
  1004    Jack    175
  1003    Mary    172
  1002    Lily    165
  1001    Tom    180
  Time taken: 2.158 seconds, Fetched: 10 row(s)

  [02].加载课程表

• 创建课程表

  hive> create table cos(id string,cos_name string,grade double)row format delimited fields terminated by '\t';
  OK
  Time taken: 0.371 seconds

• 本地导入

  hive> load data local inpath '/opt/input/course.txt' overwrite into table cos;
  Loading data to table default.cos
  OK
  Time taken: 0.527 seconds

• 查询

  hive> select * from cos;
  OK
  1001    en    85.0
  1001    ma    100.0
  1002    en    72.0
  1002    ma    90.0
  1003    en    60.0
  1003    ma    85.0
  1004    en    95.0
  1004    ma    80.0
  1005    en    88.0
  1005    ma    70.0
  1006    en    78.0
  1006    ma    86.0
  1007    en    81.0
  1007    ma    60.0
  1008    en    68.0
  1008    ma    85.0
  Time taken: 0.195 seconds, Fetched: 16 row(s)