hdh-spark-job - Details for Query 1429

Submitted Time: 2026/10/23 13:29:12
Duration: 17 s
Succeeded Jobs: 1427 1432

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 2074.0: task 1809)) 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 2074.0: task 1809)) 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 2074.0: task 1809))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n12.3 s (6.1 s, 6.2 s, 6.2 s (stage 2074.0: task 1810))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 12.3 s (6.1 s, 6.2 s, 6.2 s (stage 2074.0: task 1810)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 6.1 s"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 0"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"ot_numcot\", \"ot_numdem\", \"ot_numdos\", \"ot_numpco\", \"ot_primai\", \"ot_annval\", \"ot_codcha\", \"ot_codbas\", \"ot_rattac\", \"ot_lettre\", \"ot_coeff\", \"ot_cocal\", \"ot_platre\", \"ot_compar\", \"ot_codper\", \"ot_codser\", \"ot_qtebas\", \"ot_cdam\", \"ot_numsal\", \"ot_nomdos\", \"ot_cr\", \"ot_indbas\", \"ot_inftra\", \"ot_factur\", \"ot_monnaie\", \"ot_tarif\", \"ot_numero\", \"ot_t_red\", \"ot_datmaj\", \"ot_codsit\", \"ot_coduti\", \"ot_flrmo\", \"ot_nuit\", \"ot_majonuit\", \"ot_ferie\", \"ot_majoferie\", \"ot_flald\", \"ot_typexo\", \"ot_avisexo\", \"ot_basrmb\", \"ot_taucai\", \"ot_parcai\", \"ot_flid\", \"ot_mttid\", \"ot_tauid\", \"ot_amoid\", \"ot_mttik\", \"ot_tauik\", \"ot_amoik\", \"ot_nbrikm\", \"ot_mttikm\", \"ot_tauikm\", \"ot_amoikm\", \"ot_mttiks\", \"ot_tauiks\", \"ot_amoiks\", \"ot_taumut\", \"ot_parmut\", \"ot_nbriks\", \"ot_nbrik\", \"ot_numord\", \"ot_ligrgr\", \"ot_fldivise\", \"ot_codpre\", \"ot_majoage\", \"ot_faitlit\", \"ot_qualdp\", \"ot_priuni\", \"ot_denomb\", \"ot_amcid\", \"ot_codlis\", \"ot_coditm\", \"ot_numtli\", \"ot_depmnt\", \"ot_forc\", \"ot_formamc\", \"ot_numcot_ccam\", \"ot_coduam\", \"ot_mtdep\", \"ot_mtpenhps\", \"ot_mttori\", \"ot_codper2\", \"ot_letads\", \"ot_later\", \"ot_numexa\", \"ot_codapp\", \"ot_codper3\", \"ot_codtit\" FROM \"xplore\".\"h_cotdet\") as x) [numPartitions=1] number of output rows: 50,890"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 6.2 s"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 0"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"ot_numcot\", \"ot_numdem\", \"ot_numdos\", \"ot_numpco\", \"ot_primai\", \"ot_annval\", \"ot_codcha\", \"ot_codbas\", \"ot_rattac\", \"ot_lettre\", \"ot_coeff\", \"ot_cocal\", \"ot_platre\", \"ot_compar\", \"ot_codper\", \"ot_codser\", \"ot_qtebas\", \"ot_cdam\", \"ot_numsal\", \"ot_nomdos\", \"ot_cr\", \"ot_indbas\", \"ot_inftra\", \"ot_factur\", \"ot_monnaie\", \"ot_tarif\", \"ot_numero\", \"ot_t_red\", \"ot_datmaj\", \"ot_codsit\", \"ot_coduti\", \"ot_flrmo\", \"ot_nuit\", \"ot_majonuit\", \"ot_ferie\", \"ot_majoferie\", \"ot_flald\", \"ot_typexo\", \"ot_avisexo\", \"ot_basrmb\", \"ot_taucai\", \"ot_parcai\", \"ot_flid\", \"ot_mttid\", \"ot_tauid\", \"ot_amoid\", \"ot_mttik\", \"ot_tauik\", \"ot_amoik\", \"ot_nbrikm\", \"ot_mttikm\", \"ot_tauikm\", \"ot_amoikm\", \"ot_mttiks\", \"ot_tauiks\", \"ot_amoiks\", \"ot_taumut\", \"ot_parmut\", \"ot_nbriks\", \"ot_nbrik\", \"ot_numord\", \"ot_ligrgr\", \"ot_fldivise\", \"ot_codpre\", \"ot_majoage\", \"ot_faitlit\", \"ot_qualdp\", \"ot_priuni\", \"ot_denomb\", \"ot_amcid\", \"ot_codlis\", \"ot_coditm\", \"ot_numtli\", \"ot_depmnt\", \"ot_forc\", \"ot_formamc\", \"ot_numcot_ccam\", \"ot_coduam\", \"ot_mtdep\", \"ot_mtpenhps\", \"ot_mttori\", \"ot_codper2\", \"ot_letads\", \"ot_later\", \"ot_numexa\", \"ot_codapp\", \"ot_codper3\", \"ot_codtit\" FROM \"xplore2\".\"h_cotdet\") as x) [numPartitions=1] number of output rows: 50,890"]; } 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=38842]

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#720612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#720612)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#720613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#720613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#720614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#720614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#720615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#720615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#720616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#720616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#720617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#720617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#720618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#720618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#720619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#720619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#720620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#720620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#720621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#720621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#720622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#720622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#720623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#720623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#720624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#720624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#720625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#720625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#720626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#720626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#720627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#720627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#720628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#720628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#720629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#720629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#720630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#720630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#720631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#720631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#720632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#720632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#720633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#720633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#720634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#720634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#720635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#720635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#720636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#720636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#720637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#720637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#720638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#720638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#720639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#720639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#720640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#720640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#720641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#720641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#720642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#720642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#720643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#720643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#720644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#720644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#720645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#720645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#720646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#720646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#720647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#720647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#720648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#720648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#720649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#720649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#720650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#720650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#720651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#720651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#720652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#720652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#720653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#720653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#720654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#720654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#720655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#720655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#720656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#720656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#720657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#720657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#720658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#720658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#720659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#720659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#720660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#720660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#720661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#720661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#720662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#720662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#720663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#720663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#720664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#720664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#720665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#720665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#720666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#720666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#720667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#720667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#720668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#720668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#720669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#720669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#720670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#720670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#720671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#720671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#720672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#720672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#720673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#720673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#720674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#720674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#720675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#720675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#720676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#720676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#720677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#720677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#720678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#720678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#720679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#720679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#720680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#720680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#720681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#720681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#720682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#720682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#720683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#720683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#720684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#720684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#720685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#720685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#720686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#720686)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#720687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#720687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#720688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#720688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#720689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#720689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#720690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#720690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#720691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#720691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#720692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#720692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#720693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#720693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#720694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#720694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#720695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#720695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#720696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#720696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#720697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#720697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#720698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#720698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#720699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#720699)), 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 "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore"."h_cotdet") as x) [numPartitions=1] [ot_numcot#720612,ot_numdem#720613,ot_numdos#720614,ot_numpco#720615,ot_primai#720616,ot_annval#720617,ot_codcha#720618,ot_codbas#720619,ot_rattac#720620,ot_lettre#720621,ot_coeff#720622,ot_cocal#720623,ot_platre#720624,ot_compar#720625,ot_codper#720626,ot_codser#720627,ot_qtebas#720628,ot_cdam#720629,ot_numsal#720630,ot_nomdos#720631,ot_cr#720632,ot_indbas#720633,ot_inftra#720634,ot_factur#720635,... 64 more fields] PushedFilters: [], ReadSchema: struct<ot_numcot:string,ot_numdem:string,ot_numdos:string,ot_numpco:string,ot_primai:string,ot_an...

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#721499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#721499)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#721500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#721500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#721501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#721501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#721502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#721502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#721503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#721503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#721504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#721504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#721505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#721505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#721506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#721506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#721507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#721507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#721508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#721508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#721509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#721509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#721510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#721510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#721511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#721511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#721512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#721512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#721513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#721513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#721514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#721514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#721515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#721515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#721516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#721516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#721517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#721517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#721518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#721518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#721519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#721519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#721520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#721520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#721521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#721521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#721522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#721522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#721523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#721523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#721524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#721524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#721525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#721525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#721526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#721526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#721527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#721527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#721528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#721528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#721529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#721529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#721530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#721530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#721531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#721531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#721532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#721532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#721533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#721533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#721534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#721534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#721535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#721535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#721536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#721536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#721537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#721537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#721538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#721538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#721539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#721539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#721540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#721540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#721541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#721541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#721542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#721542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#721543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#721543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#721544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#721544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#721545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#721545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#721546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#721546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#721547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#721547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#721548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#721548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#721549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#721549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#721550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#721550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#721551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#721551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#721552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#721552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#721553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#721553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#721554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#721554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#721555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#721555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#721556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#721556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#721557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#721557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#721558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#721558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#721559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#721559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#721560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#721560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#721561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#721561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#721562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#721562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#721563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#721563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#721564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#721564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#721565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#721565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#721566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#721566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#721567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#721567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#721568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#721568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#721569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#721569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#721570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#721570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#721571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#721571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#721572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#721572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#721573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#721573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#721574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#721574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#721575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#721575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#721576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#721576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#721577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#721577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#721578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#721578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#721579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#721579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#721580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#721580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#721581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#721581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#721582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#721582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#721583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#721583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#721584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#721584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#721585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#721585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#721586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#721586)), 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 "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore2"."h_cotdet") as x) [numPartitions=1] [ot_numcot#721499,ot_numdem#721500,ot_numdos#721501,ot_numpco#721502,ot_primai#721503,ot_annval#721504,ot_codcha#721505,ot_codbas#721506,ot_rattac#721507,ot_lettre#721508,ot_coeff#721509,ot_cocal#721510,ot_platre#721511,ot_compar#721512,ot_codper#721513,ot_codser#721514,ot_qtebas#721515,ot_cdam#721516,ot_numsal#721517,ot_nomdos#721518,ot_cr#721519,ot_indbas#721520,ot_inftra#721521,ot_factur#721522,... 64 more fields] PushedFilters: [], ReadSchema: struct<ot_numcot:string,ot_numdem:string,ot_numdos:string,ot_numpco:string,ot_primai:string,ot_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 "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore"."h_cotdet") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore2"."h_cotdet") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore"."h_cotdet") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore2"."h_cotdet") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore"."h_cotdet") as x) [numPartitions=1]  [codegen id : 1]
Output [88]: [ot_numcot#720612, ot_numdem#720613, ot_numdos#720614, ot_numpco#720615, ot_primai#720616, ot_annval#720617, ot_codcha#720618, ot_codbas#720619, ot_rattac#720620, ot_lettre#720621, ot_coeff#720622, ot_cocal#720623, ot_platre#720624, ot_compar#720625, ot_codper#720626, ot_codser#720627, ot_qtebas#720628, ot_cdam#720629, ot_numsal#720630, ot_nomdos#720631, ot_cr#720632, ot_indbas#720633, ot_inftra#720634, ot_factur#720635, ot_monnaie#720636, ot_tarif#720637, ot_numero#720638, ot_t_red#720639, ot_datmaj#720640, ot_codsit#720641, ot_coduti#720642, ot_flrmo#720643, ot_nuit#720644, ot_majonuit#720645, ot_ferie#720646, ot_majoferie#720647, ot_flald#720648, ot_typexo#720649, ot_avisexo#720650, ot_basrmb#720651, ot_taucai#720652, ot_parcai#720653, ot_flid#720654, ot_mttid#720655, ot_tauid#720656, ot_amoid#720657, ot_mttik#720658, ot_tauik#720659, ot_amoik#720660, ot_nbrikm#720661, ot_mttikm#720662, ot_tauikm#720663, ot_amoikm#720664, ot_mttiks#720665, ot_tauiks#720666, ot_amoiks#720667, ot_taumut#720668, ot_parmut#720669, ot_nbriks#720670, ot_nbrik#720671, ot_numord#720672, ot_ligrgr#720673, ot_fldivise#720674, ot_codpre#720675, ot_majoage#720676, ot_faitlit#720677, ot_qualdp#720678, ot_priuni#720679, ot_denomb#720680, ot_amcid#720681, ot_codlis#720682, ot_coditm#720683, ot_numtli#720684, ot_depmnt#720685, ot_forc#720686, ot_formamc#720687, ot_numcot_ccam#720688, ot_coduam#720689, ot_mtdep#720690, ot_mtpenhps#720691, ot_mttori#720692, ot_codper2#720693, ot_letads#720694, ot_later#720695, ot_numexa#720696, ot_codapp#720697, ot_codper3#720698, ot_codtit#720699]
ReadSchema: struct<ot_numcot:string,ot_numdem:string,ot_numdos:string,ot_numpco:string,ot_primai:string,ot_annval:string,ot_codcha:string,ot_codbas:string,ot_rattac:string,ot_lettre:string,ot_coeff:string,ot_cocal:string,ot_platre:string,ot_compar:string,ot_codper:string,ot_codser:string,ot_qtebas:string,ot_cdam:string,ot_numsal:string,ot_nomdos:string,ot_cr:string,ot_indbas:string,ot_inftra:string,ot_factur:string,ot_monnaie:string,ot_tarif:string,ot_numero:string,ot_t_red:string,ot_datmaj:string,ot_codsit:string,ot_coduti:string,ot_flrmo:string,ot_nuit:string,ot_majonuit:string,ot_ferie:string,ot_majoferie:string,ot_flald:string,ot_typexo:string,ot_avisexo:string,ot_basrmb:string,ot_taucai:string,ot_parcai:string,ot_flid:string,ot_mttid:string,ot_tauid:string,ot_amoid:string,ot_mttik:string,ot_tauik:string,ot_amoik:string,ot_nbrikm:string,ot_mttikm:string,ot_tauikm:string,ot_amoikm:string,ot_mttiks:string,ot_tauiks:string,ot_amoiks:string,ot_taumut:string,ot_parmut:string,ot_nbriks:string,ot_nbrik:string,ot_numord:string,ot_ligrgr:string,ot_fldivise:string,ot_codpre:string,ot_majoage:string,ot_faitlit:string,ot_qualdp:string,ot_priuni:string,ot_denomb:string,ot_amcid:string,ot_codlis:string,ot_coditm:string,ot_numtli:string,ot_depmnt:string,ot_forc:string,ot_formamc:string,ot_numcot_ccam:string,ot_coduam:string,ot_mtdep:string,ot_mtpenhps:string,ot_mttori:string,ot_codper2:string,ot_letads:string,ot_later:string,ot_numexa:string,ot_codapp:string,ot_codper3:string,ot_codtit:string>

(2) Filter [codegen id : 1]
Input [88]: [ot_numcot#720612, ot_numdem#720613, ot_numdos#720614, ot_numpco#720615, ot_primai#720616, ot_annval#720617, ot_codcha#720618, ot_codbas#720619, ot_rattac#720620, ot_lettre#720621, ot_coeff#720622, ot_cocal#720623, ot_platre#720624, ot_compar#720625, ot_codper#720626, ot_codser#720627, ot_qtebas#720628, ot_cdam#720629, ot_numsal#720630, ot_nomdos#720631, ot_cr#720632, ot_indbas#720633, ot_inftra#720634, ot_factur#720635, ot_monnaie#720636, ot_tarif#720637, ot_numero#720638, ot_t_red#720639, ot_datmaj#720640, ot_codsit#720641, ot_coduti#720642, ot_flrmo#720643, ot_nuit#720644, ot_majonuit#720645, ot_ferie#720646, ot_majoferie#720647, ot_flald#720648, ot_typexo#720649, ot_avisexo#720650, ot_basrmb#720651, ot_taucai#720652, ot_parcai#720653, ot_flid#720654, ot_mttid#720655, ot_tauid#720656, ot_amoid#720657, ot_mttik#720658, ot_tauik#720659, ot_amoik#720660, ot_nbrikm#720661, ot_mttikm#720662, ot_tauikm#720663, ot_amoikm#720664, ot_mttiks#720665, ot_tauiks#720666, ot_amoiks#720667, ot_taumut#720668, ot_parmut#720669, ot_nbriks#720670, ot_nbrik#720671, ot_numord#720672, ot_ligrgr#720673, ot_fldivise#720674, ot_codpre#720675, ot_majoage#720676, ot_faitlit#720677, ot_qualdp#720678, ot_priuni#720679, ot_denomb#720680, ot_amcid#720681, ot_codlis#720682, ot_coditm#720683, ot_numtli#720684, ot_depmnt#720685, ot_forc#720686, ot_formamc#720687, ot_numcot_ccam#720688, ot_coduam#720689, ot_mtdep#720690, ot_mtpenhps#720691, ot_mttori#720692, ot_codper2#720693, ot_letads#720694, ot_later#720695, ot_numexa#720696, ot_codapp#720697, ot_codper3#720698, ot_codtit#720699]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#720612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#720612)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#720613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#720613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#720614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#720614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#720615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#720615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#720616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#720616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#720617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#720617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#720618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#720618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#720619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#720619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#720620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#720620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#720621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#720621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#720622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#720622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#720623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#720623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#720624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#720624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#720625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#720625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#720626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#720626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#720627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#720627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#720628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#720628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#720629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#720629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#720630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#720630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#720631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#720631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#720632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#720632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#720633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#720633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#720634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#720634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#720635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#720635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#720636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#720636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#720637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#720637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#720638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#720638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#720639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#720639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#720640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#720640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#720641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#720641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#720642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#720642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#720643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#720643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#720644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#720644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#720645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#720645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#720646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#720646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#720647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#720647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#720648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#720648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#720649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#720649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#720650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#720650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#720651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#720651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#720652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#720652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#720653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#720653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#720654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#720654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#720655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#720655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#720656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#720656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#720657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#720657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#720658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#720658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#720659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#720659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#720660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#720660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#720661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#720661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#720662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#720662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#720663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#720663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#720664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#720664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#720665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#720665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#720666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#720666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#720667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#720667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#720668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#720668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#720669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#720669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#720670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#720670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#720671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#720671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#720672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#720672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#720673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#720673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#720674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#720674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#720675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#720675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#720676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#720676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#720677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#720677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#720678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#720678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#720679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#720679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#720680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#720680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#720681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#720681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#720682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#720682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#720683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#720683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#720684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#720684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#720685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#720685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#720686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#720686)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#720687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#720687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#720688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#720688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#720689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#720689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#720690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#720690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#720691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#720691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#720692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#720692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#720693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#720693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#720694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#720694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#720695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#720695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#720696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#720696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#720697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#720697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#720698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#720698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#720699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#720699)), 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 [88]: [ot_numcot#720612, ot_numdem#720613, ot_numdos#720614, ot_numpco#720615, ot_primai#720616, ot_annval#720617, ot_codcha#720618, ot_codbas#720619, ot_rattac#720620, ot_lettre#720621, ot_coeff#720622, ot_cocal#720623, ot_platre#720624, ot_compar#720625, ot_codper#720626, ot_codser#720627, ot_qtebas#720628, ot_cdam#720629, ot_numsal#720630, ot_nomdos#720631, ot_cr#720632, ot_indbas#720633, ot_inftra#720634, ot_factur#720635, ot_monnaie#720636, ot_tarif#720637, ot_numero#720638, ot_t_red#720639, ot_datmaj#720640, ot_codsit#720641, ot_coduti#720642, ot_flrmo#720643, ot_nuit#720644, ot_majonuit#720645, ot_ferie#720646, ot_majoferie#720647, ot_flald#720648, ot_typexo#720649, ot_avisexo#720650, ot_basrmb#720651, ot_taucai#720652, ot_parcai#720653, ot_flid#720654, ot_mttid#720655, ot_tauid#720656, ot_amoid#720657, ot_mttik#720658, ot_tauik#720659, ot_amoik#720660, ot_nbrikm#720661, ot_mttikm#720662, ot_tauikm#720663, ot_amoikm#720664, ot_mttiks#720665, ot_tauiks#720666, ot_amoiks#720667, ot_taumut#720668, ot_parmut#720669, ot_nbriks#720670, ot_nbrik#720671, ot_numord#720672, ot_ligrgr#720673, ot_fldivise#720674, ot_codpre#720675, ot_majoage#720676, ot_faitlit#720677, ot_qualdp#720678, ot_priuni#720679, ot_denomb#720680, ot_amcid#720681, ot_codlis#720682, ot_coditm#720683, ot_numtli#720684, ot_depmnt#720685, ot_forc#720686, ot_formamc#720687, ot_numcot_ccam#720688, ot_coduam#720689, ot_mtdep#720690, ot_mtpenhps#720691, ot_mttori#720692, ot_codper2#720693, ot_letads#720694, ot_later#720695, ot_numexa#720696, ot_codapp#720697, ot_codper3#720698, ot_codtit#720699]

(4) Scan JDBCRelation((SELECT "ot_numcot", "ot_numdem", "ot_numdos", "ot_numpco", "ot_primai", "ot_annval", "ot_codcha", "ot_codbas", "ot_rattac", "ot_lettre", "ot_coeff", "ot_cocal", "ot_platre", "ot_compar", "ot_codper", "ot_codser", "ot_qtebas", "ot_cdam", "ot_numsal", "ot_nomdos", "ot_cr", "ot_indbas", "ot_inftra", "ot_factur", "ot_monnaie", "ot_tarif", "ot_numero", "ot_t_red", "ot_datmaj", "ot_codsit", "ot_coduti", "ot_flrmo", "ot_nuit", "ot_majonuit", "ot_ferie", "ot_majoferie", "ot_flald", "ot_typexo", "ot_avisexo", "ot_basrmb", "ot_taucai", "ot_parcai", "ot_flid", "ot_mttid", "ot_tauid", "ot_amoid", "ot_mttik", "ot_tauik", "ot_amoik", "ot_nbrikm", "ot_mttikm", "ot_tauikm", "ot_amoikm", "ot_mttiks", "ot_tauiks", "ot_amoiks", "ot_taumut", "ot_parmut", "ot_nbriks", "ot_nbrik", "ot_numord", "ot_ligrgr", "ot_fldivise", "ot_codpre", "ot_majoage", "ot_faitlit", "ot_qualdp", "ot_priuni", "ot_denomb", "ot_amcid", "ot_codlis", "ot_coditm", "ot_numtli", "ot_depmnt", "ot_forc", "ot_formamc", "ot_numcot_ccam", "ot_coduam", "ot_mtdep", "ot_mtpenhps", "ot_mttori", "ot_codper2", "ot_letads", "ot_later", "ot_numexa", "ot_codapp", "ot_codper3", "ot_codtit" FROM "xplore2"."h_cotdet") as x) [numPartitions=1]  [codegen id : 2]
Output [88]: [ot_numcot#721499, ot_numdem#721500, ot_numdos#721501, ot_numpco#721502, ot_primai#721503, ot_annval#721504, ot_codcha#721505, ot_codbas#721506, ot_rattac#721507, ot_lettre#721508, ot_coeff#721509, ot_cocal#721510, ot_platre#721511, ot_compar#721512, ot_codper#721513, ot_codser#721514, ot_qtebas#721515, ot_cdam#721516, ot_numsal#721517, ot_nomdos#721518, ot_cr#721519, ot_indbas#721520, ot_inftra#721521, ot_factur#721522, ot_monnaie#721523, ot_tarif#721524, ot_numero#721525, ot_t_red#721526, ot_datmaj#721527, ot_codsit#721528, ot_coduti#721529, ot_flrmo#721530, ot_nuit#721531, ot_majonuit#721532, ot_ferie#721533, ot_majoferie#721534, ot_flald#721535, ot_typexo#721536, ot_avisexo#721537, ot_basrmb#721538, ot_taucai#721539, ot_parcai#721540, ot_flid#721541, ot_mttid#721542, ot_tauid#721543, ot_amoid#721544, ot_mttik#721545, ot_tauik#721546, ot_amoik#721547, ot_nbrikm#721548, ot_mttikm#721549, ot_tauikm#721550, ot_amoikm#721551, ot_mttiks#721552, ot_tauiks#721553, ot_amoiks#721554, ot_taumut#721555, ot_parmut#721556, ot_nbriks#721557, ot_nbrik#721558, ot_numord#721559, ot_ligrgr#721560, ot_fldivise#721561, ot_codpre#721562, ot_majoage#721563, ot_faitlit#721564, ot_qualdp#721565, ot_priuni#721566, ot_denomb#721567, ot_amcid#721568, ot_codlis#721569, ot_coditm#721570, ot_numtli#721571, ot_depmnt#721572, ot_forc#721573, ot_formamc#721574, ot_numcot_ccam#721575, ot_coduam#721576, ot_mtdep#721577, ot_mtpenhps#721578, ot_mttori#721579, ot_codper2#721580, ot_letads#721581, ot_later#721582, ot_numexa#721583, ot_codapp#721584, ot_codper3#721585, ot_codtit#721586]
ReadSchema: struct<ot_numcot:string,ot_numdem:string,ot_numdos:string,ot_numpco:string,ot_primai:string,ot_annval:string,ot_codcha:string,ot_codbas:string,ot_rattac:string,ot_lettre:string,ot_coeff:string,ot_cocal:string,ot_platre:string,ot_compar:string,ot_codper:string,ot_codser:string,ot_qtebas:string,ot_cdam:string,ot_numsal:string,ot_nomdos:string,ot_cr:string,ot_indbas:string,ot_inftra:string,ot_factur:string,ot_monnaie:string,ot_tarif:string,ot_numero:string,ot_t_red:string,ot_datmaj:string,ot_codsit:string,ot_coduti:string,ot_flrmo:string,ot_nuit:string,ot_majonuit:string,ot_ferie:string,ot_majoferie:string,ot_flald:string,ot_typexo:string,ot_avisexo:string,ot_basrmb:string,ot_taucai:string,ot_parcai:string,ot_flid:string,ot_mttid:string,ot_tauid:string,ot_amoid:string,ot_mttik:string,ot_tauik:string,ot_amoik:string,ot_nbrikm:string,ot_mttikm:string,ot_tauikm:string,ot_amoikm:string,ot_mttiks:string,ot_tauiks:string,ot_amoiks:string,ot_taumut:string,ot_parmut:string,ot_nbriks:string,ot_nbrik:string,ot_numord:string,ot_ligrgr:string,ot_fldivise:string,ot_codpre:string,ot_majoage:string,ot_faitlit:string,ot_qualdp:string,ot_priuni:string,ot_denomb:string,ot_amcid:string,ot_codlis:string,ot_coditm:string,ot_numtli:string,ot_depmnt:string,ot_forc:string,ot_formamc:string,ot_numcot_ccam:string,ot_coduam:string,ot_mtdep:string,ot_mtpenhps:string,ot_mttori:string,ot_codper2:string,ot_letads:string,ot_later:string,ot_numexa:string,ot_codapp:string,ot_codper3:string,ot_codtit:string>

(5) Filter [codegen id : 2]
Input [88]: [ot_numcot#721499, ot_numdem#721500, ot_numdos#721501, ot_numpco#721502, ot_primai#721503, ot_annval#721504, ot_codcha#721505, ot_codbas#721506, ot_rattac#721507, ot_lettre#721508, ot_coeff#721509, ot_cocal#721510, ot_platre#721511, ot_compar#721512, ot_codper#721513, ot_codser#721514, ot_qtebas#721515, ot_cdam#721516, ot_numsal#721517, ot_nomdos#721518, ot_cr#721519, ot_indbas#721520, ot_inftra#721521, ot_factur#721522, ot_monnaie#721523, ot_tarif#721524, ot_numero#721525, ot_t_red#721526, ot_datmaj#721527, ot_codsit#721528, ot_coduti#721529, ot_flrmo#721530, ot_nuit#721531, ot_majonuit#721532, ot_ferie#721533, ot_majoferie#721534, ot_flald#721535, ot_typexo#721536, ot_avisexo#721537, ot_basrmb#721538, ot_taucai#721539, ot_parcai#721540, ot_flid#721541, ot_mttid#721542, ot_tauid#721543, ot_amoid#721544, ot_mttik#721545, ot_tauik#721546, ot_amoik#721547, ot_nbrikm#721548, ot_mttikm#721549, ot_tauikm#721550, ot_amoikm#721551, ot_mttiks#721552, ot_tauiks#721553, ot_amoiks#721554, ot_taumut#721555, ot_parmut#721556, ot_nbriks#721557, ot_nbrik#721558, ot_numord#721559, ot_ligrgr#721560, ot_fldivise#721561, ot_codpre#721562, ot_majoage#721563, ot_faitlit#721564, ot_qualdp#721565, ot_priuni#721566, ot_denomb#721567, ot_amcid#721568, ot_codlis#721569, ot_coditm#721570, ot_numtli#721571, ot_depmnt#721572, ot_forc#721573, ot_formamc#721574, ot_numcot_ccam#721575, ot_coduam#721576, ot_mtdep#721577, ot_mtpenhps#721578, ot_mttori#721579, ot_codper2#721580, ot_letads#721581, ot_later#721582, ot_numexa#721583, ot_codapp#721584, ot_codper3#721585, ot_codtit#721586]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#721499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#721499)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#721500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#721500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#721501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#721501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#721502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#721502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#721503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#721503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#721504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#721504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#721505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#721505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#721506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#721506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#721507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#721507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#721508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#721508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#721509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#721509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#721510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#721510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#721511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#721511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#721512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#721512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#721513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#721513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#721514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#721514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#721515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#721515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#721516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#721516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#721517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#721517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#721518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#721518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#721519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#721519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#721520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#721520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#721521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#721521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#721522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#721522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#721523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#721523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#721524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#721524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#721525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#721525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#721526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#721526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#721527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#721527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#721528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#721528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#721529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#721529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#721530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#721530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#721531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#721531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#721532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#721532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#721533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#721533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#721534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#721534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#721535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#721535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#721536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#721536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#721537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#721537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#721538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#721538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#721539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#721539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#721540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#721540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#721541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#721541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#721542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#721542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#721543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#721543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#721544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#721544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#721545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#721545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#721546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#721546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#721547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#721547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#721548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#721548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#721549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#721549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#721550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#721550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#721551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#721551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#721552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#721552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#721553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#721553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#721554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#721554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#721555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#721555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#721556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#721556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#721557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#721557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#721558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#721558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#721559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#721559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#721560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#721560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#721561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#721561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#721562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#721562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#721563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#721563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#721564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#721564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#721565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#721565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#721566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#721566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#721567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#721567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#721568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#721568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#721569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#721569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#721570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#721570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#721571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#721571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#721572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#721572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#721573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#721573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#721574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#721574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#721575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#721575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#721576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#721576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#721577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#721577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#721578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#721578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#721579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#721579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#721580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#721580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#721581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#721581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#721582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#721582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#721583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#721583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#721584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#721584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#721585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#721585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#721586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#721586)), 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 [88]: [ot_numcot#721499, ot_numdem#721500, ot_numdos#721501, ot_numpco#721502, ot_primai#721503, ot_annval#721504, ot_codcha#721505, ot_codbas#721506, ot_rattac#721507, ot_lettre#721508, ot_coeff#721509, ot_cocal#721510, ot_platre#721511, ot_compar#721512, ot_codper#721513, ot_codser#721514, ot_qtebas#721515, ot_cdam#721516, ot_numsal#721517, ot_nomdos#721518, ot_cr#721519, ot_indbas#721520, ot_inftra#721521, ot_factur#721522, ot_monnaie#721523, ot_tarif#721524, ot_numero#721525, ot_t_red#721526, ot_datmaj#721527, ot_codsit#721528, ot_coduti#721529, ot_flrmo#721530, ot_nuit#721531, ot_majonuit#721532, ot_ferie#721533, ot_majoferie#721534, ot_flald#721535, ot_typexo#721536, ot_avisexo#721537, ot_basrmb#721538, ot_taucai#721539, ot_parcai#721540, ot_flid#721541, ot_mttid#721542, ot_tauid#721543, ot_amoid#721544, ot_mttik#721545, ot_tauik#721546, ot_amoik#721547, ot_nbrikm#721548, ot_mttikm#721549, ot_tauikm#721550, ot_amoikm#721551, ot_mttiks#721552, ot_tauiks#721553, ot_amoiks#721554, ot_taumut#721555, ot_parmut#721556, ot_nbriks#721557, ot_nbrik#721558, ot_numord#721559, ot_ligrgr#721560, ot_fldivise#721561, ot_codpre#721562, ot_majoage#721563, ot_faitlit#721564, ot_qualdp#721565, ot_priuni#721566, ot_denomb#721567, ot_amcid#721568, ot_codlis#721569, ot_coditm#721570, ot_numtli#721571, ot_depmnt#721572, ot_forc#721573, ot_formamc#721574, ot_numcot_ccam#721575, ot_coduam#721576, ot_mtdep#721577, ot_mtpenhps#721578, ot_mttori#721579, ot_codper2#721580, ot_letads#721581, ot_later#721582, ot_numexa#721583, ot_codapp#721584, ot_codper3#721585, ot_codtit#721586]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#723196L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#723008L]
Results [1]: [count(1)#723008L AS COL_9ef84d8c-57b2-447d-83a4-6174713fe184#723010L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#723196L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#723008L]
Results [1]: [count(1)#723008L AS COL_9ef84d8c-57b2-447d-83a4-6174713fe184#723010L]

(16) AdaptiveSparkPlan
Output [1]: [COL_9ef84d8c-57b2-447d-83a4-6174713fe184#723010L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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