hdh-spark-job - Details for Query 1474

Submitted Time: 2026/10/23 13:29:41
Duration: 17 s
Succeeded Jobs: 1473 1478

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

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#755285)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#755285)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#755286)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#755286)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#755287)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#755287)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#755288)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#755288)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#755289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#755289)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#755290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#755290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#755291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#755291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#755292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#755292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#755293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#755293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#755294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#755294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#755295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#755295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#755296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#755296)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#755297)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#755297)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#755298)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#755298)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#755299)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#755299)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#755300)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#755300)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#755301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#755301)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#755302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#755302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#755303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#755303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#755304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#755304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#755305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#755305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#755306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#755306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#755307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#755307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#755308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#755308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#755309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#755309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#755310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#755310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#755311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#755311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#755312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#755312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#755313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#755313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#755314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#755314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#755315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#755315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#755316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#755316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#755317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#755317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#755318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#755318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#755319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#755319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#755320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#755320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#755321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#755321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#755322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#755322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#755323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#755323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#755324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#755324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#755325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#755325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#755326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#755326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#755327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#755327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#755328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#755328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#755329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#755329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#755330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#755330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#755331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#755331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#755332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#755332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#755333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#755333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#755334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#755334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#755335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#755335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#755336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#755336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#755337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#755337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#755338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#755338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#755339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#755339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#755340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#755340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#755341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#755341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#755342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#755342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#755343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#755343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#755344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#755344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#755345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#755345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#755346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#755346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#755347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#755347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#755348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#755348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#755349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#755349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#755350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#755350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#755351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#755351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#755352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#755352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#755353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#755353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#755354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#755354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#755355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#755355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#755356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#755356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#755357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#755357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#755358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#755358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#755359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#755359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#755360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#755360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#755361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#755361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#755362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#755362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#755363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#755363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#755364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#755364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#755365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#755365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#755366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#755366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#755367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#755367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#755368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#755368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#755369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#755369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#755370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#755370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#755371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#755371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#755372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#755372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#755373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#755373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#755374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#755374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#755375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#755375)), 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#755285,et_numdos#755286,et_numdem#755287,et_typexa#755288,et_codexa#755289,et_exaacc#755290,et_libexa#755291,et_codapp#755292,et_numsal#755293,et_codper#755294,et_codrad#755295,et_codpro#755296,et_m_am_i#755297,et_ag_on#755298,et_datexa#755299,et_heuexa#755300,et_heusal#755301,et_heufin#755302,et_durtot#755303,et_durava#755304,et_durpen#755305,et_durapr#755306,et_datarr#755307,et_heuarr#755308,... 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#756356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#756356)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#756357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#756357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#756358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#756358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#756359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#756359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#756360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#756360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#756361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#756361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#756362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#756362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#756363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#756363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#756364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#756364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#756365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#756365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#756366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#756366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#756367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#756367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#756368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#756368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#756369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#756369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#756370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#756370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#756371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#756371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#756372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#756372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#756373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#756373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#756374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#756374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#756375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#756375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#756376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#756376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#756377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#756377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#756378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#756378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#756379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#756379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#756380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#756380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#756381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#756381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#756382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#756382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#756383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#756383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#756384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#756384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#756385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#756385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#756386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#756386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#756387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#756387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#756388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#756388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#756389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#756389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#756390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#756390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#756391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#756391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#756392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#756392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#756393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#756393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#756394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#756394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#756395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#756395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#756396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#756396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#756397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#756397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#756398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#756398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#756399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#756399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#756400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#756400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#756401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#756401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#756402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#756402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#756403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#756403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#756404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#756404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#756405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#756405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#756406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#756406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#756407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#756407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#756408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#756408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#756409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#756409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#756410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#756410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#756411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#756411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#756412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#756412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#756413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#756413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#756414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#756414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#756415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#756415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#756416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#756416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#756417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#756417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#756418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#756418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#756419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#756419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#756420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#756420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#756421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#756421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#756422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#756422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#756423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#756423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#756424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#756424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#756425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#756425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#756426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#756426)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#756427)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#756427)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#756428)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#756428)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#756429)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#756429)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#756430)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#756430)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#756431)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#756431)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#756432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#756432)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#756433)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#756433)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#756434)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#756434)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#756435)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#756435)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#756436)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#756436)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#756437)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#756437)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#756438)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#756438)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#756439)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#756439)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#756440)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#756440)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#756441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#756441)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#756442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#756442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#756443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#756443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#756444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#756444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#756445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#756445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#756446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#756446)), 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#756356,et_numdos#756357,et_numdem#756358,et_typexa#756359,et_codexa#756360,et_exaacc#756361,et_libexa#756362,et_codapp#756363,et_numsal#756364,et_codper#756365,et_codrad#756366,et_codpro#756367,et_m_am_i#756368,et_ag_on#756369,et_datexa#756370,et_heuexa#756371,et_heusal#756372,et_heufin#756373,et_durtot#756374,et_durava#756375,et_durpen#756376,et_durapr#756377,et_datarr#756378,et_heuarr#756379,... 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#755285, et_numdos#755286, et_numdem#755287, et_typexa#755288, et_codexa#755289, et_exaacc#755290, et_libexa#755291, et_codapp#755292, et_numsal#755293, et_codper#755294, et_codrad#755295, et_codpro#755296, et_m_am_i#755297, et_ag_on#755298, et_datexa#755299, et_heuexa#755300, et_heusal#755301, et_heufin#755302, et_durtot#755303, et_durava#755304, et_durpen#755305, et_durapr#755306, et_datarr#755307, et_heuarr#755308, et_heud_e#755309, et_heuf_e#755310, et_codsit#755311, et_datmaj#755312, et_coduti#755313, et_numsat#755314, et_affect#755315, et_stu_id#755316, et_sta_pps#755317, et_sop_uid#755318, et_numgrp#755319, et_carrdv#755320, et_sanscr#755321, et_codats#755322, et_stabcd#755323, et_typesclq#755324, et_typbcd#755325, et_codprx#755326, et_flplan#755327, et_available#755328, et_aetitle#755329, et_secondaire#755330, et_mednuc#755331, et_fltbdi#755332, et_codfvu#755333, et_datfvu#755334, et_heufvu#755335, et_suspens#755336, et_acados#755337, et_acapub#755338, et_acamed#755339, et_acalib#755340, et_later#755341, et_position#755342, et_incidence#755343, et_numpdt#755344, et_numord#755345, et_trstat#755346, et_organe#755347, et_heuapp#755348, et_orirdv#755349, et_codvac#755350, et_codvaca#755351, et_numxus#755352, et_numexa_ori#755353, et_exacot#755354, et_flnocot#755355, et_alarmes#755356, et_modal_aet#755357, et_numprore#755358, et_comprore#755359, et_numrvx#755360, et_noseq#755361, et_datfin#755362, et_numresa#755363, et_fhirid#755364, et_regana#755365, et_nb_ser#755366, et_nb_fic#755367, et_nb_img_key#755368, et_stu_id_ori#755369, et_codper_prore#755370, et_numseance#755371, et_numordseance#755372, et_numtrt#755373, et_comment#755374, et_codloinc#755375]
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#755285, et_numdos#755286, et_numdem#755287, et_typexa#755288, et_codexa#755289, et_exaacc#755290, et_libexa#755291, et_codapp#755292, et_numsal#755293, et_codper#755294, et_codrad#755295, et_codpro#755296, et_m_am_i#755297, et_ag_on#755298, et_datexa#755299, et_heuexa#755300, et_heusal#755301, et_heufin#755302, et_durtot#755303, et_durava#755304, et_durpen#755305, et_durapr#755306, et_datarr#755307, et_heuarr#755308, et_heud_e#755309, et_heuf_e#755310, et_codsit#755311, et_datmaj#755312, et_coduti#755313, et_numsat#755314, et_affect#755315, et_stu_id#755316, et_sta_pps#755317, et_sop_uid#755318, et_numgrp#755319, et_carrdv#755320, et_sanscr#755321, et_codats#755322, et_stabcd#755323, et_typesclq#755324, et_typbcd#755325, et_codprx#755326, et_flplan#755327, et_available#755328, et_aetitle#755329, et_secondaire#755330, et_mednuc#755331, et_fltbdi#755332, et_codfvu#755333, et_datfvu#755334, et_heufvu#755335, et_suspens#755336, et_acados#755337, et_acapub#755338, et_acamed#755339, et_acalib#755340, et_later#755341, et_position#755342, et_incidence#755343, et_numpdt#755344, et_numord#755345, et_trstat#755346, et_organe#755347, et_heuapp#755348, et_orirdv#755349, et_codvac#755350, et_codvaca#755351, et_numxus#755352, et_numexa_ori#755353, et_exacot#755354, et_flnocot#755355, et_alarmes#755356, et_modal_aet#755357, et_numprore#755358, et_comprore#755359, et_numrvx#755360, et_noseq#755361, et_datfin#755362, et_numresa#755363, et_fhirid#755364, et_regana#755365, et_nb_ser#755366, et_nb_fic#755367, et_nb_img_key#755368, et_stu_id_ori#755369, et_codper_prore#755370, et_numseance#755371, et_numordseance#755372, et_numtrt#755373, et_comment#755374, et_codloinc#755375]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#755285)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#755285)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#755286)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#755286)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#755287)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#755287)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#755288)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#755288)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#755289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#755289)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#755290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#755290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#755291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#755291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#755292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#755292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#755293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#755293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#755294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#755294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#755295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#755295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#755296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#755296)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#755297)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#755297)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#755298)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#755298)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#755299)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#755299)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#755300)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#755300)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#755301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#755301)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#755302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#755302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#755303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#755303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#755304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#755304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#755305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#755305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#755306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#755306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#755307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#755307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#755308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#755308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#755309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#755309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#755310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#755310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#755311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#755311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#755312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#755312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#755313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#755313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#755314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#755314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#755315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#755315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#755316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#755316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#755317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#755317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#755318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#755318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#755319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#755319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#755320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#755320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#755321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#755321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#755322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#755322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#755323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#755323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#755324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#755324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#755325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#755325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#755326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#755326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#755327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#755327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#755328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#755328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#755329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#755329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#755330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#755330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#755331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#755331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#755332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#755332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#755333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#755333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#755334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#755334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#755335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#755335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#755336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#755336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#755337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#755337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#755338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#755338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#755339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#755339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#755340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#755340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#755341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#755341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#755342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#755342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#755343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#755343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#755344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#755344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#755345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#755345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#755346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#755346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#755347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#755347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#755348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#755348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#755349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#755349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#755350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#755350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#755351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#755351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#755352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#755352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#755353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#755353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#755354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#755354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#755355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#755355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#755356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#755356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#755357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#755357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#755358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#755358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#755359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#755359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#755360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#755360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#755361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#755361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#755362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#755362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#755363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#755363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#755364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#755364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#755365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#755365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#755366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#755366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#755367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#755367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#755368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#755368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#755369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#755369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#755370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#755370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#755371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#755371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#755372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#755372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#755373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#755373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#755374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#755374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#755375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#755375)), 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#755285, et_numdos#755286, et_numdem#755287, et_typexa#755288, et_codexa#755289, et_exaacc#755290, et_libexa#755291, et_codapp#755292, et_numsal#755293, et_codper#755294, et_codrad#755295, et_codpro#755296, et_m_am_i#755297, et_ag_on#755298, et_datexa#755299, et_heuexa#755300, et_heusal#755301, et_heufin#755302, et_durtot#755303, et_durava#755304, et_durpen#755305, et_durapr#755306, et_datarr#755307, et_heuarr#755308, et_heud_e#755309, et_heuf_e#755310, et_codsit#755311, et_datmaj#755312, et_coduti#755313, et_numsat#755314, et_affect#755315, et_stu_id#755316, et_sta_pps#755317, et_sop_uid#755318, et_numgrp#755319, et_carrdv#755320, et_sanscr#755321, et_codats#755322, et_stabcd#755323, et_typesclq#755324, et_typbcd#755325, et_codprx#755326, et_flplan#755327, et_available#755328, et_aetitle#755329, et_secondaire#755330, et_mednuc#755331, et_fltbdi#755332, et_codfvu#755333, et_datfvu#755334, et_heufvu#755335, et_suspens#755336, et_acados#755337, et_acapub#755338, et_acamed#755339, et_acalib#755340, et_later#755341, et_position#755342, et_incidence#755343, et_numpdt#755344, et_numord#755345, et_trstat#755346, et_organe#755347, et_heuapp#755348, et_orirdv#755349, et_codvac#755350, et_codvaca#755351, et_numxus#755352, et_numexa_ori#755353, et_exacot#755354, et_flnocot#755355, et_alarmes#755356, et_modal_aet#755357, et_numprore#755358, et_comprore#755359, et_numrvx#755360, et_noseq#755361, et_datfin#755362, et_numresa#755363, et_fhirid#755364, et_regana#755365, et_nb_ser#755366, et_nb_fic#755367, et_nb_img_key#755368, et_stu_id_ori#755369, et_codper_prore#755370, et_numseance#755371, et_numordseance#755372, et_numtrt#755373, et_comment#755374, et_codloinc#755375]

(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#756356, et_numdos#756357, et_numdem#756358, et_typexa#756359, et_codexa#756360, et_exaacc#756361, et_libexa#756362, et_codapp#756363, et_numsal#756364, et_codper#756365, et_codrad#756366, et_codpro#756367, et_m_am_i#756368, et_ag_on#756369, et_datexa#756370, et_heuexa#756371, et_heusal#756372, et_heufin#756373, et_durtot#756374, et_durava#756375, et_durpen#756376, et_durapr#756377, et_datarr#756378, et_heuarr#756379, et_heud_e#756380, et_heuf_e#756381, et_codsit#756382, et_datmaj#756383, et_coduti#756384, et_numsat#756385, et_affect#756386, et_stu_id#756387, et_sta_pps#756388, et_sop_uid#756389, et_numgrp#756390, et_carrdv#756391, et_sanscr#756392, et_codats#756393, et_stabcd#756394, et_typesclq#756395, et_typbcd#756396, et_codprx#756397, et_flplan#756398, et_available#756399, et_aetitle#756400, et_secondaire#756401, et_mednuc#756402, et_fltbdi#756403, et_codfvu#756404, et_datfvu#756405, et_heufvu#756406, et_suspens#756407, et_acados#756408, et_acapub#756409, et_acamed#756410, et_acalib#756411, et_later#756412, et_position#756413, et_incidence#756414, et_numpdt#756415, et_numord#756416, et_trstat#756417, et_organe#756418, et_heuapp#756419, et_orirdv#756420, et_codvac#756421, et_codvaca#756422, et_numxus#756423, et_numexa_ori#756424, et_exacot#756425, et_flnocot#756426, et_alarmes#756427, et_modal_aet#756428, et_numprore#756429, et_comprore#756430, et_numrvx#756431, et_noseq#756432, et_datfin#756433, et_numresa#756434, et_fhirid#756435, et_regana#756436, et_nb_ser#756437, et_nb_fic#756438, et_nb_img_key#756439, et_stu_id_ori#756440, et_codper_prore#756441, et_numseance#756442, et_numordseance#756443, et_numtrt#756444, et_comment#756445, et_codloinc#756446]
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#756356, et_numdos#756357, et_numdem#756358, et_typexa#756359, et_codexa#756360, et_exaacc#756361, et_libexa#756362, et_codapp#756363, et_numsal#756364, et_codper#756365, et_codrad#756366, et_codpro#756367, et_m_am_i#756368, et_ag_on#756369, et_datexa#756370, et_heuexa#756371, et_heusal#756372, et_heufin#756373, et_durtot#756374, et_durava#756375, et_durpen#756376, et_durapr#756377, et_datarr#756378, et_heuarr#756379, et_heud_e#756380, et_heuf_e#756381, et_codsit#756382, et_datmaj#756383, et_coduti#756384, et_numsat#756385, et_affect#756386, et_stu_id#756387, et_sta_pps#756388, et_sop_uid#756389, et_numgrp#756390, et_carrdv#756391, et_sanscr#756392, et_codats#756393, et_stabcd#756394, et_typesclq#756395, et_typbcd#756396, et_codprx#756397, et_flplan#756398, et_available#756399, et_aetitle#756400, et_secondaire#756401, et_mednuc#756402, et_fltbdi#756403, et_codfvu#756404, et_datfvu#756405, et_heufvu#756406, et_suspens#756407, et_acados#756408, et_acapub#756409, et_acamed#756410, et_acalib#756411, et_later#756412, et_position#756413, et_incidence#756414, et_numpdt#756415, et_numord#756416, et_trstat#756417, et_organe#756418, et_heuapp#756419, et_orirdv#756420, et_codvac#756421, et_codvaca#756422, et_numxus#756423, et_numexa_ori#756424, et_exacot#756425, et_flnocot#756426, et_alarmes#756427, et_modal_aet#756428, et_numprore#756429, et_comprore#756430, et_numrvx#756431, et_noseq#756432, et_datfin#756433, et_numresa#756434, et_fhirid#756435, et_regana#756436, et_nb_ser#756437, et_nb_fic#756438, et_nb_img_key#756439, et_stu_id_ori#756440, et_codper_prore#756441, et_numseance#756442, et_numordseance#756443, et_numtrt#756444, et_comment#756445, et_codloinc#756446]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#756356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#756356)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#756357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#756357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#756358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#756358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#756359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#756359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#756360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#756360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#756361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#756361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#756362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#756362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#756363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#756363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#756364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#756364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#756365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#756365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#756366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#756366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#756367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#756367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#756368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#756368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#756369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#756369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#756370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#756370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#756371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#756371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#756372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#756372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#756373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#756373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#756374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#756374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#756375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#756375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#756376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#756376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#756377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#756377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#756378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#756378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#756379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#756379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#756380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#756380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#756381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#756381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#756382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#756382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#756383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#756383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#756384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#756384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#756385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#756385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#756386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#756386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#756387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#756387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#756388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#756388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#756389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#756389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#756390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#756390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#756391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#756391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#756392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#756392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#756393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#756393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#756394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#756394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#756395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#756395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#756396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#756396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#756397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#756397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#756398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#756398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#756399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#756399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#756400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#756400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#756401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#756401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#756402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#756402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#756403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#756403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#756404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#756404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#756405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#756405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#756406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#756406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#756407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#756407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#756408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#756408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#756409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#756409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#756410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#756410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#756411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#756411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#756412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#756412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#756413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#756413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#756414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#756414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#756415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#756415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#756416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#756416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#756417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#756417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#756418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#756418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#756419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#756419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#756420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#756420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#756421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#756421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#756422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#756422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#756423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#756423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#756424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#756424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#756425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#756425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#756426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#756426)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#756427)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#756427)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#756428)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#756428)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#756429)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#756429)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#756430)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#756430)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#756431)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#756431)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#756432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#756432)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#756433)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#756433)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#756434)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#756434)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#756435)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#756435)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#756436)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#756436)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#756437)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#756437)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#756438)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#756438)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#756439)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#756439)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#756440)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#756440)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#756441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#756441)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#756442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#756442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#756443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#756443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#756444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#756444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#756445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#756445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#756446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#756446)), 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#756356, et_numdos#756357, et_numdem#756358, et_typexa#756359, et_codexa#756360, et_exaacc#756361, et_libexa#756362, et_codapp#756363, et_numsal#756364, et_codper#756365, et_codrad#756366, et_codpro#756367, et_m_am_i#756368, et_ag_on#756369, et_datexa#756370, et_heuexa#756371, et_heusal#756372, et_heufin#756373, et_durtot#756374, et_durava#756375, et_durpen#756376, et_durapr#756377, et_datarr#756378, et_heuarr#756379, et_heud_e#756380, et_heuf_e#756381, et_codsit#756382, et_datmaj#756383, et_coduti#756384, et_numsat#756385, et_affect#756386, et_stu_id#756387, et_sta_pps#756388, et_sop_uid#756389, et_numgrp#756390, et_carrdv#756391, et_sanscr#756392, et_codats#756393, et_stabcd#756394, et_typesclq#756395, et_typbcd#756396, et_codprx#756397, et_flplan#756398, et_available#756399, et_aetitle#756400, et_secondaire#756401, et_mednuc#756402, et_fltbdi#756403, et_codfvu#756404, et_datfvu#756405, et_heufvu#756406, et_suspens#756407, et_acados#756408, et_acapub#756409, et_acamed#756410, et_acalib#756411, et_later#756412, et_position#756413, et_incidence#756414, et_numpdt#756415, et_numord#756416, et_trstat#756417, et_organe#756418, et_heuapp#756419, et_orirdv#756420, et_codvac#756421, et_codvaca#756422, et_numxus#756423, et_numexa_ori#756424, et_exacot#756425, et_flnocot#756426, et_alarmes#756427, et_modal_aet#756428, et_numprore#756429, et_comprore#756430, et_numrvx#756431, et_noseq#756432, et_datfin#756433, et_numresa#756434, et_fhirid#756435, et_regana#756436, et_nb_ser#756437, et_nb_fic#756438, et_nb_img_key#756439, et_stu_id_ori#756440, et_codper_prore#756441, et_numseance#756442, et_numordseance#756443, et_numtrt#756444, et_comment#756445, et_codloinc#756446]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#758192L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#757996L]
Results [1]: [count(1)#757996L AS COL_668b0ebf-de8b-4cd4-9f2f-e250c511f945#757998L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#758192L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#757996L]
Results [1]: [count(1)#757996L AS COL_668b0ebf-de8b-4cd4-9f2f-e250c511f945#757998L]

(16) AdaptiveSparkPlan
Output [1]: [COL_668b0ebf-de8b-4cd4-9f2f-e250c511f945#757998L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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