mem_OrderProducts 0 / - 2019/07/12 19:30:58.949 - 2019/07/12 19:30:58.949 ID_JOB Y ID_JOB CHANNEL_ID Y CHANNEL_ID JOBNAME Y JOBNAME 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 START_JOB_ENTRY N START_JOB_ENTRY CLIENT N CLIENT ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE JOBNAME Y TRANSNAME JOBENTRYNAME Y STEPNAME 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 RESULT Y RESULT NR_RESULT_ROWS Y NR_RESULT_ROWS NR_RESULT_FILES Y NR_RESULT_FILES LOG_FIELD N LOG_FIELD COPY_NR N COPY_NR 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 N 设置变量1237 SET_VARIABLES N JVM mem_orderproducts_page1 21 JVM mem_orderproducts_pagesize1 500 JVM mem_orderproducts_pagecount1 ${mem_orderproducts_count1} JVM mem_orderproducts_pagecountSum ${mem_orderproducts_countSum} JVM mem_orderproducts_pagetSum ${mem_orderproducts_pageSum} JVM N Y 0 176 160 Start SPECIAL Y N N 0 0 60 12 0 1 1 N Y 0 32 80 page<=pagecount SIMPLE_EVAL variable pageSum mem_orderproducts_pageSum number ${mem_orderproducts_pagecountSum} equal smallequal false N N Y 0 336 192 JavaScript EVAL N Y 0 272 64 转换 TRANS filename ${Internal.Entry.Current.Directory}/mem_Order_product_etl.ktr N N N N N N N N Basic N N Y N N N Pentaho local Y N Y 0 448 80 成功 SUCCESS N Y 0 576 192 转换 (2) TRANS filename ${Internal.Entry.Current.Directory}/mem_orderproducts_etl_count_perday.ktr N N N N N N N N Basic N N Y N N N Pentaho local Y N Y 1 96 144 JavaScript 2 EVAL N Y 0 144 64 Start 转换 (2) 0 1 Y Y Y 转换 (2) JavaScript 2 1 0 Y Y N JavaScript 2 设置变量1237 0 0 Y Y N 设置变量1237 page<=pagecount 0 0 Y Y N page<=pagecount 转换 0 0 Y Y N 转换 JavaScript 0 0 Y Y N page<=pagecount 成功 0 0 Y N N JavaScript page<=pagecount 0 0 Y Y N METASTORE.NamedClusters NamedCluster {"namespace":"NamedClusters","id":"NamedCluster","name":"NamedCluster","description":"A NamedCluster","metaStoreName":null} {"_":"Embedded MetaStore Elements","namespace":"NamedClusters","type":"NamedCluster"} test {"children":[{"children":[],"id":"hdfsPassword","value":null},{"children":[],"id":"oozieUrl","value":null},{"children":[],"id":"mapr","value":"N"},{"children":[],"id":"useGateway","value":"N"},{"children":[],"id":"lastModifiedDate","value":"1557461136900"},{"children":[],"id":"jobTrackerHost","value":"localhost"},{"children":[],"id":"zooKeeperHost","value":null},{"children":[],"id":"shimIdentifier","value":null},{"children":[],"id":"gatewayUrl","value":null},{"children":[],"id":"jobTrackerPort","value":"8032"},{"children":[],"id":"zooKeeperPort","value":null},{"children":[],"id":"name","value":"test"},{"children":[],"id":"hdfsPort","value":"9000"},{"children":[],"id":"hdfsUsername","value":"hadoop"},{"children":[],"id":"gatewayPassword","value":null},{"children":[],"id":"kafkaBootstrapServers","value":null},{"children":[],"id":"storageScheme","value":"hdfs"},{"children":[],"id":"hdfsHost","value":"localhost"},{"children":[],"id":"gatewayUsername","value":null}],"id":"test","value":null,"name":"test","owner":null,"ownerPermissionsList":[]} testH {"children":[{"children":[],"id":"hdfsPassword","value":null},{"children":[],"id":"oozieUrl","value":null},{"children":[],"id":"mapr","value":"N"},{"children":[],"id":"useGateway","value":"N"},{"children":[],"id":"lastModifiedDate","value":"1557471867127"},{"children":[],"id":"jobTrackerHost","value":"192.168.50.32"},{"children":[],"id":"zooKeeperHost","value":null},{"children":[],"id":"shimIdentifier","value":null},{"children":[],"id":"gatewayUrl","value":null},{"children":[],"id":"jobTrackerPort","value":"8032"},{"children":[],"id":"zooKeeperPort","value":null},{"children":[],"id":"name","value":"testH"},{"children":[],"id":"hdfsPort","value":"9000"},{"children":[],"id":"hdfsUsername","value":"administrator1"},{"children":[],"id":"gatewayPassword","value":null},{"children":[],"id":"kafkaBootstrapServers","value":null},{"children":[],"id":"storageScheme","value":"hdfs"},{"children":[],"id":"hdfsHost","value":"192.168.50.32"},{"children":[],"id":"gatewayUsername","value":null}],"id":"testH","value":null,"name":"testH","owner":null,"ownerPermissionsList":[]}