如题:
学生id,课程id,分数
1,12,80
2,30,91
2,21,98
3,2,100
4,1,50
4,2,58
4,3,65
1,11,75
请实现:
(1)找出每门课不及格学生信息按照格式 “课程id:学生id1,学生id2”格式输出。
(2)找到所有科目都及格的学生id,按照id的升序排序。
(3)统计每门课的学生分数段按照 如下格式输出:课程id:[100,90]分数段学生人数,(90,80]分数段学生人数,(80,70]分数段学生人数,(70,60]分数段学生人数,不及格学生人数。
(1)直接上代码:
public class demo01 { static class m extends Mapper{ @Override protected void map(LongWritable key, Text value, Mapper .Context context) throws IOException, InterruptedException { String l = value.toString(); String[] a = l.split(","); String a1 = a[0]; String a2 = a[1]; int a3 = Integer.parseInt(a[2]); if (a3 < 60) { context.write(new Text(a2), new Text(a1)); } } } static class s extends Reducer { @Override protected void reduce(Text key, Iterable values, Reducer .Context context) throws IOException, InterruptedException { for(Text v : values) { context.write(new Text(key), new Text(v)); } } } public static void main(String[] args) throws Exception { Configuration conf = new Configuration(); Job job = Job.getInstance(conf); job.setJarByClass(demo01.class); job.setMapperClass(m.class); job.setReducerClass(s.class); job.setMapOutputKeyClass(Text.class); job.setMapOutputValueClass(Text.class); job.setOutputKeyClass(Text.class); job.setOutputValueClass(Text.class); FileInputFormat.setInputPaths(job, new Path("")); FileOutputFormat.setOutputPath(job, new Path("")); boolean res = job.waitForCompletion(true); System.exit(res ? 0 : 1); } }
效果(代码完善后):
(2)上代码:
public class demo02 { static class m extends Mapper{ @Override protected void map(LongWritable key, Text value, Mapper .Context context) throws IOException, InterruptedException { String l = value.toString(); String[] a = l.split(","); String a1 = a[0]; String a2 = a[1]; int a3 = Integer.parseInt(a[2]); if (a3 >= 60) { context.write(new Text(a1), new Text(a2+a3)); } } } static class s extends Reducer { @Override protected void reduce(Text key, Iterable values, Reducer .Context context) throws IOException, InterruptedException { for(Text v : values) { context.write(new Text(key), new Text(v)); } } } public static void main(String[] args) throws Exception{ Configuration conf = new Configuration(); Job job = Job.getInstance(conf); job.setJarByClass(demo02.class); job.setMapperClass(m.class); job.setReducerClass(s.class); job.setMapOutputKeyClass(Text.class); job.setMapOutputValueClass(Text.class); job.setOutputKeyClass(Text.class); job.setOutputValueClass(Text.class); FileInputFormat.setInputPaths(job, new Path("")); FileOutputFormat.setOutputPath(job, new Path("")); boolean res = job.waitForCompletion(true); System.exit(res ? 0 : 1); } }
效果(完善代码过后):
(3)上代码:
public class demo03 { static class m extends Mapper{ @Override protected void map(LongWritable key, Text value, Mapper .Context context) throws IOException, InterruptedException { String l = value.toString(); String[] a = l.split(","); String a1 = a[0]; String a2 = a[1]; int a3 = Integer.parseInt(a[2]); if (a3 >= 90 && a3 <= 100) { a2 += "[90,100]"; } else if (a3 >= 80 && a3 < 90) { a2 += "[80,90)"; } else if(a3 >= 70 && a3 < 80){ a2 += "[70,80)"; }else if(a3 >= 60 && a3 < 70){ a2 += "[60,70)"; }else { a2 += "不及格"; } context.write(new Text(a2), new Text(a1)); } } static class s extends Reducer { @Override protected void reduce(Text key, Iterable values, Reducer .Context context) throws IOException, InterruptedException { int i = 0; for (Text j: values) { i++; } context.write(new Text(key.toString()), new IntWritable(i)); } } public static void main(String[] args) throws Exception { Configuration conf = new Configuration(); Job job = Job.getInstance(conf); job.setJarByClass(demo03.class); job.setMapperClass(m.class); job.setReducerClass(s.class); job.setMapOutputKeyClass(Text.class); job.setMapOutputValueClass(Text.class); job.setOutputKeyClass(Text.class); job.setOutputValueClass(Text.class); FileInputFormat.setInputPaths(job, new Path("")); FileOutputFormat.setOutputPath(job, new Path("")); boolean res = job.waitForCompletion(true); System.exit(res ? 0 : 1); } }
效果(完善代码过后):
例子挺简单的,思路就是这样,有问题欢迎交流!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)