You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Prabhakar Bhosale <bh...@gmail.com> on 2023/01/26 11:58:22 UTC
Advice execution plan
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
}
} ]
}
Re: Advice execution plan
Posted by James Turton <dz...@apache.org>.
If you frequently need to operate on a particular subset of records that
is much smaller than the total dataset (such as might be selected by
ORG_ID = '01' and CUST_CUS_TYPE = 'DD') and that is weakly correlated
with your partitioning scheme then you should consider a storage back
end that supports the creation of secondary indexes. Parquet itself
doesn't, but you do have the option of maintaining a derivative Parquet
dataset that is already sorted and perhaps even already aggregated by
the columns of interest. Alternatively, take a look at the secondary
indexes provided by systems like Apache Phoenix[1]. Drill has strong
support for pushing SQL down to Phoenix.
1. https://phoenix.apache.org/secondary_indexing.html
On 2023/01/28 07:52, Prabhakar Bhosale wrote:
> Dear Team,
> Any advice?
>
>
> Regards
> Prabhakar
>
> On Thu, Jan 26, 2023 at 5:28 PM Prabhakar Bhosale <bh...@gmail.com>
> wrote:
>
>> 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
>> }
>> } ]
>> }
>>
Re: Advice execution plan
Posted by Prabhakar Bhosale <bh...@gmail.com>.
Dear Team,
Any advice?
Regards
Prabhakar
On Thu, Jan 26, 2023 at 5:28 PM Prabhakar Bhosale <bh...@gmail.com>
wrote:
> 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
> }
> } ]
> }
>