Dear Team, Any advice?
Regards Prabhakar On Thu, Jan 26, 2023 at 5:28 PM Prabhakar Bhosale <[email protected]> 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 > } > } ] > } >
