hdh-spark-job - Details for Query 1321

Submitted Time: 2026/10/23 13:26:34
Duration: 13 s
Succeeded Jobs: 1318 1323

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

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#646267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#646267)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#646268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#646268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#646269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#646269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#646270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#646270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#646271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#646271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#646272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#646272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#646273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#646273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#646274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#646274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#646275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#646275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#646276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#646276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#646277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#646277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#646278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#646278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#646279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#646279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#646280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#646280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#646281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#646281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#646282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#646282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#646283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#646283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#646284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#646284)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#646285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#646285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#646286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#646286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#646287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#646287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#646288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#646288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#646289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#646289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#646290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#646290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#646291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#646291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#646292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#646292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#646293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#646293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#646294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#646294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#646295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#646295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#646296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#646296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#646297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#646297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#646298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#646298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#646299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#646299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#646300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#646300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#646301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#646301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#646302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#646302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#646303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#646303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#646304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#646304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#646305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#646305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#646306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#646306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#646307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#646307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#646308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#646308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#646309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#646309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#646310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#646310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#646311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#646311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#646312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#646312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#646313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#646313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#646314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#646314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#646315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#646315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#646316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#646316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#646317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#646317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#646318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#646318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#646319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#646319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#646320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#646320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#646321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#646321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#646322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#646322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#646323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#646323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#646324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#646324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#646325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#646325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#646326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#646326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#646327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#646327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#646328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#646328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#646329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#646329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#646330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#646330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#646331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#646331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#646332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#646332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#646333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#646333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#646334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#646334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#646335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#646335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#646336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#646336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#646337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#646337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#646338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#646338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#646339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#646339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#646340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#646340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#646341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#646341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#646342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#646342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#646343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#646343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#646344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#646344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#646345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#646345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#646346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#646346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#646347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#646347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#646348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#646348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#646349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#646349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#646350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#646350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#646351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#646351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#646352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#646352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#646353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#646353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#646354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#646354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

Scan JDBCRelation((SELECT "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#646267,ot_numdem#646268,ot_numdos#646269,ot_numpco#646270,ot_primai#646271,ot_annval#646272,ot_codcha#646273,ot_codbas#646274,ot_rattac#646275,ot_lettre#646276,ot_coeff#646277,ot_cocal#646278,ot_platre#646279,ot_compar#646280,ot_codper#646281,ot_codser#646282,ot_qtebas#646283,ot_cdam#646284,ot_numsal#646285,ot_nomdos#646286,ot_cr#646287,ot_indbas#646288,ot_inftra#646289,ot_factur#646290,... 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#647156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#647156)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#647157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#647157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#647158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#647158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#647159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#647159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#647160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#647160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#647161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#647161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#647162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#647162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#647163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#647163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#647164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#647164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#647165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#647165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#647166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#647166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#647167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#647167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#647168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#647168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#647169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#647169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#647170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#647170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#647171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#647171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#647172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#647172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#647173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#647173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#647174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#647174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#647175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#647175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#647176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#647176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#647177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#647177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#647178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#647178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#647179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#647179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#647180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#647180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#647181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#647181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#647182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#647182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#647183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#647183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#647184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#647184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#647185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#647185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#647186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#647186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#647187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#647187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#647188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#647188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#647189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#647189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#647190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#647190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#647191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#647191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#647192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#647192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#647193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#647193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#647194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#647194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#647195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#647195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#647196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#647196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#647197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#647197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#647198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#647198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#647199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#647199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#647200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#647200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#647201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#647201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#647202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#647202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#647203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#647203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#647204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#647204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#647205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#647205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#647206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#647206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#647207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#647207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#647208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#647208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#647209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#647209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#647210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#647210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#647211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#647211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#647212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#647212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#647213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#647213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#647214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#647214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#647215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#647215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#647216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#647216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#647217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#647217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#647218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#647218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#647219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#647219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#647220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#647220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#647221)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#647221)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#647222)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#647222)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#647223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#647223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#647224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#647224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#647225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#647225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#647226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#647226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#647227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#647227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#647228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#647228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#647229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#647229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#647230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#647230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#647231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#647231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#647232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#647232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#647233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#647233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#647234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#647234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#647235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#647235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#647236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#647236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#647237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#647237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#647238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#647238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#647239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#647239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#647240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#647240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#647241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#647241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#647242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#647242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#647243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#647243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

Scan JDBCRelation((SELECT "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#647156,ot_numdem#647157,ot_numdos#647158,ot_numpco#647159,ot_primai#647160,ot_annval#647161,ot_codcha#647162,ot_codbas#647163,ot_rattac#647164,ot_lettre#647165,ot_coeff#647166,ot_cocal#647167,ot_platre#647168,ot_compar#647169,ot_codper#647170,ot_codser#647171,ot_qtebas#647172,ot_cdam#647173,ot_numsal#647174,ot_nomdos#647175,ot_cr#647176,ot_indbas#647177,ot_inftra#647178,ot_factur#647179,... 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#646267, ot_numdem#646268, ot_numdos#646269, ot_numpco#646270, ot_primai#646271, ot_annval#646272, ot_codcha#646273, ot_codbas#646274, ot_rattac#646275, ot_lettre#646276, ot_coeff#646277, ot_cocal#646278, ot_platre#646279, ot_compar#646280, ot_codper#646281, ot_codser#646282, ot_qtebas#646283, ot_cdam#646284, ot_numsal#646285, ot_nomdos#646286, ot_cr#646287, ot_indbas#646288, ot_inftra#646289, ot_factur#646290, ot_monnaie#646291, ot_tarif#646292, ot_numero#646293, ot_t_red#646294, ot_datmaj#646295, ot_codsit#646296, ot_coduti#646297, ot_flrmo#646298, ot_nuit#646299, ot_majonuit#646300, ot_ferie#646301, ot_majoferie#646302, ot_flald#646303, ot_typexo#646304, ot_avisexo#646305, ot_basrmb#646306, ot_taucai#646307, ot_parcai#646308, ot_flid#646309, ot_mttid#646310, ot_tauid#646311, ot_amoid#646312, ot_mttik#646313, ot_tauik#646314, ot_amoik#646315, ot_nbrikm#646316, ot_mttikm#646317, ot_tauikm#646318, ot_amoikm#646319, ot_mttiks#646320, ot_tauiks#646321, ot_amoiks#646322, ot_taumut#646323, ot_parmut#646324, ot_nbriks#646325, ot_nbrik#646326, ot_numord#646327, ot_ligrgr#646328, ot_fldivise#646329, ot_codpre#646330, ot_majoage#646331, ot_faitlit#646332, ot_qualdp#646333, ot_priuni#646334, ot_denomb#646335, ot_amcid#646336, ot_codlis#646337, ot_coditm#646338, ot_numtli#646339, ot_depmnt#646340, ot_forc#646341, ot_formamc#646342, ot_numcot_ccam#646343, ot_coduam#646344, ot_mtdep#646345, ot_mtpenhps#646346, ot_mttori#646347, ot_codper2#646348, ot_letads#646349, ot_later#646350, ot_numexa#646351, ot_codapp#646352, ot_codper3#646353, ot_codtit#646354]
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#646267, ot_numdem#646268, ot_numdos#646269, ot_numpco#646270, ot_primai#646271, ot_annval#646272, ot_codcha#646273, ot_codbas#646274, ot_rattac#646275, ot_lettre#646276, ot_coeff#646277, ot_cocal#646278, ot_platre#646279, ot_compar#646280, ot_codper#646281, ot_codser#646282, ot_qtebas#646283, ot_cdam#646284, ot_numsal#646285, ot_nomdos#646286, ot_cr#646287, ot_indbas#646288, ot_inftra#646289, ot_factur#646290, ot_monnaie#646291, ot_tarif#646292, ot_numero#646293, ot_t_red#646294, ot_datmaj#646295, ot_codsit#646296, ot_coduti#646297, ot_flrmo#646298, ot_nuit#646299, ot_majonuit#646300, ot_ferie#646301, ot_majoferie#646302, ot_flald#646303, ot_typexo#646304, ot_avisexo#646305, ot_basrmb#646306, ot_taucai#646307, ot_parcai#646308, ot_flid#646309, ot_mttid#646310, ot_tauid#646311, ot_amoid#646312, ot_mttik#646313, ot_tauik#646314, ot_amoik#646315, ot_nbrikm#646316, ot_mttikm#646317, ot_tauikm#646318, ot_amoikm#646319, ot_mttiks#646320, ot_tauiks#646321, ot_amoiks#646322, ot_taumut#646323, ot_parmut#646324, ot_nbriks#646325, ot_nbrik#646326, ot_numord#646327, ot_ligrgr#646328, ot_fldivise#646329, ot_codpre#646330, ot_majoage#646331, ot_faitlit#646332, ot_qualdp#646333, ot_priuni#646334, ot_denomb#646335, ot_amcid#646336, ot_codlis#646337, ot_coditm#646338, ot_numtli#646339, ot_depmnt#646340, ot_forc#646341, ot_formamc#646342, ot_numcot_ccam#646343, ot_coduam#646344, ot_mtdep#646345, ot_mtpenhps#646346, ot_mttori#646347, ot_codper2#646348, ot_letads#646349, ot_later#646350, ot_numexa#646351, ot_codapp#646352, ot_codper3#646353, ot_codtit#646354]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#646267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#646267)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#646268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#646268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#646269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#646269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#646270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#646270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#646271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#646271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#646272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#646272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#646273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#646273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#646274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#646274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#646275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#646275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#646276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#646276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#646277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#646277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#646278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#646278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#646279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#646279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#646280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#646280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#646281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#646281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#646282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#646282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#646283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#646283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#646284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#646284)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#646285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#646285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#646286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#646286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#646287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#646287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#646288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#646288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#646289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#646289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#646290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#646290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#646291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#646291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#646292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#646292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#646293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#646293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#646294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#646294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#646295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#646295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#646296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#646296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#646297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#646297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#646298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#646298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#646299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#646299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#646300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#646300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#646301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#646301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#646302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#646302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#646303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#646303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#646304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#646304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#646305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#646305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#646306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#646306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#646307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#646307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#646308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#646308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#646309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#646309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#646310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#646310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#646311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#646311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#646312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#646312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#646313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#646313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#646314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#646314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#646315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#646315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#646316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#646316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#646317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#646317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#646318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#646318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#646319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#646319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#646320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#646320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#646321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#646321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#646322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#646322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#646323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#646323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#646324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#646324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#646325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#646325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#646326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#646326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#646327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#646327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#646328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#646328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#646329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#646329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#646330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#646330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#646331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#646331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#646332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#646332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#646333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#646333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#646334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#646334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#646335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#646335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#646336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#646336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#646337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#646337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#646338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#646338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#646339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#646339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#646340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#646340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#646341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#646341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#646342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#646342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#646343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#646343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#646344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#646344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#646345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#646345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#646346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#646346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#646347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#646347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#646348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#646348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#646349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#646349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#646350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#646350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#646351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#646351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#646352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#646352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#646353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#646353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#646354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#646354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project [codegen id : 1]
Output: []
Input [88]: [ot_numcot#646267, ot_numdem#646268, ot_numdos#646269, ot_numpco#646270, ot_primai#646271, ot_annval#646272, ot_codcha#646273, ot_codbas#646274, ot_rattac#646275, ot_lettre#646276, ot_coeff#646277, ot_cocal#646278, ot_platre#646279, ot_compar#646280, ot_codper#646281, ot_codser#646282, ot_qtebas#646283, ot_cdam#646284, ot_numsal#646285, ot_nomdos#646286, ot_cr#646287, ot_indbas#646288, ot_inftra#646289, ot_factur#646290, ot_monnaie#646291, ot_tarif#646292, ot_numero#646293, ot_t_red#646294, ot_datmaj#646295, ot_codsit#646296, ot_coduti#646297, ot_flrmo#646298, ot_nuit#646299, ot_majonuit#646300, ot_ferie#646301, ot_majoferie#646302, ot_flald#646303, ot_typexo#646304, ot_avisexo#646305, ot_basrmb#646306, ot_taucai#646307, ot_parcai#646308, ot_flid#646309, ot_mttid#646310, ot_tauid#646311, ot_amoid#646312, ot_mttik#646313, ot_tauik#646314, ot_amoik#646315, ot_nbrikm#646316, ot_mttikm#646317, ot_tauikm#646318, ot_amoikm#646319, ot_mttiks#646320, ot_tauiks#646321, ot_amoiks#646322, ot_taumut#646323, ot_parmut#646324, ot_nbriks#646325, ot_nbrik#646326, ot_numord#646327, ot_ligrgr#646328, ot_fldivise#646329, ot_codpre#646330, ot_majoage#646331, ot_faitlit#646332, ot_qualdp#646333, ot_priuni#646334, ot_denomb#646335, ot_amcid#646336, ot_codlis#646337, ot_coditm#646338, ot_numtli#646339, ot_depmnt#646340, ot_forc#646341, ot_formamc#646342, ot_numcot_ccam#646343, ot_coduam#646344, ot_mtdep#646345, ot_mtpenhps#646346, ot_mttori#646347, ot_codper2#646348, ot_letads#646349, ot_later#646350, ot_numexa#646351, ot_codapp#646352, ot_codper3#646353, ot_codtit#646354]

(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#647156, ot_numdem#647157, ot_numdos#647158, ot_numpco#647159, ot_primai#647160, ot_annval#647161, ot_codcha#647162, ot_codbas#647163, ot_rattac#647164, ot_lettre#647165, ot_coeff#647166, ot_cocal#647167, ot_platre#647168, ot_compar#647169, ot_codper#647170, ot_codser#647171, ot_qtebas#647172, ot_cdam#647173, ot_numsal#647174, ot_nomdos#647175, ot_cr#647176, ot_indbas#647177, ot_inftra#647178, ot_factur#647179, ot_monnaie#647180, ot_tarif#647181, ot_numero#647182, ot_t_red#647183, ot_datmaj#647184, ot_codsit#647185, ot_coduti#647186, ot_flrmo#647187, ot_nuit#647188, ot_majonuit#647189, ot_ferie#647190, ot_majoferie#647191, ot_flald#647192, ot_typexo#647193, ot_avisexo#647194, ot_basrmb#647195, ot_taucai#647196, ot_parcai#647197, ot_flid#647198, ot_mttid#647199, ot_tauid#647200, ot_amoid#647201, ot_mttik#647202, ot_tauik#647203, ot_amoik#647204, ot_nbrikm#647205, ot_mttikm#647206, ot_tauikm#647207, ot_amoikm#647208, ot_mttiks#647209, ot_tauiks#647210, ot_amoiks#647211, ot_taumut#647212, ot_parmut#647213, ot_nbriks#647214, ot_nbrik#647215, ot_numord#647216, ot_ligrgr#647217, ot_fldivise#647218, ot_codpre#647219, ot_majoage#647220, ot_faitlit#647221, ot_qualdp#647222, ot_priuni#647223, ot_denomb#647224, ot_amcid#647225, ot_codlis#647226, ot_coditm#647227, ot_numtli#647228, ot_depmnt#647229, ot_forc#647230, ot_formamc#647231, ot_numcot_ccam#647232, ot_coduam#647233, ot_mtdep#647234, ot_mtpenhps#647235, ot_mttori#647236, ot_codper2#647237, ot_letads#647238, ot_later#647239, ot_numexa#647240, ot_codapp#647241, ot_codper3#647242, ot_codtit#647243]
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#647156, ot_numdem#647157, ot_numdos#647158, ot_numpco#647159, ot_primai#647160, ot_annval#647161, ot_codcha#647162, ot_codbas#647163, ot_rattac#647164, ot_lettre#647165, ot_coeff#647166, ot_cocal#647167, ot_platre#647168, ot_compar#647169, ot_codper#647170, ot_codser#647171, ot_qtebas#647172, ot_cdam#647173, ot_numsal#647174, ot_nomdos#647175, ot_cr#647176, ot_indbas#647177, ot_inftra#647178, ot_factur#647179, ot_monnaie#647180, ot_tarif#647181, ot_numero#647182, ot_t_red#647183, ot_datmaj#647184, ot_codsit#647185, ot_coduti#647186, ot_flrmo#647187, ot_nuit#647188, ot_majonuit#647189, ot_ferie#647190, ot_majoferie#647191, ot_flald#647192, ot_typexo#647193, ot_avisexo#647194, ot_basrmb#647195, ot_taucai#647196, ot_parcai#647197, ot_flid#647198, ot_mttid#647199, ot_tauid#647200, ot_amoid#647201, ot_mttik#647202, ot_tauik#647203, ot_amoik#647204, ot_nbrikm#647205, ot_mttikm#647206, ot_tauikm#647207, ot_amoikm#647208, ot_mttiks#647209, ot_tauiks#647210, ot_amoiks#647211, ot_taumut#647212, ot_parmut#647213, ot_nbriks#647214, ot_nbrik#647215, ot_numord#647216, ot_ligrgr#647217, ot_fldivise#647218, ot_codpre#647219, ot_majoage#647220, ot_faitlit#647221, ot_qualdp#647222, ot_priuni#647223, ot_denomb#647224, ot_amcid#647225, ot_codlis#647226, ot_coditm#647227, ot_numtli#647228, ot_depmnt#647229, ot_forc#647230, ot_formamc#647231, ot_numcot_ccam#647232, ot_coduam#647233, ot_mtdep#647234, ot_mtpenhps#647235, ot_mttori#647236, ot_codper2#647237, ot_letads#647238, ot_later#647239, ot_numexa#647240, ot_codapp#647241, ot_codper3#647242, ot_codtit#647243]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#647156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#647156)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#647157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#647157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#647158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#647158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#647159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#647159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#647160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#647160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#647161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#647161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#647162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#647162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#647163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#647163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#647164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#647164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#647165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#647165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#647166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#647166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#647167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#647167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#647168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#647168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#647169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#647169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#647170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#647170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#647171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#647171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#647172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#647172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#647173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#647173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#647174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#647174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#647175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#647175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#647176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#647176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#647177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#647177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#647178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#647178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#647179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#647179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#647180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#647180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#647181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#647181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#647182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#647182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#647183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#647183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#647184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#647184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#647185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#647185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#647186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#647186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#647187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#647187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#647188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#647188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#647189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#647189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#647190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#647190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#647191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#647191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#647192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#647192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#647193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#647193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#647194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#647194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#647195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#647195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#647196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#647196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#647197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#647197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#647198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#647198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#647199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#647199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#647200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#647200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#647201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#647201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#647202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#647202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#647203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#647203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#647204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#647204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#647205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#647205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#647206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#647206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#647207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#647207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#647208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#647208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#647209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#647209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#647210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#647210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#647211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#647211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#647212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#647212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#647213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#647213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#647214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#647214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#647215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#647215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#647216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#647216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#647217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#647217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#647218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#647218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#647219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#647219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#647220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#647220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#647221)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#647221)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#647222)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#647222)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#647223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#647223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#647224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#647224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#647225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#647225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#647226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#647226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#647227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#647227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#647228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#647228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#647229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#647229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#647230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#647230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#647231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#647231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#647232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#647232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#647233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#647233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#647234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#647234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#647235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#647235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#647236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#647236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#647237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#647237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#647238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#647238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#647239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#647239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#647240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#647240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#647241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#647241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#647242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#647242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#647243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#647243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(6) Project [codegen id : 2]
Output: []
Input [88]: [ot_numcot#647156, ot_numdem#647157, ot_numdos#647158, ot_numpco#647159, ot_primai#647160, ot_annval#647161, ot_codcha#647162, ot_codbas#647163, ot_rattac#647164, ot_lettre#647165, ot_coeff#647166, ot_cocal#647167, ot_platre#647168, ot_compar#647169, ot_codper#647170, ot_codser#647171, ot_qtebas#647172, ot_cdam#647173, ot_numsal#647174, ot_nomdos#647175, ot_cr#647176, ot_indbas#647177, ot_inftra#647178, ot_factur#647179, ot_monnaie#647180, ot_tarif#647181, ot_numero#647182, ot_t_red#647183, ot_datmaj#647184, ot_codsit#647185, ot_coduti#647186, ot_flrmo#647187, ot_nuit#647188, ot_majonuit#647189, ot_ferie#647190, ot_majoferie#647191, ot_flald#647192, ot_typexo#647193, ot_avisexo#647194, ot_basrmb#647195, ot_taucai#647196, ot_parcai#647197, ot_flid#647198, ot_mttid#647199, ot_tauid#647200, ot_amoid#647201, ot_mttik#647202, ot_tauik#647203, ot_amoik#647204, ot_nbrikm#647205, ot_mttikm#647206, ot_tauikm#647207, ot_amoikm#647208, ot_mttiks#647209, ot_tauiks#647210, ot_amoiks#647211, ot_taumut#647212, ot_parmut#647213, ot_nbriks#647214, ot_nbrik#647215, ot_numord#647216, ot_ligrgr#647217, ot_fldivise#647218, ot_codpre#647219, ot_majoage#647220, ot_faitlit#647221, ot_qualdp#647222, ot_priuni#647223, ot_denomb#647224, ot_amcid#647225, ot_codlis#647226, ot_coditm#647227, ot_numtli#647228, ot_depmnt#647229, ot_forc#647230, ot_formamc#647231, ot_numcot_ccam#647232, ot_coduam#647233, ot_mtdep#647234, ot_mtpenhps#647235, ot_mttori#647236, ot_codper2#647237, ot_letads#647238, ot_later#647239, ot_numexa#647240, ot_codapp#647241, ot_codper3#647242, ot_codtit#647243]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#648857L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#648669L]
Results [1]: [count(1)#648669L AS COL_08e7830b-1e86-49f5-bd1c-ac5b76ac85ca#648671L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#648857L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#648669L]
Results [1]: [count(1)#648669L AS COL_08e7830b-1e86-49f5-bd1c-ac5b76ac85ca#648671L]

(16) AdaptiveSparkPlan
Output [1]: [COL_08e7830b-1e86-49f5-bd1c-ac5b76ac85ca#648671L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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