hdh-spark-job - Details for Query 1372

Submitted Time: 2026/10/23 13:28:09
Duration: 18 s
Succeeded Jobs: 1371 1375

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1985.0: task 1731)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 2 local bytes read: 112.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (16.0 B, 16.0 B, 16.0 B (stage 1985.0: task 1731)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 112.0 B (56.0 B, 56.0 B, 56.0 B (stage 1985.0: task 1731))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n6.3 s (3.1 s, 3.2 s, 3.2 s (stage 1985.0: task 1730))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 6.3 s (3.1 s, 3.2 s, 3.2 s (stage 1985.0: task 1730)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 3.2 s"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 0"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"zd_numcot\", \"zd_numdem\", \"zd_numdos\", \"zd_numpco\", \"zd_primai\", \"zd_annval\", \"zd_monnaie\", \"zd_cod_acte\", \"zd_ver_ccam\", \"zd_codsit\", \"zd_coduti\", \"zd_datmaj\", \"zd_cod_aa\", \"zd_modificateur\", \"zd_codper\", \"zd_codser\", \"zd_numsal\", \"zd_flassprev\", \"zd_assnonprev\", \"zd_numord\", \"zd_priuni\", \"zd_coefmino\", \"zd_mino\", \"zd_majo\", \"zd_basrmb\", \"zd_factur\", \"zd_typexo\", \"zd_taucai\", \"zd_parcai\", \"zd_taumut\", \"zd_parmut\", \"zd_ligrgr\", \"zd_regrou_cod\", \"zd_cod_aap\", \"zd_qualdp\", \"zd_flrmbexc\", \"zd_flsuppcharge\", \"zd_donncompl\", \"zd_dents\", \"zd_depmnt\", \"zd_flid\", \"zd_mttid\", \"zd_tauid\", \"zd_amoid\", \"zd_tauid_amc\", \"zd_amcid\", \"zd_nbrik\", \"zd_mttik\", \"zd_tauik\", \"zd_amoik\", \"zd_nbrikm\", \"zd_mttikm\", \"zd_tauikm\", \"zd_amoikm\", \"zd_nbriks\", \"zd_mttiks\", \"zd_tauiks\", \"zd_amoiks\", \"zd_forc\", \"zd_formamc\", \"zd_codtit\", \"zd_flald\", \"zd_a_fact\", \"zd_x_exo_tm\", \"zd_modiffact\", \"zd_assnonprev_c\", \"zd_qualdp_c\", \"zd_coduam\", \"zd_mtdep\", \"zd_mtpenhps\", \"zd_flpav\", \"zd_mttori\", \"zd_acr\", \"zd_codapp\", \"zd_codper2\", \"zd_codind\", \"zd_codres\", \"zd_codextdoc\", \"zd_numexa\", \"zd_codextpmsi\" FROM \"xplore\".\"h_ccamdet\") as x) [numPartitions=1] number of output rows: 37,790"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 3.1 s"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 0"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"zd_numcot\", \"zd_numdem\", \"zd_numdos\", \"zd_numpco\", \"zd_primai\", \"zd_annval\", \"zd_monnaie\", \"zd_cod_acte\", \"zd_ver_ccam\", \"zd_codsit\", \"zd_coduti\", \"zd_datmaj\", \"zd_cod_aa\", \"zd_modificateur\", \"zd_codper\", \"zd_codser\", \"zd_numsal\", \"zd_flassprev\", \"zd_assnonprev\", \"zd_numord\", \"zd_priuni\", \"zd_coefmino\", \"zd_mino\", \"zd_majo\", \"zd_basrmb\", \"zd_factur\", \"zd_typexo\", \"zd_taucai\", \"zd_parcai\", \"zd_taumut\", \"zd_parmut\", \"zd_ligrgr\", \"zd_regrou_cod\", \"zd_cod_aap\", \"zd_qualdp\", \"zd_flrmbexc\", \"zd_flsuppcharge\", \"zd_donncompl\", \"zd_dents\", \"zd_depmnt\", \"zd_flid\", \"zd_mttid\", \"zd_tauid\", \"zd_amoid\", \"zd_tauid_amc\", \"zd_amcid\", \"zd_nbrik\", \"zd_mttik\", \"zd_tauik\", \"zd_amoik\", \"zd_nbrikm\", \"zd_mttikm\", \"zd_tauikm\", \"zd_amoikm\", \"zd_nbriks\", \"zd_mttiks\", \"zd_tauiks\", \"zd_amoiks\", \"zd_forc\", \"zd_formamc\", \"zd_codtit\", \"zd_flald\", \"zd_a_fact\", \"zd_x_exo_tm\", \"zd_modiffact\", \"zd_assnonprev_c\", \"zd_qualdp_c\", \"zd_coduam\", \"zd_mtdep\", \"zd_mtpenhps\", \"zd_flpav\", \"zd_mttori\", \"zd_acr\", \"zd_codapp\", \"zd_codper2\", \"zd_codind\", \"zd_codres\", \"zd_codextdoc\", \"zd_numexa\", \"zd_codextpmsi\" FROM \"xplore2\".\"h_ccamdet\") as x) [numPartitions=1] number of output rows: 37,790"]; } 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->6; 13->12; 14->13; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (4)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=36971]

HashAggregate(keys=[], functions=[partial_count(1)])

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#681045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#681045)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#681046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#681046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#681047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#681047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#681048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#681048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#681049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#681049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#681050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#681050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#681051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#681051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#681052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#681052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#681053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#681053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#681054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#681054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#681055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#681055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#681056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#681056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#681057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#681057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#681058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#681058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#681059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#681059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#681060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#681060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#681061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#681061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#681062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#681062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#681063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#681063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#681064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#681064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#681065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#681065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#681066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#681066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#681067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#681067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#681068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#681068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#681069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#681069)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#681070)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#681070)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#681071)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#681071)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#681072)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#681072)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#681073)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#681073)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#681074)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#681074)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#681075)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#681075)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#681076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#681076)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#681077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#681077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#681078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#681078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#681079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#681079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#681080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#681080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#681081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#681081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#681082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#681082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#681083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#681083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#681084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#681084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#681085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#681085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#681086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#681086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#681087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#681087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#681088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#681088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#681089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#681089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#681090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#681090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#681091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#681091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#681092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#681092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#681093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#681093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#681094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#681094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#681095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#681095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#681096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#681096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#681097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#681097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#681098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#681098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#681099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#681099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#681100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#681100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#681101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#681101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#681102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#681102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#681103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#681103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#681104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#681104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#681105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#681105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#681106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#681106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#681107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#681107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#681108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#681108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#681109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#681109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#681110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#681110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#681111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#681111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#681112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#681112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#681113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#681113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#681114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#681114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#681115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#681115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#681116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#681116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#681117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#681117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#681118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#681118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#681119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#681119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#681120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#681120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#681121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#681121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#681122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#681122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#681123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#681123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#681124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#681124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore"."h_ccamdet") as x) [numPartitions=1] [zd_numcot#681045,zd_numdem#681046,zd_numdos#681047,zd_numpco#681048,zd_primai#681049,zd_annval#681050,zd_monnaie#681051,zd_cod_acte#681052,zd_ver_ccam#681053,zd_codsit#681054,zd_coduti#681055,zd_datmaj#681056,zd_cod_aa#681057,zd_modificateur#681058,zd_codper#681059,zd_codser#681060,zd_numsal#681061,zd_flassprev#681062,zd_assnonprev#681063,zd_numord#681064,zd_priuni#681065,zd_coefmino#681066,zd_mino#681067,zd_majo#681068,... 56 more fields] PushedFilters: [], ReadSchema: struct<zd_numcot:string,zd_numdem:string,zd_numdos:string,zd_numpco:string,zd_primai:string,zd_an...

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#681769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#681769)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#681770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#681770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#681771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#681771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#681772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#681772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#681773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#681773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#681774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#681774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#681775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#681775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#681776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#681776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#681777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#681777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#681778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#681778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#681779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#681779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#681780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#681780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#681781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#681781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#681782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#681782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#681783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#681783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#681784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#681784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#681785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#681785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#681786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#681786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#681787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#681787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#681788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#681788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#681789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#681789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#681790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#681790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#681791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#681791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#681792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#681792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#681793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#681793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#681794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#681794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#681795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#681795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#681796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#681796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#681797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#681797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#681798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#681798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#681799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#681799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#681800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#681800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#681801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#681801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#681802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#681802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#681803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#681803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#681804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#681804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#681805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#681805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#681806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#681806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#681807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#681807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#681808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#681808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#681809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#681809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#681810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#681810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#681811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#681811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#681812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#681812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#681813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#681813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#681814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#681814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#681815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#681815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#681816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#681816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#681817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#681817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#681818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#681818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#681819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#681819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#681820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#681820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#681821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#681821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#681822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#681822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#681823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#681823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#681824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#681824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#681825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#681825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#681826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#681826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#681827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#681827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#681828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#681828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#681829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#681829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#681830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#681830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#681831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#681831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#681832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#681832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#681833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#681833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#681834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#681834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#681835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#681835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#681836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#681836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#681837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#681837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#681838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#681838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#681839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#681839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#681840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#681840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#681841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#681841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#681842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#681842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#681843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#681843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#681844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#681844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#681845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#681845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#681846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#681846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#681847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#681847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#681848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#681848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x) [numPartitions=1] [zd_numcot#681769,zd_numdem#681770,zd_numdos#681771,zd_numpco#681772,zd_primai#681773,zd_annval#681774,zd_monnaie#681775,zd_cod_acte#681776,zd_ver_ccam#681777,zd_codsit#681778,zd_coduti#681779,zd_datmaj#681780,zd_cod_aa#681781,zd_modificateur#681782,zd_codper#681783,zd_codser#681784,zd_numsal#681785,zd_flassprev#681786,zd_assnonprev#681787,zd_numord#681788,zd_priuni#681789,zd_coefmino#681790,zd_mino#681791,zd_majo#681792,... 56 more fields] PushedFilters: [], ReadSchema: struct<zd_numcot:string,zd_numdem:string,zd_numdos:string,zd_numpco:string,zd_primai:string,zd_an...

WholeStageCodegen (2)

Details

== Physical Plan ==
AdaptiveSparkPlan (16)
+- == Final Plan ==
   * HashAggregate (11)
   +- ShuffleQueryStage (10), Statistics(sizeInBytes=32.0 B, rowCount=2)
      +- Exchange (9)
         +- * HashAggregate (8)
            +- Union (7)
               :- * Project (3)
               :  +- * Filter (2)
               :     +- * Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore"."h_ccamdet") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore"."h_ccamdet") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore"."h_ccamdet") as x) [numPartitions=1]  [codegen id : 1]
Output [80]: [zd_numcot#681045, zd_numdem#681046, zd_numdos#681047, zd_numpco#681048, zd_primai#681049, zd_annval#681050, zd_monnaie#681051, zd_cod_acte#681052, zd_ver_ccam#681053, zd_codsit#681054, zd_coduti#681055, zd_datmaj#681056, zd_cod_aa#681057, zd_modificateur#681058, zd_codper#681059, zd_codser#681060, zd_numsal#681061, zd_flassprev#681062, zd_assnonprev#681063, zd_numord#681064, zd_priuni#681065, zd_coefmino#681066, zd_mino#681067, zd_majo#681068, zd_basrmb#681069, zd_factur#681070, zd_typexo#681071, zd_taucai#681072, zd_parcai#681073, zd_taumut#681074, zd_parmut#681075, zd_ligrgr#681076, zd_regrou_cod#681077, zd_cod_aap#681078, zd_qualdp#681079, zd_flrmbexc#681080, zd_flsuppcharge#681081, zd_donncompl#681082, zd_dents#681083, zd_depmnt#681084, zd_flid#681085, zd_mttid#681086, zd_tauid#681087, zd_amoid#681088, zd_tauid_amc#681089, zd_amcid#681090, zd_nbrik#681091, zd_mttik#681092, zd_tauik#681093, zd_amoik#681094, zd_nbrikm#681095, zd_mttikm#681096, zd_tauikm#681097, zd_amoikm#681098, zd_nbriks#681099, zd_mttiks#681100, zd_tauiks#681101, zd_amoiks#681102, zd_forc#681103, zd_formamc#681104, zd_codtit#681105, zd_flald#681106, zd_a_fact#681107, zd_x_exo_tm#681108, zd_modiffact#681109, zd_assnonprev_c#681110, zd_qualdp_c#681111, zd_coduam#681112, zd_mtdep#681113, zd_mtpenhps#681114, zd_flpav#681115, zd_mttori#681116, zd_acr#681117, zd_codapp#681118, zd_codper2#681119, zd_codind#681120, zd_codres#681121, zd_codextdoc#681122, zd_numexa#681123, zd_codextpmsi#681124]
ReadSchema: struct<zd_numcot:string,zd_numdem:string,zd_numdos:string,zd_numpco:string,zd_primai:string,zd_annval:string,zd_monnaie:string,zd_cod_acte:string,zd_ver_ccam:string,zd_codsit:string,zd_coduti:string,zd_datmaj:string,zd_cod_aa:string,zd_modificateur:string,zd_codper:string,zd_codser:string,zd_numsal:string,zd_flassprev:string,zd_assnonprev:string,zd_numord:string,zd_priuni:string,zd_coefmino:string,zd_mino:string,zd_majo:string,zd_basrmb:string,zd_factur:string,zd_typexo:string,zd_taucai:string,zd_parcai:string,zd_taumut:string,zd_parmut:string,zd_ligrgr:string,zd_regrou_cod:string,zd_cod_aap:string,zd_qualdp:string,zd_flrmbexc:string,zd_flsuppcharge:string,zd_donncompl:string,zd_dents:string,zd_depmnt:string,zd_flid:string,zd_mttid:string,zd_tauid:string,zd_amoid:string,zd_tauid_amc:string,zd_amcid:string,zd_nbrik:string,zd_mttik:string,zd_tauik:string,zd_amoik:string,zd_nbrikm:string,zd_mttikm:string,zd_tauikm:string,zd_amoikm:string,zd_nbriks:string,zd_mttiks:string,zd_tauiks:string,zd_amoiks:string,zd_forc:string,zd_formamc:string,zd_codtit:string,zd_flald:string,zd_a_fact:string,zd_x_exo_tm:string,zd_modiffact:string,zd_assnonprev_c:string,zd_qualdp_c:string,zd_coduam:string,zd_mtdep:string,zd_mtpenhps:string,zd_flpav:string,zd_mttori:string,zd_acr:string,zd_codapp:string,zd_codper2:string,zd_codind:string,zd_codres:string,zd_codextdoc:string,zd_numexa:string,zd_codextpmsi:string>

(2) Filter [codegen id : 1]
Input [80]: [zd_numcot#681045, zd_numdem#681046, zd_numdos#681047, zd_numpco#681048, zd_primai#681049, zd_annval#681050, zd_monnaie#681051, zd_cod_acte#681052, zd_ver_ccam#681053, zd_codsit#681054, zd_coduti#681055, zd_datmaj#681056, zd_cod_aa#681057, zd_modificateur#681058, zd_codper#681059, zd_codser#681060, zd_numsal#681061, zd_flassprev#681062, zd_assnonprev#681063, zd_numord#681064, zd_priuni#681065, zd_coefmino#681066, zd_mino#681067, zd_majo#681068, zd_basrmb#681069, zd_factur#681070, zd_typexo#681071, zd_taucai#681072, zd_parcai#681073, zd_taumut#681074, zd_parmut#681075, zd_ligrgr#681076, zd_regrou_cod#681077, zd_cod_aap#681078, zd_qualdp#681079, zd_flrmbexc#681080, zd_flsuppcharge#681081, zd_donncompl#681082, zd_dents#681083, zd_depmnt#681084, zd_flid#681085, zd_mttid#681086, zd_tauid#681087, zd_amoid#681088, zd_tauid_amc#681089, zd_amcid#681090, zd_nbrik#681091, zd_mttik#681092, zd_tauik#681093, zd_amoik#681094, zd_nbrikm#681095, zd_mttikm#681096, zd_tauikm#681097, zd_amoikm#681098, zd_nbriks#681099, zd_mttiks#681100, zd_tauiks#681101, zd_amoiks#681102, zd_forc#681103, zd_formamc#681104, zd_codtit#681105, zd_flald#681106, zd_a_fact#681107, zd_x_exo_tm#681108, zd_modiffact#681109, zd_assnonprev_c#681110, zd_qualdp_c#681111, zd_coduam#681112, zd_mtdep#681113, zd_mtpenhps#681114, zd_flpav#681115, zd_mttori#681116, zd_acr#681117, zd_codapp#681118, zd_codper2#681119, zd_codind#681120, zd_codres#681121, zd_codextdoc#681122, zd_numexa#681123, zd_codextpmsi#681124]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#681045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#681045)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#681046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#681046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#681047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#681047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#681048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#681048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#681049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#681049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#681050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#681050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#681051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#681051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#681052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#681052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#681053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#681053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#681054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#681054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#681055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#681055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#681056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#681056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#681057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#681057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#681058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#681058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#681059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#681059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#681060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#681060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#681061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#681061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#681062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#681062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#681063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#681063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#681064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#681064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#681065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#681065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#681066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#681066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#681067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#681067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#681068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#681068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#681069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#681069)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#681070)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#681070)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#681071)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#681071)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#681072)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#681072)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#681073)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#681073)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#681074)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#681074)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#681075)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#681075)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#681076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#681076)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#681077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#681077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#681078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#681078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#681079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#681079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#681080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#681080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#681081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#681081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#681082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#681082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#681083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#681083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#681084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#681084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#681085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#681085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#681086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#681086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#681087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#681087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#681088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#681088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#681089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#681089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#681090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#681090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#681091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#681091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#681092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#681092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#681093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#681093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#681094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#681094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#681095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#681095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#681096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#681096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#681097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#681097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#681098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#681098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#681099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#681099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#681100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#681100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#681101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#681101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#681102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#681102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#681103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#681103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#681104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#681104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#681105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#681105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#681106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#681106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#681107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#681107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#681108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#681108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#681109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#681109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#681110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#681110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#681111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#681111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#681112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#681112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#681113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#681113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#681114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#681114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#681115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#681115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#681116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#681116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#681117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#681117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#681118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#681118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#681119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#681119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#681120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#681120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#681121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#681121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#681122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#681122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#681123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#681123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#681124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#681124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project [codegen id : 1]
Output: []
Input [80]: [zd_numcot#681045, zd_numdem#681046, zd_numdos#681047, zd_numpco#681048, zd_primai#681049, zd_annval#681050, zd_monnaie#681051, zd_cod_acte#681052, zd_ver_ccam#681053, zd_codsit#681054, zd_coduti#681055, zd_datmaj#681056, zd_cod_aa#681057, zd_modificateur#681058, zd_codper#681059, zd_codser#681060, zd_numsal#681061, zd_flassprev#681062, zd_assnonprev#681063, zd_numord#681064, zd_priuni#681065, zd_coefmino#681066, zd_mino#681067, zd_majo#681068, zd_basrmb#681069, zd_factur#681070, zd_typexo#681071, zd_taucai#681072, zd_parcai#681073, zd_taumut#681074, zd_parmut#681075, zd_ligrgr#681076, zd_regrou_cod#681077, zd_cod_aap#681078, zd_qualdp#681079, zd_flrmbexc#681080, zd_flsuppcharge#681081, zd_donncompl#681082, zd_dents#681083, zd_depmnt#681084, zd_flid#681085, zd_mttid#681086, zd_tauid#681087, zd_amoid#681088, zd_tauid_amc#681089, zd_amcid#681090, zd_nbrik#681091, zd_mttik#681092, zd_tauik#681093, zd_amoik#681094, zd_nbrikm#681095, zd_mttikm#681096, zd_tauikm#681097, zd_amoikm#681098, zd_nbriks#681099, zd_mttiks#681100, zd_tauiks#681101, zd_amoiks#681102, zd_forc#681103, zd_formamc#681104, zd_codtit#681105, zd_flald#681106, zd_a_fact#681107, zd_x_exo_tm#681108, zd_modiffact#681109, zd_assnonprev_c#681110, zd_qualdp_c#681111, zd_coduam#681112, zd_mtdep#681113, zd_mtpenhps#681114, zd_flpav#681115, zd_mttori#681116, zd_acr#681117, zd_codapp#681118, zd_codper2#681119, zd_codind#681120, zd_codres#681121, zd_codextdoc#681122, zd_numexa#681123, zd_codextpmsi#681124]

(4) Scan JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x) [numPartitions=1]  [codegen id : 2]
Output [80]: [zd_numcot#681769, zd_numdem#681770, zd_numdos#681771, zd_numpco#681772, zd_primai#681773, zd_annval#681774, zd_monnaie#681775, zd_cod_acte#681776, zd_ver_ccam#681777, zd_codsit#681778, zd_coduti#681779, zd_datmaj#681780, zd_cod_aa#681781, zd_modificateur#681782, zd_codper#681783, zd_codser#681784, zd_numsal#681785, zd_flassprev#681786, zd_assnonprev#681787, zd_numord#681788, zd_priuni#681789, zd_coefmino#681790, zd_mino#681791, zd_majo#681792, zd_basrmb#681793, zd_factur#681794, zd_typexo#681795, zd_taucai#681796, zd_parcai#681797, zd_taumut#681798, zd_parmut#681799, zd_ligrgr#681800, zd_regrou_cod#681801, zd_cod_aap#681802, zd_qualdp#681803, zd_flrmbexc#681804, zd_flsuppcharge#681805, zd_donncompl#681806, zd_dents#681807, zd_depmnt#681808, zd_flid#681809, zd_mttid#681810, zd_tauid#681811, zd_amoid#681812, zd_tauid_amc#681813, zd_amcid#681814, zd_nbrik#681815, zd_mttik#681816, zd_tauik#681817, zd_amoik#681818, zd_nbrikm#681819, zd_mttikm#681820, zd_tauikm#681821, zd_amoikm#681822, zd_nbriks#681823, zd_mttiks#681824, zd_tauiks#681825, zd_amoiks#681826, zd_forc#681827, zd_formamc#681828, zd_codtit#681829, zd_flald#681830, zd_a_fact#681831, zd_x_exo_tm#681832, zd_modiffact#681833, zd_assnonprev_c#681834, zd_qualdp_c#681835, zd_coduam#681836, zd_mtdep#681837, zd_mtpenhps#681838, zd_flpav#681839, zd_mttori#681840, zd_acr#681841, zd_codapp#681842, zd_codper2#681843, zd_codind#681844, zd_codres#681845, zd_codextdoc#681846, zd_numexa#681847, zd_codextpmsi#681848]
ReadSchema: struct<zd_numcot:string,zd_numdem:string,zd_numdos:string,zd_numpco:string,zd_primai:string,zd_annval:string,zd_monnaie:string,zd_cod_acte:string,zd_ver_ccam:string,zd_codsit:string,zd_coduti:string,zd_datmaj:string,zd_cod_aa:string,zd_modificateur:string,zd_codper:string,zd_codser:string,zd_numsal:string,zd_flassprev:string,zd_assnonprev:string,zd_numord:string,zd_priuni:string,zd_coefmino:string,zd_mino:string,zd_majo:string,zd_basrmb:string,zd_factur:string,zd_typexo:string,zd_taucai:string,zd_parcai:string,zd_taumut:string,zd_parmut:string,zd_ligrgr:string,zd_regrou_cod:string,zd_cod_aap:string,zd_qualdp:string,zd_flrmbexc:string,zd_flsuppcharge:string,zd_donncompl:string,zd_dents:string,zd_depmnt:string,zd_flid:string,zd_mttid:string,zd_tauid:string,zd_amoid:string,zd_tauid_amc:string,zd_amcid:string,zd_nbrik:string,zd_mttik:string,zd_tauik:string,zd_amoik:string,zd_nbrikm:string,zd_mttikm:string,zd_tauikm:string,zd_amoikm:string,zd_nbriks:string,zd_mttiks:string,zd_tauiks:string,zd_amoiks:string,zd_forc:string,zd_formamc:string,zd_codtit:string,zd_flald:string,zd_a_fact:string,zd_x_exo_tm:string,zd_modiffact:string,zd_assnonprev_c:string,zd_qualdp_c:string,zd_coduam:string,zd_mtdep:string,zd_mtpenhps:string,zd_flpav:string,zd_mttori:string,zd_acr:string,zd_codapp:string,zd_codper2:string,zd_codind:string,zd_codres:string,zd_codextdoc:string,zd_numexa:string,zd_codextpmsi:string>

(5) Filter [codegen id : 2]
Input [80]: [zd_numcot#681769, zd_numdem#681770, zd_numdos#681771, zd_numpco#681772, zd_primai#681773, zd_annval#681774, zd_monnaie#681775, zd_cod_acte#681776, zd_ver_ccam#681777, zd_codsit#681778, zd_coduti#681779, zd_datmaj#681780, zd_cod_aa#681781, zd_modificateur#681782, zd_codper#681783, zd_codser#681784, zd_numsal#681785, zd_flassprev#681786, zd_assnonprev#681787, zd_numord#681788, zd_priuni#681789, zd_coefmino#681790, zd_mino#681791, zd_majo#681792, zd_basrmb#681793, zd_factur#681794, zd_typexo#681795, zd_taucai#681796, zd_parcai#681797, zd_taumut#681798, zd_parmut#681799, zd_ligrgr#681800, zd_regrou_cod#681801, zd_cod_aap#681802, zd_qualdp#681803, zd_flrmbexc#681804, zd_flsuppcharge#681805, zd_donncompl#681806, zd_dents#681807, zd_depmnt#681808, zd_flid#681809, zd_mttid#681810, zd_tauid#681811, zd_amoid#681812, zd_tauid_amc#681813, zd_amcid#681814, zd_nbrik#681815, zd_mttik#681816, zd_tauik#681817, zd_amoik#681818, zd_nbrikm#681819, zd_mttikm#681820, zd_tauikm#681821, zd_amoikm#681822, zd_nbriks#681823, zd_mttiks#681824, zd_tauiks#681825, zd_amoiks#681826, zd_forc#681827, zd_formamc#681828, zd_codtit#681829, zd_flald#681830, zd_a_fact#681831, zd_x_exo_tm#681832, zd_modiffact#681833, zd_assnonprev_c#681834, zd_qualdp_c#681835, zd_coduam#681836, zd_mtdep#681837, zd_mtpenhps#681838, zd_flpav#681839, zd_mttori#681840, zd_acr#681841, zd_codapp#681842, zd_codper2#681843, zd_codind#681844, zd_codres#681845, zd_codextdoc#681846, zd_numexa#681847, zd_codextpmsi#681848]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#681769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#681769)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#681770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#681770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#681771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#681771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#681772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#681772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#681773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#681773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#681774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#681774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#681775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#681775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#681776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#681776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#681777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#681777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#681778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#681778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#681779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#681779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#681780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#681780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#681781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#681781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#681782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#681782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#681783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#681783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#681784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#681784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#681785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#681785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#681786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#681786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#681787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#681787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#681788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#681788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#681789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#681789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#681790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#681790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#681791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#681791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#681792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#681792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#681793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#681793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#681794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#681794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#681795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#681795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#681796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#681796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#681797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#681797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#681798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#681798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#681799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#681799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#681800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#681800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#681801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#681801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#681802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#681802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#681803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#681803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#681804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#681804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#681805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#681805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#681806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#681806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#681807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#681807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#681808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#681808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#681809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#681809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#681810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#681810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#681811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#681811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#681812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#681812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#681813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#681813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#681814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#681814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#681815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#681815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#681816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#681816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#681817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#681817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#681818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#681818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#681819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#681819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#681820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#681820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#681821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#681821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#681822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#681822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#681823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#681823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#681824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#681824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#681825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#681825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#681826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#681826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#681827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#681827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#681828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#681828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#681829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#681829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#681830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#681830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#681831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#681831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#681832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#681832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#681833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#681833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#681834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#681834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#681835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#681835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#681836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#681836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#681837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#681837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#681838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#681838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#681839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#681839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#681840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#681840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#681841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#681841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#681842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#681842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#681843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#681843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#681844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#681844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#681845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#681845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#681846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#681846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#681847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#681847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#681848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#681848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(6) Project [codegen id : 2]
Output: []
Input [80]: [zd_numcot#681769, zd_numdem#681770, zd_numdos#681771, zd_numpco#681772, zd_primai#681773, zd_annval#681774, zd_monnaie#681775, zd_cod_acte#681776, zd_ver_ccam#681777, zd_codsit#681778, zd_coduti#681779, zd_datmaj#681780, zd_cod_aa#681781, zd_modificateur#681782, zd_codper#681783, zd_codser#681784, zd_numsal#681785, zd_flassprev#681786, zd_assnonprev#681787, zd_numord#681788, zd_priuni#681789, zd_coefmino#681790, zd_mino#681791, zd_majo#681792, zd_basrmb#681793, zd_factur#681794, zd_typexo#681795, zd_taucai#681796, zd_parcai#681797, zd_taumut#681798, zd_parmut#681799, zd_ligrgr#681800, zd_regrou_cod#681801, zd_cod_aap#681802, zd_qualdp#681803, zd_flrmbexc#681804, zd_flsuppcharge#681805, zd_donncompl#681806, zd_dents#681807, zd_depmnt#681808, zd_flid#681809, zd_mttid#681810, zd_tauid#681811, zd_amoid#681812, zd_tauid_amc#681813, zd_amcid#681814, zd_nbrik#681815, zd_mttik#681816, zd_tauik#681817, zd_amoik#681818, zd_nbrikm#681819, zd_mttikm#681820, zd_tauikm#681821, zd_amoikm#681822, zd_nbriks#681823, zd_mttiks#681824, zd_tauiks#681825, zd_amoiks#681826, zd_forc#681827, zd_formamc#681828, zd_codtit#681829, zd_flald#681830, zd_a_fact#681831, zd_x_exo_tm#681832, zd_modiffact#681833, zd_assnonprev_c#681834, zd_qualdp_c#681835, zd_coduam#681836, zd_mtdep#681837, zd_mtpenhps#681838, zd_flpav#681839, zd_mttori#681840, zd_acr#681841, zd_codapp#681842, zd_codper2#681843, zd_codind#681844, zd_codres#681845, zd_codextdoc#681846, zd_numexa#681847, zd_codextpmsi#681848]

(7) Union

(8) HashAggregate [codegen id : 3]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#683309L]
Results [1]: [count#683310L]

(9) Exchange
Input [1]: [count#683310L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=36971]

(10) ShuffleQueryStage
Output [1]: [count#683310L]
Arguments: 0

(11) HashAggregate [codegen id : 4]
Input [1]: [count#683310L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#683140L]
Results [1]: [count(1)#683140L AS COL_336d45f6-c4a1-4a8f-9c64-8fb22eda6ae8#683142L]

(12) Union

(13) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#683309L]
Results [1]: [count#683310L]

(14) Exchange
Input [1]: [count#683310L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=36951]

(15) HashAggregate
Input [1]: [count#683310L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#683140L]
Results [1]: [count(1)#683140L AS COL_336d45f6-c4a1-4a8f-9c64-8fb22eda6ae8#683142L]

(16) AdaptiveSparkPlan
Output [1]: [COL_336d45f6-c4a1-4a8f-9c64-8fb22eda6ae8#683142L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet