AUTO_ENDinsertD:\Program Files\Greenplum\greenplum-clients\bin\gpload.batD:/control.txtD:/data,NUTF8N8080idid2NNnumnum2NNnamename2NN10.10.24.8848048YJavaScript代码ScriptValueModN1noneN90Script 1//Script here
var num2 = 1;
var name2 = "";
var id2 = "";
var str = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ";
var lastname="赵钱孙李西吴郑王冯陈楮卫蒋沈韩杨朱秦尤许何吕施张孔曹严华金魏陶姜戚谢邹喻柏水窦章云苏潘葛奚范彭郎鲁韦昌马苗凤花方俞任袁柳酆鲍史唐费廉岑薛雷贺倪汤滕殷罗毕郝邬安常乐于时傅皮卞齐康伍余元卜顾孟平黄穆萧尹赖";
var firstname="爱安百邦宝保抱贝倍蓓本必碧璧斌冰兵炳步彩曹昌长常超朝陈晨成呈承诚崇楚传春纯翠村殿丁定东冬二凡方芳昉飞菲纷芬奋风峰锋凤芙福付复富改刚高阁铬根庚耕公功冠光广归桂国海寒翰昊浩荷红宏洪鸿厚华存大丹道德登砥典佃小亲";
for(var no=0;no<total;no++)
{
var outputRow = new Array(_step_.getOutputRowMeta().size());
outputRow[_step_.getOutputRowMeta().indexOfValue("num2")] = Math.round(Math.random()*1000);
var ran = Math.ceil(Math.random()*99);
var result = lastname[ran];
for(var i = 0; i < 2 ; i ++) {
var id = Math.ceil(Math.random()*100);
result += firstname[id];
}
outputRow[_step_.getOutputRowMeta().indexOfValue("name2")] = result;
id2 ='xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
var r = Math.random()*16|0, v = c == 'x' ? r : (r&0x3|0x8);
return v.toString(16);
});
outputRow[_step_.getOutputRowMeta().indexOfValue("id2")] = id2;
_step_.putRow(_step_.getOutputRowMeta(), outputRow);
}
var trans_Status = SKIP_TRANSFORMATION;
num2num2Number80Nname2name2String360Nid2id2String360N304144Y文本文件输出TextFileOutputY1none##NNNDOSNoneNY/D:/NNtxtNNNNNNYNNnum2Integer####0;-####0.,none80name2Stringnone-1-1id2Stringnone-1-1480144Y自定义常量数据DataGridN1nonetotalInteger-1-1N1000000128144Y表输出TableOutputY1none10.10.14.111_GPpublic