hdh-spark-job - Details for Query 1370

Submitted Time: 2026/10/23 13:28:08
Duration: 11 s
Succeeded Jobs: 1369 1373

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 1981.0: task 1728)) 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: 118.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 1981.0: task 1727)) 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)) 118.0 B (59.0 B, 59.0 B, 59.0 B (stage 1981.0: task 1727))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n6.0 s (2.9 s, 3.1 s, 3.1 s (stage 1981.0: task 1727))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 6.0 s (2.9 s, 3.1 s, 3.1 s (stage 1981.0: task 1727)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 3.1 s"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 735"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"et_numexa\", \"et_numdos\", \"et_numdem\", \"et_typexa\", \"et_codexa\", \"et_exaacc\", \"et_libexa\", \"et_codapp\", \"et_numsal\", \"et_codper\", \"et_codrad\", \"et_codpro\", \"et_m_am_i\", \"et_ag_on\", \"et_datexa\", \"et_heuexa\", \"et_heusal\", \"et_heufin\", \"et_durtot\", \"et_durava\", \"et_durpen\", \"et_durapr\", \"et_datarr\", \"et_heuarr\", \"et_heud_e\", \"et_heuf_e\", \"et_codsit\", \"et_datmaj\", \"et_coduti\", \"et_numsat\", \"et_affect\", \"et_stu_id\", \"et_sta_pps\", \"et_sop_uid\", \"et_numgrp\", \"et_carrdv\", \"et_sanscr\", \"et_codats\", \"et_stabcd\", \"et_typesclq\", \"et_typbcd\", \"et_codprx\", \"et_flplan\", \"et_available\", \"et_aetitle\", \"et_secondaire\", \"et_mednuc\", \"et_fltbdi\", \"et_codfvu\", \"et_datfvu\", \"et_heufvu\", \"et_suspens\", \"et_acados\", \"et_acapub\", \"et_acamed\", \"et_acalib\", \"et_later\", \"et_position\", \"et_incidence\", \"et_numpdt\", \"et_numord\", \"et_trstat\", \"et_organe\", \"et_heuapp\", \"et_orirdv\", \"et_codvac\", \"et_codvaca\", \"et_numxus\", \"et_numexa_ori\", \"et_exacot\", \"et_flnocot\", \"et_alarmes\", \"et_modal_aet\", \"et_numprore\", \"et_comprore\", \"et_numrvx\", \"et_noseq\", \"et_datfin\", \"et_numresa\", \"et_fhirid\", \"et_regana\", \"et_nb_ser\", \"et_nb_fic\", \"et_nb_img_key\", \"et_stu_id_ori\", \"et_codper_prore\", \"et_numseance\", \"et_numordseance\", \"et_numtrt\", \"et_comment\", \"et_codloinc\" FROM \"xplore\".\"h_detexa\") as x) [numPartitions=1] number of output rows: 34,851"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 2.9 s"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 735"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"et_numexa\", \"et_numdos\", \"et_numdem\", \"et_typexa\", \"et_codexa\", \"et_exaacc\", \"et_libexa\", \"et_codapp\", \"et_numsal\", \"et_codper\", \"et_codrad\", \"et_codpro\", \"et_m_am_i\", \"et_ag_on\", \"et_datexa\", \"et_heuexa\", \"et_heusal\", \"et_heufin\", \"et_durtot\", \"et_durava\", \"et_durpen\", \"et_durapr\", \"et_datarr\", \"et_heuarr\", \"et_heud_e\", \"et_heuf_e\", \"et_codsit\", \"et_datmaj\", \"et_coduti\", \"et_numsat\", \"et_affect\", \"et_stu_id\", \"et_sta_pps\", \"et_sop_uid\", \"et_numgrp\", \"et_carrdv\", \"et_sanscr\", \"et_codats\", \"et_stabcd\", \"et_typesclq\", \"et_typbcd\", \"et_codprx\", \"et_flplan\", \"et_available\", \"et_aetitle\", \"et_secondaire\", \"et_mednuc\", \"et_fltbdi\", \"et_codfvu\", \"et_datfvu\", \"et_heufvu\", \"et_suspens\", \"et_acados\", \"et_acapub\", \"et_acamed\", \"et_acalib\", \"et_later\", \"et_position\", \"et_incidence\", \"et_numpdt\", \"et_numord\", \"et_trstat\", \"et_organe\", \"et_heuapp\", \"et_orirdv\", \"et_codvac\", \"et_codvaca\", \"et_numxus\", \"et_numexa_ori\", \"et_exacot\", \"et_flnocot\", \"et_alarmes\", \"et_modal_aet\", \"et_numprore\", \"et_comprore\", \"et_numrvx\", \"et_noseq\", \"et_datfin\", \"et_numresa\", \"et_fhirid\", \"et_regana\", \"et_nb_ser\", \"et_nb_fic\", \"et_nb_img_key\", \"et_stu_id_ori\", \"et_codper_prore\", \"et_numseance\", \"et_numordseance\", \"et_numtrt\", \"et_comment\", \"et_codloinc\" FROM \"xplore2\".\"h_detexa\") as x) [numPartitions=1] number of output rows: 34,851"]; } 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=36902]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#678467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#678467)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#678468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#678468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#678469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#678469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#678470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#678470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#678471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#678471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#678472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#678472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#678473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#678473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#678474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#678474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#678475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#678475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#678476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#678476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#678477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#678477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#678478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#678478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#678479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#678479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#678480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#678480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#678481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#678481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#678482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#678482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#678483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#678483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#678484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#678484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#678485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#678485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#678486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#678486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#678487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#678487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#678488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#678488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#678489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#678489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#678490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#678490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#678491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#678491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#678492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#678492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#678493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#678493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#678494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#678494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#678495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#678495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#678496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#678496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#678497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#678497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#678498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#678498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#678499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#678499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#678500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#678500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#678501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#678501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#678502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#678502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#678503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#678503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#678504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#678504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#678505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#678505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#678506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#678506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#678507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#678507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#678508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#678508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#678509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#678509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#678510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#678510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#678511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#678511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#678512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#678512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#678513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#678513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#678514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#678514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#678515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#678515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#678516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#678516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#678517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#678517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#678518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#678518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#678519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#678519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#678520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#678520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#678521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#678521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#678522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#678522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#678523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#678523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#678524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#678524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#678525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#678525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#678526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#678526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#678527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#678527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#678528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#678528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#678529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#678529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#678530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#678530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#678531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#678531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#678532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#678532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#678533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#678533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#678534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#678534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#678535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#678535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#678536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#678536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#678537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#678537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#678538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#678538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#678539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#678539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#678540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#678540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#678541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#678541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#678542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#678542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#678543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#678543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#678544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#678544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#678545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#678545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#678546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#678546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#678547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#678547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#678548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#678548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#678549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#678549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#678550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#678550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#678551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#678551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#678552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#678552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#678553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#678553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#678554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#678554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#678555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#678555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#678556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#678556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#678557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#678557)), 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 "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1] [et_numexa#678467,et_numdos#678468,et_numdem#678469,et_typexa#678470,et_codexa#678471,et_exaacc#678472,et_libexa#678473,et_codapp#678474,et_numsal#678475,et_codper#678476,et_codrad#678477,et_codpro#678478,et_m_am_i#678479,et_ag_on#678480,et_datexa#678481,et_heuexa#678482,et_heusal#678483,et_heufin#678484,et_durtot#678485,et_durava#678486,et_durpen#678487,et_durapr#678488,et_datarr#678489,et_heuarr#678490,... 67 more fields] PushedFilters: [], ReadSchema: struct<et_numexa:string,et_numdos:string,et_numdem:string,et_typexa:string,et_codexa:string,et_ex...

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#679289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#679289)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#679290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#679290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#679291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#679291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#679292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#679292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#679293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#679293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#679294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#679294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#679295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#679295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#679296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#679296)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#679297)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#679297)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#679298)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#679298)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#679299)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#679299)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#679300)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#679300)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#679301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#679301)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#679302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#679302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#679303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#679303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#679304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#679304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#679305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#679305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#679306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#679306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#679307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#679307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#679308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#679308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#679309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#679309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#679310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#679310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#679311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#679311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#679312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#679312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#679313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#679313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#679314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#679314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#679315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#679315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#679316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#679316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#679317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#679317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#679318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#679318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#679319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#679319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#679320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#679320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#679321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#679321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#679322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#679322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#679323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#679323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#679324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#679324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#679325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#679325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#679326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#679326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#679327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#679327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#679328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#679328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#679329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#679329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#679330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#679330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#679331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#679331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#679332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#679332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#679333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#679333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#679334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#679334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#679335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#679335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#679336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#679336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#679337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#679337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#679338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#679338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#679339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#679339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#679340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#679340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#679341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#679341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#679342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#679342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#679343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#679343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#679344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#679344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#679345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#679345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#679346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#679346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#679347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#679347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#679348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#679348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#679349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#679349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#679350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#679350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#679351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#679351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#679352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#679352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#679353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#679353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#679354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#679354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#679355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#679355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#679356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#679356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#679357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#679357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#679358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#679358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#679359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#679359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#679360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#679360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#679361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#679361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#679362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#679362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#679363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#679363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#679364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#679364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#679365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#679365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#679366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#679366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#679367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#679367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#679368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#679368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#679369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#679369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#679370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#679370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#679371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#679371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#679372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#679372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#679373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#679373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#679374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#679374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#679375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#679375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#679376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#679376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#679377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#679377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#679378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#679378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#679379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#679379)), 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 "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1] [et_numexa#679289,et_numdos#679290,et_numdem#679291,et_typexa#679292,et_codexa#679293,et_exaacc#679294,et_libexa#679295,et_codapp#679296,et_numsal#679297,et_codper#679298,et_codrad#679299,et_codpro#679300,et_m_am_i#679301,et_ag_on#679302,et_datexa#679303,et_heuexa#679304,et_heusal#679305,et_heufin#679306,et_durtot#679307,et_durava#679308,et_durpen#679309,et_durapr#679310,et_datarr#679311,et_heuarr#679312,... 67 more fields] PushedFilters: [], ReadSchema: struct<et_numexa:string,et_numdos:string,et_numdem:string,et_typexa:string,et_codexa:string,et_ex...

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 "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1]  [codegen id : 1]
Output [91]: [et_numexa#678467, et_numdos#678468, et_numdem#678469, et_typexa#678470, et_codexa#678471, et_exaacc#678472, et_libexa#678473, et_codapp#678474, et_numsal#678475, et_codper#678476, et_codrad#678477, et_codpro#678478, et_m_am_i#678479, et_ag_on#678480, et_datexa#678481, et_heuexa#678482, et_heusal#678483, et_heufin#678484, et_durtot#678485, et_durava#678486, et_durpen#678487, et_durapr#678488, et_datarr#678489, et_heuarr#678490, et_heud_e#678491, et_heuf_e#678492, et_codsit#678493, et_datmaj#678494, et_coduti#678495, et_numsat#678496, et_affect#678497, et_stu_id#678498, et_sta_pps#678499, et_sop_uid#678500, et_numgrp#678501, et_carrdv#678502, et_sanscr#678503, et_codats#678504, et_stabcd#678505, et_typesclq#678506, et_typbcd#678507, et_codprx#678508, et_flplan#678509, et_available#678510, et_aetitle#678511, et_secondaire#678512, et_mednuc#678513, et_fltbdi#678514, et_codfvu#678515, et_datfvu#678516, et_heufvu#678517, et_suspens#678518, et_acados#678519, et_acapub#678520, et_acamed#678521, et_acalib#678522, et_later#678523, et_position#678524, et_incidence#678525, et_numpdt#678526, et_numord#678527, et_trstat#678528, et_organe#678529, et_heuapp#678530, et_orirdv#678531, et_codvac#678532, et_codvaca#678533, et_numxus#678534, et_numexa_ori#678535, et_exacot#678536, et_flnocot#678537, et_alarmes#678538, et_modal_aet#678539, et_numprore#678540, et_comprore#678541, et_numrvx#678542, et_noseq#678543, et_datfin#678544, et_numresa#678545, et_fhirid#678546, et_regana#678547, et_nb_ser#678548, et_nb_fic#678549, et_nb_img_key#678550, et_stu_id_ori#678551, et_codper_prore#678552, et_numseance#678553, et_numordseance#678554, et_numtrt#678555, et_comment#678556, et_codloinc#678557]
ReadSchema: struct<et_numexa:string,et_numdos:string,et_numdem:string,et_typexa:string,et_codexa:string,et_exaacc:string,et_libexa:string,et_codapp:string,et_numsal:string,et_codper:string,et_codrad:string,et_codpro:string,et_m_am_i:string,et_ag_on:string,et_datexa:string,et_heuexa:string,et_heusal:string,et_heufin:string,et_durtot:string,et_durava:string,et_durpen:string,et_durapr:string,et_datarr:string,et_heuarr:string,et_heud_e:string,et_heuf_e:string,et_codsit:string,et_datmaj:string,et_coduti:string,et_numsat:string,et_affect:string,et_stu_id:string,et_sta_pps:string,et_sop_uid:string,et_numgrp:string,et_carrdv:string,et_sanscr:string,et_codats:string,et_stabcd:string,et_typesclq:string,et_typbcd:string,et_codprx:string,et_flplan:string,et_available:string,et_aetitle:string,et_secondaire:string,et_mednuc:string,et_fltbdi:string,et_codfvu:string,et_datfvu:string,et_heufvu:string,et_suspens:string,et_acados:string,et_acapub:string,et_acamed:string,et_acalib:string,et_later:string,et_position:string,et_incidence:string,et_numpdt:string,et_numord:string,et_trstat:string,et_organe:string,et_heuapp:string,et_orirdv:string,et_codvac:string,et_codvaca:string,et_numxus:string,et_numexa_ori:string,et_exacot:string,et_flnocot:string,et_alarmes:string,et_modal_aet:string,et_numprore:string,et_comprore:string,et_numrvx:string,et_noseq:string,et_datfin:string,et_numresa:string,et_fhirid:string,et_regana:string,et_nb_ser:string,et_nb_fic:string,et_nb_img_key:string,et_stu_id_ori:string,et_codper_prore:string,et_numseance:string,et_numordseance:string,et_numtrt:string,et_comment:string,et_codloinc:string>

(2) Filter [codegen id : 1]
Input [91]: [et_numexa#678467, et_numdos#678468, et_numdem#678469, et_typexa#678470, et_codexa#678471, et_exaacc#678472, et_libexa#678473, et_codapp#678474, et_numsal#678475, et_codper#678476, et_codrad#678477, et_codpro#678478, et_m_am_i#678479, et_ag_on#678480, et_datexa#678481, et_heuexa#678482, et_heusal#678483, et_heufin#678484, et_durtot#678485, et_durava#678486, et_durpen#678487, et_durapr#678488, et_datarr#678489, et_heuarr#678490, et_heud_e#678491, et_heuf_e#678492, et_codsit#678493, et_datmaj#678494, et_coduti#678495, et_numsat#678496, et_affect#678497, et_stu_id#678498, et_sta_pps#678499, et_sop_uid#678500, et_numgrp#678501, et_carrdv#678502, et_sanscr#678503, et_codats#678504, et_stabcd#678505, et_typesclq#678506, et_typbcd#678507, et_codprx#678508, et_flplan#678509, et_available#678510, et_aetitle#678511, et_secondaire#678512, et_mednuc#678513, et_fltbdi#678514, et_codfvu#678515, et_datfvu#678516, et_heufvu#678517, et_suspens#678518, et_acados#678519, et_acapub#678520, et_acamed#678521, et_acalib#678522, et_later#678523, et_position#678524, et_incidence#678525, et_numpdt#678526, et_numord#678527, et_trstat#678528, et_organe#678529, et_heuapp#678530, et_orirdv#678531, et_codvac#678532, et_codvaca#678533, et_numxus#678534, et_numexa_ori#678535, et_exacot#678536, et_flnocot#678537, et_alarmes#678538, et_modal_aet#678539, et_numprore#678540, et_comprore#678541, et_numrvx#678542, et_noseq#678543, et_datfin#678544, et_numresa#678545, et_fhirid#678546, et_regana#678547, et_nb_ser#678548, et_nb_fic#678549, et_nb_img_key#678550, et_stu_id_ori#678551, et_codper_prore#678552, et_numseance#678553, et_numordseance#678554, et_numtrt#678555, et_comment#678556, et_codloinc#678557]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#678467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#678467)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#678468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#678468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#678469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#678469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#678470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#678470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#678471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#678471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#678472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#678472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#678473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#678473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#678474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#678474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#678475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#678475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#678476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#678476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#678477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#678477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#678478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#678478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#678479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#678479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#678480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#678480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#678481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#678481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#678482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#678482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#678483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#678483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#678484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#678484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#678485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#678485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#678486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#678486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#678487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#678487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#678488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#678488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#678489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#678489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#678490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#678490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#678491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#678491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#678492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#678492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#678493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#678493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#678494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#678494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#678495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#678495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#678496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#678496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#678497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#678497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#678498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#678498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#678499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#678499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#678500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#678500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#678501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#678501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#678502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#678502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#678503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#678503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#678504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#678504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#678505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#678505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#678506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#678506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#678507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#678507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#678508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#678508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#678509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#678509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#678510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#678510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#678511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#678511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#678512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#678512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#678513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#678513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#678514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#678514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#678515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#678515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#678516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#678516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#678517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#678517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#678518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#678518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#678519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#678519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#678520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#678520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#678521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#678521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#678522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#678522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#678523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#678523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#678524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#678524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#678525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#678525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#678526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#678526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#678527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#678527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#678528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#678528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#678529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#678529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#678530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#678530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#678531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#678531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#678532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#678532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#678533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#678533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#678534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#678534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#678535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#678535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#678536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#678536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#678537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#678537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#678538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#678538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#678539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#678539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#678540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#678540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#678541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#678541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#678542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#678542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#678543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#678543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#678544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#678544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#678545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#678545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#678546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#678546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#678547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#678547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#678548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#678548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#678549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#678549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#678550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#678550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#678551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#678551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#678552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#678552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#678553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#678553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#678554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#678554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#678555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#678555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#678556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#678556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#678557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#678557)), 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 [91]: [et_numexa#678467, et_numdos#678468, et_numdem#678469, et_typexa#678470, et_codexa#678471, et_exaacc#678472, et_libexa#678473, et_codapp#678474, et_numsal#678475, et_codper#678476, et_codrad#678477, et_codpro#678478, et_m_am_i#678479, et_ag_on#678480, et_datexa#678481, et_heuexa#678482, et_heusal#678483, et_heufin#678484, et_durtot#678485, et_durava#678486, et_durpen#678487, et_durapr#678488, et_datarr#678489, et_heuarr#678490, et_heud_e#678491, et_heuf_e#678492, et_codsit#678493, et_datmaj#678494, et_coduti#678495, et_numsat#678496, et_affect#678497, et_stu_id#678498, et_sta_pps#678499, et_sop_uid#678500, et_numgrp#678501, et_carrdv#678502, et_sanscr#678503, et_codats#678504, et_stabcd#678505, et_typesclq#678506, et_typbcd#678507, et_codprx#678508, et_flplan#678509, et_available#678510, et_aetitle#678511, et_secondaire#678512, et_mednuc#678513, et_fltbdi#678514, et_codfvu#678515, et_datfvu#678516, et_heufvu#678517, et_suspens#678518, et_acados#678519, et_acapub#678520, et_acamed#678521, et_acalib#678522, et_later#678523, et_position#678524, et_incidence#678525, et_numpdt#678526, et_numord#678527, et_trstat#678528, et_organe#678529, et_heuapp#678530, et_orirdv#678531, et_codvac#678532, et_codvaca#678533, et_numxus#678534, et_numexa_ori#678535, et_exacot#678536, et_flnocot#678537, et_alarmes#678538, et_modal_aet#678539, et_numprore#678540, et_comprore#678541, et_numrvx#678542, et_noseq#678543, et_datfin#678544, et_numresa#678545, et_fhirid#678546, et_regana#678547, et_nb_ser#678548, et_nb_fic#678549, et_nb_img_key#678550, et_stu_id_ori#678551, et_codper_prore#678552, et_numseance#678553, et_numordseance#678554, et_numtrt#678555, et_comment#678556, et_codloinc#678557]

(4) Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1]  [codegen id : 2]
Output [91]: [et_numexa#679289, et_numdos#679290, et_numdem#679291, et_typexa#679292, et_codexa#679293, et_exaacc#679294, et_libexa#679295, et_codapp#679296, et_numsal#679297, et_codper#679298, et_codrad#679299, et_codpro#679300, et_m_am_i#679301, et_ag_on#679302, et_datexa#679303, et_heuexa#679304, et_heusal#679305, et_heufin#679306, et_durtot#679307, et_durava#679308, et_durpen#679309, et_durapr#679310, et_datarr#679311, et_heuarr#679312, et_heud_e#679313, et_heuf_e#679314, et_codsit#679315, et_datmaj#679316, et_coduti#679317, et_numsat#679318, et_affect#679319, et_stu_id#679320, et_sta_pps#679321, et_sop_uid#679322, et_numgrp#679323, et_carrdv#679324, et_sanscr#679325, et_codats#679326, et_stabcd#679327, et_typesclq#679328, et_typbcd#679329, et_codprx#679330, et_flplan#679331, et_available#679332, et_aetitle#679333, et_secondaire#679334, et_mednuc#679335, et_fltbdi#679336, et_codfvu#679337, et_datfvu#679338, et_heufvu#679339, et_suspens#679340, et_acados#679341, et_acapub#679342, et_acamed#679343, et_acalib#679344, et_later#679345, et_position#679346, et_incidence#679347, et_numpdt#679348, et_numord#679349, et_trstat#679350, et_organe#679351, et_heuapp#679352, et_orirdv#679353, et_codvac#679354, et_codvaca#679355, et_numxus#679356, et_numexa_ori#679357, et_exacot#679358, et_flnocot#679359, et_alarmes#679360, et_modal_aet#679361, et_numprore#679362, et_comprore#679363, et_numrvx#679364, et_noseq#679365, et_datfin#679366, et_numresa#679367, et_fhirid#679368, et_regana#679369, et_nb_ser#679370, et_nb_fic#679371, et_nb_img_key#679372, et_stu_id_ori#679373, et_codper_prore#679374, et_numseance#679375, et_numordseance#679376, et_numtrt#679377, et_comment#679378, et_codloinc#679379]
ReadSchema: struct<et_numexa:string,et_numdos:string,et_numdem:string,et_typexa:string,et_codexa:string,et_exaacc:string,et_libexa:string,et_codapp:string,et_numsal:string,et_codper:string,et_codrad:string,et_codpro:string,et_m_am_i:string,et_ag_on:string,et_datexa:string,et_heuexa:string,et_heusal:string,et_heufin:string,et_durtot:string,et_durava:string,et_durpen:string,et_durapr:string,et_datarr:string,et_heuarr:string,et_heud_e:string,et_heuf_e:string,et_codsit:string,et_datmaj:string,et_coduti:string,et_numsat:string,et_affect:string,et_stu_id:string,et_sta_pps:string,et_sop_uid:string,et_numgrp:string,et_carrdv:string,et_sanscr:string,et_codats:string,et_stabcd:string,et_typesclq:string,et_typbcd:string,et_codprx:string,et_flplan:string,et_available:string,et_aetitle:string,et_secondaire:string,et_mednuc:string,et_fltbdi:string,et_codfvu:string,et_datfvu:string,et_heufvu:string,et_suspens:string,et_acados:string,et_acapub:string,et_acamed:string,et_acalib:string,et_later:string,et_position:string,et_incidence:string,et_numpdt:string,et_numord:string,et_trstat:string,et_organe:string,et_heuapp:string,et_orirdv:string,et_codvac:string,et_codvaca:string,et_numxus:string,et_numexa_ori:string,et_exacot:string,et_flnocot:string,et_alarmes:string,et_modal_aet:string,et_numprore:string,et_comprore:string,et_numrvx:string,et_noseq:string,et_datfin:string,et_numresa:string,et_fhirid:string,et_regana:string,et_nb_ser:string,et_nb_fic:string,et_nb_img_key:string,et_stu_id_ori:string,et_codper_prore:string,et_numseance:string,et_numordseance:string,et_numtrt:string,et_comment:string,et_codloinc:string>

(5) Filter [codegen id : 2]
Input [91]: [et_numexa#679289, et_numdos#679290, et_numdem#679291, et_typexa#679292, et_codexa#679293, et_exaacc#679294, et_libexa#679295, et_codapp#679296, et_numsal#679297, et_codper#679298, et_codrad#679299, et_codpro#679300, et_m_am_i#679301, et_ag_on#679302, et_datexa#679303, et_heuexa#679304, et_heusal#679305, et_heufin#679306, et_durtot#679307, et_durava#679308, et_durpen#679309, et_durapr#679310, et_datarr#679311, et_heuarr#679312, et_heud_e#679313, et_heuf_e#679314, et_codsit#679315, et_datmaj#679316, et_coduti#679317, et_numsat#679318, et_affect#679319, et_stu_id#679320, et_sta_pps#679321, et_sop_uid#679322, et_numgrp#679323, et_carrdv#679324, et_sanscr#679325, et_codats#679326, et_stabcd#679327, et_typesclq#679328, et_typbcd#679329, et_codprx#679330, et_flplan#679331, et_available#679332, et_aetitle#679333, et_secondaire#679334, et_mednuc#679335, et_fltbdi#679336, et_codfvu#679337, et_datfvu#679338, et_heufvu#679339, et_suspens#679340, et_acados#679341, et_acapub#679342, et_acamed#679343, et_acalib#679344, et_later#679345, et_position#679346, et_incidence#679347, et_numpdt#679348, et_numord#679349, et_trstat#679350, et_organe#679351, et_heuapp#679352, et_orirdv#679353, et_codvac#679354, et_codvaca#679355, et_numxus#679356, et_numexa_ori#679357, et_exacot#679358, et_flnocot#679359, et_alarmes#679360, et_modal_aet#679361, et_numprore#679362, et_comprore#679363, et_numrvx#679364, et_noseq#679365, et_datfin#679366, et_numresa#679367, et_fhirid#679368, et_regana#679369, et_nb_ser#679370, et_nb_fic#679371, et_nb_img_key#679372, et_stu_id_ori#679373, et_codper_prore#679374, et_numseance#679375, et_numordseance#679376, et_numtrt#679377, et_comment#679378, et_codloinc#679379]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#679289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#679289)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#679290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#679290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#679291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#679291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#679292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#679292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#679293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#679293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#679294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#679294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#679295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#679295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#679296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#679296)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#679297)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#679297)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#679298)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#679298)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#679299)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#679299)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#679300)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#679300)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#679301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#679301)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#679302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#679302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#679303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#679303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#679304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#679304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#679305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#679305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#679306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#679306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#679307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#679307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#679308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#679308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#679309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#679309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#679310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#679310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#679311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#679311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#679312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#679312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#679313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#679313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#679314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#679314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#679315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#679315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#679316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#679316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#679317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#679317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#679318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#679318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#679319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#679319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#679320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#679320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#679321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#679321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#679322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#679322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#679323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#679323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#679324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#679324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#679325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#679325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#679326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#679326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#679327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#679327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#679328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#679328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#679329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#679329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#679330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#679330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#679331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#679331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#679332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#679332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#679333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#679333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#679334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#679334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#679335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#679335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#679336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#679336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#679337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#679337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#679338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#679338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#679339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#679339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#679340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#679340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#679341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#679341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#679342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#679342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#679343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#679343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#679344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#679344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#679345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#679345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#679346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#679346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#679347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#679347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#679348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#679348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#679349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#679349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#679350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#679350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#679351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#679351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#679352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#679352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#679353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#679353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#679354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#679354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#679355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#679355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#679356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#679356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#679357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#679357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#679358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#679358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#679359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#679359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#679360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#679360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#679361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#679361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#679362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#679362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#679363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#679363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#679364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#679364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#679365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#679365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#679366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#679366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#679367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#679367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#679368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#679368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#679369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#679369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#679370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#679370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#679371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#679371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#679372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#679372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#679373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#679373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#679374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#679374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#679375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#679375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#679376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#679376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#679377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#679377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#679378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#679378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#679379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#679379)), 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 [91]: [et_numexa#679289, et_numdos#679290, et_numdem#679291, et_typexa#679292, et_codexa#679293, et_exaacc#679294, et_libexa#679295, et_codapp#679296, et_numsal#679297, et_codper#679298, et_codrad#679299, et_codpro#679300, et_m_am_i#679301, et_ag_on#679302, et_datexa#679303, et_heuexa#679304, et_heusal#679305, et_heufin#679306, et_durtot#679307, et_durava#679308, et_durpen#679309, et_durapr#679310, et_datarr#679311, et_heuarr#679312, et_heud_e#679313, et_heuf_e#679314, et_codsit#679315, et_datmaj#679316, et_coduti#679317, et_numsat#679318, et_affect#679319, et_stu_id#679320, et_sta_pps#679321, et_sop_uid#679322, et_numgrp#679323, et_carrdv#679324, et_sanscr#679325, et_codats#679326, et_stabcd#679327, et_typesclq#679328, et_typbcd#679329, et_codprx#679330, et_flplan#679331, et_available#679332, et_aetitle#679333, et_secondaire#679334, et_mednuc#679335, et_fltbdi#679336, et_codfvu#679337, et_datfvu#679338, et_heufvu#679339, et_suspens#679340, et_acados#679341, et_acapub#679342, et_acamed#679343, et_acalib#679344, et_later#679345, et_position#679346, et_incidence#679347, et_numpdt#679348, et_numord#679349, et_trstat#679350, et_organe#679351, et_heuapp#679352, et_orirdv#679353, et_codvac#679354, et_codvaca#679355, et_numxus#679356, et_numexa_ori#679357, et_exacot#679358, et_flnocot#679359, et_alarmes#679360, et_modal_aet#679361, et_numprore#679362, et_comprore#679363, et_numrvx#679364, et_noseq#679365, et_datfin#679366, et_numresa#679367, et_fhirid#679368, et_regana#679369, et_nb_ser#679370, et_nb_fic#679371, et_nb_img_key#679372, et_stu_id_ori#679373, et_codper_prore#679374, et_numseance#679375, et_numordseance#679376, et_numtrt#679377, et_comment#679378, et_codloinc#679379]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#681043L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#680851L]
Results [1]: [count(1)#680851L AS COL_29f30bf1-9d3c-4029-beb9-cb776fd03fb2#680853L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#681043L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#680851L]
Results [1]: [count(1)#680851L AS COL_29f30bf1-9d3c-4029-beb9-cb776fd03fb2#680853L]

(16) AdaptiveSparkPlan
Output [1]: [COL_29f30bf1-9d3c-4029-beb9-cb776fd03fb2#680853L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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