hdh-spark-job - Details for Query 1431

Submitted Time: 2026/10/23 13:29:12
Duration: 17 s
Succeeded Jobs: 1428 1433

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

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#723199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#723199)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#723200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#723200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#723201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#723201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#723202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#723202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#723203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#723203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#723204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#723204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#723205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#723205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#723206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#723206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#723207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#723207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#723208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#723208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#723209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#723209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#723210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#723210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#723211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#723211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#723212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#723212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#723213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#723213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#723214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#723214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#723215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#723215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#723216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#723216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#723217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#723217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#723218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#723218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#723219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#723219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#723220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#723220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#723221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#723221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#723222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#723222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#723223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#723223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#723224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#723224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#723225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#723225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#723226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#723226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#723227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#723227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#723228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#723228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#723229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#723229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#723230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#723230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#723231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#723231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#723232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#723232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#723233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#723233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#723234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#723234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#723235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#723235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#723236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#723236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#723237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#723237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#723238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#723238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#723239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#723239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#723240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#723240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#723241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#723241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#723242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#723242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#723243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#723243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#723244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#723244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#723245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#723245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#723246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#723246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#723247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#723247)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#723248)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#723248)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#723249)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#723249)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#723250)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#723250)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#723251)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#723251)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#723252)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#723252)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#723253)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#723253)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#723254)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#723254)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#723255)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#723255)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#723256)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#723256)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#723257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#723257)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#723258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#723258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#723259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#723259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#723260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#723260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#723261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#723261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#723262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#723262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#723263)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#723263)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#723264)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#723264)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#723265)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#723265)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#723266)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#723266)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#723267)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#723267)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#723268)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#723268)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#723269)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#723269)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#723270)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#723270)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#723271)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#723271)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#723272)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#723272)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#723273)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#723273)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#723274)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#723274)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#723275)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#723275)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#723276)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#723276)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#723277)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#723277)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#723278)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#723278)), 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#723199,zd_numdem#723200,zd_numdos#723201,zd_numpco#723202,zd_primai#723203,zd_annval#723204,zd_monnaie#723205,zd_cod_acte#723206,zd_ver_ccam#723207,zd_codsit#723208,zd_coduti#723209,zd_datmaj#723210,zd_cod_aa#723211,zd_modificateur#723212,zd_codper#723213,zd_codser#723214,zd_numsal#723215,zd_flassprev#723216,zd_assnonprev#723217,zd_numord#723218,zd_priuni#723219,zd_coefmino#723220,zd_mino#723221,zd_majo#723222,... 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#723922)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#723922)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#723923)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#723923)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#723924)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#723924)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#723925)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#723925)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#723926)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#723926)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#723927)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#723927)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#723928)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#723928)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#723929)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#723929)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#723930)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#723930)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#723931)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#723931)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#723932)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#723932)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#723933)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#723933)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#723934)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#723934)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#723935)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#723935)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#723936)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#723936)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#723937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#723937)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#723938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#723938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#723939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#723939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#723940)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#723940)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#723941)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#723941)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#723942)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#723942)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#723943)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#723943)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#723944)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#723944)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#723945)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#723945)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#723946)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#723946)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#723947)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#723947)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#723948)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#723948)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#723949)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#723949)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#723950)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#723950)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#723951)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#723951)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#723952)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#723952)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#723953)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#723953)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#723954)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#723954)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#723955)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#723955)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#723956)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#723956)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#723957)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#723957)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#723958)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#723958)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#723959)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#723959)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#723960)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#723960)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#723961)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#723961)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#723962)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#723962)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#723963)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#723963)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#723964)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#723964)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#723965)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#723965)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#723966)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#723966)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#723967)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#723967)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#723968)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#723968)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#723969)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#723969)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#723970)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#723970)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#723971)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#723971)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#723972)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#723972)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#723973)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#723973)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#723974)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#723974)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#723975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#723975)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#723976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#723976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#723977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#723977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#723978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#723978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#723979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#723979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#723980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#723980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#723981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#723981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#723982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#723982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#723983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#723983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#723984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#723984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#723985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#723985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#723986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#723986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#723987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#723987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#723988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#723988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#723989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#723989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#723990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#723990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#723991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#723991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#723992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#723992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#723993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#723993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#723994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#723994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#723995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#723995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#723996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#723996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#723997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#723997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#723998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#723998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#723999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#723999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#724000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#724000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#724001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#724001)), 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#723922,zd_numdem#723923,zd_numdos#723924,zd_numpco#723925,zd_primai#723926,zd_annval#723927,zd_monnaie#723928,zd_cod_acte#723929,zd_ver_ccam#723930,zd_codsit#723931,zd_coduti#723932,zd_datmaj#723933,zd_cod_aa#723934,zd_modificateur#723935,zd_codper#723936,zd_codser#723937,zd_numsal#723938,zd_flassprev#723939,zd_assnonprev#723940,zd_numord#723941,zd_priuni#723942,zd_coefmino#723943,zd_mino#723944,zd_majo#723945,... 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#723199, zd_numdem#723200, zd_numdos#723201, zd_numpco#723202, zd_primai#723203, zd_annval#723204, zd_monnaie#723205, zd_cod_acte#723206, zd_ver_ccam#723207, zd_codsit#723208, zd_coduti#723209, zd_datmaj#723210, zd_cod_aa#723211, zd_modificateur#723212, zd_codper#723213, zd_codser#723214, zd_numsal#723215, zd_flassprev#723216, zd_assnonprev#723217, zd_numord#723218, zd_priuni#723219, zd_coefmino#723220, zd_mino#723221, zd_majo#723222, zd_basrmb#723223, zd_factur#723224, zd_typexo#723225, zd_taucai#723226, zd_parcai#723227, zd_taumut#723228, zd_parmut#723229, zd_ligrgr#723230, zd_regrou_cod#723231, zd_cod_aap#723232, zd_qualdp#723233, zd_flrmbexc#723234, zd_flsuppcharge#723235, zd_donncompl#723236, zd_dents#723237, zd_depmnt#723238, zd_flid#723239, zd_mttid#723240, zd_tauid#723241, zd_amoid#723242, zd_tauid_amc#723243, zd_amcid#723244, zd_nbrik#723245, zd_mttik#723246, zd_tauik#723247, zd_amoik#723248, zd_nbrikm#723249, zd_mttikm#723250, zd_tauikm#723251, zd_amoikm#723252, zd_nbriks#723253, zd_mttiks#723254, zd_tauiks#723255, zd_amoiks#723256, zd_forc#723257, zd_formamc#723258, zd_codtit#723259, zd_flald#723260, zd_a_fact#723261, zd_x_exo_tm#723262, zd_modiffact#723263, zd_assnonprev_c#723264, zd_qualdp_c#723265, zd_coduam#723266, zd_mtdep#723267, zd_mtpenhps#723268, zd_flpav#723269, zd_mttori#723270, zd_acr#723271, zd_codapp#723272, zd_codper2#723273, zd_codind#723274, zd_codres#723275, zd_codextdoc#723276, zd_numexa#723277, zd_codextpmsi#723278]
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#723199, zd_numdem#723200, zd_numdos#723201, zd_numpco#723202, zd_primai#723203, zd_annval#723204, zd_monnaie#723205, zd_cod_acte#723206, zd_ver_ccam#723207, zd_codsit#723208, zd_coduti#723209, zd_datmaj#723210, zd_cod_aa#723211, zd_modificateur#723212, zd_codper#723213, zd_codser#723214, zd_numsal#723215, zd_flassprev#723216, zd_assnonprev#723217, zd_numord#723218, zd_priuni#723219, zd_coefmino#723220, zd_mino#723221, zd_majo#723222, zd_basrmb#723223, zd_factur#723224, zd_typexo#723225, zd_taucai#723226, zd_parcai#723227, zd_taumut#723228, zd_parmut#723229, zd_ligrgr#723230, zd_regrou_cod#723231, zd_cod_aap#723232, zd_qualdp#723233, zd_flrmbexc#723234, zd_flsuppcharge#723235, zd_donncompl#723236, zd_dents#723237, zd_depmnt#723238, zd_flid#723239, zd_mttid#723240, zd_tauid#723241, zd_amoid#723242, zd_tauid_amc#723243, zd_amcid#723244, zd_nbrik#723245, zd_mttik#723246, zd_tauik#723247, zd_amoik#723248, zd_nbrikm#723249, zd_mttikm#723250, zd_tauikm#723251, zd_amoikm#723252, zd_nbriks#723253, zd_mttiks#723254, zd_tauiks#723255, zd_amoiks#723256, zd_forc#723257, zd_formamc#723258, zd_codtit#723259, zd_flald#723260, zd_a_fact#723261, zd_x_exo_tm#723262, zd_modiffact#723263, zd_assnonprev_c#723264, zd_qualdp_c#723265, zd_coduam#723266, zd_mtdep#723267, zd_mtpenhps#723268, zd_flpav#723269, zd_mttori#723270, zd_acr#723271, zd_codapp#723272, zd_codper2#723273, zd_codind#723274, zd_codres#723275, zd_codextdoc#723276, zd_numexa#723277, zd_codextpmsi#723278]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#723199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#723199)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#723200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#723200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#723201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#723201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#723202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#723202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#723203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#723203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#723204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#723204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#723205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#723205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#723206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#723206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#723207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#723207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#723208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#723208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#723209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#723209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#723210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#723210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#723211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#723211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#723212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#723212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#723213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#723213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#723214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#723214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#723215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#723215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#723216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#723216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#723217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#723217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#723218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#723218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#723219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#723219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#723220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#723220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#723221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#723221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#723222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#723222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#723223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#723223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#723224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#723224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#723225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#723225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#723226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#723226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#723227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#723227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#723228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#723228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#723229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#723229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#723230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#723230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#723231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#723231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#723232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#723232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#723233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#723233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#723234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#723234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#723235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#723235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#723236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#723236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#723237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#723237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#723238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#723238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#723239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#723239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#723240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#723240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#723241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#723241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#723242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#723242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#723243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#723243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#723244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#723244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#723245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#723245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#723246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#723246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#723247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#723247)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#723248)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#723248)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#723249)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#723249)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#723250)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#723250)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#723251)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#723251)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#723252)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#723252)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#723253)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#723253)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#723254)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#723254)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#723255)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#723255)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#723256)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#723256)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#723257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#723257)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#723258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#723258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#723259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#723259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#723260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#723260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#723261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#723261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#723262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#723262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#723263)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#723263)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#723264)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#723264)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#723265)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#723265)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#723266)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#723266)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#723267)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#723267)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#723268)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#723268)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#723269)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#723269)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#723270)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#723270)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#723271)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#723271)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#723272)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#723272)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#723273)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#723273)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#723274)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#723274)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#723275)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#723275)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#723276)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#723276)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#723277)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#723277)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#723278)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#723278)), 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#723199, zd_numdem#723200, zd_numdos#723201, zd_numpco#723202, zd_primai#723203, zd_annval#723204, zd_monnaie#723205, zd_cod_acte#723206, zd_ver_ccam#723207, zd_codsit#723208, zd_coduti#723209, zd_datmaj#723210, zd_cod_aa#723211, zd_modificateur#723212, zd_codper#723213, zd_codser#723214, zd_numsal#723215, zd_flassprev#723216, zd_assnonprev#723217, zd_numord#723218, zd_priuni#723219, zd_coefmino#723220, zd_mino#723221, zd_majo#723222, zd_basrmb#723223, zd_factur#723224, zd_typexo#723225, zd_taucai#723226, zd_parcai#723227, zd_taumut#723228, zd_parmut#723229, zd_ligrgr#723230, zd_regrou_cod#723231, zd_cod_aap#723232, zd_qualdp#723233, zd_flrmbexc#723234, zd_flsuppcharge#723235, zd_donncompl#723236, zd_dents#723237, zd_depmnt#723238, zd_flid#723239, zd_mttid#723240, zd_tauid#723241, zd_amoid#723242, zd_tauid_amc#723243, zd_amcid#723244, zd_nbrik#723245, zd_mttik#723246, zd_tauik#723247, zd_amoik#723248, zd_nbrikm#723249, zd_mttikm#723250, zd_tauikm#723251, zd_amoikm#723252, zd_nbriks#723253, zd_mttiks#723254, zd_tauiks#723255, zd_amoiks#723256, zd_forc#723257, zd_formamc#723258, zd_codtit#723259, zd_flald#723260, zd_a_fact#723261, zd_x_exo_tm#723262, zd_modiffact#723263, zd_assnonprev_c#723264, zd_qualdp_c#723265, zd_coduam#723266, zd_mtdep#723267, zd_mtpenhps#723268, zd_flpav#723269, zd_mttori#723270, zd_acr#723271, zd_codapp#723272, zd_codper2#723273, zd_codind#723274, zd_codres#723275, zd_codextdoc#723276, zd_numexa#723277, zd_codextpmsi#723278]

(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#723922, zd_numdem#723923, zd_numdos#723924, zd_numpco#723925, zd_primai#723926, zd_annval#723927, zd_monnaie#723928, zd_cod_acte#723929, zd_ver_ccam#723930, zd_codsit#723931, zd_coduti#723932, zd_datmaj#723933, zd_cod_aa#723934, zd_modificateur#723935, zd_codper#723936, zd_codser#723937, zd_numsal#723938, zd_flassprev#723939, zd_assnonprev#723940, zd_numord#723941, zd_priuni#723942, zd_coefmino#723943, zd_mino#723944, zd_majo#723945, zd_basrmb#723946, zd_factur#723947, zd_typexo#723948, zd_taucai#723949, zd_parcai#723950, zd_taumut#723951, zd_parmut#723952, zd_ligrgr#723953, zd_regrou_cod#723954, zd_cod_aap#723955, zd_qualdp#723956, zd_flrmbexc#723957, zd_flsuppcharge#723958, zd_donncompl#723959, zd_dents#723960, zd_depmnt#723961, zd_flid#723962, zd_mttid#723963, zd_tauid#723964, zd_amoid#723965, zd_tauid_amc#723966, zd_amcid#723967, zd_nbrik#723968, zd_mttik#723969, zd_tauik#723970, zd_amoik#723971, zd_nbrikm#723972, zd_mttikm#723973, zd_tauikm#723974, zd_amoikm#723975, zd_nbriks#723976, zd_mttiks#723977, zd_tauiks#723978, zd_amoiks#723979, zd_forc#723980, zd_formamc#723981, zd_codtit#723982, zd_flald#723983, zd_a_fact#723984, zd_x_exo_tm#723985, zd_modiffact#723986, zd_assnonprev_c#723987, zd_qualdp_c#723988, zd_coduam#723989, zd_mtdep#723990, zd_mtpenhps#723991, zd_flpav#723992, zd_mttori#723993, zd_acr#723994, zd_codapp#723995, zd_codper2#723996, zd_codind#723997, zd_codres#723998, zd_codextdoc#723999, zd_numexa#724000, zd_codextpmsi#724001]
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#723922, zd_numdem#723923, zd_numdos#723924, zd_numpco#723925, zd_primai#723926, zd_annval#723927, zd_monnaie#723928, zd_cod_acte#723929, zd_ver_ccam#723930, zd_codsit#723931, zd_coduti#723932, zd_datmaj#723933, zd_cod_aa#723934, zd_modificateur#723935, zd_codper#723936, zd_codser#723937, zd_numsal#723938, zd_flassprev#723939, zd_assnonprev#723940, zd_numord#723941, zd_priuni#723942, zd_coefmino#723943, zd_mino#723944, zd_majo#723945, zd_basrmb#723946, zd_factur#723947, zd_typexo#723948, zd_taucai#723949, zd_parcai#723950, zd_taumut#723951, zd_parmut#723952, zd_ligrgr#723953, zd_regrou_cod#723954, zd_cod_aap#723955, zd_qualdp#723956, zd_flrmbexc#723957, zd_flsuppcharge#723958, zd_donncompl#723959, zd_dents#723960, zd_depmnt#723961, zd_flid#723962, zd_mttid#723963, zd_tauid#723964, zd_amoid#723965, zd_tauid_amc#723966, zd_amcid#723967, zd_nbrik#723968, zd_mttik#723969, zd_tauik#723970, zd_amoik#723971, zd_nbrikm#723972, zd_mttikm#723973, zd_tauikm#723974, zd_amoikm#723975, zd_nbriks#723976, zd_mttiks#723977, zd_tauiks#723978, zd_amoiks#723979, zd_forc#723980, zd_formamc#723981, zd_codtit#723982, zd_flald#723983, zd_a_fact#723984, zd_x_exo_tm#723985, zd_modiffact#723986, zd_assnonprev_c#723987, zd_qualdp_c#723988, zd_coduam#723989, zd_mtdep#723990, zd_mtpenhps#723991, zd_flpav#723992, zd_mttori#723993, zd_acr#723994, zd_codapp#723995, zd_codper2#723996, zd_codind#723997, zd_codres#723998, zd_codextdoc#723999, zd_numexa#724000, zd_codextpmsi#724001]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#723922)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#723922)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#723923)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#723923)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#723924)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#723924)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#723925)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#723925)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#723926)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#723926)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#723927)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#723927)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#723928)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#723928)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#723929)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#723929)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#723930)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#723930)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#723931)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#723931)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#723932)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#723932)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#723933)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#723933)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#723934)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#723934)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#723935)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#723935)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#723936)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#723936)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#723937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#723937)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#723938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#723938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#723939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#723939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#723940)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#723940)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#723941)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#723941)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#723942)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#723942)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#723943)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#723943)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#723944)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#723944)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#723945)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#723945)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#723946)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#723946)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#723947)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#723947)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#723948)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#723948)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#723949)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#723949)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#723950)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#723950)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#723951)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#723951)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#723952)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#723952)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#723953)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#723953)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#723954)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#723954)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#723955)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#723955)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#723956)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#723956)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#723957)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#723957)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#723958)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#723958)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#723959)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#723959)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#723960)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#723960)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#723961)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#723961)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#723962)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#723962)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#723963)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#723963)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#723964)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#723964)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#723965)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#723965)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#723966)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#723966)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#723967)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#723967)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#723968)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#723968)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#723969)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#723969)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#723970)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#723970)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#723971)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#723971)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#723972)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#723972)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#723973)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#723973)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#723974)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#723974)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#723975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#723975)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#723976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#723976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#723977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#723977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#723978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#723978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#723979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#723979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#723980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#723980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#723981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#723981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#723982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#723982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#723983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#723983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#723984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#723984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#723985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#723985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#723986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#723986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#723987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#723987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#723988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#723988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#723989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#723989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#723990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#723990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#723991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#723991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#723992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#723992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#723993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#723993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#723994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#723994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#723995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#723995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#723996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#723996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#723997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#723997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#723998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#723998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#723999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#723999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#724000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#724000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#724001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#724001)), 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#723922, zd_numdem#723923, zd_numdos#723924, zd_numpco#723925, zd_primai#723926, zd_annval#723927, zd_monnaie#723928, zd_cod_acte#723929, zd_ver_ccam#723930, zd_codsit#723931, zd_coduti#723932, zd_datmaj#723933, zd_cod_aa#723934, zd_modificateur#723935, zd_codper#723936, zd_codser#723937, zd_numsal#723938, zd_flassprev#723939, zd_assnonprev#723940, zd_numord#723941, zd_priuni#723942, zd_coefmino#723943, zd_mino#723944, zd_majo#723945, zd_basrmb#723946, zd_factur#723947, zd_typexo#723948, zd_taucai#723949, zd_parcai#723950, zd_taumut#723951, zd_parmut#723952, zd_ligrgr#723953, zd_regrou_cod#723954, zd_cod_aap#723955, zd_qualdp#723956, zd_flrmbexc#723957, zd_flsuppcharge#723958, zd_donncompl#723959, zd_dents#723960, zd_depmnt#723961, zd_flid#723962, zd_mttid#723963, zd_tauid#723964, zd_amoid#723965, zd_tauid_amc#723966, zd_amcid#723967, zd_nbrik#723968, zd_mttik#723969, zd_tauik#723970, zd_amoik#723971, zd_nbrikm#723972, zd_mttikm#723973, zd_tauikm#723974, zd_amoikm#723975, zd_nbriks#723976, zd_mttiks#723977, zd_tauiks#723978, zd_amoiks#723979, zd_forc#723980, zd_formamc#723981, zd_codtit#723982, zd_flald#723983, zd_a_fact#723984, zd_x_exo_tm#723985, zd_modiffact#723986, zd_assnonprev_c#723987, zd_qualdp_c#723988, zd_coduam#723989, zd_mtdep#723990, zd_mtpenhps#723991, zd_flpav#723992, zd_mttori#723993, zd_acr#723994, zd_codapp#723995, zd_codper2#723996, zd_codind#723997, zd_codres#723998, zd_codextdoc#723999, zd_numexa#724000, zd_codextpmsi#724001]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#725463L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#725293L]
Results [1]: [count(1)#725293L AS COL_fb7e2eb3-c197-484d-80a8-415d3c149254#725295L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#725463L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#725293L]
Results [1]: [count(1)#725293L AS COL_fb7e2eb3-c197-484d-80a8-415d3c149254#725295L]

(16) AdaptiveSparkPlan
Output [1]: [COL_fb7e2eb3-c197-484d-80a8-415d3c149254#725295L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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