【hadoop学习之路】Hive HQL 语句实现查询

目录

表数据

表1 students_data.txt

表2 course.txt

实验步骤

结论

---

表数据

表1 students_data.txt

21434,Sara,F,21,20,73,classC
41443,Mary,M,19,30,90,classA
43333,Dery,F,20,40,85,classB
45454,Mary,F,22,10,91,classA
14634,Henry,M,18,50,56,classC
12656,Shary,M,19,60,93,classA
27676,Heary,M,21,30,81,classB
96785,Jeliy,M,23,40,88,classB
31236,Alise,F,20,10,86,classB
31134,Tom,F,21,50,95,classA
45456,David,M,22,20,90,classA
31345,Alice,M,23,10,94,classA
96865,Bob,F,19,30,71,classC
63526,Heliy,F,19,50,66,classC

表2 course.txt

10,Chinese
20,Math
30,English
40,Physics
50,Chemistry
60,Biology

实验步骤

1. 创建数据库stu

create database stu;

2. 创建students表

use stu;
create table students(id int, name string, gender string, age int,