hdh-spark-job - Details for Query 1427

Submitted Time: 2026/10/23 13:29:11
Duration: 16 s
Succeeded Jobs: 1425 1430

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

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (4)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=38771]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#717772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#717772)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#717773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#717773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#717774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#717774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#717775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#717775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#717776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#717776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#717777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#717777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#717778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#717778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#717779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#717779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#717780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#717780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#717781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#717781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#717782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#717782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#717783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#717783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#717784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#717784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#717785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#717785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#717786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#717786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#717787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#717787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#717788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#717788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#717789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#717789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#717790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#717790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#717791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#717791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#717792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#717792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#717793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#717793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#717794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#717794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#717795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#717795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#717796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#717796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#717797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#717797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#717798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#717798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#717799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#717799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#717800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#717800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#717801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#717801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#717802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#717802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#717803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#717803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#717804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#717804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#717805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#717805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#717806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#717806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#717807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#717807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#717808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#717808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#717809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#717809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#717810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#717810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#717811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#717811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#717812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#717812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#717813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#717813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#717814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#717814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#717815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#717815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#717816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#717816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#717817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#717817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#717818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#717818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#717819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#717819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#717820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#717820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#717821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#717821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#717822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#717822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#717823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#717823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#717824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#717824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#717825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#717825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#717826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#717826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#717827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#717827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#717828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#717828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#717829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#717829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#717830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#717830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#717831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#717831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#717832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#717832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#717833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#717833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#717834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#717834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#717835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#717835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#717836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#717836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#717837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#717837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#717838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#717838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#717839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#717839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#717840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#717840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#717841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#717841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#717842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#717842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#717843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#717843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#717844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#717844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#717845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#717845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#717846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#717846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#717847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#717847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#717848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#717848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#717849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#717849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#717850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#717850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#717851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#717851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#717852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#717852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#717853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#717853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#717854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#717854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#717855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#717855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#717856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#717856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#717857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#717857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#717858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#717858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#717859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#717859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#717860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#717860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#717861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#717861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#717862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#717862)), 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#717772,et_numdos#717773,et_numdem#717774,et_typexa#717775,et_codexa#717776,et_exaacc#717777,et_libexa#717778,et_codapp#717779,et_numsal#717780,et_codper#717781,et_codrad#717782,et_codpro#717783,et_m_am_i#717784,et_ag_on#717785,et_datexa#717786,et_heuexa#717787,et_heusal#717788,et_heufin#717789,et_durtot#717790,et_durava#717791,et_durpen#717792,et_durapr#717793,et_datarr#717794,et_heuarr#717795,... 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#718947)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#718947)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#718948)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#718948)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#718949)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#718949)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#718950)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#718950)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#718951)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#718951)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#718952)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#718952)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#718953)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#718953)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#718954)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#718954)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#718955)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#718955)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#718956)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#718956)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#718957)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#718957)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#718958)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#718958)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#718959)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#718959)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#718960)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#718960)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#718961)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#718961)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#718962)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#718962)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#718963)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#718963)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#718964)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#718964)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#718965)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#718965)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#718966)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#718966)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#718967)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#718967)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#718968)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#718968)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#718969)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#718969)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#718970)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#718970)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#718971)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#718971)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#718972)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#718972)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#718973)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#718973)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#718974)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#718974)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#718975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#718975)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#718976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#718976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#718977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#718977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#718978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#718978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#718979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#718979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#718980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#718980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#718981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#718981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#718982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#718982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#718983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#718983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#718984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#718984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#718985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#718985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#718986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#718986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#718987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#718987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#718988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#718988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#718989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#718989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#718990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#718990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#718991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#718991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#718992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#718992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#718993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#718993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#718994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#718994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#718995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#718995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#718996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#718996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#718997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#718997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#718998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#718998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#718999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#718999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#719000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#719000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#719001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#719001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#719002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#719002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#719003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#719003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#719004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#719004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#719005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#719005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#719006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#719006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#719007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#719007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#719008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#719008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#719009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#719009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#719010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#719010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#719011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#719011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#719012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#719012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#719013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#719013)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#719014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#719014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#719015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#719015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#719016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#719016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#719017)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#719017)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#719018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#719018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#719019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#719019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#719020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#719020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#719021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#719021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#719022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#719022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#719023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#719023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#719024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#719024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#719025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#719025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#719026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#719026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#719027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#719027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#719028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#719028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#719029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#719029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#719030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#719030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#719031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#719031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#719032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#719032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#719033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#719033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#719034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#719034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#719035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#719035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#719036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#719036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#719037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#719037)), 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#718947,et_numdos#718948,et_numdem#718949,et_typexa#718950,et_codexa#718951,et_exaacc#718952,et_libexa#718953,et_codapp#718954,et_numsal#718955,et_codper#718956,et_codrad#718957,et_codpro#718958,et_m_am_i#718959,et_ag_on#718960,et_datexa#718961,et_heuexa#718962,et_heusal#718963,et_heufin#718964,et_durtot#718965,et_durava#718966,et_durpen#718967,et_durapr#718968,et_datarr#718969,et_heuarr#718970,... 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#717772, et_numdos#717773, et_numdem#717774, et_typexa#717775, et_codexa#717776, et_exaacc#717777, et_libexa#717778, et_codapp#717779, et_numsal#717780, et_codper#717781, et_codrad#717782, et_codpro#717783, et_m_am_i#717784, et_ag_on#717785, et_datexa#717786, et_heuexa#717787, et_heusal#717788, et_heufin#717789, et_durtot#717790, et_durava#717791, et_durpen#717792, et_durapr#717793, et_datarr#717794, et_heuarr#717795, et_heud_e#717796, et_heuf_e#717797, et_codsit#717798, et_datmaj#717799, et_coduti#717800, et_numsat#717801, et_affect#717802, et_stu_id#717803, et_sta_pps#717804, et_sop_uid#717805, et_numgrp#717806, et_carrdv#717807, et_sanscr#717808, et_codats#717809, et_stabcd#717810, et_typesclq#717811, et_typbcd#717812, et_codprx#717813, et_flplan#717814, et_available#717815, et_aetitle#717816, et_secondaire#717817, et_mednuc#717818, et_fltbdi#717819, et_codfvu#717820, et_datfvu#717821, et_heufvu#717822, et_suspens#717823, et_acados#717824, et_acapub#717825, et_acamed#717826, et_acalib#717827, et_later#717828, et_position#717829, et_incidence#717830, et_numpdt#717831, et_numord#717832, et_trstat#717833, et_organe#717834, et_heuapp#717835, et_orirdv#717836, et_codvac#717837, et_codvaca#717838, et_numxus#717839, et_numexa_ori#717840, et_exacot#717841, et_flnocot#717842, et_alarmes#717843, et_modal_aet#717844, et_numprore#717845, et_comprore#717846, et_numrvx#717847, et_noseq#717848, et_datfin#717849, et_numresa#717850, et_fhirid#717851, et_regana#717852, et_nb_ser#717853, et_nb_fic#717854, et_nb_img_key#717855, et_stu_id_ori#717856, et_codper_prore#717857, et_numseance#717858, et_numordseance#717859, et_numtrt#717860, et_comment#717861, et_codloinc#717862]
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#717772, et_numdos#717773, et_numdem#717774, et_typexa#717775, et_codexa#717776, et_exaacc#717777, et_libexa#717778, et_codapp#717779, et_numsal#717780, et_codper#717781, et_codrad#717782, et_codpro#717783, et_m_am_i#717784, et_ag_on#717785, et_datexa#717786, et_heuexa#717787, et_heusal#717788, et_heufin#717789, et_durtot#717790, et_durava#717791, et_durpen#717792, et_durapr#717793, et_datarr#717794, et_heuarr#717795, et_heud_e#717796, et_heuf_e#717797, et_codsit#717798, et_datmaj#717799, et_coduti#717800, et_numsat#717801, et_affect#717802, et_stu_id#717803, et_sta_pps#717804, et_sop_uid#717805, et_numgrp#717806, et_carrdv#717807, et_sanscr#717808, et_codats#717809, et_stabcd#717810, et_typesclq#717811, et_typbcd#717812, et_codprx#717813, et_flplan#717814, et_available#717815, et_aetitle#717816, et_secondaire#717817, et_mednuc#717818, et_fltbdi#717819, et_codfvu#717820, et_datfvu#717821, et_heufvu#717822, et_suspens#717823, et_acados#717824, et_acapub#717825, et_acamed#717826, et_acalib#717827, et_later#717828, et_position#717829, et_incidence#717830, et_numpdt#717831, et_numord#717832, et_trstat#717833, et_organe#717834, et_heuapp#717835, et_orirdv#717836, et_codvac#717837, et_codvaca#717838, et_numxus#717839, et_numexa_ori#717840, et_exacot#717841, et_flnocot#717842, et_alarmes#717843, et_modal_aet#717844, et_numprore#717845, et_comprore#717846, et_numrvx#717847, et_noseq#717848, et_datfin#717849, et_numresa#717850, et_fhirid#717851, et_regana#717852, et_nb_ser#717853, et_nb_fic#717854, et_nb_img_key#717855, et_stu_id_ori#717856, et_codper_prore#717857, et_numseance#717858, et_numordseance#717859, et_numtrt#717860, et_comment#717861, et_codloinc#717862]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#717772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#717772)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#717773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#717773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#717774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#717774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#717775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#717775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#717776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#717776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#717777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#717777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#717778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#717778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#717779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#717779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#717780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#717780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#717781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#717781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#717782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#717782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#717783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#717783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#717784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#717784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#717785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#717785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#717786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#717786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#717787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#717787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#717788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#717788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#717789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#717789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#717790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#717790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#717791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#717791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#717792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#717792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#717793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#717793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#717794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#717794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#717795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#717795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#717796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#717796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#717797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#717797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#717798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#717798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#717799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#717799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#717800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#717800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#717801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#717801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#717802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#717802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#717803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#717803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#717804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#717804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#717805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#717805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#717806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#717806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#717807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#717807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#717808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#717808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#717809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#717809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#717810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#717810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#717811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#717811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#717812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#717812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#717813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#717813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#717814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#717814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#717815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#717815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#717816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#717816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#717817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#717817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#717818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#717818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#717819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#717819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#717820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#717820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#717821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#717821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#717822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#717822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#717823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#717823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#717824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#717824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#717825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#717825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#717826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#717826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#717827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#717827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#717828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#717828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#717829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#717829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#717830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#717830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#717831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#717831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#717832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#717832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#717833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#717833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#717834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#717834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#717835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#717835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#717836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#717836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#717837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#717837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#717838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#717838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#717839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#717839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#717840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#717840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#717841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#717841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#717842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#717842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#717843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#717843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#717844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#717844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#717845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#717845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#717846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#717846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#717847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#717847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#717848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#717848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#717849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#717849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#717850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#717850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#717851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#717851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#717852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#717852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#717853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#717853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#717854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#717854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#717855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#717855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#717856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#717856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#717857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#717857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#717858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#717858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#717859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#717859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#717860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#717860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#717861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#717861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#717862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#717862)), 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#717772, et_numdos#717773, et_numdem#717774, et_typexa#717775, et_codexa#717776, et_exaacc#717777, et_libexa#717778, et_codapp#717779, et_numsal#717780, et_codper#717781, et_codrad#717782, et_codpro#717783, et_m_am_i#717784, et_ag_on#717785, et_datexa#717786, et_heuexa#717787, et_heusal#717788, et_heufin#717789, et_durtot#717790, et_durava#717791, et_durpen#717792, et_durapr#717793, et_datarr#717794, et_heuarr#717795, et_heud_e#717796, et_heuf_e#717797, et_codsit#717798, et_datmaj#717799, et_coduti#717800, et_numsat#717801, et_affect#717802, et_stu_id#717803, et_sta_pps#717804, et_sop_uid#717805, et_numgrp#717806, et_carrdv#717807, et_sanscr#717808, et_codats#717809, et_stabcd#717810, et_typesclq#717811, et_typbcd#717812, et_codprx#717813, et_flplan#717814, et_available#717815, et_aetitle#717816, et_secondaire#717817, et_mednuc#717818, et_fltbdi#717819, et_codfvu#717820, et_datfvu#717821, et_heufvu#717822, et_suspens#717823, et_acados#717824, et_acapub#717825, et_acamed#717826, et_acalib#717827, et_later#717828, et_position#717829, et_incidence#717830, et_numpdt#717831, et_numord#717832, et_trstat#717833, et_organe#717834, et_heuapp#717835, et_orirdv#717836, et_codvac#717837, et_codvaca#717838, et_numxus#717839, et_numexa_ori#717840, et_exacot#717841, et_flnocot#717842, et_alarmes#717843, et_modal_aet#717844, et_numprore#717845, et_comprore#717846, et_numrvx#717847, et_noseq#717848, et_datfin#717849, et_numresa#717850, et_fhirid#717851, et_regana#717852, et_nb_ser#717853, et_nb_fic#717854, et_nb_img_key#717855, et_stu_id_ori#717856, et_codper_prore#717857, et_numseance#717858, et_numordseance#717859, et_numtrt#717860, et_comment#717861, et_codloinc#717862]

(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#718947, et_numdos#718948, et_numdem#718949, et_typexa#718950, et_codexa#718951, et_exaacc#718952, et_libexa#718953, et_codapp#718954, et_numsal#718955, et_codper#718956, et_codrad#718957, et_codpro#718958, et_m_am_i#718959, et_ag_on#718960, et_datexa#718961, et_heuexa#718962, et_heusal#718963, et_heufin#718964, et_durtot#718965, et_durava#718966, et_durpen#718967, et_durapr#718968, et_datarr#718969, et_heuarr#718970, et_heud_e#718971, et_heuf_e#718972, et_codsit#718973, et_datmaj#718974, et_coduti#718975, et_numsat#718976, et_affect#718977, et_stu_id#718978, et_sta_pps#718979, et_sop_uid#718980, et_numgrp#718981, et_carrdv#718982, et_sanscr#718983, et_codats#718984, et_stabcd#718985, et_typesclq#718986, et_typbcd#718987, et_codprx#718988, et_flplan#718989, et_available#718990, et_aetitle#718991, et_secondaire#718992, et_mednuc#718993, et_fltbdi#718994, et_codfvu#718995, et_datfvu#718996, et_heufvu#718997, et_suspens#718998, et_acados#718999, et_acapub#719000, et_acamed#719001, et_acalib#719002, et_later#719003, et_position#719004, et_incidence#719005, et_numpdt#719006, et_numord#719007, et_trstat#719008, et_organe#719009, et_heuapp#719010, et_orirdv#719011, et_codvac#719012, et_codvaca#719013, et_numxus#719014, et_numexa_ori#719015, et_exacot#719016, et_flnocot#719017, et_alarmes#719018, et_modal_aet#719019, et_numprore#719020, et_comprore#719021, et_numrvx#719022, et_noseq#719023, et_datfin#719024, et_numresa#719025, et_fhirid#719026, et_regana#719027, et_nb_ser#719028, et_nb_fic#719029, et_nb_img_key#719030, et_stu_id_ori#719031, et_codper_prore#719032, et_numseance#719033, et_numordseance#719034, et_numtrt#719035, et_comment#719036, et_codloinc#719037]
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#718947, et_numdos#718948, et_numdem#718949, et_typexa#718950, et_codexa#718951, et_exaacc#718952, et_libexa#718953, et_codapp#718954, et_numsal#718955, et_codper#718956, et_codrad#718957, et_codpro#718958, et_m_am_i#718959, et_ag_on#718960, et_datexa#718961, et_heuexa#718962, et_heusal#718963, et_heufin#718964, et_durtot#718965, et_durava#718966, et_durpen#718967, et_durapr#718968, et_datarr#718969, et_heuarr#718970, et_heud_e#718971, et_heuf_e#718972, et_codsit#718973, et_datmaj#718974, et_coduti#718975, et_numsat#718976, et_affect#718977, et_stu_id#718978, et_sta_pps#718979, et_sop_uid#718980, et_numgrp#718981, et_carrdv#718982, et_sanscr#718983, et_codats#718984, et_stabcd#718985, et_typesclq#718986, et_typbcd#718987, et_codprx#718988, et_flplan#718989, et_available#718990, et_aetitle#718991, et_secondaire#718992, et_mednuc#718993, et_fltbdi#718994, et_codfvu#718995, et_datfvu#718996, et_heufvu#718997, et_suspens#718998, et_acados#718999, et_acapub#719000, et_acamed#719001, et_acalib#719002, et_later#719003, et_position#719004, et_incidence#719005, et_numpdt#719006, et_numord#719007, et_trstat#719008, et_organe#719009, et_heuapp#719010, et_orirdv#719011, et_codvac#719012, et_codvaca#719013, et_numxus#719014, et_numexa_ori#719015, et_exacot#719016, et_flnocot#719017, et_alarmes#719018, et_modal_aet#719019, et_numprore#719020, et_comprore#719021, et_numrvx#719022, et_noseq#719023, et_datfin#719024, et_numresa#719025, et_fhirid#719026, et_regana#719027, et_nb_ser#719028, et_nb_fic#719029, et_nb_img_key#719030, et_stu_id_ori#719031, et_codper_prore#719032, et_numseance#719033, et_numordseance#719034, et_numtrt#719035, et_comment#719036, et_codloinc#719037]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#718947)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#718947)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#718948)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#718948)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#718949)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#718949)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#718950)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#718950)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#718951)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#718951)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#718952)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#718952)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#718953)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#718953)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#718954)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#718954)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#718955)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#718955)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#718956)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#718956)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#718957)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#718957)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#718958)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#718958)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#718959)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#718959)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#718960)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#718960)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#718961)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#718961)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#718962)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#718962)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#718963)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#718963)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#718964)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#718964)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#718965)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#718965)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#718966)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#718966)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#718967)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#718967)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#718968)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#718968)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#718969)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#718969)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#718970)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#718970)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#718971)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#718971)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#718972)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#718972)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#718973)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#718973)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#718974)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#718974)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#718975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#718975)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#718976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#718976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#718977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#718977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#718978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#718978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#718979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#718979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#718980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#718980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#718981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#718981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#718982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#718982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#718983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#718983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#718984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#718984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#718985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#718985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#718986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#718986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#718987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#718987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#718988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#718988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#718989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#718989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#718990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_available#718990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#718991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#718991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#718992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#718992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#718993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#718993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#718994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#718994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#718995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#718995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#718996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#718996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#718997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#718997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#718998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#718998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#718999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#718999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#719000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#719000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#719001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#719001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#719002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#719002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#719003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_later#719003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#719004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_position#719004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#719005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#719005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#719006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#719006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#719007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#719007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#719008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#719008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#719009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#719009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#719010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#719010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#719011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#719011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#719012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#719012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#719013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#719013)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#719014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#719014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#719015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#719015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#719016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#719016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#719017)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#719017)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#719018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#719018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#719019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#719019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#719020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#719020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#719021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#719021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#719022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#719022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#719023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#719023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#719024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#719024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#719025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#719025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#719026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#719026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#719027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#719027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#719028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#719028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#719029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#719029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#719030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#719030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#719031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#719031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#719032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#719032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#719033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#719033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#719034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#719034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#719035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#719035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#719036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#719036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#719037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#719037)), 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#718947, et_numdos#718948, et_numdem#718949, et_typexa#718950, et_codexa#718951, et_exaacc#718952, et_libexa#718953, et_codapp#718954, et_numsal#718955, et_codper#718956, et_codrad#718957, et_codpro#718958, et_m_am_i#718959, et_ag_on#718960, et_datexa#718961, et_heuexa#718962, et_heusal#718963, et_heufin#718964, et_durtot#718965, et_durava#718966, et_durpen#718967, et_durapr#718968, et_datarr#718969, et_heuarr#718970, et_heud_e#718971, et_heuf_e#718972, et_codsit#718973, et_datmaj#718974, et_coduti#718975, et_numsat#718976, et_affect#718977, et_stu_id#718978, et_sta_pps#718979, et_sop_uid#718980, et_numgrp#718981, et_carrdv#718982, et_sanscr#718983, et_codats#718984, et_stabcd#718985, et_typesclq#718986, et_typbcd#718987, et_codprx#718988, et_flplan#718989, et_available#718990, et_aetitle#718991, et_secondaire#718992, et_mednuc#718993, et_fltbdi#718994, et_codfvu#718995, et_datfvu#718996, et_heufvu#718997, et_suspens#718998, et_acados#718999, et_acapub#719000, et_acamed#719001, et_acalib#719002, et_later#719003, et_position#719004, et_incidence#719005, et_numpdt#719006, et_numord#719007, et_trstat#719008, et_organe#719009, et_heuapp#719010, et_orirdv#719011, et_codvac#719012, et_codvaca#719013, et_numxus#719014, et_numexa_ori#719015, et_exacot#719016, et_flnocot#719017, et_alarmes#719018, et_modal_aet#719019, et_numprore#719020, et_comprore#719021, et_numrvx#719022, et_noseq#719023, et_datfin#719024, et_numresa#719025, et_fhirid#719026, et_regana#719027, et_nb_ser#719028, et_nb_fic#719029, et_nb_img_key#719030, et_stu_id_ori#719031, et_codper_prore#719032, et_numseance#719033, et_numordseance#719034, et_numtrt#719035, et_comment#719036, et_codloinc#719037]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#723007L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#720513L]
Results [1]: [count(1)#720513L AS COL_ec6de3b4-77bb-492b-9fcf-3c211f9e0bc1#720515L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#723007L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#720513L]
Results [1]: [count(1)#720513L AS COL_ec6de3b4-77bb-492b-9fcf-3c211f9e0bc1#720515L]

(16) AdaptiveSparkPlan
Output [1]: [COL_ec6de3b4-77bb-492b-9fcf-3c211f9e0bc1#720515L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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