user Normal 0 / input_db_ip 172.17.0.1 input_db_port 27017 out_db_ip 172.17.0.1 out_db_name ry out_db_port 3306 out_db_pwd sckjadmin out_db_username root 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 100000 50 50 N Y 50000 Y N 1000 100 - 2020/07/21 14:19:28.353 - 2020/07/21 14:19:28.353 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N user ${out_db_ip} MYSQL Native ${out_db_name} ${out_db_port} ${out_db_username} ${out_db_pwd} EXTRA_OPTION_MYSQL.characterEncoding UTF-8 EXTRA_OPTION_MYSQL.defaultFetchSize 500 EXTRA_OPTION_MYSQL.rewriteBatchedStatements true EXTRA_OPTION_MYSQL.useCompression true EXTRA_OPTION_MYSQL.useCursorFetch true EXTRA_OPTION_MYSQL.useServerPrepStmts false FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER ${out_db_port} PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N STREAM_RESULTS Y SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N MongoDB input 表输出 N MongoDB input 插入 / 更新 Y MongoDB input MongoDbInput Y 1 none ${input_db_ip} ${input_db_port} N info_admin sys_user json { $project: { _id: 1, dept1: {$toString: '$dept1'}, dept2: '$dept2', dept3: '$dept3', dept4: '$dept4', dept5: '$dept5', loginName: '$loginName', userName: '$userName', sex: '$sex', politicalOutlook: '$politicalOutlook', role: {$toString: '$role'}, job: '$job', authentication:{ $cond: { if: { $ifNull: [ '$file', false ] }, then: { $cond: [{ $ne: [{ $ifNull: [ '$file', '' ] }, '' ] }, 0, 1 ], }, else: 1, }, }, } }, { $match: {dept1 : "5d4289205ffc6694f7e42082","role" : "5d0c41046a0a730a44fe06b5"} }, Encrypted N N primary N Y N dept5 $.dept5 String role $.role String sex $.sex String userName $.userName String loginName $.loginName String _id $._id String politicalOutlook $.politicalOutlook String dept1 $.dept1 String job $.job String dept2 $.dept2 String dept3 $.dept3 String authentication $.authentication Integer dept4 $.dept4 String

160 208 Y 插入 / 更新 InsertUpdate Y 1 none user 1000 N ry user _id userid = dept5 dept5 Y role role Y sex sex Y userName userName Y loginName loginName Y userid _id Y politicalOutlook politicalOutlook Y dept1 dept1 Y job job Y dept2 dept2 Y dept3 dept3 Y authentication authentication Y dept4 dept4 Y

416 208 Y 表输出 TableOutput Y 1 none user ry user 16000 Y N Y Y N N Y N Y N dept5 dept5 role role sex sex userName userName loginName loginName userid _id politicalOutlook politicalOutlook dept1 dept1 job job dept2 dept2 dept3 dept3 authentication authentication dept4 dept4

416 80 Y N