hdh-spark-job - Details for Query 1316

Submitted Time: 2026/10/23 13:26:33
Duration: 14 s
Succeeded Jobs: 1314 1319
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Physical Plan ==
AdaptiveSparkPlan (19)
+- == Final Plan ==
   * HashAggregate (5)
   +- ShuffleQueryStage (4), Statistics(sizeInBytes=0.0 B, rowCount=0)
      +- Exchange (3)
         +- * HashAggregate (2)
            +- * LocalTableScan (1)
+- == Initial Plan ==
   HashAggregate (18)
   +- Exchange (17)
      +- HashAggregate (16)
         +- HashAggregate (15)
            +- Exchange (14)
               +- HashAggregate (13)
                  +- Union (12)
                     :- Project (8)
                     :  +- Filter (7)
                     :     +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (6)
                     +- Project (11)
                        +- Filter (10)
                           +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (9)


(1) LocalTableScan [codegen id : 4]
Output: []
Arguments: <empty>

(2) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#646262L]
Results [1]: [count#646263L]

(3) Exchange
Input [1]: [count#646263L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=35274]

(4) ShuffleQueryStage
Output [1]: [count#646263L]
Arguments: 1

(5) HashAggregate [codegen id : 5]
Input [1]: [count#646263L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#644155L]
Results [1]: [count(1)#644155L AS COL_0d094836-7839-4adc-a222-56523aefe09b#644157L]

(6) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  [codegen id : 1]
Output [59]: [al_annval#638243, al_classe#638262, al_codcha#638289, al_codsit#638252, al_coduti#638251, al_codval#638242, al_comment#638287, al_datede#638285, al_datefi#638297, al_datmaj#638250, al_envadm#638258, al_flicpt#638284, al_flsej#638283, al_fltele#638288, al_forfai#638261, al_icd#638299, al_int_spe#638294, al_int_std#638293, al_letadm#638257, al_letads#638290, al_lib30#638245, al_libmaj#638246, al_monnaie#638253, al_numbmp#638255, al_numcpt#638286, al_ordre#638256, al_primai#638298, al_prior#638248, al_rcp#638296, al_rembours#638264, al_revers#638263, al_sites#638291, al_spl_trans#638295, al_taux#638247, al_taux_r#638260, al_taux_t1r#638274, al_taux_t1#638265, al_taux_t2r#638275, al_taux_t2#638266, al_taux_t3r#638276, al_taux_t3#638267, al_taux_t4r#638277, al_taux_t4#638268, al_taux_t5r#638278, al_taux_t5#638269, al_taux_t6r#638279, al_taux_t6#638270, al_taux_t7r#638280, al_taux_t7#638271, al_taux_t8r#638281, al_taux_t8#638272, al_taux_t9r#638282, al_taux_t9#638273, al_typexa#638254, al_type#638249, al_type_icd#638300, al_t_red#638259, al_urg#638292, al_valcou#638244]
ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_codval:string,al_comment:string,al_datede:string,al_datefi:string,al_datmaj:string,al_envadm:string,al_flicpt:string,al_flsej:string,al_fltele:string,al_forfai:string,al_icd:string,al_int_spe:string,al_int_std:string,al_letadm:string,al_letads:string,al_lib30:string,al_libmaj:string,al_monnaie:string,al_numbmp:string,al_numcpt:string,al_ordre:string,al_primai:string,al_prior:string,al_rcp:string,al_rembours:string,al_revers:string,al_sites:string,al_spl_trans:string,al_taux:string,al_taux_r:string,al_taux_t1r:string,al_taux_t1:string,al_taux_t2r:string,al_taux_t2:string,al_taux_t3r:string,al_taux_t3:string,al_taux_t4r:string,al_taux_t4:string,al_taux_t5r:string,al_taux_t5:string,al_taux_t6r:string,al_taux_t6:string,al_taux_t7r:string,al_taux_t7:string,al_taux_t8r:string,al_taux_t8:string,al_taux_t9r:string,al_taux_t9:string,al_typexa:string,al_type:string,al_type_icd:string,al_t_red:string,al_urg:string,al_valcou:string>

(7) Filter [codegen id : 1]
Input [59]: [al_annval#638243, al_classe#638262, al_codcha#638289, al_codsit#638252, al_coduti#638251, al_codval#638242, al_comment#638287, al_datede#638285, al_datefi#638297, al_datmaj#638250, al_envadm#638258, al_flicpt#638284, al_flsej#638283, al_fltele#638288, al_forfai#638261, al_icd#638299, al_int_spe#638294, al_int_std#638293, al_letadm#638257, al_letads#638290, al_lib30#638245, al_libmaj#638246, al_monnaie#638253, al_numbmp#638255, al_numcpt#638286, al_ordre#638256, al_primai#638298, al_prior#638248, al_rcp#638296, al_rembours#638264, al_revers#638263, al_sites#638291, al_spl_trans#638295, al_taux#638247, al_taux_r#638260, al_taux_t1r#638274, al_taux_t1#638265, al_taux_t2r#638275, al_taux_t2#638266, al_taux_t3r#638276, al_taux_t3#638267, al_taux_t4r#638277, al_taux_t4#638268, al_taux_t5r#638278, al_taux_t5#638269, al_taux_t6r#638279, al_taux_t6#638270, al_taux_t7r#638280, al_taux_t7#638271, al_taux_t8r#638281, al_taux_t8#638272, al_taux_t9r#638282, al_taux_t9#638273, al_typexa#638254, al_type#638249, al_type_icd#638300, al_t_red#638259, al_urg#638292, al_valcou#638244]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#638242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#638242)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#638243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#638243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#638244)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#638244)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#638245)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#638245)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#638246)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#638246)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#638247)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#638247)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#638248)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#638248)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#638249)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_type#638249)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#638250)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#638250)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#638251)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#638251)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#638252)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#638252)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#638253)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#638253)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#638254)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#638254)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#638255)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#638255)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#638256)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#638256)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#638257)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#638257)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#638258)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#638258)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#638259)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#638259)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#638260)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#638260)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#638261)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#638261)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#638262)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#638262)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#638263)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#638263)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#638264)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#638264)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#638265)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#638265)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#638266)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#638266)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#638267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#638267)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#638268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#638268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#638269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#638269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#638270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#638270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#638271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#638271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#638272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#638272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#638273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#638273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#638274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#638274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#638275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#638275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#638276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#638276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#638277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#638277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#638278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#638278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#638279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#638279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#638280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#638280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#638281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#638281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#638282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#638282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#638283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#638283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#638284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#638284)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#638285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#638285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#638286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#638286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#638287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#638287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#638288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#638288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#638289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#638289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#638290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#638290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#638291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#638291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#638292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#638292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#638293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#638293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#638294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#638294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#638295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#638295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#638296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#638296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#638297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#638297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#638298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#638298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#638299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#638299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#638300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#638300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MARX)) THEN false ELSE Contains(str_remove_accent(null), MARX) END)

(8) Project [codegen id : 1]
Output [60]: [al_annval#638243 AS AL_ANNVAL_438378#638957, al_classe#638262 AS AL_CLASSE_438397#638958, al_codcha#638289 AS AL_CODCHA_438424#638959, al_codsit#638252 AS AL_CODSIT_438387#638960, al_coduti#638251 AS AL_CODUTI_438386#638961, al_codval#638242 AS AL_CODVAL_438377#638962, al_comment#638287 AS AL_COMMENT_438422#638963, al_datede#638285 AS AL_DATEDE_438420#638964, al_datefi#638297 AS AL_DATEFI_438432#638965, al_datmaj#638250 AS AL_DATMAJ_438385#638966, al_envadm#638258 AS AL_ENVADM_438393#638967, al_flicpt#638284 AS AL_FLICPT_438419#638968, al_flsej#638283 AS AL_FLSEJ_438418#638969, al_fltele#638288 AS AL_FLTELE_438423#638970, al_forfai#638261 AS AL_FORFAI_438396#638971, al_icd#638299 AS AL_ICD_438434#638972, al_int_spe#638294 AS AL_INT_SPE_438429#638973, al_int_std#638293 AS AL_INT_STD_438428#638974, al_letadm#638257 AS AL_LETADM_438392#638975, al_letads#638290 AS AL_LETADS_438425#638976, al_lib30#638245 AS AL_LIB30_438380#638977, al_libmaj#638246 AS AL_LIBMAJ_438381#638978, al_monnaie#638253 AS AL_MONNAIE_438388#638979, al_numbmp#638255 AS AL_NUMBMP_438390#638980, al_numcpt#638286 AS AL_NUMCPT_438421#638981, al_ordre#638256 AS AL_ORDRE_438391#638982, al_primai#638298 AS AL_PRIMAI_438433#638983, al_prior#638248 AS AL_PRIOR_438383#638984, al_rcp#638296 AS AL_RCP_438431#638985, al_rembours#638264 AS AL_REMBOURS_438399#638986, al_revers#638263 AS AL_REVERS_438398#638987, al_sites#638291 AS AL_SITES_438426#638988, al_spl_trans#638295 AS AL_SPL_TRANS_438430#638989, al_taux#638247 AS AL_TAUX_438382#638990, al_taux_r#638260 AS AL_TAUX_R_438395#638991, al_taux_t1r#638274 AS AL_TAUX_T1R_438409#638992, al_taux_t1#638265 AS AL_TAUX_T1_438400#638993, al_taux_t2r#638275 AS AL_TAUX_T2R_438410#638994, al_taux_t2#638266 AS AL_TAUX_T2_438401#638995, al_taux_t3r#638276 AS AL_TAUX_T3R_438411#638996, al_taux_t3#638267 AS AL_TAUX_T3_438402#638997, al_taux_t4r#638277 AS AL_TAUX_T4R_438412#638998, al_taux_t4#638268 AS AL_TAUX_T4_438403#638999, al_taux_t5r#638278 AS AL_TAUX_T5R_438413#639000, al_taux_t5#638269 AS AL_TAUX_T5_438404#639001, al_taux_t6r#638279 AS AL_TAUX_T6R_438414#639002, al_taux_t6#638270 AS AL_TAUX_T6_438405#639003, al_taux_t7r#638280 AS AL_TAUX_T7R_438415#639004, al_taux_t7#638271 AS AL_TAUX_T7_438406#639005, al_taux_t8r#638281 AS AL_TAUX_T8R_438416#639006, al_taux_t8#638272 AS AL_TAUX_T8_438407#639007, al_taux_t9r#638282 AS AL_TAUX_T9R_438417#639008, al_taux_t9#638273 AS AL_TAUX_T9_438408#639009, al_typexa#638254 AS AL_TYPEXA_438389#639010, al_type#638249 AS AL_TYPE_438384#639011, al_type_icd#638300 AS AL_TYPE_ICD_438435#639012, al_t_red#638259 AS AL_T_RED_438394#639013, al_urg#638292 AS AL_URG_438427#639014, al_valcou#638244 AS AL_VALCOU_438379#639015, null AS ORIGINE_440156#639016]
Input [59]: [al_annval#638243, al_classe#638262, al_codcha#638289, al_codsit#638252, al_coduti#638251, al_codval#638242, al_comment#638287, al_datede#638285, al_datefi#638297, al_datmaj#638250, al_envadm#638258, al_flicpt#638284, al_flsej#638283, al_fltele#638288, al_forfai#638261, al_icd#638299, al_int_spe#638294, al_int_std#638293, al_letadm#638257, al_letads#638290, al_lib30#638245, al_libmaj#638246, al_monnaie#638253, al_numbmp#638255, al_numcpt#638286, al_ordre#638256, al_primai#638298, al_prior#638248, al_rcp#638296, al_rembours#638264, al_revers#638263, al_sites#638291, al_spl_trans#638295, al_taux#638247, al_taux_r#638260, al_taux_t1r#638274, al_taux_t1#638265, al_taux_t2r#638275, al_taux_t2#638266, al_taux_t3r#638276, al_taux_t3#638267, al_taux_t4r#638277, al_taux_t4#638268, al_taux_t5r#638278, al_taux_t5#638269, al_taux_t6r#638279, al_taux_t6#638270, al_taux_t7r#638280, al_taux_t7#638271, al_taux_t8r#638281, al_taux_t8#638272, al_taux_t9r#638282, al_taux_t9#638273, al_typexa#638254, al_type#638249, al_type_icd#638300, al_t_red#638259, al_urg#638292, al_valcou#638244]

(9) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  [codegen id : 2]
Output [59]: [al_annval#639378, al_classe#639397, al_codcha#639424, al_codsit#639387, al_coduti#639386, al_codval#639377, al_comment#639422, al_datede#639420, al_datefi#639432, al_datmaj#639385, al_envadm#639393, al_flicpt#639419, al_flsej#639418, al_fltele#639423, al_forfai#639396, al_icd#639434, al_int_spe#639429, al_int_std#639428, al_letadm#639392, al_letads#639425, al_lib30#639380, al_libmaj#639381, al_monnaie#639388, al_numbmp#639390, al_numcpt#639421, al_ordre#639391, al_primai#639433, al_prior#639383, al_rcp#639431, al_rembours#639399, al_revers#639398, al_sites#639426, al_spl_trans#639430, al_taux#639382, al_taux_r#639395, al_taux_t1r#639409, al_taux_t1#639400, al_taux_t2r#639410, al_taux_t2#639401, al_taux_t3r#639411, al_taux_t3#639402, al_taux_t4r#639412, al_taux_t4#639403, al_taux_t5r#639413, al_taux_t5#639404, al_taux_t6r#639414, al_taux_t6#639405, al_taux_t7r#639415, al_taux_t7#639406, al_taux_t8r#639416, al_taux_t8#639407, al_taux_t9r#639417, al_taux_t9#639408, al_typexa#639389, al_type#639384, al_type_icd#639435, al_t_red#639394, al_urg#639427, al_valcou#639379]
ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_codval:string,al_comment:string,al_datede:string,al_datefi:string,al_datmaj:string,al_envadm:string,al_flicpt:string,al_flsej:string,al_fltele:string,al_forfai:string,al_icd:string,al_int_spe:string,al_int_std:string,al_letadm:string,al_letads:string,al_lib30:string,al_libmaj:string,al_monnaie:string,al_numbmp:string,al_numcpt:string,al_ordre:string,al_primai:string,al_prior:string,al_rcp:string,al_rembours:string,al_revers:string,al_sites:string,al_spl_trans:string,al_taux:string,al_taux_r:string,al_taux_t1r:string,al_taux_t1:string,al_taux_t2r:string,al_taux_t2:string,al_taux_t3r:string,al_taux_t3:string,al_taux_t4r:string,al_taux_t4:string,al_taux_t5r:string,al_taux_t5:string,al_taux_t6r:string,al_taux_t6:string,al_taux_t7r:string,al_taux_t7:string,al_taux_t8r:string,al_taux_t8:string,al_taux_t9r:string,al_taux_t9:string,al_typexa:string,al_type:string,al_type_icd:string,al_t_red:string,al_urg:string,al_valcou:string>

(10) Filter [codegen id : 2]
Input [59]: [al_annval#639378, al_classe#639397, al_codcha#639424, al_codsit#639387, al_coduti#639386, al_codval#639377, al_comment#639422, al_datede#639420, al_datefi#639432, al_datmaj#639385, al_envadm#639393, al_flicpt#639419, al_flsej#639418, al_fltele#639423, al_forfai#639396, al_icd#639434, al_int_spe#639429, al_int_std#639428, al_letadm#639392, al_letads#639425, al_lib30#639380, al_libmaj#639381, al_monnaie#639388, al_numbmp#639390, al_numcpt#639421, al_ordre#639391, al_primai#639433, al_prior#639383, al_rcp#639431, al_rembours#639399, al_revers#639398, al_sites#639426, al_spl_trans#639430, al_taux#639382, al_taux_r#639395, al_taux_t1r#639409, al_taux_t1#639400, al_taux_t2r#639410, al_taux_t2#639401, al_taux_t3r#639411, al_taux_t3#639402, al_taux_t4r#639412, al_taux_t4#639403, al_taux_t5r#639413, al_taux_t5#639404, al_taux_t6r#639414, al_taux_t6#639405, al_taux_t7r#639415, al_taux_t7#639406, al_taux_t8r#639416, al_taux_t8#639407, al_taux_t9r#639417, al_taux_t9#639408, al_typexa#639389, al_type#639384, al_type_icd#639435, al_t_red#639394, al_urg#639427, al_valcou#639379]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#639377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#639377)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#639378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#639378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#639379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#639379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#639380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#639380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#639381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#639381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#639382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#639382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#639383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#639383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#639384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_type#639384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#639385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#639385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#639386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#639386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#639387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#639387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#639388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#639388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#639389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#639389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#639390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#639390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#639391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#639391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#639392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#639392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#639393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#639393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#639394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#639394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#639395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#639395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#639396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#639396)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#639397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#639397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#639398)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#639398)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#639399)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#639399)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#639400)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#639400)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#639401)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#639401)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#639402)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#639402)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#639403)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#639403)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#639404)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#639404)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#639405)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#639405)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#639406)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#639406)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#639407)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#639407)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#639408)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#639408)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#639409)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#639409)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#639410)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#639410)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#639411)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#639411)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#639412)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#639412)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#639413)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#639413)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#639414)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#639414)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#639415)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#639415)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#639416)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#639416)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#639417)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#639417)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#639418)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#639418)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#639419)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#639419)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#639420)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#639420)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#639421)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#639421)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#639422)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#639422)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#639423)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#639423)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#639424)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#639424)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#639425)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#639425)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#639426)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#639426)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#639427)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#639427)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#639428)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#639428)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#639429)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#639429)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#639430)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#639430)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#639431)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#639431)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#639432)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#639432)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#639433)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#639433)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#639434)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#639434)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#639435)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#639435)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MARX)) THEN false ELSE Contains(str_remove_accent(null), MARX) END)

(11) Project [codegen id : 2]
Output [60]: [al_annval#639378 AS AL_ANNVAL_438378#640044, al_classe#639397 AS AL_CLASSE_438397#640045, al_codcha#639424 AS AL_CODCHA_438424#640046, al_codsit#639387 AS AL_CODSIT_438387#640047, al_coduti#639386 AS AL_CODUTI_438386#640048, al_codval#639377 AS AL_CODVAL_438377#640049, al_comment#639422 AS AL_COMMENT_438422#640050, al_datede#639420 AS AL_DATEDE_438420#640051, al_datefi#639432 AS AL_DATEFI_438432#640052, al_datmaj#639385 AS AL_DATMAJ_438385#640053, al_envadm#639393 AS AL_ENVADM_438393#640054, al_flicpt#639419 AS AL_FLICPT_438419#640055, al_flsej#639418 AS AL_FLSEJ_438418#640056, al_fltele#639423 AS AL_FLTELE_438423#640057, al_forfai#639396 AS AL_FORFAI_438396#640058, al_icd#639434 AS AL_ICD_438434#640059, al_int_spe#639429 AS AL_INT_SPE_438429#640060, al_int_std#639428 AS AL_INT_STD_438428#640061, al_letadm#639392 AS AL_LETADM_438392#640062, al_letads#639425 AS AL_LETADS_438425#640063, al_lib30#639380 AS AL_LIB30_438380#640064, al_libmaj#639381 AS AL_LIBMAJ_438381#640065, al_monnaie#639388 AS AL_MONNAIE_438388#640066, al_numbmp#639390 AS AL_NUMBMP_438390#640067, al_numcpt#639421 AS AL_NUMCPT_438421#640068, al_ordre#639391 AS AL_ORDRE_438391#640069, al_primai#639433 AS AL_PRIMAI_438433#640070, al_prior#639383 AS AL_PRIOR_438383#640071, al_rcp#639431 AS AL_RCP_438431#640072, al_rembours#639399 AS AL_REMBOURS_438399#640073, al_revers#639398 AS AL_REVERS_438398#640074, al_sites#639426 AS AL_SITES_438426#640075, al_spl_trans#639430 AS AL_SPL_TRANS_438430#640076, al_taux#639382 AS AL_TAUX_438382#640077, al_taux_r#639395 AS AL_TAUX_R_438395#640078, al_taux_t1r#639409 AS AL_TAUX_T1R_438409#640079, al_taux_t1#639400 AS AL_TAUX_T1_438400#640080, al_taux_t2r#639410 AS AL_TAUX_T2R_438410#640081, al_taux_t2#639401 AS AL_TAUX_T2_438401#640082, al_taux_t3r#639411 AS AL_TAUX_T3R_438411#640083, al_taux_t3#639402 AS AL_TAUX_T3_438402#640084, al_taux_t4r#639412 AS AL_TAUX_T4R_438412#640085, al_taux_t4#639403 AS AL_TAUX_T4_438403#640086, al_taux_t5r#639413 AS AL_TAUX_T5R_438413#640087, al_taux_t5#639404 AS AL_TAUX_T5_438404#640088, al_taux_t6r#639414 AS AL_TAUX_T6R_438414#640089, al_taux_t6#639405 AS AL_TAUX_T6_438405#640090, al_taux_t7r#639415 AS AL_TAUX_T7R_438415#640091, al_taux_t7#639406 AS AL_TAUX_T7_438406#640092, al_taux_t8r#639416 AS AL_TAUX_T8R_438416#640093, al_taux_t8#639407 AS AL_TAUX_T8_438407#640094, al_taux_t9r#639417 AS AL_TAUX_T9R_438417#640095, al_taux_t9#639408 AS AL_TAUX_T9_438408#640096, al_typexa#639389 AS AL_TYPEXA_438389#640097, al_type#639384 AS AL_TYPE_438384#640098, al_type_icd#639435 AS AL_TYPE_ICD_438435#640099, al_t_red#639394 AS AL_T_RED_438394#640100, al_urg#639427 AS AL_URG_438427#640101, al_valcou#639379 AS AL_VALCOU_438379#640102, null AS ORIGINE_440156#640183]
Input [59]: [al_annval#639378, al_classe#639397, al_codcha#639424, al_codsit#639387, al_coduti#639386, al_codval#639377, al_comment#639422, al_datede#639420, al_datefi#639432, al_datmaj#639385, al_envadm#639393, al_flicpt#639419, al_flsej#639418, al_fltele#639423, al_forfai#639396, al_icd#639434, al_int_spe#639429, al_int_std#639428, al_letadm#639392, al_letads#639425, al_lib30#639380, al_libmaj#639381, al_monnaie#639388, al_numbmp#639390, al_numcpt#639421, al_ordre#639391, al_primai#639433, al_prior#639383, al_rcp#639431, al_rembours#639399, al_revers#639398, al_sites#639426, al_spl_trans#639430, al_taux#639382, al_taux_r#639395, al_taux_t1r#639409, al_taux_t1#639400, al_taux_t2r#639410, al_taux_t2#639401, al_taux_t3r#639411, al_taux_t3#639402, al_taux_t4r#639412, al_taux_t4#639403, al_taux_t5r#639413, al_taux_t5#639404, al_taux_t6r#639414, al_taux_t6#639405, al_taux_t7r#639415, al_taux_t7#639406, al_taux_t8r#639416, al_taux_t8#639407, al_taux_t9r#639417, al_taux_t9#639408, al_typexa#639389, al_type#639384, al_type_icd#639435, al_t_red#639394, al_urg#639427, al_valcou#639379]

(12) Union

(13) HashAggregate
Input [60]: [AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, AL_NUMCPT_438421#638981, AL_ORDRE_438391#638982, AL_PRIMAI_438433#638983, AL_PRIOR_438383#638984, AL_RCP_438431#638985, AL_REMBOURS_438399#638986, AL_REVERS_438398#638987, AL_SITES_438426#638988, AL_SPL_TRANS_438430#638989, AL_TAUX_438382#638990, AL_TAUX_R_438395#638991, AL_TAUX_T1R_438409#638992, AL_TAUX_T1_438400#638993, AL_TAUX_T2R_438410#638994, AL_TAUX_T2_438401#638995, AL_TAUX_T3R_438411#638996, AL_TAUX_T3_438402#638997, AL_TAUX_T4R_438412#638998, AL_TAUX_T4_438403#638999, AL_TAUX_T5R_438413#639000, AL_TAUX_T5_438404#639001, AL_TAUX_T6R_438414#639002, AL_TAUX_T6_438405#639003, AL_TAUX_T7R_438415#639004, AL_TAUX_T7_438406#639005, AL_TAUX_T8R_438416#639006, AL_TAUX_T8_438407#639007, AL_TAUX_T9R_438417#639008, AL_TAUX_T9_438408#639009, AL_TYPEXA_438389#639010, AL_TYPE_438384#639011, AL_TYPE_ICD_438435#639012, AL_T_RED_438394#639013, AL_URG_438427#639014, AL_VALCOU_438379#639015, ORIGINE_440156#639016]
Keys [60]: [AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, AL_NUMCPT_438421#638981, AL_ORDRE_438391#638982, AL_PRIMAI_438433#638983, AL_PRIOR_438383#638984, AL_RCP_438431#638985, AL_REMBOURS_438399#638986, AL_REVERS_438398#638987, AL_SITES_438426#638988, AL_SPL_TRANS_438430#638989, AL_TAUX_438382#638990, AL_TAUX_R_438395#638991, AL_TAUX_T1R_438409#638992, AL_TAUX_T1_438400#638993, AL_TAUX_T2R_438410#638994, AL_TAUX_T2_438401#638995, AL_TAUX_T3R_438411#638996, AL_TAUX_T3_438402#638997, AL_TAUX_T4R_438412#638998, AL_TAUX_T4_438403#638999, AL_TAUX_T5R_438413#639000, AL_TAUX_T5_438404#639001, AL_TAUX_T6R_438414#639002, AL_TAUX_T6_438405#639003, AL_TAUX_T7R_438415#639004, AL_TAUX_T7_438406#639005, AL_TAUX_T8R_438416#639006, AL_TAUX_T8_438407#639007, AL_TAUX_T9R_438417#639008, AL_TAUX_T9_438408#639009, AL_TYPEXA_438389#639010, AL_TYPE_438384#639011, AL_TYPE_ICD_438435#639012, AL_T_RED_438394#639013, AL_URG_438427#639014, AL_VALCOU_438379#639015, ORIGINE_440156#639016]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, AL_NUMCPT_438421#638981, AL_ORDRE_438391#638982, AL_PRIMAI_438433#638983, AL_PRIOR_438383#638984, AL_RCP_438431#638985, AL_REMBOURS_438399#638986, AL_REVERS_438398#638987, AL_SITES_438426#638988, AL_SPL_TRANS_438430#638989, AL_TAUX_438382#638990, AL_TAUX_R_438395#638991, AL_TAUX_T1R_438409#638992, AL_TAUX_T1_438400#638993, AL_TAUX_T2R_438410#638994, AL_TAUX_T2_438401#638995, AL_TAUX_T3R_438411#638996, AL_TAUX_T3_438402#638997, AL_TAUX_T4R_438412#638998, AL_TAUX_T4_438403#638999, AL_TAUX_T5R_438413#639000, AL_TAUX_T5_438404#639001, AL_TAUX_T6R_438414#639002, AL_TAUX_T6_438405#639003, AL_TAUX_T7R_438415#639004, AL_TAUX_T7_438406#639005, AL_TAUX_T8R_438416#639006, AL_TAUX_T8_438407#639007, AL_TAUX_T9R_438417#639008, AL_TAUX_T9_438408#639009, AL_TYPEXA_438389#639010, AL_TYPE_438384#639011, AL_TYPE_ICD_438435#639012, AL_T_RED_438394#639013, AL_URG_438427#639014, AL_VALCOU_438379#639015, ORIGINE_440156#639016]

(14) Exchange
Input [60]: [AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, AL_NUMCPT_438421#638981, AL_ORDRE_438391#638982, AL_PRIMAI_438433#638983, AL_PRIOR_438383#638984, AL_RCP_438431#638985, AL_REMBOURS_438399#638986, AL_REVERS_438398#638987, AL_SITES_438426#638988, AL_SPL_TRANS_438430#638989, AL_TAUX_438382#638990, AL_TAUX_R_438395#638991, AL_TAUX_T1R_438409#638992, AL_TAUX_T1_438400#638993, AL_TAUX_T2R_438410#638994, AL_TAUX_T2_438401#638995, AL_TAUX_T3R_438411#638996, AL_TAUX_T3_438402#638997, AL_TAUX_T4R_438412#638998, AL_TAUX_T4_438403#638999, AL_TAUX_T5R_438413#639000, AL_TAUX_T5_438404#639001, AL_TAUX_T6R_438414#639002, AL_TAUX_T6_438405#639003, AL_TAUX_T7R_438415#639004, AL_TAUX_T7_438406#639005, AL_TAUX_T8R_438416#639006, AL_TAUX_T8_438407#639007, AL_TAUX_T9R_438417#639008, AL_TAUX_T9_438408#639009, AL_TYPEXA_438389#639010, AL_TYPE_438384#639011, AL_TYPE_ICD_438435#639012, AL_T_RED_438394#639013, AL_URG_438427#639014, AL_VALCOU_438379#639015, ORIGINE_440156#639016]
Arguments: hashpartitioning(AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=35005]

(15) HashAggregate
Input [60]: [AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, AL_NUMCPT_438421#638981, AL_ORDRE_438391#638982, AL_PRIMAI_438433#638983, AL_PRIOR_438383#638984, AL_RCP_438431#638985, AL_REMBOURS_438399#638986, AL_REVERS_438398#638987, AL_SITES_438426#638988, AL_SPL_TRANS_438430#638989, AL_TAUX_438382#638990, AL_TAUX_R_438395#638991, AL_TAUX_T1R_438409#638992, AL_TAUX_T1_438400#638993, AL_TAUX_T2R_438410#638994, AL_TAUX_T2_438401#638995, AL_TAUX_T3R_438411#638996, AL_TAUX_T3_438402#638997, AL_TAUX_T4R_438412#638998, AL_TAUX_T4_438403#638999, AL_TAUX_T5R_438413#639000, AL_TAUX_T5_438404#639001, AL_TAUX_T6R_438414#639002, AL_TAUX_T6_438405#639003, AL_TAUX_T7R_438415#639004, AL_TAUX_T7_438406#639005, AL_TAUX_T8R_438416#639006, AL_TAUX_T8_438407#639007, AL_TAUX_T9R_438417#639008, AL_TAUX_T9_438408#639009, AL_TYPEXA_438389#639010, AL_TYPE_438384#639011, AL_TYPE_ICD_438435#639012, AL_T_RED_438394#639013, AL_URG_438427#639014, AL_VALCOU_438379#639015, ORIGINE_440156#639016]
Keys [60]: [AL_ANNVAL_438378#638957, AL_CLASSE_438397#638958, AL_CODCHA_438424#638959, AL_CODSIT_438387#638960, AL_CODUTI_438386#638961, AL_CODVAL_438377#638962, AL_COMMENT_438422#638963, AL_DATEDE_438420#638964, AL_DATEFI_438432#638965, AL_DATMAJ_438385#638966, AL_ENVADM_438393#638967, AL_FLICPT_438419#638968, AL_FLSEJ_438418#638969, AL_FLTELE_438423#638970, AL_FORFAI_438396#638971, AL_ICD_438434#638972, AL_INT_SPE_438429#638973, AL_INT_STD_438428#638974, AL_LETADM_438392#638975, AL_LETADS_438425#638976, AL_LIB30_438380#638977, AL_LIBMAJ_438381#638978, AL_MONNAIE_438388#638979, AL_NUMBMP_438390#638980, AL_NUMCPT_438421#638981, AL_ORDRE_438391#638982, AL_PRIMAI_438433#638983, AL_PRIOR_438383#638984, AL_RCP_438431#638985, AL_REMBOURS_438399#638986, AL_REVERS_438398#638987, AL_SITES_438426#638988, AL_SPL_TRANS_438430#638989, AL_TAUX_438382#638990, AL_TAUX_R_438395#638991, AL_TAUX_T1R_438409#638992, AL_TAUX_T1_438400#638993, AL_TAUX_T2R_438410#638994, AL_TAUX_T2_438401#638995, AL_TAUX_T3R_438411#638996, AL_TAUX_T3_438402#638997, AL_TAUX_T4R_438412#638998, AL_TAUX_T4_438403#638999, AL_TAUX_T5R_438413#639000, AL_TAUX_T5_438404#639001, AL_TAUX_T6R_438414#639002, AL_TAUX_T6_438405#639003, AL_TAUX_T7R_438415#639004, AL_TAUX_T7_438406#639005, AL_TAUX_T8R_438416#639006, AL_TAUX_T8_438407#639007, AL_TAUX_T9R_438417#639008, AL_TAUX_T9_438408#639009, AL_TYPEXA_438389#639010, AL_TYPE_438384#639011, AL_TYPE_ICD_438435#639012, AL_T_RED_438394#639013, AL_URG_438427#639014, AL_VALCOU_438379#639015, ORIGINE_440156#639016]
Functions: []
Aggregate Attributes: []
Results: []

(16) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#646262L]
Results [1]: [count#646263L]

(17) Exchange
Input [1]: [count#646263L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=35009]

(18) HashAggregate
Input [1]: [count#646263L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#644155L]
Results [1]: [count(1)#644155L AS COL_0d094836-7839-4adc-a222-56523aefe09b#644157L]

(19) AdaptiveSparkPlan
Output [1]: [COL_0d094836-7839-4adc-a222-56523aefe09b#644157L]
Arguments: isFinalPlan=true
SQL / DataFrame Properties
Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet