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":[]}