hdh-spark-job - Details for Query 1472

Submitted Time: 2026/10/23 13:29:41
Duration: 17 s
Succeeded Jobs: 1471 1476

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

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#753353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#753353)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#753354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#753354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#753355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#753355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#753356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#753356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#753357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#753357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#753358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#753358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#753359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#753359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#753360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#753360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#753361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#753361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#753362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#753362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#753363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#753363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#753364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#753364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#753365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#753365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#753366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#753366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#753367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#753367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#753368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#753368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#753369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#753369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#753370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#753370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#753371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#753371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#753372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#753372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#753373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#753373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#753374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#753374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#753375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#753375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#753376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#753376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#753377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#753377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#753378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#753378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#753379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#753379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#753380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#753380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#753381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#753381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#753382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#753382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#753383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#753383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#753384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#753384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#753385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#753385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#753386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#753386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#753387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#753387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#753388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#753388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#753389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#753389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#753390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#753390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#753391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#753391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#753392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#753392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#753393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#753393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#753394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#753394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#753395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#753395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#753396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#753396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#753397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#753397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#753398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#753398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#753399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#753399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#753400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#753400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#753401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#753401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#753402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#753402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#753403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#753403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#753404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#753404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#753405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#753405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#753406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#753406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#753407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#753407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#753408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#753408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#753409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#753409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#753410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#753410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#753411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#753411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#753412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#753412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#753413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#753413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#753414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#753414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#753415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#753415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#753416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#753416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#753417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#753417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#753418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#753418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#753419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#753419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#753420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#753420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#753421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#753421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#753422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#753422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#753423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#753423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#753424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#753424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#753425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#753425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#753426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#753426)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#753427)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#753427)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#753428)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#753428)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#753429)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#753429)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#753430)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#753430)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#753431)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#753431)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#753432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#753432)), 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#753353,zd_numdem#753354,zd_numdos#753355,zd_numpco#753356,zd_primai#753357,zd_annval#753358,zd_monnaie#753359,zd_cod_acte#753360,zd_ver_ccam#753361,zd_codsit#753362,zd_coduti#753363,zd_datmaj#753364,zd_cod_aa#753365,zd_modificateur#753366,zd_codper#753367,zd_codser#753368,zd_numsal#753369,zd_flassprev#753370,zd_assnonprev#753371,zd_numord#753372,zd_priuni#753373,zd_coefmino#753374,zd_mino#753375,zd_majo#753376,... 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#754076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#754076)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#754077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#754077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#754078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#754078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#754079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#754079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#754080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#754080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#754081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#754081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#754082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#754082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#754083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#754083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#754084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#754084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#754085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#754085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#754086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#754086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#754087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#754087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#754088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#754088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#754089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#754089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#754090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#754090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#754091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#754091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#754092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#754092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#754093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#754093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#754094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#754094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#754095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#754095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#754096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#754096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#754097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#754097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#754098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#754098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#754099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#754099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#754100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#754100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#754101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#754101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#754102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#754102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#754103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#754103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#754104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#754104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#754105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#754105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#754106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#754106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#754107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#754107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#754108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#754108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#754109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#754109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#754110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#754110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#754111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#754111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#754112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#754112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#754113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#754113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#754114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#754114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#754115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#754115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#754116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#754116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#754117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#754117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#754118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#754118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#754119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#754119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#754120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#754120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#754121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#754121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#754122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#754122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#754123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#754123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#754124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#754124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#754125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#754125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#754126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#754126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#754127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#754127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#754128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#754128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#754129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#754129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#754130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#754130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#754131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#754131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#754132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#754132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#754133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#754133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#754134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#754134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#754135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#754135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#754136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#754136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#754137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#754137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#754138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#754138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#754139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#754139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#754140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#754140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#754141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#754141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#754142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#754142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#754143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#754143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#754144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#754144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#754145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#754145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#754146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#754146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#754147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#754147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#754148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#754148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#754149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#754149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#754150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#754150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#754151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#754151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#754152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#754152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#754153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#754153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#754154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#754154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#754155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#754155)), 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#754076,zd_numdem#754077,zd_numdos#754078,zd_numpco#754079,zd_primai#754080,zd_annval#754081,zd_monnaie#754082,zd_cod_acte#754083,zd_ver_ccam#754084,zd_codsit#754085,zd_coduti#754086,zd_datmaj#754087,zd_cod_aa#754088,zd_modificateur#754089,zd_codper#754090,zd_codser#754091,zd_numsal#754092,zd_flassprev#754093,zd_assnonprev#754094,zd_numord#754095,zd_priuni#754096,zd_coefmino#754097,zd_mino#754098,zd_majo#754099,... 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#753353, zd_numdem#753354, zd_numdos#753355, zd_numpco#753356, zd_primai#753357, zd_annval#753358, zd_monnaie#753359, zd_cod_acte#753360, zd_ver_ccam#753361, zd_codsit#753362, zd_coduti#753363, zd_datmaj#753364, zd_cod_aa#753365, zd_modificateur#753366, zd_codper#753367, zd_codser#753368, zd_numsal#753369, zd_flassprev#753370, zd_assnonprev#753371, zd_numord#753372, zd_priuni#753373, zd_coefmino#753374, zd_mino#753375, zd_majo#753376, zd_basrmb#753377, zd_factur#753378, zd_typexo#753379, zd_taucai#753380, zd_parcai#753381, zd_taumut#753382, zd_parmut#753383, zd_ligrgr#753384, zd_regrou_cod#753385, zd_cod_aap#753386, zd_qualdp#753387, zd_flrmbexc#753388, zd_flsuppcharge#753389, zd_donncompl#753390, zd_dents#753391, zd_depmnt#753392, zd_flid#753393, zd_mttid#753394, zd_tauid#753395, zd_amoid#753396, zd_tauid_amc#753397, zd_amcid#753398, zd_nbrik#753399, zd_mttik#753400, zd_tauik#753401, zd_amoik#753402, zd_nbrikm#753403, zd_mttikm#753404, zd_tauikm#753405, zd_amoikm#753406, zd_nbriks#753407, zd_mttiks#753408, zd_tauiks#753409, zd_amoiks#753410, zd_forc#753411, zd_formamc#753412, zd_codtit#753413, zd_flald#753414, zd_a_fact#753415, zd_x_exo_tm#753416, zd_modiffact#753417, zd_assnonprev_c#753418, zd_qualdp_c#753419, zd_coduam#753420, zd_mtdep#753421, zd_mtpenhps#753422, zd_flpav#753423, zd_mttori#753424, zd_acr#753425, zd_codapp#753426, zd_codper2#753427, zd_codind#753428, zd_codres#753429, zd_codextdoc#753430, zd_numexa#753431, zd_codextpmsi#753432]
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#753353, zd_numdem#753354, zd_numdos#753355, zd_numpco#753356, zd_primai#753357, zd_annval#753358, zd_monnaie#753359, zd_cod_acte#753360, zd_ver_ccam#753361, zd_codsit#753362, zd_coduti#753363, zd_datmaj#753364, zd_cod_aa#753365, zd_modificateur#753366, zd_codper#753367, zd_codser#753368, zd_numsal#753369, zd_flassprev#753370, zd_assnonprev#753371, zd_numord#753372, zd_priuni#753373, zd_coefmino#753374, zd_mino#753375, zd_majo#753376, zd_basrmb#753377, zd_factur#753378, zd_typexo#753379, zd_taucai#753380, zd_parcai#753381, zd_taumut#753382, zd_parmut#753383, zd_ligrgr#753384, zd_regrou_cod#753385, zd_cod_aap#753386, zd_qualdp#753387, zd_flrmbexc#753388, zd_flsuppcharge#753389, zd_donncompl#753390, zd_dents#753391, zd_depmnt#753392, zd_flid#753393, zd_mttid#753394, zd_tauid#753395, zd_amoid#753396, zd_tauid_amc#753397, zd_amcid#753398, zd_nbrik#753399, zd_mttik#753400, zd_tauik#753401, zd_amoik#753402, zd_nbrikm#753403, zd_mttikm#753404, zd_tauikm#753405, zd_amoikm#753406, zd_nbriks#753407, zd_mttiks#753408, zd_tauiks#753409, zd_amoiks#753410, zd_forc#753411, zd_formamc#753412, zd_codtit#753413, zd_flald#753414, zd_a_fact#753415, zd_x_exo_tm#753416, zd_modiffact#753417, zd_assnonprev_c#753418, zd_qualdp_c#753419, zd_coduam#753420, zd_mtdep#753421, zd_mtpenhps#753422, zd_flpav#753423, zd_mttori#753424, zd_acr#753425, zd_codapp#753426, zd_codper2#753427, zd_codind#753428, zd_codres#753429, zd_codextdoc#753430, zd_numexa#753431, zd_codextpmsi#753432]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#753353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#753353)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#753354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#753354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#753355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#753355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#753356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#753356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#753357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#753357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#753358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#753358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#753359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#753359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#753360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#753360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#753361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#753361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#753362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#753362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#753363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#753363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#753364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#753364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#753365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#753365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#753366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#753366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#753367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#753367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#753368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#753368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#753369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#753369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#753370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#753370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#753371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#753371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#753372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#753372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#753373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#753373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#753374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#753374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#753375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#753375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#753376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#753376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#753377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#753377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#753378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#753378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#753379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#753379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#753380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#753380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#753381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#753381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#753382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#753382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#753383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#753383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#753384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#753384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#753385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#753385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#753386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#753386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#753387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#753387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#753388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#753388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#753389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#753389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#753390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#753390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#753391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#753391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#753392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#753392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#753393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#753393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#753394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#753394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#753395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#753395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#753396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#753396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#753397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#753397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#753398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#753398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#753399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#753399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#753400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#753400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#753401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#753401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#753402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#753402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#753403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#753403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#753404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#753404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#753405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#753405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#753406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#753406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#753407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#753407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#753408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#753408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#753409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#753409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#753410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#753410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#753411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#753411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#753412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#753412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#753413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#753413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#753414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#753414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#753415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#753415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#753416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#753416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#753417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#753417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#753418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#753418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#753419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#753419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#753420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#753420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#753421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#753421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#753422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#753422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#753423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#753423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#753424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#753424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#753425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#753425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#753426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#753426)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#753427)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#753427)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#753428)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#753428)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#753429)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#753429)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#753430)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#753430)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#753431)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#753431)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#753432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#753432)), 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#753353, zd_numdem#753354, zd_numdos#753355, zd_numpco#753356, zd_primai#753357, zd_annval#753358, zd_monnaie#753359, zd_cod_acte#753360, zd_ver_ccam#753361, zd_codsit#753362, zd_coduti#753363, zd_datmaj#753364, zd_cod_aa#753365, zd_modificateur#753366, zd_codper#753367, zd_codser#753368, zd_numsal#753369, zd_flassprev#753370, zd_assnonprev#753371, zd_numord#753372, zd_priuni#753373, zd_coefmino#753374, zd_mino#753375, zd_majo#753376, zd_basrmb#753377, zd_factur#753378, zd_typexo#753379, zd_taucai#753380, zd_parcai#753381, zd_taumut#753382, zd_parmut#753383, zd_ligrgr#753384, zd_regrou_cod#753385, zd_cod_aap#753386, zd_qualdp#753387, zd_flrmbexc#753388, zd_flsuppcharge#753389, zd_donncompl#753390, zd_dents#753391, zd_depmnt#753392, zd_flid#753393, zd_mttid#753394, zd_tauid#753395, zd_amoid#753396, zd_tauid_amc#753397, zd_amcid#753398, zd_nbrik#753399, zd_mttik#753400, zd_tauik#753401, zd_amoik#753402, zd_nbrikm#753403, zd_mttikm#753404, zd_tauikm#753405, zd_amoikm#753406, zd_nbriks#753407, zd_mttiks#753408, zd_tauiks#753409, zd_amoiks#753410, zd_forc#753411, zd_formamc#753412, zd_codtit#753413, zd_flald#753414, zd_a_fact#753415, zd_x_exo_tm#753416, zd_modiffact#753417, zd_assnonprev_c#753418, zd_qualdp_c#753419, zd_coduam#753420, zd_mtdep#753421, zd_mtpenhps#753422, zd_flpav#753423, zd_mttori#753424, zd_acr#753425, zd_codapp#753426, zd_codper2#753427, zd_codind#753428, zd_codres#753429, zd_codextdoc#753430, zd_numexa#753431, zd_codextpmsi#753432]

(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#754076, zd_numdem#754077, zd_numdos#754078, zd_numpco#754079, zd_primai#754080, zd_annval#754081, zd_monnaie#754082, zd_cod_acte#754083, zd_ver_ccam#754084, zd_codsit#754085, zd_coduti#754086, zd_datmaj#754087, zd_cod_aa#754088, zd_modificateur#754089, zd_codper#754090, zd_codser#754091, zd_numsal#754092, zd_flassprev#754093, zd_assnonprev#754094, zd_numord#754095, zd_priuni#754096, zd_coefmino#754097, zd_mino#754098, zd_majo#754099, zd_basrmb#754100, zd_factur#754101, zd_typexo#754102, zd_taucai#754103, zd_parcai#754104, zd_taumut#754105, zd_parmut#754106, zd_ligrgr#754107, zd_regrou_cod#754108, zd_cod_aap#754109, zd_qualdp#754110, zd_flrmbexc#754111, zd_flsuppcharge#754112, zd_donncompl#754113, zd_dents#754114, zd_depmnt#754115, zd_flid#754116, zd_mttid#754117, zd_tauid#754118, zd_amoid#754119, zd_tauid_amc#754120, zd_amcid#754121, zd_nbrik#754122, zd_mttik#754123, zd_tauik#754124, zd_amoik#754125, zd_nbrikm#754126, zd_mttikm#754127, zd_tauikm#754128, zd_amoikm#754129, zd_nbriks#754130, zd_mttiks#754131, zd_tauiks#754132, zd_amoiks#754133, zd_forc#754134, zd_formamc#754135, zd_codtit#754136, zd_flald#754137, zd_a_fact#754138, zd_x_exo_tm#754139, zd_modiffact#754140, zd_assnonprev_c#754141, zd_qualdp_c#754142, zd_coduam#754143, zd_mtdep#754144, zd_mtpenhps#754145, zd_flpav#754146, zd_mttori#754147, zd_acr#754148, zd_codapp#754149, zd_codper2#754150, zd_codind#754151, zd_codres#754152, zd_codextdoc#754153, zd_numexa#754154, zd_codextpmsi#754155]
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#754076, zd_numdem#754077, zd_numdos#754078, zd_numpco#754079, zd_primai#754080, zd_annval#754081, zd_monnaie#754082, zd_cod_acte#754083, zd_ver_ccam#754084, zd_codsit#754085, zd_coduti#754086, zd_datmaj#754087, zd_cod_aa#754088, zd_modificateur#754089, zd_codper#754090, zd_codser#754091, zd_numsal#754092, zd_flassprev#754093, zd_assnonprev#754094, zd_numord#754095, zd_priuni#754096, zd_coefmino#754097, zd_mino#754098, zd_majo#754099, zd_basrmb#754100, zd_factur#754101, zd_typexo#754102, zd_taucai#754103, zd_parcai#754104, zd_taumut#754105, zd_parmut#754106, zd_ligrgr#754107, zd_regrou_cod#754108, zd_cod_aap#754109, zd_qualdp#754110, zd_flrmbexc#754111, zd_flsuppcharge#754112, zd_donncompl#754113, zd_dents#754114, zd_depmnt#754115, zd_flid#754116, zd_mttid#754117, zd_tauid#754118, zd_amoid#754119, zd_tauid_amc#754120, zd_amcid#754121, zd_nbrik#754122, zd_mttik#754123, zd_tauik#754124, zd_amoik#754125, zd_nbrikm#754126, zd_mttikm#754127, zd_tauikm#754128, zd_amoikm#754129, zd_nbriks#754130, zd_mttiks#754131, zd_tauiks#754132, zd_amoiks#754133, zd_forc#754134, zd_formamc#754135, zd_codtit#754136, zd_flald#754137, zd_a_fact#754138, zd_x_exo_tm#754139, zd_modiffact#754140, zd_assnonprev_c#754141, zd_qualdp_c#754142, zd_coduam#754143, zd_mtdep#754144, zd_mtpenhps#754145, zd_flpav#754146, zd_mttori#754147, zd_acr#754148, zd_codapp#754149, zd_codper2#754150, zd_codind#754151, zd_codres#754152, zd_codextdoc#754153, zd_numexa#754154, zd_codextpmsi#754155]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numcot#754076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numcot#754076)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdem#754077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdem#754077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numdos#754078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numdos#754078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numpco#754079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numpco#754079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_primai#754080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_primai#754080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_annval#754081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_annval#754081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_monnaie#754082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_monnaie#754082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_acte#754083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_acte#754083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ver_ccam#754084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ver_ccam#754084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codsit#754085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codsit#754085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduti#754086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduti#754086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_datmaj#754087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_datmaj#754087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aa#754088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aa#754088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modificateur#754089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modificateur#754089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper#754090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper#754090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codser#754091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codser#754091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numsal#754092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numsal#754092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flassprev#754093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flassprev#754093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev#754094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev#754094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numord#754095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numord#754095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_priuni#754096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_priuni#754096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coefmino#754097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coefmino#754097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mino#754098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mino#754098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_majo#754099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_majo#754099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_basrmb#754100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_basrmb#754100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_factur#754101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_factur#754101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_typexo#754102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_typexo#754102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taucai#754103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taucai#754103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parcai#754104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parcai#754104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_taumut#754105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_taumut#754105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_parmut#754106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_parmut#754106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_ligrgr#754107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_ligrgr#754107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_regrou_cod#754108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_regrou_cod#754108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_cod_aap#754109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_cod_aap#754109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp#754110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp#754110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flrmbexc#754111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flrmbexc#754111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flsuppcharge#754112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flsuppcharge#754112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_donncompl#754113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_donncompl#754113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_dents#754114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_dents#754114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_depmnt#754115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_depmnt#754115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flid#754116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flid#754116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttid#754117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttid#754117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid#754118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid#754118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoid#754119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoid#754119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauid_amc#754120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauid_amc#754120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amcid#754121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amcid#754121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrik#754122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrik#754122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttik#754123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttik#754123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauik#754124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauik#754124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoik#754125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoik#754125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbrikm#754126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbrikm#754126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttikm#754127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttikm#754127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauikm#754128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauikm#754128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoikm#754129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoikm#754129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_nbriks#754130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_nbriks#754130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttiks#754131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttiks#754131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_tauiks#754132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_tauiks#754132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_amoiks#754133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_amoiks#754133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_forc#754134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_forc#754134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_formamc#754135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_formamc#754135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codtit#754136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codtit#754136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flald#754137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flald#754137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_a_fact#754138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_a_fact#754138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_x_exo_tm#754139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_x_exo_tm#754139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_modiffact#754140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_modiffact#754140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_assnonprev_c#754141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_assnonprev_c#754141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_qualdp_c#754142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_qualdp_c#754142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_coduam#754143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_coduam#754143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtdep#754144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtdep#754144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mtpenhps#754145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mtpenhps#754145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_flpav#754146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_flpav#754146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_mttori#754147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_mttori#754147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_acr#754148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_acr#754148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codapp#754149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codapp#754149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codper2#754150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codper2#754150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codind#754151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codind#754151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codres#754152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codres#754152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextdoc#754153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextdoc#754153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_numexa#754154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_numexa#754154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(zd_codextpmsi#754155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(zd_codextpmsi#754155)), 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#754076, zd_numdem#754077, zd_numdos#754078, zd_numpco#754079, zd_primai#754080, zd_annval#754081, zd_monnaie#754082, zd_cod_acte#754083, zd_ver_ccam#754084, zd_codsit#754085, zd_coduti#754086, zd_datmaj#754087, zd_cod_aa#754088, zd_modificateur#754089, zd_codper#754090, zd_codser#754091, zd_numsal#754092, zd_flassprev#754093, zd_assnonprev#754094, zd_numord#754095, zd_priuni#754096, zd_coefmino#754097, zd_mino#754098, zd_majo#754099, zd_basrmb#754100, zd_factur#754101, zd_typexo#754102, zd_taucai#754103, zd_parcai#754104, zd_taumut#754105, zd_parmut#754106, zd_ligrgr#754107, zd_regrou_cod#754108, zd_cod_aap#754109, zd_qualdp#754110, zd_flrmbexc#754111, zd_flsuppcharge#754112, zd_donncompl#754113, zd_dents#754114, zd_depmnt#754115, zd_flid#754116, zd_mttid#754117, zd_tauid#754118, zd_amoid#754119, zd_tauid_amc#754120, zd_amcid#754121, zd_nbrik#754122, zd_mttik#754123, zd_tauik#754124, zd_amoik#754125, zd_nbrikm#754126, zd_mttikm#754127, zd_tauikm#754128, zd_amoikm#754129, zd_nbriks#754130, zd_mttiks#754131, zd_tauiks#754132, zd_amoiks#754133, zd_forc#754134, zd_formamc#754135, zd_codtit#754136, zd_flald#754137, zd_a_fact#754138, zd_x_exo_tm#754139, zd_modiffact#754140, zd_assnonprev_c#754141, zd_qualdp_c#754142, zd_coduam#754143, zd_mtdep#754144, zd_mtpenhps#754145, zd_flpav#754146, zd_mttori#754147, zd_acr#754148, zd_codapp#754149, zd_codper2#754150, zd_codind#754151, zd_codres#754152, zd_codextdoc#754153, zd_numexa#754154, zd_codextpmsi#754155]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#758096L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#756269L]
Results [1]: [count(1)#756269L AS COL_18ec60b3-929d-4db9-96d7-57fca7965424#756271L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#758096L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#756269L]
Results [1]: [count(1)#756269L AS COL_18ec60b3-929d-4db9-96d7-57fca7965424#756271L]

(16) AdaptiveSparkPlan
Output [1]: [COL_18ec60b3-929d-4db9-96d7-57fca7965424#756271L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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