Dear Team,
I am querying around 250 parquet files with a total size 23gb . total
records are 140 million.
The query is taking around 3.5 minutes to retrieve certain records. From
the execution plan it is very obvious that the cost is very high.
Any advice on performance improvement is highly appreciated. Below is the
query execution plan from profile. Please guide
Drill -.1.20.1
OS - RHEL
{
"head" : {
"version" : 1,
"generator" : {
"type" : "ExplainHandler",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"options" : [ {
"kind" : "LONG",
"accessibleScopes" : "ALL",
"name" : "exec.query.max_rows",
"num_val" : 0,
"scope" : "QUERY"
} ],
"queue" : 0,
"hasResourcePlan" : false,
"resultMode" : "EXEC"
},
"graph" : [ {
"pop" : "jdbc-scan",
"@id" : 327683,
"sql" : "SELECT \"CUSTCODE\", \"CUST_DEC\"\nFROM
\"CUSTD\".\"CUST_CODE_T\"\nWHERE \"CUST_CUS_TYPE\" = 'DD' AND \"ORG_ID\" =
'01' AND (\"DEL_FLG\" <> 'Y' AND \"CUSTCODE\" IS NOT NULL)",
"columns" : [ "`CUSTCODE`", "`CUST_DEC`" ],
"config" : {
"type" : "jdbc",
"driver" : "oracle.jdbc.OracleDriver",
"url" : "jdbc:oracle:thin:XXXXXXXXX_XXXXXXXXX",
"caseInsensitiveTableNames" : true,
"writerBatchSize" : 10000,
"enabled" : true
},
"userName" : "",
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 1.0125
}
}, {
"pop" : "external-sort",
"@id" : 327682,
"child" : 327683,
"orderings" : [ {
"order" : "ASC",
"expr" : "`CUSTCODE`",
"nullDirection" : "LAST"
} ],
"reverse" : false,
"initialAllocation" : 20000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 16.2,
"outputRowCount" : 1.0125
}
}, {
"pop" : "streaming-aggregate",
"@id" : 327681,
"child" : 327682,
"keys" : [ {
"ref" : "`CUSTCODE`",
"expr" : "`CUSTCODE`"
} ],
"exprs" : [ {
"ref" : "`$f1`",
"expr" : "single_value(`CUST_DEC`) "
} ],
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 0.50625
}
}, {
"pop" : "broadcast-exchange",
"@id" : 196611,
"child" : 327681,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 1.0
}
},
{
"pop" : "parquet-scan",
"@id" : 196618,
"userName" : "RRRRR",
"entries" : [ {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~122/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~75/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~118/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~85/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~6/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~27/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~56/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~29/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~80/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~50/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~50/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~2/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~92/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~45/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~73/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~11/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~99/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~5/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~66/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~28/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~19/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~52/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~46/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~91/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~123/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~65/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~26/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~88/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~51/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~42/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~24/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~20/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~76/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~113/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~17/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~124/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~4/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~81/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~16/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~43/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~3/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~70/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~77/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~27/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~121/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~53/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~82/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~89/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~6/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~107/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~93/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~109/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~120/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~66/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~45/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~59/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~60/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~21/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~70/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~110/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~62/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~1/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~106/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~65/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~31/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~28/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~7/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~90/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~8/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~11/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~13/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~31/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~4/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~121/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~18/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~47/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~58/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~37/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~97/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~101/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~23/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~74/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~110/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~34/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~105/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~103/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~21/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~47/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~98/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~95/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~30/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~84/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~9/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~35/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~74/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~124/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~8/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~75/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~96/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~94/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~15/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~25/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~80/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~116/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~22/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~63/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~111/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~44/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~104/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~114/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~85/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~36/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~17/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~35/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~5/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~72/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~112/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~19/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~59/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~61/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~34/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~94/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~102/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~7/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~86/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~118/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~87/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~107/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~71/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~67/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~88/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~83/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~69/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~89/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~76/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~97/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~72/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~111/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~115/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~87/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~25/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~116/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~16/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~55/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~114/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~61/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~38/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~106/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~108/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~68/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~125/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~30/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~64/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~101/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~14/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~100/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~32/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~69/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~92/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~67/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~119/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~41/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~64/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~71/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~49/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~18/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~26/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~82/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~3/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~95/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~39/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~78/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~54/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~43/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~83/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~99/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~90/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~100/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~39/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~22/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~108/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~40/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~53/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~109/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~49/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~2/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~120/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~79/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~105/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~57/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~33/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~42/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~23/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~73/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~44/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~56/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~12/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~93/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~81/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~102/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~78/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~20/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~104/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~86/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~63/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~119/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~91/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~60/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~117/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~126/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~15/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~77/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~98/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~41/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~36/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~9/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~40/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~123/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~10/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~33/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~117/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~52/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~14/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~46/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~48/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~10/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~112/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~37/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~58/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~55/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~57/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~79/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~51/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~48/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~103/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~29/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~113/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~68/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~122/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~24/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~38/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~12/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~115/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~62/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~270~2019~JULY~54/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~32/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~96/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~1/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~13/0_0_0.parquet"
}, {
"path" :
"/llog/log_files/UAT/JOB_TABLE/2019/7/JOB_TABLE~256~300~2019~JULY~84/0_0_0.parquet"
} ],
"storage" : {
"type" : "file",
"connection" : "file:///",
"workspaces" : {
"default" : {
"location" : "/llog/log_files/UAT",
"writable" : true,
"defaultInputFormat" : "json",
"allowAccessOutsideWorkspace" : true
},
"tmp" : {
"location" : "/opt/fda/tmp",
"writable" : true,
"defaultInputFormat" : "json",
"allowAccessOutsideWorkspace" : true
},
"root" : {
"location" : "/llog/log_files/UAT",
"writable" : false,
"defaultInputFormat" : "json",
"allowAccessOutsideWorkspace" : true
}
},
"formats" : {
"parquet" : {
"type" : "parquet"
},
"json" : {
"type" : "json",
"extensions" : [ "json" ]
}
},
"enabled" : true
},
"format" : {
"type" : "parquet"
},
"columns" : [ "`job_date`", "`job_id`", "`ORG_ID`", "`DEL_FLG`",
"`job_id_sec`", "`JOB_EX_DATE`", "`JOB_ST_DATE`", "`JOB_GO_DATE`",
"`JOB_TYPE`", "`JOB_SUB_TYPE`", "`JOB_SR_NUM`", "`JOB_CCY_CODE`",
"`JOB_RET_CODE`", "`job_rdp_code`", "`JOB_PARTICULAR`",
"`JOB_PARTICULAR_2`", "`JOB_RMKS`", "`JOB_TMA`", "`PART_JOB_TYPE`",
"`FLG_POST_TOP`", "`INST_TYPE`", "`INST_DATE`", "`INST_NUM`", "`INST_TAG`",
"`JOB_USER_ID`", "`csv_job_id_csc`", "`XXX_XXX_XXX41`", "`RATE`",
"`XXX_YYY_15`", "`XXX_YYY_15`", "`REF_NUM`" ],
"selectionRoot" : "/llog/log_files/UAT/HIST_TRAN_DTL_TABLE",
"schema" : {
"type" : "tuple_schema",
"columns" : [ {
"name" : "job_date",
"type" : "VARCHAR",
"mode" : "REQUIRED"
}, {
"name" : "job_id_sec",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_SR_NUM",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "del_flg",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_TYPE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_SUB_TYPE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "part_JOB_TYPE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "gl_sub_head_code",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "job_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_ST_DATE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_TMA",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_PARTICULAR",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "entry_user_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "pstd_user_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_USER_ID",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "job_entry_date",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_EX_DATE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "job_vfd_date",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "job_rdp_code",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "ref_num",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "INST_TYPE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "INST_DATE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "INST_NUM",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "INST_TAG",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_RMKS",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "FLG_POST_TOP",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "pr_ad_dn",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "code_poss_ind",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "reservation_ID",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "restrict_ID_SAR",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "trg_user",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "job_time",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "mon_user_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "time_crs",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "cust_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "sts_print_flg",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "module_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "code_st",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "fx_JOB_TMA",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "rate_code",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "rate",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "ccode_rd",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "navigation_flg",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_CCY_CODE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_15",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_15",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_15",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_15",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_14",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_13",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_12",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "gst_upd_flg",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_!1",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_YYY_!",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "lXXX_XXX_YY211",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "pXXX_XXX_YY211d",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_YY211",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "si_XXX_XXX_YY21",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_YY2",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "serial_num",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_YY1",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "uXXX_XXX_YYd",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXZZTTAA",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "rXXX_XXX_XXZZTT",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXZZE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXZZ",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "proxy_job_id",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXYY121",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXYY12",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXYY1",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "rXXX_XXX_XXYY",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXCC",
"type" : "DOUBLE",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX31",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_PERT",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_R_CODE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX21",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "csv_job_id_csc",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "cXXX_XXX_XXX42",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX41",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX40",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "JOB_GO_DATE",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX39",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "ORG_ID",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX15",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX13",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX38",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX386",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX3",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX2",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX1",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
}, {
"name" : "XXX_XXX_XXX",
"type" : "VARCHAR",
"mode" : "OPTIONAL"
} ]
},
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 1.29121196E8
},
"limit" : -1
}, {
"pop" : "filter",
"@id" : 196617,
"child" : 196618,
"expr" : "booleanAnd(greater_than(`job_date`, cast( 1561939200000 as
DATE)) , less_than(`job_date`, cast( 1564531200000 as DATE)) ,
equal(`job_id`, 'AB33435802') , equal(`ORG_ID`, '01') ,
not_equal(`DEL_FLG`, 'Y') ) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "selection-vector-remover",
"@id" : 196616,
"child" : 196617,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "project",
"@id" : 196615,
"exprs" : [ {
"ref" : "`job_date`",
"expr" : "`job_date`"
}, {
"ref" : "`job_id`",
"expr" : "`job_id`"
}, {
"ref" : "`DEL_FLG`",
"expr" : "`DEL_FLG`"
}, {
"ref" : "`job_id_sec`",
"expr" : "`job_id_sec`"
}, {
"ref" : "`JOB_EX_DATE`",
"expr" : "`JOB_EX_DATE`"
}, {
"ref" : "`JOB_ST_DATE`",
"expr" : "`JOB_ST_DATE`"
}, {
"ref" : "`JOB_GO_DATE`",
"expr" : "`JOB_GO_DATE`"
}, {
"ref" : "`JOB_TYPE`",
"expr" : "`JOB_TYPE`"
}, {
"ref" : "`JOB_SUB_TYPE`",
"expr" : "`JOB_SUB_TYPE`"
}, {
"ref" : "`JOB_SR_NUM`",
"expr" : "`JOB_SR_NUM`"
}, {
"ref" : "`JOB_CCY_CODE`",
"expr" : "`JOB_CCY_CODE`"
}, {
"ref" : "`JOB_RET_CODE`",
"expr" : "`JOB_RET_CODE`"
}, {
"ref" : "`job_rdp_code`",
"expr" : "`job_rdp_code`"
}, {
"ref" : "`JOB_PARTICULAR`",
"expr" : "`JOB_PARTICULAR`"
}, {
"ref" : "`JOB_PARTICULAR_2`",
"expr" : "`JOB_PARTICULAR_2`"
}, {
"ref" : "`JOB_RMKS`",
"expr" : "`JOB_RMKS`"
}, {
"ref" : "`JOB_TMA`",
"expr" : "`JOB_TMA`"
}, {
"ref" : "`PART_JOB_TYPE`",
"expr" : "`PART_JOB_TYPE`"
}, {
"ref" : "`FLG_POST_TOP`",
"expr" : "`FLG_POST_TOP`"
}, {
"ref" : "`INST_TYPE`",
"expr" : "`INST_TYPE`"
}, {
"ref" : "`INST_DATE`",
"expr" : "`INST_DATE`"
}, {
"ref" : "`INST_NUM`",
"expr" : "`INST_NUM`"
}, {
"ref" : "`INST_TAG`",
"expr" : "`INST_TAG`"
}, {
"ref" : "`JOB_USER_ID`",
"expr" : "`JOB_USER_ID`"
}, {
"ref" : "`csv_job_id_csc`",
"expr" : "`csv_job_id_csc`"
}, {
"ref" : "`XXX_XXX_XXX41`",
"expr" : "`XXX_XXX_XXX41`"
}, {
"ref" : "`RATE`",
"expr" : "`RATE`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`REF_NUM`",
"expr" : "`REF_NUM`"
} ],
"child" : 196616,
"outputProj" : false,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "jdbc-scan",
"@id" : 262147,
"sql" : "SELECT \"CUSTCODE\", \"CUST_DEC\"\nFROM
\"CUSTD\".\"CUST_CODE_T\"\nWHERE \"CUST_CUS_TYPE\" = 'DD' AND \"ORG_ID\" =
'01' AND (\"DEL_FLG\" <> 'Y' AND \"CUSTCODE\" IS NOT NULL)",
"columns" : [ "`CUSTCODE`", "`CUST_DEC`" ],
"config" : {
"type" : "jdbc",
"driver" : "oracle.jdbc.OracleDriver",
"url" : "jdbc:oracle:thin:XXXXXXXXX_XXXXXXXXX",
"caseInsensitiveTableNames" : true,
"writerBatchSize" : 10000,
"enabled" : true
},
"userName" : "",
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 1.0125
}
}, {
"pop" : "external-sort",
"@id" : 262146,
"child" : 262147,
"orderings" : [ {
"order" : "ASC",
"expr" : "`CUSTCODE`",
"nullDirection" : "LAST"
} ],
"reverse" : false,
"initialAllocation" : 20000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 16.2,
"outputRowCount" : 1.0125
}
}, {
"pop" : "streaming-aggregate",
"@id" : 262145,
"child" : 262146,
"keys" : [ {
"ref" : "`CUSTCODE`",
"expr" : "`CUSTCODE`"
} ],
"exprs" : [ {
"ref" : "`$f1`",
"expr" : "single_value(`CUST_DEC`) "
} ],
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 0.50625
}
}, {
"pop" : "broadcast-exchange",
"@id" : 196614,
"child" : 262145,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 1.0
}
}, {
"pop" : "hash-join",
"@id" : 196613,
"left" : 196615,
"right" : 196614,
"conditions" : [ {
"relationship" : "EQUALS",
"left" : "`JOB_RET_CODE`",
"right" : "`CUSTCODE`"
} ],
"joinType" : "LEFT",
"semiJoin" : false,
"isRowKeyJoin" : false,
"joinControl" : 0,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 17.6,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "project",
"@id" : 196612,
"exprs" : [ {
"ref" : "`job_date`",
"expr" : "`job_date`"
}, {
"ref" : "`job_id`",
"expr" : "`job_id`"
}, {
"ref" : "`DEL_FLG`",
"expr" : "`DEL_FLG`"
}, {
"ref" : "`job_id_sec`",
"expr" : "`job_id_sec`"
}, {
"ref" : "`JOB_EX_DATE`",
"expr" : "`JOB_EX_DATE`"
}, {
"ref" : "`JOB_ST_DATE`",
"expr" : "`JOB_ST_DATE`"
}, {
"ref" : "`JOB_GO_DATE`",
"expr" : "`JOB_GO_DATE`"
}, {
"ref" : "`JOB_TYPE`",
"expr" : "`JOB_TYPE`"
}, {
"ref" : "`JOB_SUB_TYPE`",
"expr" : "`JOB_SUB_TYPE`"
}, {
"ref" : "`JOB_SR_NUM`",
"expr" : "`JOB_SR_NUM`"
}, {
"ref" : "`JOB_CCY_CODE`",
"expr" : "`JOB_CCY_CODE`"
}, {
"ref" : "`JOB_RET_CODE`",
"expr" : "`JOB_RET_CODE`"
}, {
"ref" : "`job_rdp_code`",
"expr" : "`job_rdp_code`"
}, {
"ref" : "`JOB_PARTICULAR`",
"expr" : "`JOB_PARTICULAR`"
}, {
"ref" : "`JOB_PARTICULAR_2`",
"expr" : "`JOB_PARTICULAR_2`"
}, {
"ref" : "`JOB_RMKS`",
"expr" : "`JOB_RMKS`"
}, {
"ref" : "`JOB_TMA`",
"expr" : "`JOB_TMA`"
}, {
"ref" : "`PART_JOB_TYPE`",
"expr" : "`PART_JOB_TYPE`"
}, {
"ref" : "`FLG_POST_TOP`",
"expr" : "`FLG_POST_TOP`"
}, {
"ref" : "`INST_TYPE`",
"expr" : "`INST_TYPE`"
}, {
"ref" : "`INST_DATE`",
"expr" : "`INST_DATE`"
}, {
"ref" : "`INST_NUM`",
"expr" : "`INST_NUM`"
}, {
"ref" : "`INST_TAG`",
"expr" : "`INST_TAG`"
}, {
"ref" : "`JOB_USER_ID`",
"expr" : "`JOB_USER_ID`"
}, {
"ref" : "`csv_job_id_csc`",
"expr" : "`csv_job_id_csc`"
}, {
"ref" : "`XXX_XXX_XXX41`",
"expr" : "`XXX_XXX_XXX41`"
}, {
"ref" : "`RATE`",
"expr" : "`RATE`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`REF_NUM`",
"expr" : "`REF_NUM`"
}, {
"ref" : "`$f0`",
"expr" : "`$f1`"
} ],
"child" : 196613,
"outputProj" : false,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "hash-join",
"@id" : 196610,
"left" : 196612,
"right" : 196611,
"conditions" : [ {
"relationship" : "EQUALS",
"left" : "`job_rdp_code`",
"right" : "`CUSTCODE`"
} ],
"joinType" : "LEFT",
"semiJoin" : false,
"isRowKeyJoin" : false,
"joinControl" : 0,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 17.6,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "project",
"@id" : 196609,
"exprs" : [ {
"ref" : "`job_id`",
"expr" : "`job_id`"
}, {
"ref" : "`job_id_sec`",
"expr" : "`job_id_sec`"
}, {
"ref" : "`job_date`",
"expr" : "`job_date`"
}, {
"ref" : "`JOB_EX_DATE`",
"expr" : "`JOB_EX_DATE`"
}, {
"ref" : "`JOB_ST_DATE`",
"expr" : "`JOB_ST_DATE`"
}, {
"ref" : "`JOB_GO_DATE`",
"expr" : "`JOB_GO_DATE`"
}, {
"ref" : "`JOB_TYPE`",
"expr" : "`JOB_TYPE`"
}, {
"ref" : "`JOB_SUB_TYPE`",
"expr" : "`JOB_SUB_TYPE`"
}, {
"ref" : "`JOB_SR_NUM`",
"expr" : "`JOB_SR_NUM`"
}, {
"ref" : "`JOB_CCY_CODE`",
"expr" : "`JOB_CCY_CODE`"
}, {
"ref" : "`JOB_RET_CODE`",
"expr" : "`JOB_RET_CODE`"
}, {
"ref" : "`job_rdp_code`",
"expr" : "`job_rdp_code`"
}, {
"ref" : "`JOB_PARTICULAR`",
"expr" : "`JOB_PARTICULAR`"
}, {
"ref" : "`JOB_PARTICULAR_2`",
"expr" : "`JOB_PARTICULAR_2`"
}, {
"ref" : "`JOB_RMKS`",
"expr" : "`JOB_RMKS`"
}, {
"ref" : "`JOB_TMA`",
"expr" : "`JOB_TMA`"
}, {
"ref" : "`PART_JOB_TYPE`",
"expr" : "`PART_JOB_TYPE`"
}, {
"ref" : "`FLG_POST_TOP`",
"expr" : "`FLG_POST_TOP`"
}, {
"ref" : "`DEL_FLG`",
"expr" : "`DEL_FLG`"
}, {
"ref" : "`INST_TYPE`",
"expr" : "`INST_TYPE`"
}, {
"ref" : "`INST_DATE`",
"expr" : "`INST_DATE`"
}, {
"ref" : "`INST_NUM`",
"expr" : "`INST_NUM`"
}, {
"ref" : "`INST_TAG`",
"expr" : "`INST_TAG`"
}, {
"ref" : "`JOB_USER_ID`",
"expr" : "`JOB_USER_ID`"
}, {
"ref" : "`csv_job_id_csc`",
"expr" : "`csv_job_id_csc`"
}, {
"ref" : "`XXX_XXX_XXX41`",
"expr" : "`XXX_XXX_XXX41`"
}, {
"ref" : "`RATE`",
"expr" : "`RATE`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`REF_NUM`",
"expr" : "`REF_NUM`"
}, {
"ref" : "`JOB_RET_CODE_DESC`",
"expr" : "`$f0`"
}, {
"ref" : "`job_rdp_code_DESC`",
"expr" : "`$f1`"
} ],
"child" : 196610,
"outputProj" : false,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "hash-to-random-exchange",
"@id" : 131075,
"child" : 196609,
"expr" : "hash32AsDouble(`JOB_SR_NUM`, hash32AsDouble(`job_id_sec`,
hash32AsDouble(`JOB_EX_DATE`, hash32AsDouble(`job_date`, 1301011) ) ) ) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "external-sort",
"@id" : 131074,
"child" : 131075,
"orderings" : [ {
"order" : "ASC",
"expr" : "`job_date`",
"nullDirection" : "LAST"
}, {
"order" : "ASC",
"expr" : "`JOB_EX_DATE`",
"nullDirection" : "LAST"
}, {
"order" : "ASC",
"expr" : "`job_id_sec`",
"nullDirection" : "LAST"
}, {
"order" : "ASC",
"expr" : "`JOB_SR_NUM`",
"nullDirection" : "LAST"
} ],
"reverse" : false,
"initialAllocation" : 20000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 9.296726111999999E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "selection-vector-remover",
"@id" : 131073,
"child" : 131074,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "ordered-mux-exchange",
"@id" : 65537,
"child" : 131073,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "single-merge-exchange",
"@id" : 2,
"child" : 65537,
"orderings" : [ {
"order" : "ASC",
"expr" : "`job_date`",
"nullDirection" : "LAST"
}, {
"order" : "ASC",
"expr" : "`JOB_EX_DATE`",
"nullDirection" : "LAST"
}, {
"order" : "ASC",
"expr" : "`job_id_sec`",
"nullDirection" : "LAST"
}, {
"order" : "ASC",
"expr" : "`JOB_SR_NUM`",
"nullDirection" : "LAST"
} ],
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "project",
"@id" : 1,
"exprs" : [ {
"ref" : "`job_id`",
"expr" : "`job_id`"
}, {
"ref" : "`job_id_sec`",
"expr" : "`job_id_sec`"
}, {
"ref" : "`job_date`",
"expr" : "`job_date`"
}, {
"ref" : "`JOB_EX_DATE`",
"expr" : "`JOB_EX_DATE`"
}, {
"ref" : "`JOB_ST_DATE`",
"expr" : "`JOB_ST_DATE`"
}, {
"ref" : "`JOB_GO_DATE`",
"expr" : "`JOB_GO_DATE`"
}, {
"ref" : "`JOB_TYPE`",
"expr" : "`JOB_TYPE`"
}, {
"ref" : "`JOB_SUB_TYPE`",
"expr" : "`JOB_SUB_TYPE`"
}, {
"ref" : "`JOB_SR_NUM`",
"expr" : "`JOB_SR_NUM`"
}, {
"ref" : "`JOB_CCY_CODE`",
"expr" : "`JOB_CCY_CODE`"
}, {
"ref" : "`JOB_RET_CODE`",
"expr" : "`JOB_RET_CODE`"
}, {
"ref" : "`job_rdp_code`",
"expr" : "`job_rdp_code`"
}, {
"ref" : "`JOB_PARTICULAR`",
"expr" : "`JOB_PARTICULAR`"
}, {
"ref" : "`JOB_PARTICULAR_2`",
"expr" : "`JOB_PARTICULAR_2`"
}, {
"ref" : "`JOB_RMKS`",
"expr" : "`JOB_RMKS`"
}, {
"ref" : "`JOB_TMA`",
"expr" : "`JOB_TMA`"
}, {
"ref" : "`PART_JOB_TYPE`",
"expr" : "`PART_JOB_TYPE`"
}, {
"ref" : "`FLG_POST_TOP`",
"expr" : "`FLG_POST_TOP`"
}, {
"ref" : "`DEL_FLG`",
"expr" : "`DEL_FLG`"
}, {
"ref" : "`INST_TYPE`",
"expr" : "`INST_TYPE`"
}, {
"ref" : "`INST_DATE`",
"expr" : "`INST_DATE`"
}, {
"ref" : "`INST_NUM`",
"expr" : "`INST_NUM`"
}, {
"ref" : "`INST_TAG`",
"expr" : "`INST_TAG`"
}, {
"ref" : "`JOB_USER_ID`",
"expr" : "`JOB_USER_ID`"
}, {
"ref" : "`csv_job_id_csc`",
"expr" : "`csv_job_id_csc`"
}, {
"ref" : "`XXX_XXX_XXX41`",
"expr" : "`XXX_XXX_XXX41`"
}, {
"ref" : "`RATE`",
"expr" : "`RATE`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`XXX_YYY_15`",
"expr" : "`XXX_YYY_15`"
}, {
"ref" : "`REF_NUM`",
"expr" : "`REF_NUM`"
}, {
"ref" : "`JOB_RET_CODE_DESC`",
"expr" : "`JOB_RET_CODE_DESC`"
}, {
"ref" : "`job_rdp_code_DESC`",
"expr" : "`job_rdp_code_DESC`"
} ],
"child" : 2,
"outputProj" : true,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : {
"memoryCost" : 1.6777216E7,
"outputRowCount" : 363153.36374999996
}
} ]
}
