hdh-spark-job - Details for Query 1476

Submitted Time: 2026/10/23 13:29:42
Duration: 16 s
Succeeded Jobs: 1475 1480

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

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#758195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#758195)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#758196)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#758196)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#758197)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#758197)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#758198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#758198)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#758199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#758199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#758200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#758200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#758201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#758201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#758202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#758202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#758203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#758203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#758204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#758204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#758205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#758205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#758206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#758206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#758207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#758207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#758208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#758208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#758209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#758209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#758210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#758210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#758211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#758211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#758212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#758212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#758213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#758213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#758214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#758214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#758215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#758215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#758216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#758216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#758217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#758217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#758218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#758218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#758219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#758219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#758220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#758220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#758221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#758221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#758222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#758222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#758223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#758223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#758224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#758224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#758225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#758225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#758226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#758226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#758227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#758227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#758228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#758228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#758229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#758229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#758230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#758230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#758231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#758231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#758232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#758232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#758233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#758233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#758234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#758234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#758235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#758235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#758236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#758236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#758237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#758237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#758238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#758238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#758239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#758239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#758240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#758240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#758241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#758241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#758242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#758242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#758243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#758243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#758244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#758244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#758245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#758245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#758246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#758246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#758247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#758247)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#758248)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#758248)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#758249)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#758249)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#758250)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#758250)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#758251)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#758251)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#758252)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#758252)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#758253)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#758253)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#758254)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#758254)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#758255)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#758255)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#758256)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#758256)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#758257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#758257)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#758258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#758258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#758259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#758259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#758260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#758260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#758261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#758261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#758262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#758262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#758263)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#758263)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#758264)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#758264)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#758265)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#758265)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#758266)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#758266)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#758267)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#758267)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#758268)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#758268)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#758269)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#758269)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#758270)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#758270)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#758271)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#758271)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#758272)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#758272)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#758273)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#758273)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#758274)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#758274)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#758275)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#758275)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#758276)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#758276)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#758277)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#758277)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#758278)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#758278)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#758279)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#758279)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#758280)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#758280)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#758281)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#758281)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#758282)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#758282)), 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#758195,ot_numdem#758196,ot_numdos#758197,ot_numpco#758198,ot_primai#758199,ot_annval#758200,ot_codcha#758201,ot_codbas#758202,ot_rattac#758203,ot_lettre#758204,ot_coeff#758205,ot_cocal#758206,ot_platre#758207,ot_compar#758208,ot_codper#758209,ot_codser#758210,ot_qtebas#758211,ot_cdam#758212,ot_numsal#758213,ot_nomdos#758214,ot_cr#758215,ot_indbas#758216,ot_inftra#758217,ot_factur#758218,... 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#758990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#758990)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#758991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#758991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#758992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#758992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#758993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#758993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#758994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#758994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#758995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#758995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#758996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#758996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#758997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#758997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#758998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#758998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#758999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#758999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#759000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#759000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#759001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#759001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#759002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#759002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#759003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#759003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#759004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#759004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#759005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#759005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#759006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#759006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#759007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#759007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#759008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#759008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#759009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#759009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#759010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#759010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#759011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#759011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#759012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#759012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#759013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#759013)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#759014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#759014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#759015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#759015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#759016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#759016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#759017)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#759017)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#759018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#759018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#759019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#759019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#759020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#759020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#759021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#759021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#759022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#759022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#759023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#759023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#759024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#759024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#759025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#759025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#759026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#759026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#759027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#759027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#759028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#759028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#759029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#759029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#759030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#759030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#759031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#759031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#759032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#759032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#759033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#759033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#759034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#759034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#759035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#759035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#759036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#759036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#759037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#759037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#759038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#759038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#759039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#759039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#759040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#759040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#759041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#759041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#759042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#759042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#759043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#759043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#759044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#759044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#759045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#759045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#759046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#759046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#759047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#759047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#759048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#759048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#759049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#759049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#759050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#759050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#759051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#759051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#759052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#759052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#759053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#759053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#759054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#759054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#759055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#759055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#759056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#759056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#759057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#759057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#759058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#759058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#759059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#759059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#759060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#759060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#759061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#759061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#759062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#759062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#759063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#759063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#759064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#759064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#759065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#759065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#759066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#759066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#759067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#759067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#759068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#759068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#759069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#759069)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#759070)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#759070)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#759071)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#759071)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#759072)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#759072)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#759073)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#759073)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#759074)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#759074)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#759075)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#759075)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#759076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#759076)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#759077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#759077)), 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#758990,ot_numdem#758991,ot_numdos#758992,ot_numpco#758993,ot_primai#758994,ot_annval#758995,ot_codcha#758996,ot_codbas#758997,ot_rattac#758998,ot_lettre#758999,ot_coeff#759000,ot_cocal#759001,ot_platre#759002,ot_compar#759003,ot_codper#759004,ot_codser#759005,ot_qtebas#759006,ot_cdam#759007,ot_numsal#759008,ot_nomdos#759009,ot_cr#759010,ot_indbas#759011,ot_inftra#759012,ot_factur#759013,... 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#758195, ot_numdem#758196, ot_numdos#758197, ot_numpco#758198, ot_primai#758199, ot_annval#758200, ot_codcha#758201, ot_codbas#758202, ot_rattac#758203, ot_lettre#758204, ot_coeff#758205, ot_cocal#758206, ot_platre#758207, ot_compar#758208, ot_codper#758209, ot_codser#758210, ot_qtebas#758211, ot_cdam#758212, ot_numsal#758213, ot_nomdos#758214, ot_cr#758215, ot_indbas#758216, ot_inftra#758217, ot_factur#758218, ot_monnaie#758219, ot_tarif#758220, ot_numero#758221, ot_t_red#758222, ot_datmaj#758223, ot_codsit#758224, ot_coduti#758225, ot_flrmo#758226, ot_nuit#758227, ot_majonuit#758228, ot_ferie#758229, ot_majoferie#758230, ot_flald#758231, ot_typexo#758232, ot_avisexo#758233, ot_basrmb#758234, ot_taucai#758235, ot_parcai#758236, ot_flid#758237, ot_mttid#758238, ot_tauid#758239, ot_amoid#758240, ot_mttik#758241, ot_tauik#758242, ot_amoik#758243, ot_nbrikm#758244, ot_mttikm#758245, ot_tauikm#758246, ot_amoikm#758247, ot_mttiks#758248, ot_tauiks#758249, ot_amoiks#758250, ot_taumut#758251, ot_parmut#758252, ot_nbriks#758253, ot_nbrik#758254, ot_numord#758255, ot_ligrgr#758256, ot_fldivise#758257, ot_codpre#758258, ot_majoage#758259, ot_faitlit#758260, ot_qualdp#758261, ot_priuni#758262, ot_denomb#758263, ot_amcid#758264, ot_codlis#758265, ot_coditm#758266, ot_numtli#758267, ot_depmnt#758268, ot_forc#758269, ot_formamc#758270, ot_numcot_ccam#758271, ot_coduam#758272, ot_mtdep#758273, ot_mtpenhps#758274, ot_mttori#758275, ot_codper2#758276, ot_letads#758277, ot_later#758278, ot_numexa#758279, ot_codapp#758280, ot_codper3#758281, ot_codtit#758282]
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#758195, ot_numdem#758196, ot_numdos#758197, ot_numpco#758198, ot_primai#758199, ot_annval#758200, ot_codcha#758201, ot_codbas#758202, ot_rattac#758203, ot_lettre#758204, ot_coeff#758205, ot_cocal#758206, ot_platre#758207, ot_compar#758208, ot_codper#758209, ot_codser#758210, ot_qtebas#758211, ot_cdam#758212, ot_numsal#758213, ot_nomdos#758214, ot_cr#758215, ot_indbas#758216, ot_inftra#758217, ot_factur#758218, ot_monnaie#758219, ot_tarif#758220, ot_numero#758221, ot_t_red#758222, ot_datmaj#758223, ot_codsit#758224, ot_coduti#758225, ot_flrmo#758226, ot_nuit#758227, ot_majonuit#758228, ot_ferie#758229, ot_majoferie#758230, ot_flald#758231, ot_typexo#758232, ot_avisexo#758233, ot_basrmb#758234, ot_taucai#758235, ot_parcai#758236, ot_flid#758237, ot_mttid#758238, ot_tauid#758239, ot_amoid#758240, ot_mttik#758241, ot_tauik#758242, ot_amoik#758243, ot_nbrikm#758244, ot_mttikm#758245, ot_tauikm#758246, ot_amoikm#758247, ot_mttiks#758248, ot_tauiks#758249, ot_amoiks#758250, ot_taumut#758251, ot_parmut#758252, ot_nbriks#758253, ot_nbrik#758254, ot_numord#758255, ot_ligrgr#758256, ot_fldivise#758257, ot_codpre#758258, ot_majoage#758259, ot_faitlit#758260, ot_qualdp#758261, ot_priuni#758262, ot_denomb#758263, ot_amcid#758264, ot_codlis#758265, ot_coditm#758266, ot_numtli#758267, ot_depmnt#758268, ot_forc#758269, ot_formamc#758270, ot_numcot_ccam#758271, ot_coduam#758272, ot_mtdep#758273, ot_mtpenhps#758274, ot_mttori#758275, ot_codper2#758276, ot_letads#758277, ot_later#758278, ot_numexa#758279, ot_codapp#758280, ot_codper3#758281, ot_codtit#758282]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#758195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#758195)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#758196)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#758196)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#758197)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#758197)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#758198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#758198)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#758199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#758199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#758200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#758200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#758201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#758201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#758202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#758202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#758203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#758203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#758204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#758204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#758205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#758205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#758206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#758206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#758207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#758207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#758208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#758208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#758209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#758209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#758210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#758210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#758211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#758211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#758212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#758212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#758213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#758213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#758214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#758214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#758215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#758215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#758216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#758216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#758217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#758217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#758218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#758218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#758219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#758219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#758220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#758220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#758221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#758221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#758222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#758222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#758223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#758223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#758224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#758224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#758225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#758225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#758226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#758226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#758227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#758227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#758228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#758228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#758229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#758229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#758230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#758230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#758231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#758231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#758232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#758232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#758233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#758233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#758234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#758234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#758235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#758235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#758236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#758236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#758237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#758237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#758238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#758238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#758239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#758239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#758240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#758240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#758241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#758241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#758242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#758242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#758243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#758243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#758244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#758244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#758245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#758245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#758246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#758246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#758247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#758247)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#758248)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#758248)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#758249)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#758249)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#758250)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#758250)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#758251)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#758251)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#758252)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#758252)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#758253)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#758253)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#758254)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#758254)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#758255)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#758255)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#758256)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#758256)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#758257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#758257)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#758258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#758258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#758259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#758259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#758260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#758260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#758261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#758261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#758262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#758262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#758263)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#758263)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#758264)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#758264)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#758265)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#758265)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#758266)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#758266)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#758267)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#758267)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#758268)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#758268)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#758269)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#758269)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#758270)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#758270)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#758271)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#758271)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#758272)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#758272)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#758273)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#758273)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#758274)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#758274)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#758275)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#758275)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#758276)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#758276)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#758277)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#758277)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#758278)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#758278)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#758279)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#758279)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#758280)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#758280)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#758281)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#758281)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#758282)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#758282)), 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#758195, ot_numdem#758196, ot_numdos#758197, ot_numpco#758198, ot_primai#758199, ot_annval#758200, ot_codcha#758201, ot_codbas#758202, ot_rattac#758203, ot_lettre#758204, ot_coeff#758205, ot_cocal#758206, ot_platre#758207, ot_compar#758208, ot_codper#758209, ot_codser#758210, ot_qtebas#758211, ot_cdam#758212, ot_numsal#758213, ot_nomdos#758214, ot_cr#758215, ot_indbas#758216, ot_inftra#758217, ot_factur#758218, ot_monnaie#758219, ot_tarif#758220, ot_numero#758221, ot_t_red#758222, ot_datmaj#758223, ot_codsit#758224, ot_coduti#758225, ot_flrmo#758226, ot_nuit#758227, ot_majonuit#758228, ot_ferie#758229, ot_majoferie#758230, ot_flald#758231, ot_typexo#758232, ot_avisexo#758233, ot_basrmb#758234, ot_taucai#758235, ot_parcai#758236, ot_flid#758237, ot_mttid#758238, ot_tauid#758239, ot_amoid#758240, ot_mttik#758241, ot_tauik#758242, ot_amoik#758243, ot_nbrikm#758244, ot_mttikm#758245, ot_tauikm#758246, ot_amoikm#758247, ot_mttiks#758248, ot_tauiks#758249, ot_amoiks#758250, ot_taumut#758251, ot_parmut#758252, ot_nbriks#758253, ot_nbrik#758254, ot_numord#758255, ot_ligrgr#758256, ot_fldivise#758257, ot_codpre#758258, ot_majoage#758259, ot_faitlit#758260, ot_qualdp#758261, ot_priuni#758262, ot_denomb#758263, ot_amcid#758264, ot_codlis#758265, ot_coditm#758266, ot_numtli#758267, ot_depmnt#758268, ot_forc#758269, ot_formamc#758270, ot_numcot_ccam#758271, ot_coduam#758272, ot_mtdep#758273, ot_mtpenhps#758274, ot_mttori#758275, ot_codper2#758276, ot_letads#758277, ot_later#758278, ot_numexa#758279, ot_codapp#758280, ot_codper3#758281, ot_codtit#758282]

(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#758990, ot_numdem#758991, ot_numdos#758992, ot_numpco#758993, ot_primai#758994, ot_annval#758995, ot_codcha#758996, ot_codbas#758997, ot_rattac#758998, ot_lettre#758999, ot_coeff#759000, ot_cocal#759001, ot_platre#759002, ot_compar#759003, ot_codper#759004, ot_codser#759005, ot_qtebas#759006, ot_cdam#759007, ot_numsal#759008, ot_nomdos#759009, ot_cr#759010, ot_indbas#759011, ot_inftra#759012, ot_factur#759013, ot_monnaie#759014, ot_tarif#759015, ot_numero#759016, ot_t_red#759017, ot_datmaj#759018, ot_codsit#759019, ot_coduti#759020, ot_flrmo#759021, ot_nuit#759022, ot_majonuit#759023, ot_ferie#759024, ot_majoferie#759025, ot_flald#759026, ot_typexo#759027, ot_avisexo#759028, ot_basrmb#759029, ot_taucai#759030, ot_parcai#759031, ot_flid#759032, ot_mttid#759033, ot_tauid#759034, ot_amoid#759035, ot_mttik#759036, ot_tauik#759037, ot_amoik#759038, ot_nbrikm#759039, ot_mttikm#759040, ot_tauikm#759041, ot_amoikm#759042, ot_mttiks#759043, ot_tauiks#759044, ot_amoiks#759045, ot_taumut#759046, ot_parmut#759047, ot_nbriks#759048, ot_nbrik#759049, ot_numord#759050, ot_ligrgr#759051, ot_fldivise#759052, ot_codpre#759053, ot_majoage#759054, ot_faitlit#759055, ot_qualdp#759056, ot_priuni#759057, ot_denomb#759058, ot_amcid#759059, ot_codlis#759060, ot_coditm#759061, ot_numtli#759062, ot_depmnt#759063, ot_forc#759064, ot_formamc#759065, ot_numcot_ccam#759066, ot_coduam#759067, ot_mtdep#759068, ot_mtpenhps#759069, ot_mttori#759070, ot_codper2#759071, ot_letads#759072, ot_later#759073, ot_numexa#759074, ot_codapp#759075, ot_codper3#759076, ot_codtit#759077]
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#758990, ot_numdem#758991, ot_numdos#758992, ot_numpco#758993, ot_primai#758994, ot_annval#758995, ot_codcha#758996, ot_codbas#758997, ot_rattac#758998, ot_lettre#758999, ot_coeff#759000, ot_cocal#759001, ot_platre#759002, ot_compar#759003, ot_codper#759004, ot_codser#759005, ot_qtebas#759006, ot_cdam#759007, ot_numsal#759008, ot_nomdos#759009, ot_cr#759010, ot_indbas#759011, ot_inftra#759012, ot_factur#759013, ot_monnaie#759014, ot_tarif#759015, ot_numero#759016, ot_t_red#759017, ot_datmaj#759018, ot_codsit#759019, ot_coduti#759020, ot_flrmo#759021, ot_nuit#759022, ot_majonuit#759023, ot_ferie#759024, ot_majoferie#759025, ot_flald#759026, ot_typexo#759027, ot_avisexo#759028, ot_basrmb#759029, ot_taucai#759030, ot_parcai#759031, ot_flid#759032, ot_mttid#759033, ot_tauid#759034, ot_amoid#759035, ot_mttik#759036, ot_tauik#759037, ot_amoik#759038, ot_nbrikm#759039, ot_mttikm#759040, ot_tauikm#759041, ot_amoikm#759042, ot_mttiks#759043, ot_tauiks#759044, ot_amoiks#759045, ot_taumut#759046, ot_parmut#759047, ot_nbriks#759048, ot_nbrik#759049, ot_numord#759050, ot_ligrgr#759051, ot_fldivise#759052, ot_codpre#759053, ot_majoage#759054, ot_faitlit#759055, ot_qualdp#759056, ot_priuni#759057, ot_denomb#759058, ot_amcid#759059, ot_codlis#759060, ot_coditm#759061, ot_numtli#759062, ot_depmnt#759063, ot_forc#759064, ot_formamc#759065, ot_numcot_ccam#759066, ot_coduam#759067, ot_mtdep#759068, ot_mtpenhps#759069, ot_mttori#759070, ot_codper2#759071, ot_letads#759072, ot_later#759073, ot_numexa#759074, ot_codapp#759075, ot_codper3#759076, ot_codtit#759077]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#758990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#758990)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#758991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#758991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#758992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#758992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#758993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#758993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#758994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#758994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#758995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#758995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#758996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#758996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#758997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#758997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#758998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#758998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#758999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#758999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#759000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#759000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#759001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#759001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#759002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#759002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#759003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#759003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#759004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#759004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#759005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#759005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#759006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#759006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#759007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#759007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#759008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#759008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#759009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#759009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#759010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#759010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#759011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#759011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#759012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#759012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#759013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#759013)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#759014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#759014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#759015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#759015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#759016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#759016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#759017)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#759017)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#759018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#759018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#759019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#759019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#759020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#759020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#759021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#759021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#759022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#759022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#759023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#759023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#759024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#759024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#759025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#759025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#759026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#759026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#759027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#759027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#759028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#759028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#759029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#759029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#759030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#759030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#759031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#759031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#759032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#759032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#759033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#759033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#759034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#759034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#759035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#759035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#759036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#759036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#759037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#759037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#759038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#759038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#759039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#759039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#759040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#759040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#759041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#759041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#759042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#759042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#759043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#759043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#759044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#759044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#759045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#759045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#759046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#759046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#759047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#759047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#759048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#759048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#759049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#759049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#759050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#759050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#759051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#759051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#759052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#759052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#759053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#759053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#759054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#759054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#759055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#759055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#759056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#759056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#759057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#759057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#759058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#759058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#759059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#759059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#759060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#759060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#759061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#759061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#759062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#759062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#759063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#759063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#759064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#759064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#759065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#759065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#759066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#759066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#759067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#759067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#759068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#759068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#759069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#759069)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#759070)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#759070)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#759071)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#759071)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#759072)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#759072)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#759073)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#759073)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#759074)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#759074)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#759075)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#759075)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#759076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#759076)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#759077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#759077)), 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#758990, ot_numdem#758991, ot_numdos#758992, ot_numpco#758993, ot_primai#758994, ot_annval#758995, ot_codcha#758996, ot_codbas#758997, ot_rattac#758998, ot_lettre#758999, ot_coeff#759000, ot_cocal#759001, ot_platre#759002, ot_compar#759003, ot_codper#759004, ot_codser#759005, ot_qtebas#759006, ot_cdam#759007, ot_numsal#759008, ot_nomdos#759009, ot_cr#759010, ot_indbas#759011, ot_inftra#759012, ot_factur#759013, ot_monnaie#759014, ot_tarif#759015, ot_numero#759016, ot_t_red#759017, ot_datmaj#759018, ot_codsit#759019, ot_coduti#759020, ot_flrmo#759021, ot_nuit#759022, ot_majonuit#759023, ot_ferie#759024, ot_majoferie#759025, ot_flald#759026, ot_typexo#759027, ot_avisexo#759028, ot_basrmb#759029, ot_taucai#759030, ot_parcai#759031, ot_flid#759032, ot_mttid#759033, ot_tauid#759034, ot_amoid#759035, ot_mttik#759036, ot_tauik#759037, ot_amoik#759038, ot_nbrikm#759039, ot_mttikm#759040, ot_tauikm#759041, ot_amoikm#759042, ot_mttiks#759043, ot_tauiks#759044, ot_amoiks#759045, ot_taumut#759046, ot_parmut#759047, ot_nbriks#759048, ot_nbrik#759049, ot_numord#759050, ot_ligrgr#759051, ot_fldivise#759052, ot_codpre#759053, ot_majoage#759054, ot_faitlit#759055, ot_qualdp#759056, ot_priuni#759057, ot_denomb#759058, ot_amcid#759059, ot_codlis#759060, ot_coditm#759061, ot_numtli#759062, ot_depmnt#759063, ot_forc#759064, ot_formamc#759065, ot_numcot_ccam#759066, ot_coduam#759067, ot_mtdep#759068, ot_mtpenhps#759069, ot_mttori#759070, ot_codper2#759071, ot_letads#759072, ot_later#759073, ot_numexa#759074, ot_codapp#759075, ot_codper3#759076, ot_codtit#759077]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#766348L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#761472L]
Results [1]: [count(1)#761472L AS COL_6af767a5-64c2-4963-a63b-f50806e4c694#761474L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#766348L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#761472L]
Results [1]: [count(1)#761472L AS COL_6af767a5-64c2-4963-a63b-f50806e4c694#761474L]

(16) AdaptiveSparkPlan
Output [1]: [COL_6af767a5-64c2-4963-a63b-f50806e4c694#761474L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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