多路輸入輸出示例__示例程序_MapReduce_大數據計算服務-阿裏雲
目前ODPS支持多表的輸入及輸出。
測試準備
(1)準備好測試程序jar包,假設名字為mapreduce-examples.jar;
(2)準備好多路輸入輸出的測試表和資源;
創建表
create table wc_in1(key string, value string);create table wc_in2(key string, value string);create table mr_multiinout_out1 (key string, cnt bigint);create table mr_multiinout_out2 (key string, cnt bigint) partitioned by (a string, b string);alter table mr_multiinout_out2 add partition (a='1', b='1');alter table mr_multiinout_out2 add partition (a='2', b='2');
添加資源
add jar mapreduce-examples.jar -f;
(3)使用tunnel導入數據;
tunnel upload data1 wc_in1;tunnel upload data2 wc_in2;
- 導入wc_in1表的數據文件data內容為:
hello,odps
- 導入wc_in2表的數據文件data內容為:
hello,world
測試步驟
在odpscmd中執行MultipleInOut
jar -resources mapreduce-examples.jar -classpath mapreduce-examples.jarcom.aliyun.odps.mapred.open.example.MultipleInOut wc_in1,wc_in2 mr_multiinout_out1,mr_multiinout_out2|a=1/b=1|out1,mr_multiinout_out2|a=2/b=2|out2;
預期結果
作業成功結束。mr_multiinout_out1中內容為:
+------------+------------+| key | cnt |+------------+------------+| default | 1 |+------------+------------+
mr_multiinout_out2中內容為:
+--------+------------+---+---+| key | cnt | a | b |+--------+------------+---+---+| odps | 1 | 1 | 1 || world | 1 | 1 | 1 || out1 | 1 | 1 | 1 || hello | 2 | 2 | 2 || out2 | 1 | 2 | 2 |+--------+------------+---+---+
代碼示例
package com.aliyun.odps.mapred.open.example;import java.io.IOException;import java.util.Iterator;import java.util.LinkedHashMap;import com.aliyun.odps.data.Record;import com.aliyun.odps.data.TableInfo;import com.aliyun.odps.mapred.JobClient;import com.aliyun.odps.mapred.MapperBase;import com.aliyun.odps.mapred.ReducerBase;import com.aliyun.odps.mapred.TaskContext;import com.aliyun.odps.mapred.conf.JobConf;import com.aliyun.odps.mapred.utils.InputUtils;import com.aliyun.odps.mapred.utils.OutputUtils;import com.aliyun.odps.mapred.utils.SchemaUtils;/*** Multi input & output example.**/public class MultipleInOut {public static class TokenizerMapper extends MapperBase {Record word;Record one;@Overridepublic void setup(TaskContext context) throws IOException {word = context.createMapOutputKeyRecord();one = context.createMapOutputValueRecord();one.set(new Object[] { 1L });}@Overridepublic void map(long recordNum, Record record, TaskContext context)throws IOException {for (int i = 0; i < record.getColumnCount(); i++) {word.set(new Object[] { record.get(i).toString() });context.write(word, one);}}}public static class SumReducer extends ReducerBase {private Record result;private Record result1;private Record result2;@Overridepublic void setup(TaskContext context) throws IOException {result = context.createOutputRecord();result1 = context.createOutputRecord("out1");result2 = context.createOutputRecord("out2");}@Overridepublic void reduce(Record key, Iterator<Record> values, TaskContext context)throws IOException {long count = 0;while (values.hasNext()) {Record val = values.next();count += (Long) val.get(0);}long mod = count % 3;if (mod == 0) {result.set(0, key.get(0));result.set(1, count);//不指定label,輸出的默認(default)輸出context.write(result);} else if (mod == 1) {result1.set(0, key.get(0));result1.set(1, count);context.write(result1, "out1");} else {result2.set(0, key.get(0));result2.set(1, count);context.write(result2, "out2");}}@Overridepublic void cleanup(TaskContext context) throws IOException {Record result = context.createOutputRecord();result.set(0, "default");result.set(1, 1L);context.write(result);Record result1 = context.createOutputRecord("out1");result1.set(0, "out1");result1.set(1, 1L);context.write(result1, "out1");Record result2 = context.createOutputRecord("out2");result2.set(0, "out2");result2.set(1, 1L);context.write(result2, "out2");}}public static LinkedHashMap<String, String> convertPartSpecToMap(String partSpec) {LinkedHashMap<String, String> map = new LinkedHashMap<String, String>();if (partSpec != null && !partSpec.trim().isEmpty()) {String[] parts = partSpec.split("/");for (String part : parts) {String[] ss = part.split("=");if (ss.length != 2) {throw new RuntimeException("ODPS-0730001: error part spec format: "+ partSpec);}map.put(ss[0], ss[1]);}}return map;}public static void main(String[] args) throws Exception {String[] inputs = null;String[] outputs = null;if (args.length == 2) {inputs = args[0].split(",");outputs = args[1].split(",");} else {System.err.println("MultipleInOut in... out...");System.exit(1);}JobConf job = new JobConf();job.setMapperClass(TokenizerMapper.class);job.setReducerClass(SumReducer.class);job.setMapOutputKeySchema(SchemaUtils.fromString("word:string"));job.setMapOutputValueSchema(SchemaUtils.fromString("count:bigint"));//解析用戶的輸入表字符串for (String in : inputs) {String[] ss = in.split("\|");if (ss.length == 1) {InputUtils.addTable(TableInfo.builder().tableName(ss[0]).build(), job);} else if (ss.length == 2) {LinkedHashMap<String, String> map = convertPartSpecToMap(ss[1]);InputUtils.addTable(TableInfo.builder().tableName(ss[0]).partSpec(map).build(), job);} else {System.err.println("Style of input: " + in + " is not right");System.exit(1);}}//解析用戶的輸出表字符串for (String out : outputs) {String[] ss = out.split("\|");if (ss.length == 1) {OutputUtils.addTable(TableInfo.builder().tableName(ss[0]).build(), job);} else if (ss.length == 2) {LinkedHashMap<String, String> map = convertPartSpecToMap(ss[1]);OutputUtils.addTable(TableInfo.builder().tableName(ss[0]).partSpec(map).build(), job);} else if (ss.length == 3) {if (ss[1].isEmpty()) {LinkedHashMap<String, String> map = convertPartSpecToMap(ss[2]);OutputUtils.addTable(TableInfo.builder().tableName(ss[0]).partSpec(map).build(), job);} else {LinkedHashMap<String, String> map = convertPartSpecToMap(ss[1]);OutputUtils.addTable(TableInfo.builder().tableName(ss[0]).partSpec(map).label(ss[2]).build(), job);}} else {System.err.println("Style of output: " + out + " is not right");System.exit(1);}}JobClient.runJob(job);}}
最後更新:2016-09-22 10:05:19
上一篇:
MapOnly示例__示例程序_MapReduce_大數據計算服務-阿裏雲
下一篇:
多任務示例__示例程序_MapReduce_大數據計算服務-阿裏雲
OpenIdConnectConfig__數據類型_API_API 網關-阿裏雲
DeleteRole__角色管理接口_RAM API文檔_訪問控製-阿裏雲
提交備案初審流程__流程引導圖_備案流程_備案-阿裏雲
大數據早報:阿裏雲與中科院宣布合作發布量子計算雲平台 10.12
短信發送頻率上有什麼限製?__常見問題_短信服務-阿裏雲
修改路由器屬性__路由器相關接口_API 參考_雲服務器 ECS-阿裏雲
DRDS自定義注釋__開發手冊_分布式關係型數據庫 DRDS-阿裏雲
ALIYUN::ECS::EIP__資源列表_資源編排-阿裏雲
附錄一 元數據庫數據字典__附錄_使用手冊_分析型數據庫-阿裏雲
key分區__分區_SQL語法參考_雲數據庫 OceanBase-阿裏雲
相關內容
常見錯誤說明__附錄_大數據計算服務-阿裏雲
發送短信接口__API使用手冊_短信服務-阿裏雲
接口文檔__Android_安全組件教程_移動安全-阿裏雲
運營商錯誤碼(聯通)__常見問題_短信服務-阿裏雲
設置短信模板__使用手冊_短信服務-阿裏雲
OSS 權限問題及排查__常見錯誤及排除_最佳實踐_對象存儲 OSS-阿裏雲
消息通知__操作指南_批量計算-阿裏雲
設備端快速接入(MQTT)__快速開始_阿裏雲物聯網套件-阿裏雲
查詢API調用流量數據__API管理相關接口_API_API 網關-阿裏雲
使用STS訪問__JavaScript-SDK_SDK 參考_對象存儲 OSS-阿裏雲