Kettle_GP_Mock Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT
ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE
0.0 0.0 10000 50 50 N Y 50000 Y Y 1000 100 - 2020/09/28 15:57:07.369 - 2020/09/28 15:57:07.369 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N 10.10.14.111_GP 10.10.14.111 GREENPLUM Native gpdb_dsideal 5432 gpadmin Encrypted 2be98afc86aa7f2e4cb1dbd79da97aed6 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 5432 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N JavaScript代码 文本文件输出 N 自定义常量数据 JavaScript代码 Y JavaScript代码 表输出 N JavaScript代码 Greenplum load Y Greenplum load GPLoad Y 1 none 10.10.14.111_GP 50 public
t_test
AUTO_END insert D:\Program Files\Greenplum\greenplum-clients\bin\gpload.bat D:/control.txt D:/data , N UTF8 N 8080 id id2 N N num num2 N N name name2 N N 10.10.24.88 480 48 Y JavaScript代码 ScriptValueMod N 1 none N 9 0 Script 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; num2 num2 Number 8 0 N name2 name2 String 36 0 N id2 id2 String 36 0 N 304 144 Y 文本文件输出 TextFileOutput Y 1 none ## N N
N
N
DOS None N Y /D:/ N N txt N N N N N N Y N N num2 Integer ####0;-####0 . , none 8 0 name2 String none -1 -1 id2 String none -1 -1 480 144 Y
自定义常量数据 DataGrid N 1 none total Integer -1 -1 N 1000000 128 144 Y 表输出 TableOutput Y 1 none 10.10.14.111_GP public t_test
100 N N Y Y N N Y N Y N num num2 name name2 id id2 480 240 Y
N