hdh-spark-job - Details for Query 1374

Submitted Time: 2026/10/23 13:28:10
Duration: 24 s
Succeeded Jobs: 1374 1379

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 1989.0: task 1735)) 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 1989.0: task 1736)) 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 1989.0: task 1736))"]; 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 1989.0: task 1735))"; 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 1989.0: task 1735)) 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=37068]

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#683313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#683313)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#683314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#683314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#683315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#683315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#683316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#683316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#683317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#683317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#683318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#683318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#683319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#683319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#683320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#683320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#683321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#683321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#683322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#683322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#683323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#683323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#683324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#683324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#683325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#683325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#683326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#683326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#683327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#683327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#683328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#683328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#683329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#683329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#683330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#683330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#683331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#683331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#683332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#683332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#683333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#683333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#683334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#683334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#683335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#683335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#683336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#683336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#683337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#683337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#683338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#683338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#683339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#683339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#683340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#683340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#683341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#683341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#683342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#683342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#683343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#683343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#683344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#683344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#683345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#683345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#683346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#683346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#683347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#683347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#683348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#683348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#683349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#683349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#683350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#683350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#683351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#683351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#683352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#683352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#683353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#683353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#683354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#683354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#683355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#683355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#683356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#683356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#683357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#683357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#683358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#683358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#683359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#683359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#683360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#683360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#683361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#683361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#683362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#683362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#683363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#683363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#683364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#683364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#683365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#683365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#683366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#683366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#683367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#683367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#683368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#683368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#683369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#683369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#683370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#683370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#683371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#683371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#683372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#683372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#683373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#683373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#683374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#683374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#683375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#683375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#683376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#683376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#683377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#683377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#683378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#683378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#683379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#683379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#683380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#683380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#683381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#683381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#683382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#683382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#683383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#683383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#683384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#683384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#683385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#683385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#683386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#683386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#683387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#683387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#683388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#683388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#683389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#683389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#683390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#683390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#683391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#683391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#683392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#683392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#683393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#683393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#683394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#683394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#683395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#683395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#683396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#683396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#683397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#683397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#683398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#683398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#683399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#683399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#683400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#683400)), 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#683313,ot_numdem#683314,ot_numdos#683315,ot_numpco#683316,ot_primai#683317,ot_annval#683318,ot_codcha#683319,ot_codbas#683320,ot_rattac#683321,ot_lettre#683322,ot_coeff#683323,ot_cocal#683324,ot_platre#683325,ot_compar#683326,ot_codper#683327,ot_codser#683328,ot_qtebas#683329,ot_cdam#683330,ot_numsal#683331,ot_nomdos#683332,ot_cr#683333,ot_indbas#683334,ot_inftra#683335,ot_factur#683336,... 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#684108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#684108)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#684109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#684109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#684110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#684110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#684111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#684111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#684112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#684112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#684113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#684113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#684114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#684114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#684115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#684115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#684116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#684116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#684117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#684117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#684118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#684118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#684119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#684119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#684120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#684120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#684121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#684121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#684122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#684122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#684123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#684123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#684124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#684124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#684125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#684125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#684126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#684126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#684127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#684127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#684128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#684128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#684129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#684129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#684130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#684130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#684131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#684131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#684132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#684132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#684133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#684133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#684134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#684134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#684135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#684135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#684136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#684136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#684137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#684137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#684138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#684138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#684139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#684139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#684140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#684140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#684141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#684141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#684142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#684142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#684143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#684143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#684144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#684144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#684145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#684145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#684146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#684146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#684147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#684147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#684148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#684148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#684149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#684149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#684150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#684150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#684151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#684151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#684152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#684152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#684153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#684153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#684154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#684154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#684155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#684155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#684156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#684156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#684157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#684157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#684158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#684158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#684159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#684159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#684160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#684160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#684161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#684161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#684162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#684162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#684163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#684163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#684164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#684164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#684165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#684165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#684166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#684166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#684167)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#684167)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#684168)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#684168)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#684169)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#684169)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#684170)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#684170)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#684171)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#684171)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#684172)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#684172)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#684173)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#684173)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#684174)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#684174)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#684175)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#684175)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#684176)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#684176)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#684177)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#684177)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#684178)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#684178)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#684179)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#684179)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#684180)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#684180)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#684181)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#684181)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#684182)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#684182)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#684183)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#684183)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#684184)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#684184)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#684185)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#684185)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#684186)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#684186)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#684187)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#684187)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#684188)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#684188)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#684189)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#684189)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#684190)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#684190)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#684191)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#684191)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#684192)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#684192)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#684193)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#684193)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#684194)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#684194)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#684195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#684195)), 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#684108,ot_numdem#684109,ot_numdos#684110,ot_numpco#684111,ot_primai#684112,ot_annval#684113,ot_codcha#684114,ot_codbas#684115,ot_rattac#684116,ot_lettre#684117,ot_coeff#684118,ot_cocal#684119,ot_platre#684120,ot_compar#684121,ot_codper#684122,ot_codser#684123,ot_qtebas#684124,ot_cdam#684125,ot_numsal#684126,ot_nomdos#684127,ot_cr#684128,ot_indbas#684129,ot_inftra#684130,ot_factur#684131,... 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#683313, ot_numdem#683314, ot_numdos#683315, ot_numpco#683316, ot_primai#683317, ot_annval#683318, ot_codcha#683319, ot_codbas#683320, ot_rattac#683321, ot_lettre#683322, ot_coeff#683323, ot_cocal#683324, ot_platre#683325, ot_compar#683326, ot_codper#683327, ot_codser#683328, ot_qtebas#683329, ot_cdam#683330, ot_numsal#683331, ot_nomdos#683332, ot_cr#683333, ot_indbas#683334, ot_inftra#683335, ot_factur#683336, ot_monnaie#683337, ot_tarif#683338, ot_numero#683339, ot_t_red#683340, ot_datmaj#683341, ot_codsit#683342, ot_coduti#683343, ot_flrmo#683344, ot_nuit#683345, ot_majonuit#683346, ot_ferie#683347, ot_majoferie#683348, ot_flald#683349, ot_typexo#683350, ot_avisexo#683351, ot_basrmb#683352, ot_taucai#683353, ot_parcai#683354, ot_flid#683355, ot_mttid#683356, ot_tauid#683357, ot_amoid#683358, ot_mttik#683359, ot_tauik#683360, ot_amoik#683361, ot_nbrikm#683362, ot_mttikm#683363, ot_tauikm#683364, ot_amoikm#683365, ot_mttiks#683366, ot_tauiks#683367, ot_amoiks#683368, ot_taumut#683369, ot_parmut#683370, ot_nbriks#683371, ot_nbrik#683372, ot_numord#683373, ot_ligrgr#683374, ot_fldivise#683375, ot_codpre#683376, ot_majoage#683377, ot_faitlit#683378, ot_qualdp#683379, ot_priuni#683380, ot_denomb#683381, ot_amcid#683382, ot_codlis#683383, ot_coditm#683384, ot_numtli#683385, ot_depmnt#683386, ot_forc#683387, ot_formamc#683388, ot_numcot_ccam#683389, ot_coduam#683390, ot_mtdep#683391, ot_mtpenhps#683392, ot_mttori#683393, ot_codper2#683394, ot_letads#683395, ot_later#683396, ot_numexa#683397, ot_codapp#683398, ot_codper3#683399, ot_codtit#683400]
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#683313, ot_numdem#683314, ot_numdos#683315, ot_numpco#683316, ot_primai#683317, ot_annval#683318, ot_codcha#683319, ot_codbas#683320, ot_rattac#683321, ot_lettre#683322, ot_coeff#683323, ot_cocal#683324, ot_platre#683325, ot_compar#683326, ot_codper#683327, ot_codser#683328, ot_qtebas#683329, ot_cdam#683330, ot_numsal#683331, ot_nomdos#683332, ot_cr#683333, ot_indbas#683334, ot_inftra#683335, ot_factur#683336, ot_monnaie#683337, ot_tarif#683338, ot_numero#683339, ot_t_red#683340, ot_datmaj#683341, ot_codsit#683342, ot_coduti#683343, ot_flrmo#683344, ot_nuit#683345, ot_majonuit#683346, ot_ferie#683347, ot_majoferie#683348, ot_flald#683349, ot_typexo#683350, ot_avisexo#683351, ot_basrmb#683352, ot_taucai#683353, ot_parcai#683354, ot_flid#683355, ot_mttid#683356, ot_tauid#683357, ot_amoid#683358, ot_mttik#683359, ot_tauik#683360, ot_amoik#683361, ot_nbrikm#683362, ot_mttikm#683363, ot_tauikm#683364, ot_amoikm#683365, ot_mttiks#683366, ot_tauiks#683367, ot_amoiks#683368, ot_taumut#683369, ot_parmut#683370, ot_nbriks#683371, ot_nbrik#683372, ot_numord#683373, ot_ligrgr#683374, ot_fldivise#683375, ot_codpre#683376, ot_majoage#683377, ot_faitlit#683378, ot_qualdp#683379, ot_priuni#683380, ot_denomb#683381, ot_amcid#683382, ot_codlis#683383, ot_coditm#683384, ot_numtli#683385, ot_depmnt#683386, ot_forc#683387, ot_formamc#683388, ot_numcot_ccam#683389, ot_coduam#683390, ot_mtdep#683391, ot_mtpenhps#683392, ot_mttori#683393, ot_codper2#683394, ot_letads#683395, ot_later#683396, ot_numexa#683397, ot_codapp#683398, ot_codper3#683399, ot_codtit#683400]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#683313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#683313)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#683314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#683314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#683315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#683315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#683316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#683316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#683317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#683317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#683318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#683318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#683319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#683319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#683320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#683320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#683321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#683321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#683322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#683322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#683323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#683323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#683324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#683324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#683325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#683325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#683326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#683326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#683327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#683327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#683328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#683328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#683329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#683329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#683330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#683330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#683331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#683331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#683332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#683332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#683333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#683333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#683334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#683334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#683335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#683335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#683336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#683336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#683337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#683337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#683338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#683338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#683339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#683339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#683340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#683340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#683341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#683341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#683342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#683342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#683343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#683343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#683344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#683344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#683345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#683345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#683346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#683346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#683347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#683347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#683348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#683348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#683349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#683349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#683350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#683350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#683351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#683351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#683352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#683352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#683353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#683353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#683354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#683354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#683355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#683355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#683356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#683356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#683357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#683357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#683358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#683358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#683359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#683359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#683360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#683360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#683361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#683361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#683362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#683362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#683363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#683363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#683364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#683364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#683365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#683365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#683366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#683366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#683367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#683367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#683368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#683368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#683369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#683369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#683370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#683370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#683371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#683371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#683372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#683372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#683373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#683373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#683374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#683374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#683375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#683375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#683376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#683376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#683377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#683377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#683378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#683378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#683379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#683379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#683380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#683380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#683381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#683381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#683382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#683382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#683383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#683383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#683384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#683384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#683385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#683385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#683386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#683386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#683387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#683387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#683388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#683388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#683389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#683389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#683390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#683390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#683391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#683391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#683392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#683392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#683393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#683393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#683394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#683394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#683395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#683395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#683396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#683396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#683397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#683397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#683398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#683398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#683399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#683399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#683400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#683400)), 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#683313, ot_numdem#683314, ot_numdos#683315, ot_numpco#683316, ot_primai#683317, ot_annval#683318, ot_codcha#683319, ot_codbas#683320, ot_rattac#683321, ot_lettre#683322, ot_coeff#683323, ot_cocal#683324, ot_platre#683325, ot_compar#683326, ot_codper#683327, ot_codser#683328, ot_qtebas#683329, ot_cdam#683330, ot_numsal#683331, ot_nomdos#683332, ot_cr#683333, ot_indbas#683334, ot_inftra#683335, ot_factur#683336, ot_monnaie#683337, ot_tarif#683338, ot_numero#683339, ot_t_red#683340, ot_datmaj#683341, ot_codsit#683342, ot_coduti#683343, ot_flrmo#683344, ot_nuit#683345, ot_majonuit#683346, ot_ferie#683347, ot_majoferie#683348, ot_flald#683349, ot_typexo#683350, ot_avisexo#683351, ot_basrmb#683352, ot_taucai#683353, ot_parcai#683354, ot_flid#683355, ot_mttid#683356, ot_tauid#683357, ot_amoid#683358, ot_mttik#683359, ot_tauik#683360, ot_amoik#683361, ot_nbrikm#683362, ot_mttikm#683363, ot_tauikm#683364, ot_amoikm#683365, ot_mttiks#683366, ot_tauiks#683367, ot_amoiks#683368, ot_taumut#683369, ot_parmut#683370, ot_nbriks#683371, ot_nbrik#683372, ot_numord#683373, ot_ligrgr#683374, ot_fldivise#683375, ot_codpre#683376, ot_majoage#683377, ot_faitlit#683378, ot_qualdp#683379, ot_priuni#683380, ot_denomb#683381, ot_amcid#683382, ot_codlis#683383, ot_coditm#683384, ot_numtli#683385, ot_depmnt#683386, ot_forc#683387, ot_formamc#683388, ot_numcot_ccam#683389, ot_coduam#683390, ot_mtdep#683391, ot_mtpenhps#683392, ot_mttori#683393, ot_codper2#683394, ot_letads#683395, ot_later#683396, ot_numexa#683397, ot_codapp#683398, ot_codper3#683399, ot_codtit#683400]

(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#684108, ot_numdem#684109, ot_numdos#684110, ot_numpco#684111, ot_primai#684112, ot_annval#684113, ot_codcha#684114, ot_codbas#684115, ot_rattac#684116, ot_lettre#684117, ot_coeff#684118, ot_cocal#684119, ot_platre#684120, ot_compar#684121, ot_codper#684122, ot_codser#684123, ot_qtebas#684124, ot_cdam#684125, ot_numsal#684126, ot_nomdos#684127, ot_cr#684128, ot_indbas#684129, ot_inftra#684130, ot_factur#684131, ot_monnaie#684132, ot_tarif#684133, ot_numero#684134, ot_t_red#684135, ot_datmaj#684136, ot_codsit#684137, ot_coduti#684138, ot_flrmo#684139, ot_nuit#684140, ot_majonuit#684141, ot_ferie#684142, ot_majoferie#684143, ot_flald#684144, ot_typexo#684145, ot_avisexo#684146, ot_basrmb#684147, ot_taucai#684148, ot_parcai#684149, ot_flid#684150, ot_mttid#684151, ot_tauid#684152, ot_amoid#684153, ot_mttik#684154, ot_tauik#684155, ot_amoik#684156, ot_nbrikm#684157, ot_mttikm#684158, ot_tauikm#684159, ot_amoikm#684160, ot_mttiks#684161, ot_tauiks#684162, ot_amoiks#684163, ot_taumut#684164, ot_parmut#684165, ot_nbriks#684166, ot_nbrik#684167, ot_numord#684168, ot_ligrgr#684169, ot_fldivise#684170, ot_codpre#684171, ot_majoage#684172, ot_faitlit#684173, ot_qualdp#684174, ot_priuni#684175, ot_denomb#684176, ot_amcid#684177, ot_codlis#684178, ot_coditm#684179, ot_numtli#684180, ot_depmnt#684181, ot_forc#684182, ot_formamc#684183, ot_numcot_ccam#684184, ot_coduam#684185, ot_mtdep#684186, ot_mtpenhps#684187, ot_mttori#684188, ot_codper2#684189, ot_letads#684190, ot_later#684191, ot_numexa#684192, ot_codapp#684193, ot_codper3#684194, ot_codtit#684195]
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#684108, ot_numdem#684109, ot_numdos#684110, ot_numpco#684111, ot_primai#684112, ot_annval#684113, ot_codcha#684114, ot_codbas#684115, ot_rattac#684116, ot_lettre#684117, ot_coeff#684118, ot_cocal#684119, ot_platre#684120, ot_compar#684121, ot_codper#684122, ot_codser#684123, ot_qtebas#684124, ot_cdam#684125, ot_numsal#684126, ot_nomdos#684127, ot_cr#684128, ot_indbas#684129, ot_inftra#684130, ot_factur#684131, ot_monnaie#684132, ot_tarif#684133, ot_numero#684134, ot_t_red#684135, ot_datmaj#684136, ot_codsit#684137, ot_coduti#684138, ot_flrmo#684139, ot_nuit#684140, ot_majonuit#684141, ot_ferie#684142, ot_majoferie#684143, ot_flald#684144, ot_typexo#684145, ot_avisexo#684146, ot_basrmb#684147, ot_taucai#684148, ot_parcai#684149, ot_flid#684150, ot_mttid#684151, ot_tauid#684152, ot_amoid#684153, ot_mttik#684154, ot_tauik#684155, ot_amoik#684156, ot_nbrikm#684157, ot_mttikm#684158, ot_tauikm#684159, ot_amoikm#684160, ot_mttiks#684161, ot_tauiks#684162, ot_amoiks#684163, ot_taumut#684164, ot_parmut#684165, ot_nbriks#684166, ot_nbrik#684167, ot_numord#684168, ot_ligrgr#684169, ot_fldivise#684170, ot_codpre#684171, ot_majoage#684172, ot_faitlit#684173, ot_qualdp#684174, ot_priuni#684175, ot_denomb#684176, ot_amcid#684177, ot_codlis#684178, ot_coditm#684179, ot_numtli#684180, ot_depmnt#684181, ot_forc#684182, ot_formamc#684183, ot_numcot_ccam#684184, ot_coduam#684185, ot_mtdep#684186, ot_mtpenhps#684187, ot_mttori#684188, ot_codper2#684189, ot_letads#684190, ot_later#684191, ot_numexa#684192, ot_codapp#684193, ot_codper3#684194, ot_codtit#684195]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot#684108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot#684108)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdem#684109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdem#684109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numdos#684110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numdos#684110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numpco#684111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numpco#684111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_primai#684112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_primai#684112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_annval#684113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_annval#684113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codcha#684114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codcha#684114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codbas#684115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codbas#684115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_rattac#684116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_rattac#684116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_lettre#684117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_lettre#684117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coeff#684118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coeff#684118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cocal#684119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cocal#684119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_platre#684120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_platre#684120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_compar#684121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_compar#684121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper#684122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper#684122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codser#684123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codser#684123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qtebas#684124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qtebas#684124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cdam#684125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cdam#684125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numsal#684126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numsal#684126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nomdos#684127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nomdos#684127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_cr#684128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_cr#684128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_indbas#684129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_indbas#684129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_inftra#684130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_inftra#684130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_factur#684131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_factur#684131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_monnaie#684132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_monnaie#684132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tarif#684133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tarif#684133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numero#684134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numero#684134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_t_red#684135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_t_red#684135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_datmaj#684136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_datmaj#684136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codsit#684137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codsit#684137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduti#684138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduti#684138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flrmo#684139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flrmo#684139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nuit#684140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nuit#684140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majonuit#684141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majonuit#684141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ferie#684142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ferie#684142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoferie#684143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoferie#684143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flald#684144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flald#684144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_typexo#684145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_typexo#684145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_avisexo#684146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_avisexo#684146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_basrmb#684147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_basrmb#684147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taucai#684148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taucai#684148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parcai#684149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parcai#684149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_flid#684150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_flid#684150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttid#684151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttid#684151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauid#684152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauid#684152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoid#684153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoid#684153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttik#684154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttik#684154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauik#684155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauik#684155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoik#684156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoik#684156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrikm#684157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrikm#684157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttikm#684158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttikm#684158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauikm#684159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauikm#684159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoikm#684160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoikm#684160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttiks#684161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttiks#684161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_tauiks#684162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_tauiks#684162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amoiks#684163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amoiks#684163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_taumut#684164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_taumut#684164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_parmut#684165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_parmut#684165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbriks#684166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbriks#684166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_nbrik#684167)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_nbrik#684167)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numord#684168)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numord#684168)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_ligrgr#684169)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_ligrgr#684169)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_fldivise#684170)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_fldivise#684170)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codpre#684171)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codpre#684171)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_majoage#684172)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_majoage#684172)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_faitlit#684173)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_faitlit#684173)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_qualdp#684174)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_qualdp#684174)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_priuni#684175)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_priuni#684175)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_denomb#684176)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_denomb#684176)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_amcid#684177)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_amcid#684177)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codlis#684178)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codlis#684178)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coditm#684179)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coditm#684179)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numtli#684180)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numtli#684180)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_depmnt#684181)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_depmnt#684181)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_forc#684182)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_forc#684182)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_formamc#684183)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_formamc#684183)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numcot_ccam#684184)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numcot_ccam#684184)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_coduam#684185)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_coduam#684185)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtdep#684186)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtdep#684186)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mtpenhps#684187)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mtpenhps#684187)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_mttori#684188)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_mttori#684188)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper2#684189)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper2#684189)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_letads#684190)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_letads#684190)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_later#684191)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_later#684191)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_numexa#684192)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_numexa#684192)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codapp#684193)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codapp#684193)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codper3#684194)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codper3#684194)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ot_codtit#684195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ot_codtit#684195)), 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#684108, ot_numdem#684109, ot_numdos#684110, ot_numpco#684111, ot_primai#684112, ot_annval#684113, ot_codcha#684114, ot_codbas#684115, ot_rattac#684116, ot_lettre#684117, ot_coeff#684118, ot_cocal#684119, ot_platre#684120, ot_compar#684121, ot_codper#684122, ot_codser#684123, ot_qtebas#684124, ot_cdam#684125, ot_numsal#684126, ot_nomdos#684127, ot_cr#684128, ot_indbas#684129, ot_inftra#684130, ot_factur#684131, ot_monnaie#684132, ot_tarif#684133, ot_numero#684134, ot_t_red#684135, ot_datmaj#684136, ot_codsit#684137, ot_coduti#684138, ot_flrmo#684139, ot_nuit#684140, ot_majonuit#684141, ot_ferie#684142, ot_majoferie#684143, ot_flald#684144, ot_typexo#684145, ot_avisexo#684146, ot_basrmb#684147, ot_taucai#684148, ot_parcai#684149, ot_flid#684150, ot_mttid#684151, ot_tauid#684152, ot_amoid#684153, ot_mttik#684154, ot_tauik#684155, ot_amoik#684156, ot_nbrikm#684157, ot_mttikm#684158, ot_tauikm#684159, ot_amoikm#684160, ot_mttiks#684161, ot_tauiks#684162, ot_amoiks#684163, ot_taumut#684164, ot_parmut#684165, ot_nbriks#684166, ot_nbrik#684167, ot_numord#684168, ot_ligrgr#684169, ot_fldivise#684170, ot_codpre#684171, ot_majoage#684172, ot_faitlit#684173, ot_qualdp#684174, ot_priuni#684175, ot_denomb#684176, ot_amcid#684177, ot_codlis#684178, ot_coditm#684179, ot_numtli#684180, ot_depmnt#684181, ot_forc#684182, ot_formamc#684183, ot_numcot_ccam#684184, ot_coduam#684185, ot_mtdep#684186, ot_mtpenhps#684187, ot_mttori#684188, ot_codper2#684189, ot_letads#684190, ot_later#684191, ot_numexa#684192, ot_codapp#684193, ot_codper3#684194, ot_codtit#684195]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#685801L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#685615L]
Results [1]: [count(1)#685615L AS COL_d0e3aa5d-8723-443f-a538-e54166902ad9#685617L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#685801L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#685615L]
Results [1]: [count(1)#685615L AS COL_d0e3aa5d-8723-443f-a538-e54166902ad9#685617L]

(16) AdaptiveSparkPlan
Output [1]: [COL_d0e3aa5d-8723-443f-a538-e54166902ad9#685617L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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