Hive安装与操作
查询选修课程的学生姓名,输入:select distinct Sname from student inner join sc on student.Sno=Sc.Sno (select distinct用于返回唯一不同的值。接着去hive下输入:load data local inpath ‘/home/hadoop/student.txt’ overwrite into table student;查询全体学生的学号和姓名,输入:select Sno,Sname from student;
原创
2023-04-16 09:40:23 ·
227 阅读 ·
0 评论