hdh-spark-job - Details for Query 1318

Submitted Time: 2026/10/23 13:26:33
Duration: 14 s
Succeeded Jobs: 1316 1321

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 1895.0: task 1652)) 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 1895.0: task 1652)) 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 1895.0: task 1652))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n3.3 s (1.6 s, 1.7 s, 1.7 s (stage 1895.0: task 1653))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 3.3 s (1.6 s, 1.7 s, 1.7 s (stage 1895.0: task 1653)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 1.6 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: 1.7 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=35102]

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#640103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#640103)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#640104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#640104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#640105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#640105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#640106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#640106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#640107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#640107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#640108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#640108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#640109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#640109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#640110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#640110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#640111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#640111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#640112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#640112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#640113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#640113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#640114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#640114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#640115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#640115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#640116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#640116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#640117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#640117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#640118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#640118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#640119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#640119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#640120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#640120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#640121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#640121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#640122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#640122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#640123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#640123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#640124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#640124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#640125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#640125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#640126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#640126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#640127)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#640127)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#640128)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#640128)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#640129)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#640129)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#640130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#640130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#640131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#640131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#640132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#640132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#640133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#640133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#640134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#640134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#640135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#640135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#640136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#640136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#640137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#640137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#640138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#640138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#640139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#640139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#640140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#640140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#640141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#640141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#640142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#640142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#640143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#640143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#640144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#640144)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#640145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#640145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#640146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#640146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#640147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#640147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#640148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#640148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#640149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#640149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#640150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#640150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#640151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#640151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#640152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#640152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#640153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#640153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#640154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#640154)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#640155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#640155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#640156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#640156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#640157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#640157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#640158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#640158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#640159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#640159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#640160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#640160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#640161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#640161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#640162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#640162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#640163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#640163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#640164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#640164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#640165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#640165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#640166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#640166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#640167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#640167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#640168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#640168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#640169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#640169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#640170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#640170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#640171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#640171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#640172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#640172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#640173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#640173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#640174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#640174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#640175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#640175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#640176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#640176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#640177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#640177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#640178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#640178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#640179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#640179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#640180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#640180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#640181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#640181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#640182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#640182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) 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#640103,zd_numdem#640104,zd_numdos#640105,zd_numpco#640106,zd_primai#640107,zd_annval#640108,zd_monnaie#640109,zd_cod_acte#640110,zd_ver_ccam#640111,zd_codsit#640112,zd_coduti#640113,zd_datmaj#640114,zd_cod_aa#640115,zd_modificateur#640116,zd_codper#640117,zd_codser#640118,zd_numsal#640119,zd_flassprev#640120,zd_assnonprev#640121,zd_numord#640122,zd_priuni#640123,zd_coefmino#640124,zd_mino#640125,zd_majo#640126,... 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#641757)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#641757)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#641758)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#641758)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#641759)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#641759)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#641760)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#641760)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#641761)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#641761)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#641762)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#641762)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#641763)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#641763)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#641764)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#641764)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#641765)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#641765)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#641766)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#641766)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#641767)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#641767)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#641768)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#641768)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#641769)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#641769)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#641770)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#641770)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#641771)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#641771)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#641772)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#641772)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#641773)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#641773)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#641774)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#641774)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#641775)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#641775)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#641776)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#641776)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#641777)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#641777)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#641778)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#641778)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#641779)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#641779)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#641780)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#641780)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#641781)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#641781)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#641782)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#641782)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#641783)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#641783)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#641784)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#641784)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#641785)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#641785)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#641786)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#641786)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#641787)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#641787)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#641788)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#641788)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#641789)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#641789)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#641790)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#641790)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#641791)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#641791)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#641792)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#641792)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#641793)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#641793)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#641794)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#641794)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#641795)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#641795)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#641796)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#641796)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#641797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#641797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#641798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#641798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#641799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#641799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#641800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#641800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#641801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#641801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#641802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#641802)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#641803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#641803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#641804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#641804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#641805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#641805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#641806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#641806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#641807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#641807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#641808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#641808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#641809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#641809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#641810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#641810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#641811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#641811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#641812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#641812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#641813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#641813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#641814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#641814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#641815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#641815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#641816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#641816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#641817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#641817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#641818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#641818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#641819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#641819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#641820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#641820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#641821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#641821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#641822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#641822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#641823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#641823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#641824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#641824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#641825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#641825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#641826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#641826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#641827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#641827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#641828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#641828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#641829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#641829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#641830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#641830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#641831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#641831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#641832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#641832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#641833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#641833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#641834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#641834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#641835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#641835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#641836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#641836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) 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#641757,zd_numdem#641758,zd_numdos#641759,zd_numpco#641760,zd_primai#641761,zd_annval#641762,zd_monnaie#641763,zd_cod_acte#641764,zd_ver_ccam#641765,zd_codsit#641766,zd_coduti#641767,zd_datmaj#641768,zd_cod_aa#641769,zd_modificateur#641770,zd_codper#641771,zd_codser#641772,zd_numsal#641773,zd_flassprev#641774,zd_assnonprev#641775,zd_numord#641776,zd_priuni#641777,zd_coefmino#641778,zd_mino#641779,zd_majo#641780,... 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#640103, zd_numdem#640104, zd_numdos#640105, zd_numpco#640106, zd_primai#640107, zd_annval#640108, zd_monnaie#640109, zd_cod_acte#640110, zd_ver_ccam#640111, zd_codsit#640112, zd_coduti#640113, zd_datmaj#640114, zd_cod_aa#640115, zd_modificateur#640116, zd_codper#640117, zd_codser#640118, zd_numsal#640119, zd_flassprev#640120, zd_assnonprev#640121, zd_numord#640122, zd_priuni#640123, zd_coefmino#640124, zd_mino#640125, zd_majo#640126, zd_basrmb#640127, zd_factur#640128, zd_typexo#640129, zd_taucai#640130, zd_parcai#640131, zd_taumut#640132, zd_parmut#640133, zd_ligrgr#640134, zd_regrou_cod#640135, zd_cod_aap#640136, zd_qualdp#640137, zd_flrmbexc#640138, zd_flsuppcharge#640139, zd_donncompl#640140, zd_dents#640141, zd_depmnt#640142, zd_flid#640143, zd_mttid#640144, zd_tauid#640145, zd_amoid#640146, zd_tauid_amc#640147, zd_amcid#640148, zd_nbrik#640149, zd_mttik#640150, zd_tauik#640151, zd_amoik#640152, zd_nbrikm#640153, zd_mttikm#640154, zd_tauikm#640155, zd_amoikm#640156, zd_nbriks#640157, zd_mttiks#640158, zd_tauiks#640159, zd_amoiks#640160, zd_forc#640161, zd_formamc#640162, zd_codtit#640163, zd_flald#640164, zd_a_fact#640165, zd_x_exo_tm#640166, zd_modiffact#640167, zd_assnonprev_c#640168, zd_qualdp_c#640169, zd_coduam#640170, zd_mtdep#640171, zd_mtpenhps#640172, zd_flpav#640173, zd_mttori#640174, zd_acr#640175, zd_codapp#640176, zd_codper2#640177, zd_codind#640178, zd_codres#640179, zd_codextdoc#640180, zd_numexa#640181, zd_codextpmsi#640182]
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#640103, zd_numdem#640104, zd_numdos#640105, zd_numpco#640106, zd_primai#640107, zd_annval#640108, zd_monnaie#640109, zd_cod_acte#640110, zd_ver_ccam#640111, zd_codsit#640112, zd_coduti#640113, zd_datmaj#640114, zd_cod_aa#640115, zd_modificateur#640116, zd_codper#640117, zd_codser#640118, zd_numsal#640119, zd_flassprev#640120, zd_assnonprev#640121, zd_numord#640122, zd_priuni#640123, zd_coefmino#640124, zd_mino#640125, zd_majo#640126, zd_basrmb#640127, zd_factur#640128, zd_typexo#640129, zd_taucai#640130, zd_parcai#640131, zd_taumut#640132, zd_parmut#640133, zd_ligrgr#640134, zd_regrou_cod#640135, zd_cod_aap#640136, zd_qualdp#640137, zd_flrmbexc#640138, zd_flsuppcharge#640139, zd_donncompl#640140, zd_dents#640141, zd_depmnt#640142, zd_flid#640143, zd_mttid#640144, zd_tauid#640145, zd_amoid#640146, zd_tauid_amc#640147, zd_amcid#640148, zd_nbrik#640149, zd_mttik#640150, zd_tauik#640151, zd_amoik#640152, zd_nbrikm#640153, zd_mttikm#640154, zd_tauikm#640155, zd_amoikm#640156, zd_nbriks#640157, zd_mttiks#640158, zd_tauiks#640159, zd_amoiks#640160, zd_forc#640161, zd_formamc#640162, zd_codtit#640163, zd_flald#640164, zd_a_fact#640165, zd_x_exo_tm#640166, zd_modiffact#640167, zd_assnonprev_c#640168, zd_qualdp_c#640169, zd_coduam#640170, zd_mtdep#640171, zd_mtpenhps#640172, zd_flpav#640173, zd_mttori#640174, zd_acr#640175, zd_codapp#640176, zd_codper2#640177, zd_codind#640178, zd_codres#640179, zd_codextdoc#640180, zd_numexa#640181, zd_codextpmsi#640182]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#640103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#640103)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#640104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#640104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#640105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#640105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#640106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#640106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#640107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#640107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#640108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#640108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#640109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#640109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#640110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#640110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#640111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#640111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#640112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#640112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#640113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#640113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#640114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#640114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#640115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#640115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#640116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#640116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#640117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#640117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#640118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#640118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#640119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#640119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#640120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#640120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#640121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#640121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#640122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#640122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#640123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#640123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#640124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#640124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#640125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#640125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#640126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#640126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#640127)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#640127)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#640128)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#640128)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#640129)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#640129)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#640130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#640130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#640131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#640131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#640132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#640132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#640133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#640133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#640134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#640134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#640135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#640135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#640136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#640136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#640137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#640137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#640138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#640138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#640139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#640139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#640140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#640140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#640141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#640141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#640142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#640142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#640143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#640143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#640144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#640144)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#640145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#640145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#640146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#640146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#640147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#640147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#640148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#640148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#640149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#640149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#640150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#640150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#640151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#640151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#640152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#640152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#640153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#640153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#640154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#640154)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#640155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#640155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#640156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#640156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#640157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#640157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#640158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#640158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#640159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#640159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#640160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#640160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#640161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#640161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#640162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#640162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#640163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#640163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#640164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#640164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#640165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#640165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#640166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#640166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#640167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#640167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#640168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#640168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#640169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#640169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#640170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#640170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#640171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#640171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#640172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#640172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#640173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#640173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#640174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#640174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#640175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#640175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#640176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#640176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#640177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#640177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#640178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#640178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#640179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#640179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#640180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#640180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#640181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#640181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#640182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#640182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project [codegen id : 1]
Output: []
Input [80]: [zd_numcot#640103, zd_numdem#640104, zd_numdos#640105, zd_numpco#640106, zd_primai#640107, zd_annval#640108, zd_monnaie#640109, zd_cod_acte#640110, zd_ver_ccam#640111, zd_codsit#640112, zd_coduti#640113, zd_datmaj#640114, zd_cod_aa#640115, zd_modificateur#640116, zd_codper#640117, zd_codser#640118, zd_numsal#640119, zd_flassprev#640120, zd_assnonprev#640121, zd_numord#640122, zd_priuni#640123, zd_coefmino#640124, zd_mino#640125, zd_majo#640126, zd_basrmb#640127, zd_factur#640128, zd_typexo#640129, zd_taucai#640130, zd_parcai#640131, zd_taumut#640132, zd_parmut#640133, zd_ligrgr#640134, zd_regrou_cod#640135, zd_cod_aap#640136, zd_qualdp#640137, zd_flrmbexc#640138, zd_flsuppcharge#640139, zd_donncompl#640140, zd_dents#640141, zd_depmnt#640142, zd_flid#640143, zd_mttid#640144, zd_tauid#640145, zd_amoid#640146, zd_tauid_amc#640147, zd_amcid#640148, zd_nbrik#640149, zd_mttik#640150, zd_tauik#640151, zd_amoik#640152, zd_nbrikm#640153, zd_mttikm#640154, zd_tauikm#640155, zd_amoikm#640156, zd_nbriks#640157, zd_mttiks#640158, zd_tauiks#640159, zd_amoiks#640160, zd_forc#640161, zd_formamc#640162, zd_codtit#640163, zd_flald#640164, zd_a_fact#640165, zd_x_exo_tm#640166, zd_modiffact#640167, zd_assnonprev_c#640168, zd_qualdp_c#640169, zd_coduam#640170, zd_mtdep#640171, zd_mtpenhps#640172, zd_flpav#640173, zd_mttori#640174, zd_acr#640175, zd_codapp#640176, zd_codper2#640177, zd_codind#640178, zd_codres#640179, zd_codextdoc#640180, zd_numexa#640181, zd_codextpmsi#640182]

(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#641757, zd_numdem#641758, zd_numdos#641759, zd_numpco#641760, zd_primai#641761, zd_annval#641762, zd_monnaie#641763, zd_cod_acte#641764, zd_ver_ccam#641765, zd_codsit#641766, zd_coduti#641767, zd_datmaj#641768, zd_cod_aa#641769, zd_modificateur#641770, zd_codper#641771, zd_codser#641772, zd_numsal#641773, zd_flassprev#641774, zd_assnonprev#641775, zd_numord#641776, zd_priuni#641777, zd_coefmino#641778, zd_mino#641779, zd_majo#641780, zd_basrmb#641781, zd_factur#641782, zd_typexo#641783, zd_taucai#641784, zd_parcai#641785, zd_taumut#641786, zd_parmut#641787, zd_ligrgr#641788, zd_regrou_cod#641789, zd_cod_aap#641790, zd_qualdp#641791, zd_flrmbexc#641792, zd_flsuppcharge#641793, zd_donncompl#641794, zd_dents#641795, zd_depmnt#641796, zd_flid#641797, zd_mttid#641798, zd_tauid#641799, zd_amoid#641800, zd_tauid_amc#641801, zd_amcid#641802, zd_nbrik#641803, zd_mttik#641804, zd_tauik#641805, zd_amoik#641806, zd_nbrikm#641807, zd_mttikm#641808, zd_tauikm#641809, zd_amoikm#641810, zd_nbriks#641811, zd_mttiks#641812, zd_tauiks#641813, zd_amoiks#641814, zd_forc#641815, zd_formamc#641816, zd_codtit#641817, zd_flald#641818, zd_a_fact#641819, zd_x_exo_tm#641820, zd_modiffact#641821, zd_assnonprev_c#641822, zd_qualdp_c#641823, zd_coduam#641824, zd_mtdep#641825, zd_mtpenhps#641826, zd_flpav#641827, zd_mttori#641828, zd_acr#641829, zd_codapp#641830, zd_codper2#641831, zd_codind#641832, zd_codres#641833, zd_codextdoc#641834, zd_numexa#641835, zd_codextpmsi#641836]
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#641757, zd_numdem#641758, zd_numdos#641759, zd_numpco#641760, zd_primai#641761, zd_annval#641762, zd_monnaie#641763, zd_cod_acte#641764, zd_ver_ccam#641765, zd_codsit#641766, zd_coduti#641767, zd_datmaj#641768, zd_cod_aa#641769, zd_modificateur#641770, zd_codper#641771, zd_codser#641772, zd_numsal#641773, zd_flassprev#641774, zd_assnonprev#641775, zd_numord#641776, zd_priuni#641777, zd_coefmino#641778, zd_mino#641779, zd_majo#641780, zd_basrmb#641781, zd_factur#641782, zd_typexo#641783, zd_taucai#641784, zd_parcai#641785, zd_taumut#641786, zd_parmut#641787, zd_ligrgr#641788, zd_regrou_cod#641789, zd_cod_aap#641790, zd_qualdp#641791, zd_flrmbexc#641792, zd_flsuppcharge#641793, zd_donncompl#641794, zd_dents#641795, zd_depmnt#641796, zd_flid#641797, zd_mttid#641798, zd_tauid#641799, zd_amoid#641800, zd_tauid_amc#641801, zd_amcid#641802, zd_nbrik#641803, zd_mttik#641804, zd_tauik#641805, zd_amoik#641806, zd_nbrikm#641807, zd_mttikm#641808, zd_tauikm#641809, zd_amoikm#641810, zd_nbriks#641811, zd_mttiks#641812, zd_tauiks#641813, zd_amoiks#641814, zd_forc#641815, zd_formamc#641816, zd_codtit#641817, zd_flald#641818, zd_a_fact#641819, zd_x_exo_tm#641820, zd_modiffact#641821, zd_assnonprev_c#641822, zd_qualdp_c#641823, zd_coduam#641824, zd_mtdep#641825, zd_mtpenhps#641826, zd_flpav#641827, zd_mttori#641828, zd_acr#641829, zd_codapp#641830, zd_codper2#641831, zd_codind#641832, zd_codres#641833, zd_codextdoc#641834, zd_numexa#641835, zd_codextpmsi#641836]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#641757)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#641757)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#641758)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#641758)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#641759)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#641759)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#641760)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#641760)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#641761)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#641761)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#641762)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#641762)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#641763)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#641763)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#641764)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#641764)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#641765)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#641765)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#641766)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#641766)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#641767)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#641767)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#641768)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#641768)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#641769)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#641769)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#641770)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#641770)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#641771)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#641771)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#641772)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#641772)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#641773)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#641773)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#641774)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#641774)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#641775)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#641775)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#641776)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#641776)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#641777)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#641777)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#641778)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#641778)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#641779)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#641779)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#641780)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#641780)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#641781)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#641781)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#641782)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#641782)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#641783)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#641783)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#641784)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#641784)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#641785)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#641785)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#641786)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#641786)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#641787)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#641787)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#641788)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#641788)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#641789)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#641789)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#641790)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#641790)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#641791)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#641791)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#641792)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#641792)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#641793)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#641793)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#641794)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#641794)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#641795)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#641795)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#641796)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#641796)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#641797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#641797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#641798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#641798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#641799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#641799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#641800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#641800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#641801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#641801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#641802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#641802)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#641803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#641803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#641804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#641804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#641805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#641805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#641806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#641806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#641807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#641807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#641808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#641808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#641809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#641809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#641810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#641810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#641811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#641811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#641812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#641812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#641813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#641813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#641814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#641814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#641815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#641815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#641816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#641816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#641817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#641817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#641818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#641818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#641819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#641819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#641820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#641820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#641821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#641821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#641822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#641822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#641823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#641823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#641824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#641824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#641825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#641825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#641826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#641826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#641827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#641827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#641828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#641828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#641829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#641829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#641830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#641830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#641831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#641831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#641832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#641832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#641833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#641833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#641834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#641834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#641835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#641835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#641836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#641836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(6) Project [codegen id : 2]
Output: []
Input [80]: [zd_numcot#641757, zd_numdem#641758, zd_numdos#641759, zd_numpco#641760, zd_primai#641761, zd_annval#641762, zd_monnaie#641763, zd_cod_acte#641764, zd_ver_ccam#641765, zd_codsit#641766, zd_coduti#641767, zd_datmaj#641768, zd_cod_aa#641769, zd_modificateur#641770, zd_codper#641771, zd_codser#641772, zd_numsal#641773, zd_flassprev#641774, zd_assnonprev#641775, zd_numord#641776, zd_priuni#641777, zd_coefmino#641778, zd_mino#641779, zd_majo#641780, zd_basrmb#641781, zd_factur#641782, zd_typexo#641783, zd_taucai#641784, zd_parcai#641785, zd_taumut#641786, zd_parmut#641787, zd_ligrgr#641788, zd_regrou_cod#641789, zd_cod_aap#641790, zd_qualdp#641791, zd_flrmbexc#641792, zd_flsuppcharge#641793, zd_donncompl#641794, zd_dents#641795, zd_depmnt#641796, zd_flid#641797, zd_mttid#641798, zd_tauid#641799, zd_amoid#641800, zd_tauid_amc#641801, zd_amcid#641802, zd_nbrik#641803, zd_mttik#641804, zd_tauik#641805, zd_amoik#641806, zd_nbrikm#641807, zd_mttikm#641808, zd_tauikm#641809, zd_amoikm#641810, zd_nbriks#641811, zd_mttiks#641812, zd_tauiks#641813, zd_amoiks#641814, zd_forc#641815, zd_formamc#641816, zd_codtit#641817, zd_flald#641818, zd_a_fact#641819, zd_x_exo_tm#641820, zd_modiffact#641821, zd_assnonprev_c#641822, zd_qualdp_c#641823, zd_coduam#641824, zd_mtdep#641825, zd_mtpenhps#641826, zd_flpav#641827, zd_mttori#641828, zd_acr#641829, zd_codapp#641830, zd_codper2#641831, zd_codind#641832, zd_codres#641833, zd_codextdoc#641834, zd_numexa#641835, zd_codextpmsi#641836]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#647863L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#645629L]
Results [1]: [count(1)#645629L AS COL_8459675e-fde4-440c-8458-e5573c46443c#645631L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#647863L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#645629L]
Results [1]: [count(1)#645629L AS COL_8459675e-fde4-440c-8458-e5573c46443c#645631L]

(16) AdaptiveSparkPlan
Output [1]: [COL_8459675e-fde4-440c-8458-e5573c46443c#645631L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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