hdh-spark-job - Details for Query 1184

Submitted Time: 2026/10/23 11:59:11
Duration: 1 s
Succeeded Jobs: 1179 1180 1181 1182 1183 1184 1185 1186 1187

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 (24)\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: 1 local merged chunks fetched: 0 shuffle write time: 0 ms 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: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B 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: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (23)\n \nduration: 101 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 101 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="SortMergeJoin number of output rows: 417,404 spill size: 0.0 B"]; } subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (21)\n \nduration: 114 ms"; 9 [labelType="html" label="Sort sort time: 17 ms peak memory: 66.0 MiB spill size: 0.0 B"]; } 10 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 103.5 KiB number of coalesced partitions: 1"]; 11 [labelType="html" label="Exchange shuffle records written: 72,488 local merged chunks fetched: 0 shuffle write time: 1 ms 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: 72,488 local bytes read: 96.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1698.7 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 96.1 KiB"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (20)\n \nduration: 155 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="SortMergeJoin number of output rows: 72,488 spill size: 0.0 B"]; } subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: 168 ms"; 16 [labelType="html" label="Sort sort time: 31 ms peak memory: 66.0 MiB spill size: 0.0 B"]; } 17 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 787.1 KiB number of coalesced partitions: 1"]; 18 [labelType="html" label="Exchange shuffle records written: 69,702 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (2 ms, 2 ms, 2 ms (stage 1629.0: task 1448)) 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: 69,702 local bytes read: 763.0 KiB 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)) 3.2 MiB (1633.5 KiB, 1633.5 KiB, 1633.5 KiB (stage 1629.0: task 1448)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 763.0 KiB (381.3 KiB, 381.8 KiB, 381.8 KiB (stage 1629.0: task 1448))"]; 19 [labelType="html" label=" Union "]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 37 ms"; 21 [labelType="html" label=" Project "]; 22 [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 cluster23 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 38 ms"; 24 [labelType="html" label=" Project "]; 25 [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"]; } subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: 162 ms"; 27 [labelType="html" label="Sort sort time: 18 ms peak memory: 65.0 MiB spill size: 0.0 B"]; } 28 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 216.7 KiB number of coalesced partitions: 1"]; 29 [labelType="html" label="Exchange shuffle records written: 28,520 local merged chunks fetched: 0 shuffle write time: 2 ms 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: 28,520 local bytes read: 204.0 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 891.3 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 204.0 KiB"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 325 ms"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="SortMergeJoin number of output rows: 28,520 spill size: 0.0 B"]; } subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 350 ms"; 34 [labelType="html" label="Sort sort time: 35 ms peak memory: 65.0 MiB spill size: 0.0 B"]; } 35 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 429.7 KiB number of coalesced partitions: 1"]; 36 [labelType="html" label="Exchange shuffle records written: 27,596 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 4 ms (2 ms, 2 ms, 2 ms (stage 1630.0: task 1450)) 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: 27,596 local bytes read: 408.6 KiB 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)) 1509.2 KiB (754.6 KiB, 754.6 KiB, 754.6 KiB (stage 1630.0: task 1451)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 408.6 KiB (204.1 KiB, 204.5 KiB, 204.5 KiB (stage 1630.0: task 1450))"]; 37 [labelType="html" label=" Union "]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 16 ms"; 39 [labelType="html" label=" Project "]; 40 [labelType="html" label="Scan JDBCRelation((SELECT \"cr_numcr\", \"cr_numdos\", \"cr_nomdic\", \"cr_numdem\", \"cr_numexa\", \"cr_typdoc\", \"cr_prior\", \"cr_nomdcr\", \"cr_taidcr\", \"cr_durdcr\", \"cr_posdcr\", \"cr_nomdos\", \"cr_for_cr\", \"cr_cr\", \"cr_statdic\", \"cr_statsm\", \"cr_statcr\", \"cr_coddic\", \"cr_context\", \"cr_datdic\", \"cr_heudic\", \"cr_heui_d\", \"cr_heui_f\", \"cr_codsec\", \"cr_datsec\", \"cr_heusec\", \"cr_codvcr\", \"cr_datvcr\", \"cr_heuvcr\", \"cr_coddcr\", \"cr_datdcr\", \"cr_heudcr\", \"cr_dat_eff_d\", \"cr_dat_eff_w\", \"cr_coduti\", \"cr_datmaj\", \"cr_codsit\", \"cr_sectra\", \"cr_typcr\", \"cr_codsup\", \"cr_nivvcr\", \"cr_numvcr\", \"cr_nb_cor\", \"cr_datsup\", \"cr_heusup\", \"cr_flarch\", \"cr_staext\", \"cr_flimpr\", \"cr_lockcr\", \"cr_codmcr\", \"cr_datmcr\", \"cr_heumcr\", \"cr_codacc\", \"cr_motpas\", \"cr_libco\", \"cr_subdic\", \"cr_subdir\", \"cr_numprt\", \"cr_sta_env_prt\", \"cr_sta_ret_pro\", \"cr_sta_env_fra\", \"cr_sta_ret_fra\", \"cr_codcli\", \"cr_pri_dic\", \"cr_dat_dic_tra\", \"cr_heu_dic_tra\", \"cr_codfra\", \"cr_secext\", \"cr_statut_ext\", \"cr_simp_job_id\", \"cr_dat_cr_int\", \"cr_heu_cr_int\", \"cr_delai_total\", \"cr_nb_ligne_ext\", \"cr_nb_car_ext\", \"cr_nomext\", \"cr_subext\", \"cr_fltbdi\", \"cr_typdic\", \"cr_sta_env_ack\", \"cr_sta_ret_ack\", \"cr_taille_dic\", \"cr_chksum_dic\", \"cr_datmail\", \"cr_heumail\", \"cr_codmail\", \"cr_stadmp\", \"cr_coddmp\", \"cr_datdmp\", \"cr_heudmp\", \"cr_oiddmp\", \"cr_visdmp\", \"cr_scnpat\", \"cr_datscn\", \"cr_nummcr\", \"cr_numcr_cloud\", \"cr_numdrv\", \"cr_flarch_d\", \"cr_refext\", \"cr_annonce\", \"cr_periph\", \"cr_datcre\", \"cr_heucre\", \"cr_origine\", \"cr_oid\", \"cr_flordo\", \"cr_idcda\", \"cr_fltr\" FROM \"xplore\".\"h_cr\") as x) [numPartitions=1] number of output rows: 13,798"]; } subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 16 ms"; 42 [labelType="html" label=" Project "]; 43 [labelType="html" label="Scan JDBCRelation((SELECT \"cr_numcr\", \"cr_numdos\", \"cr_nomdic\", \"cr_numdem\", \"cr_numexa\", \"cr_typdoc\", \"cr_prior\", \"cr_nomdcr\", \"cr_taidcr\", \"cr_durdcr\", \"cr_posdcr\", \"cr_nomdos\", \"cr_for_cr\", \"cr_cr\", \"cr_statdic\", \"cr_statsm\", \"cr_statcr\", \"cr_coddic\", \"cr_context\", \"cr_datdic\", \"cr_heudic\", \"cr_heui_d\", \"cr_heui_f\", \"cr_codsec\", \"cr_datsec\", \"cr_heusec\", \"cr_codvcr\", \"cr_datvcr\", \"cr_heuvcr\", \"cr_coddcr\", \"cr_datdcr\", \"cr_heudcr\", \"cr_dat_eff_d\", \"cr_dat_eff_w\", \"cr_coduti\", \"cr_datmaj\", \"cr_codsit\", \"cr_sectra\", \"cr_typcr\", \"cr_codsup\", \"cr_nivvcr\", \"cr_numvcr\", \"cr_nb_cor\", \"cr_datsup\", \"cr_heusup\", \"cr_flarch\", \"cr_staext\", \"cr_flimpr\", \"cr_lockcr\", \"cr_codmcr\", \"cr_datmcr\", \"cr_heumcr\", \"cr_codacc\", \"cr_motpas\", \"cr_libco\", \"cr_subdic\", \"cr_subdir\", \"cr_numprt\", \"cr_sta_env_prt\", \"cr_sta_ret_pro\", \"cr_sta_env_fra\", \"cr_sta_ret_fra\", \"cr_codcli\", \"cr_pri_dic\", \"cr_dat_dic_tra\", \"cr_heu_dic_tra\", \"cr_codfra\", \"cr_secext\", \"cr_statut_ext\", \"cr_simp_job_id\", \"cr_dat_cr_int\", \"cr_heu_cr_int\", \"cr_delai_total\", \"cr_nb_ligne_ext\", \"cr_nb_car_ext\", \"cr_nomext\", \"cr_subext\", \"cr_fltbdi\", \"cr_typdic\", \"cr_sta_env_ack\", \"cr_sta_ret_ack\", \"cr_taille_dic\", \"cr_chksum_dic\", \"cr_datmail\", \"cr_heumail\", \"cr_codmail\", \"cr_stadmp\", \"cr_coddmp\", \"cr_datdmp\", \"cr_heudmp\", \"cr_oiddmp\", \"cr_visdmp\", \"cr_scnpat\", \"cr_datscn\", \"cr_nummcr\", \"cr_numcr_cloud\", \"cr_numdrv\", \"cr_flarch_d\", \"cr_refext\", \"cr_annonce\", \"cr_periph\", \"cr_datcre\", \"cr_heucre\", \"cr_origine\", \"cr_oid\", \"cr_flordo\", \"cr_idcda\", \"cr_fltr\" FROM \"xplore2\".\"h_cr\") as x) [numPartitions=1] number of output rows: 13,798"]; } subgraph cluster44 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 45 [labelType="html" label=" Project "]; 46 [labelType="html" label="SortMergeJoin number of output rows: 57,883 spill size: 0.0 B"]; } subgraph cluster47 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 0 ms"; 48 [labelType="html" label="Sort sort time: 48 ms peak memory: 66.0 MiB spill size: 0.0 B"]; } 49 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 376.1 KiB number of coalesced partitions: 1"]; 50 [labelType="html" label="Exchange shuffle records written: 47,008 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 4 ms (2 ms, 2 ms, 2 ms (stage 1631.0: task 1452)) 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: 94,016 local bytes read: 718.0 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 4 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1403.6 KiB (701.8 KiB, 701.8 KiB, 701.8 KiB (stage 1631.0: task 1453)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 359.0 KiB (179.4 KiB, 179.6 KiB, 179.6 KiB (stage 1631.0: task 1452))"]; 51 [labelType="html" label=" Union "]; subgraph cluster52 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 24 ms"; 53 [labelType="html" label=" Project "]; 54 [labelType="html" label="Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; } subgraph cluster55 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 24 ms"; 56 [labelType="html" label=" Project "]; 57 [labelType="html" label="Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore2\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; } subgraph cluster58 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 0 ms"; 59 [labelType="html" label="Sort sort time: 48 ms peak memory: 66.0 MiB spill size: 0.0 B"]; } 60 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 376.1 KiB number of coalesced partitions: 1"]; subgraph cluster61 { isCluster="true"; label="WholeStageCodegen (22)\n \nduration: 0 ms"; 62 [labelType="html" label="Sort sort time: 3 ms peak memory: 64.2 MiB spill size: 0.0 B"]; } 63 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 82.9 KiB number of coalesced partitions: 1"]; 64 [labelType="html" label="Exchange shuffle records written: 9,179 local merged chunks fetched: 0 shuffle write time: 2 ms 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: 9,179 local bytes read: 77.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 215.5 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 77.9 KiB"]; subgraph cluster65 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: 167 ms"; 66 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 149 ms peak memory: 64.5 MiB number of output rows: 9,179 number of sort fallback tasks: 0 avg hash probes per key: 1.3"]; } 67 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1957.4 KiB number of coalesced partitions: 1"]; 68 [labelType="html" label="Exchange shuffle records written: 18,358 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 8 ms (3 ms, 4 ms, 4 ms (stage 1632.0: task 1454)) 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: 18,358 local bytes read: 1860.1 KiB 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)) 14.5 MiB (7.3 MiB, 7.3 MiB, 7.3 MiB (stage 1632.0: task 1455)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1860.1 KiB (930.0 KiB, 930.0 KiB, 930.0 KiB (stage 1632.0: task 1455))"]; subgraph cluster69 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n539 ms (265 ms, 274 ms, 274 ms (stage 1632.0: task 1454))"; 70 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 353 ms (171 ms, 182 ms, 182 ms (stage 1632.0: task 1454)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1632.0: task 1455)) number of output rows: 18,358 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1.4, 1.4, 1.4 (stage 1632.0: task 1455))"]; } 71 [labelType="html" label=" Union "]; subgraph cluster72 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 244 ms"; 73 [labelType="html" label=" Project "]; 74 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,179"]; } subgraph cluster75 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 229 ms"; 76 [labelType="html" label=" Project "]; 77 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore2\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,179"]; } 2->0; 3->2; 5->3; 6->5; 7->6; 9->7; 10->9; 11->10; 13->11; 14->13; 16->14; 17->16; 18->17; 19->18; 21->19; 22->21; 24->19; 25->24; 27->14; 28->27; 29->28; 31->29; 32->31; 34->32; 35->34; 36->35; 37->36; 39->37; 40->39; 42->37; 43->42; 45->32; 46->45; 48->46; 49->48; 50->49; 51->50; 53->51; 54->53; 56->51; 57->56; 59->46; 60->59; 50->60; 62->7; 63->62; 64->63; 66->64; 67->66; 68->67; 70->68; 71->70; 73->71; 74->73; 76->71; 77->76; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (24)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=27962]

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

Project

SortMergeJoin [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260], [H_VALEU_438376_AL_VALCOU_438379#459597], LeftOuter

WholeStageCodegen (23)

Sort [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260 ASC NULLS FIRST], false, 0

WholeStageCodegen (21)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, 10), ENSURE_REQUIREMENTS, [plan_id=27884]

Project [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]

SortMergeJoin [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252], [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302], LeftOuter

WholeStageCodegen (20)

Sort [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252 ASC NULLS FIRST], false, 0

WholeStageCodegen (18)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, 10), ENSURE_REQUIREMENTS, [plan_id=27306]

Union

Project [et_numexa#446319 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, et_numsal#446327 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]

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#446319,et_numsal#446327] PushedFilters: [], ReadSchema: struct<et_numexa:string,et_numsal:string>

WholeStageCodegen (1)

Project [et_numexa#447141 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#460369, et_numsal#447149 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#460370]

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#447141,et_numsal#447149] PushedFilters: [], ReadSchema: struct<et_numexa:string,et_numsal:string>

WholeStageCodegen (2)

Sort [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302 ASC NULLS FIRST], false, 0

WholeStageCodegen (19)

AQEShuffleRead coalesced

Exchange hashpartitioning(H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302, 10), ENSURE_REQUIREMENTS, [plan_id=27661]

Project [COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234 AS H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]

SortMergeJoin [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231], [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269], LeftOuter

WholeStageCodegen (16)

Sort [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231 ASC NULLS FIRST], false, 0

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, 10), ENSURE_REQUIREMENTS, [plan_id=27317]

Union

Project [cr_numdos#455172 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, cr_numexa#455175 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]

Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] [cr_numdos#455172,cr_numexa#455175] PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL])), *IsNotNull(cr_numexa)], ReadSchema: struct<cr_numdos:string,cr_numexa:string>

WholeStageCodegen (3)

Project [cr_numdos#456147 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#460371, cr_numexa#456150 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#460372]

Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] [cr_numdos#456147,cr_numexa#456150] PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL])), *IsNotNull(cr_numexa)], ReadSchema: struct<cr_numdos:string,cr_numexa:string>

WholeStageCodegen (4)

Project [COL_499EB20D_E124_400E_A51E_F020884D243F#454742 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]

SortMergeJoin [COL_499EB20D_E124_400E_A51E_F020884D243F#454742], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781], LeftOuter

WholeStageCodegen (15)

Sort [COL_499EB20D_E124_400E_A51E_F020884D243F#454742 ASC NULLS FIRST], false, 0

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#454742, 10), ENSURE_REQUIREMENTS, [plan_id=27328]

Union

Project [at_numdos#449573 AS COL_499EB20D_E124_400E_A51E_F020884D243F#454742]

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [at_numdos#449573] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string>

WholeStageCodegen (5)

Project [at_numdos#450800 AS COL_499EB20D_E124_400E_A51E_F020884D243F#460373]

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [at_numdos#450800] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string>

WholeStageCodegen (6)

Sort [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781 ASC NULLS FIRST], false, 0

WholeStageCodegen (14)

AQEShuffleRead coalesced

Sort [H_VALEU_438376_AL_VALCOU_438379#459597 ASC NULLS FIRST], false, 0

WholeStageCodegen (22)

AQEShuffleRead coalesced

Exchange hashpartitioning(H_VALEU_438376_AL_VALCOU_438379#459597, 10), ENSURE_REQUIREMENTS, [plan_id=27767]

HashAggregate(keys=[AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, ... 36 more fields], functions=[])

WholeStageCodegen (17)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=27365]

WholeStageCodegen (11)

Union

Project [al_annval#448148 AS AL_ANNVAL_438378#448560, al_classe#448167 AS AL_CLASSE_438397#448561, al_codcha#448194 AS AL_CODCHA_438424#448562, al_codsit#448157 AS AL_CODSIT_438387#448563, al_coduti#448156 AS AL_CODUTI_438386#448564, al_codval#448147 AS AL_CODVAL_438377#448565, al_comment#448192 AS AL_COMMENT_438422#448566, al_datede#448190 AS AL_DATEDE_438420#448567, al_datefi#448202 AS AL_DATEFI_438432#448568, al_datmaj#448155 AS AL_DATMAJ_438385#448569, al_envadm#448163 AS AL_ENVADM_438393#448570, al_flicpt#448189 AS AL_FLICPT_438419#448571, al_flsej#448188 AS AL_FLSEJ_438418#448572, al_fltele#448193 AS AL_FLTELE_438423#448573, al_forfai#448166 AS AL_FORFAI_438396#448574, al_icd#448204 AS AL_ICD_438434#448575, al_int_spe#448199 AS AL_INT_SPE_438429#448576, al_int_std#448198 AS AL_INT_STD_438428#448577, al_letadm#448162 AS AL_LETADM_438392#448578, al_letads#448195 AS AL_LETADS_438425#448579, al_lib30#448150 AS AL_LIB30_438380#448580, al_libmaj#448151 AS AL_LIBMAJ_438381#448581, al_monnaie#448158 AS AL_MONNAIE_438388#448582, al_numbmp#448160 AS AL_NUMBMP_438390#448583, ... 36 more fields]

Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1] [al_annval#448148,al_classe#448167,al_codcha#448194,al_codsit#448157,al_coduti#448156,al_codval#448147,al_comment#448192,al_datede#448190,al_datefi#448202,al_datmaj#448155,al_envadm#448163,al_flicpt#448189,al_flsej#448188,al_fltele#448193,al_forfai#448166,al_icd#448204,al_int_spe#448199,al_int_std#448198,al_letadm#448162,al_letads#448195,al_lib30#448150,al_libmaj#448151,al_monnaie#448158,al_numbmp#448160,... 35 more fields] PushedFilters: [*IsNotNull(al_valcou)], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (9)

Project [al_annval#448681 AS AL_ANNVAL_438378#449093, al_classe#448700 AS AL_CLASSE_438397#449094, al_codcha#448727 AS AL_CODCHA_438424#449095, al_codsit#448690 AS AL_CODSIT_438387#449096, al_coduti#448689 AS AL_CODUTI_438386#449097, al_codval#448680 AS AL_CODVAL_438377#449098, al_comment#448725 AS AL_COMMENT_438422#449099, al_datede#448723 AS AL_DATEDE_438420#449100, al_datefi#448735 AS AL_DATEFI_438432#449101, al_datmaj#448688 AS AL_DATMAJ_438385#449102, al_envadm#448696 AS AL_ENVADM_438393#449103, al_flicpt#448722 AS AL_FLICPT_438419#449104, al_flsej#448721 AS AL_FLSEJ_438418#449105, al_fltele#448726 AS AL_FLTELE_438423#449106, al_forfai#448699 AS AL_FORFAI_438396#449107, al_icd#448737 AS AL_ICD_438434#449108, al_int_spe#448732 AS AL_INT_SPE_438429#449109, al_int_std#448731 AS AL_INT_STD_438428#449110, al_letadm#448695 AS AL_LETADM_438392#449111, al_letads#448728 AS AL_LETADS_438425#449112, al_lib30#448683 AS AL_LIB30_438380#449113, al_libmaj#448684 AS AL_LIBMAJ_438381#449114, al_monnaie#448691 AS AL_MONNAIE_438388#449115, al_numbmp#448693 AS AL_NUMBMP_438390#449116, ... 36 more fields]

Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1] [al_annval#448681,al_classe#448700,al_codcha#448727,al_codsit#448690,al_coduti#448689,al_codval#448680,al_comment#448725,al_datede#448723,al_datefi#448735,al_datmaj#448688,al_envadm#448696,al_flicpt#448722,al_flsej#448721,al_fltele#448726,al_forfai#448699,al_icd#448737,al_int_spe#448732,al_int_std#448731,al_letadm#448695,al_letads#448728,al_lib30#448683,al_libmaj#448684,al_monnaie#448691,al_numbmp#448693,... 35 more fields] PushedFilters: [*IsNotNull(al_valcou)], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (10)

Details

== Physical Plan ==
AdaptiveSparkPlan (103)
+- == Final Plan ==
   * HashAggregate (65)
   +- ShuffleQueryStage (64), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (63)
         +- * HashAggregate (62)
            +- * Project (61)
               +- * SortMergeJoin LeftOuter (60)
                  :- * Sort (45)
                  :  +- AQEShuffleRead (44)
                  :     +- ShuffleQueryStage (43), Statistics(sizeInBytes=1698.7 KiB, rowCount=7.25E+4)
                  :        +- Exchange (42)
                  :           +- * Project (41)
                  :              +- * SortMergeJoin LeftOuter (40)
                  :                 :- * Sort (9)
                  :                 :  +- AQEShuffleRead (8)
                  :                 :     +- ShuffleQueryStage (7), Statistics(sizeInBytes=3.2 MiB, rowCount=6.97E+4)
                  :                 :        +- Exchange (6)
                  :                 :           +- Union (5)
                  :                 :              :- * Project (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 (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]  (3)
                  :                 +- * Sort (39)
                  :                    +- AQEShuffleRead (38)
                  :                       +- ShuffleQueryStage (37), Statistics(sizeInBytes=891.3 KiB, rowCount=2.85E+4)
                  :                          +- Exchange (36)
                  :                             +- * Project (35)
                  :                                +- * SortMergeJoin LeftOuter (34)
                  :                                   :- * Sort (18)
                  :                                   :  +- AQEShuffleRead (17)
                  :                                   :     +- ShuffleQueryStage (16), Statistics(sizeInBytes=1509.2 KiB, rowCount=2.76E+4)
                  :                                   :        +- Exchange (15)
                  :                                   :           +- Union (14)
                  :                                   :              :- * Project (11)
                  :                                   :              :  +- * Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1]  (10)
                  :                                   :              +- * Project (13)
                  :                                   :                 +- * Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1]  (12)
                  :                                   +- * Project (33)
                  :                                      +- * SortMergeJoin LeftOuter (32)
                  :                                         :- * Sort (27)
                  :                                         :  +- AQEShuffleRead (26)
                  :                                         :     +- ShuffleQueryStage (25), Statistics(sizeInBytes=1403.6 KiB, rowCount=4.70E+4)
                  :                                         :        +- Exchange (24)
                  :                                         :           +- Union (23)
                  :                                         :              :- * Project (20)
                  :                                         :              :  +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  (19)
                  :                                         :              +- * Project (22)
                  :                                         :                 +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  (21)
                  :                                         +- * Sort (31)
                  :                                            +- AQEShuffleRead (30)
                  :                                               +- ShuffleQueryStage (29), Statistics(sizeInBytes=1403.6 KiB, rowCount=4.70E+4)
                  :                                                  +- ReusedExchange (28)
                  +- * Sort (59)
                     +- AQEShuffleRead (58)
                        +- ShuffleQueryStage (57), Statistics(sizeInBytes=215.5 KiB, rowCount=9.18E+3)
                           +- Exchange (56)
                              +- * HashAggregate (55)
                                 +- AQEShuffleRead (54)
                                    +- ShuffleQueryStage (53), Statistics(sizeInBytes=14.5 MiB, rowCount=1.84E+4)
                                       +- Exchange (52)
                                          +- * HashAggregate (51)
                                             +- Union (50)
                                                :- * Project (47)
                                                :  +- * Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (46)
                                                +- * Project (49)
                                                   +- * Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (48)
+- == Initial Plan ==
   HashAggregate (102)
   +- Exchange (101)
      +- HashAggregate (100)
         +- Project (99)
            +- SortMergeJoin LeftOuter (98)
               :- Sort (91)
               :  +- Exchange (90)
               :     +- Project (89)
               :        +- SortMergeJoin LeftOuter (88)
               :           :- Sort (68)
               :           :  +- Exchange (67)
               :           :     +- Union (66)
               :           :        :- Project (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 (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]  (3)
               :           +- Sort (87)
               :              +- Exchange (86)
               :                 +- Project (85)
               :                    +- SortMergeJoin LeftOuter (84)
               :                       :- Sort (71)
               :                       :  +- Exchange (70)
               :                       :     +- Union (69)
               :                       :        :- Project (11)
               :                       :        :  +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1]  (10)
               :                       :        +- Project (13)
               :                       :           +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1]  (12)
               :                       +- Project (83)
               :                          +- SortMergeJoin LeftOuter (82)
               :                             :- Sort (74)
               :                             :  +- Exchange (73)
               :                             :     +- Union (72)
               :                             :        :- Project (20)
               :                             :        :  +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  (19)
               :                             :        +- Project (22)
               :                             :           +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  (21)
               :                             +- Sort (81)
               :                                +- Exchange (80)
               :                                   +- Union (79)
               :                                      :- Project (76)
               :                                      :  +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  (75)
               :                                      +- Project (78)
               :                                         +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  (77)
               +- Sort (97)
                  +- Exchange (96)
                     +- HashAggregate (95)
                        +- Exchange (94)
                           +- HashAggregate (93)
                              +- Union (92)
                                 :- Project (47)
                                 :  +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (46)
                                 +- Project (49)
                                    +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (48)


(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 [2]: [et_numexa#446319, et_numsal#446327]
ReadSchema: struct<et_numexa:string,et_numsal:string>

(2) Project [codegen id : 1]
Output [2]: [et_numexa#446319 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, et_numsal#446327 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Input [2]: [et_numexa#446319, et_numsal#446327]

(3) 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 [2]: [et_numexa#447141, et_numsal#447149]
ReadSchema: struct<et_numexa:string,et_numsal:string>

(4) Project [codegen id : 2]
Output [2]: [et_numexa#447141 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#460369, et_numsal#447149 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#460370]
Input [2]: [et_numexa#447141, et_numsal#447149]

(5) Union

(6) Exchange
Input [2]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: hashpartitioning(COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, 10), ENSURE_REQUIREMENTS, [plan_id=27306]

(7) ShuffleQueryStage
Output [2]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: 0

(8) AQEShuffleRead
Input [2]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: coalesced

(9) Sort [codegen id : 18]
Input [2]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252 ASC NULLS FIRST], false, 0

(10) Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1]  [codegen id : 3]
Output [2]: [cr_numdos#455172, cr_numexa#455175]
PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL])), *IsNotNull(cr_numexa)]
ReadSchema: struct<cr_numdos:string,cr_numexa:string>

(11) Project [codegen id : 3]
Output [2]: [cr_numdos#455172 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, cr_numexa#455175 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Input [2]: [cr_numdos#455172, cr_numexa#455175]

(12) Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1]  [codegen id : 4]
Output [2]: [cr_numdos#456147, cr_numexa#456150]
PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL])), *IsNotNull(cr_numexa)]
ReadSchema: struct<cr_numdos:string,cr_numexa:string>

(13) Project [codegen id : 4]
Output [2]: [cr_numdos#456147 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#460371, cr_numexa#456150 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#460372]
Input [2]: [cr_numdos#456147, cr_numexa#456150]

(14) Union

(15) Exchange
Input [2]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, 10), ENSURE_REQUIREMENTS, [plan_id=27317]

(16) ShuffleQueryStage
Output [2]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Arguments: 1

(17) AQEShuffleRead
Input [2]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Arguments: coalesced

(18) Sort [codegen id : 12]
Input [2]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231 ASC NULLS FIRST], false, 0

(19) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  [codegen id : 5]
Output [1]: [at_numdos#449573]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>

(20) Project [codegen id : 5]
Output [1]: [at_numdos#449573 AS COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Input [1]: [at_numdos#449573]

(21) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  [codegen id : 6]
Output [1]: [at_numdos#450800]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>

(22) Project [codegen id : 6]
Output [1]: [at_numdos#450800 AS COL_499EB20D_E124_400E_A51E_F020884D243F#460373]
Input [1]: [at_numdos#450800]

(23) Union

(24) Exchange
Input [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#454742, 10), ENSURE_REQUIREMENTS, [plan_id=27328]

(25) ShuffleQueryStage
Output [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Arguments: 2

(26) AQEShuffleRead
Input [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Arguments: coalesced

(27) Sort [codegen id : 13]
Input [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742 ASC NULLS FIRST], false, 0

(28) ReusedExchange [Reuses operator id: 24]
Output [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]

(29) ShuffleQueryStage
Output [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Arguments: 4

(30) AQEShuffleRead
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Arguments: coalesced

(31) Sort [codegen id : 14]
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781 ASC NULLS FIRST], false, 0

(32) SortMergeJoin [codegen id : 15]
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Join type: LeftOuter
Join condition: None

(33) Project [codegen id : 15]
Output [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]
Input [2]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]

(34) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]
Join type: LeftOuter
Join condition: None

(35) Project [codegen id : 16]
Output [1]: [COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234 AS H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Input [3]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]

(36) Exchange
Input [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Arguments: hashpartitioning(H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302, 10), ENSURE_REQUIREMENTS, [plan_id=27661]

(37) ShuffleQueryStage
Output [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Arguments: 6

(38) AQEShuffleRead
Input [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Arguments: coalesced

(39) Sort [codegen id : 19]
Input [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Arguments: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302 ASC NULLS FIRST], false, 0

(40) SortMergeJoin [codegen id : 20]
Left keys [1]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252]
Right keys [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Join type: LeftOuter
Join condition: None

(41) Project [codegen id : 20]
Output [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Input [3]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]

(42) Exchange
Input [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: hashpartitioning(COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, 10), ENSURE_REQUIREMENTS, [plan_id=27884]

(43) ShuffleQueryStage
Output [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: 8

(44) AQEShuffleRead
Input [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: coalesced

(45) Sort [codegen id : 21]
Input [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260 ASC NULLS FIRST], false, 0

(46) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  [codegen id : 9]
Output [59]: [al_annval#448148, al_classe#448167, al_codcha#448194, al_codsit#448157, al_coduti#448156, al_codval#448147, al_comment#448192, al_datede#448190, al_datefi#448202, al_datmaj#448155, al_envadm#448163, al_flicpt#448189, al_flsej#448188, al_fltele#448193, al_forfai#448166, al_icd#448204, al_int_spe#448199, al_int_std#448198, al_letadm#448162, al_letads#448195, al_lib30#448150, al_libmaj#448151, al_monnaie#448158, al_numbmp#448160, al_numcpt#448191, al_ordre#448161, al_primai#448203, al_prior#448153, al_rcp#448201, al_rembours#448169, al_revers#448168, al_sites#448196, al_spl_trans#448200, al_taux#448152, al_taux_r#448165, al_taux_t1r#448179, al_taux_t1#448170, al_taux_t2r#448180, al_taux_t2#448171, al_taux_t3r#448181, al_taux_t3#448172, al_taux_t4r#448182, al_taux_t4#448173, al_taux_t5r#448183, al_taux_t5#448174, al_taux_t6r#448184, al_taux_t6#448175, al_taux_t7r#448185, al_taux_t7#448176, al_taux_t8r#448186, al_taux_t8#448177, al_taux_t9r#448187, al_taux_t9#448178, al_typexa#448159, al_type#448154, al_type_icd#448205, al_t_red#448164, al_urg#448197, al_valcou#448149]
PushedFilters: [*IsNotNull(al_valcou)]
ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_codval:string,al_comment:string,al_datede:string,al_datefi:string,al_datmaj:string,al_envadm:string,al_flicpt:string,al_flsej:string,al_fltele:string,al_forfai:string,al_icd:string,al_int_spe:string,al_int_std:string,al_letadm:string,al_letads:string,al_lib30:string,al_libmaj:string,al_monnaie:string,al_numbmp:string,al_numcpt:string,al_ordre:string,al_primai:string,al_prior:string,al_rcp:string,al_rembours:string,al_revers:string,al_sites:string,al_spl_trans:string,al_taux:string,al_taux_r:string,al_taux_t1r:string,al_taux_t1:string,al_taux_t2r:string,al_taux_t2:string,al_taux_t3r:string,al_taux_t3:string,al_taux_t4r:string,al_taux_t4:string,al_taux_t5r:string,al_taux_t5:string,al_taux_t6r:string,al_taux_t6:string,al_taux_t7r:string,al_taux_t7:string,al_taux_t8r:string,al_taux_t8:string,al_taux_t9r:string,al_taux_t9:string,al_typexa:string,al_type:string,al_type_icd:string,al_t_red:string,al_urg:string,al_valcou:string>

(47) Project [codegen id : 9]
Output [60]: [al_annval#448148 AS AL_ANNVAL_438378#448560, al_classe#448167 AS AL_CLASSE_438397#448561, al_codcha#448194 AS AL_CODCHA_438424#448562, al_codsit#448157 AS AL_CODSIT_438387#448563, al_coduti#448156 AS AL_CODUTI_438386#448564, al_codval#448147 AS AL_CODVAL_438377#448565, al_comment#448192 AS AL_COMMENT_438422#448566, al_datede#448190 AS AL_DATEDE_438420#448567, al_datefi#448202 AS AL_DATEFI_438432#448568, al_datmaj#448155 AS AL_DATMAJ_438385#448569, al_envadm#448163 AS AL_ENVADM_438393#448570, al_flicpt#448189 AS AL_FLICPT_438419#448571, al_flsej#448188 AS AL_FLSEJ_438418#448572, al_fltele#448193 AS AL_FLTELE_438423#448573, al_forfai#448166 AS AL_FORFAI_438396#448574, al_icd#448204 AS AL_ICD_438434#448575, al_int_spe#448199 AS AL_INT_SPE_438429#448576, al_int_std#448198 AS AL_INT_STD_438428#448577, al_letadm#448162 AS AL_LETADM_438392#448578, al_letads#448195 AS AL_LETADS_438425#448579, al_lib30#448150 AS AL_LIB30_438380#448580, al_libmaj#448151 AS AL_LIBMAJ_438381#448581, al_monnaie#448158 AS AL_MONNAIE_438388#448582, al_numbmp#448160 AS AL_NUMBMP_438390#448583, al_numcpt#448191 AS AL_NUMCPT_438421#448584, al_ordre#448161 AS AL_ORDRE_438391#448585, al_primai#448203 AS AL_PRIMAI_438433#448586, al_prior#448153 AS AL_PRIOR_438383#448587, al_rcp#448201 AS AL_RCP_438431#448588, al_rembours#448169 AS AL_REMBOURS_438399#448589, al_revers#448168 AS AL_REVERS_438398#448590, al_sites#448196 AS AL_SITES_438426#448591, al_spl_trans#448200 AS AL_SPL_TRANS_438430#448592, al_taux#448152 AS AL_TAUX_438382#448593, al_taux_r#448165 AS AL_TAUX_R_438395#448594, al_taux_t1r#448179 AS AL_TAUX_T1R_438409#448595, al_taux_t1#448170 AS AL_TAUX_T1_438400#448596, al_taux_t2r#448180 AS AL_TAUX_T2R_438410#448597, al_taux_t2#448171 AS AL_TAUX_T2_438401#448598, al_taux_t3r#448181 AS AL_TAUX_T3R_438411#448599, al_taux_t3#448172 AS AL_TAUX_T3_438402#448600, al_taux_t4r#448182 AS AL_TAUX_T4R_438412#448601, al_taux_t4#448173 AS AL_TAUX_T4_438403#448602, al_taux_t5r#448183 AS AL_TAUX_T5R_438413#448603, al_taux_t5#448174 AS AL_TAUX_T5_438404#448604, al_taux_t6r#448184 AS AL_TAUX_T6R_438414#448605, al_taux_t6#448175 AS AL_TAUX_T6_438405#448606, al_taux_t7r#448185 AS AL_TAUX_T7R_438415#448607, al_taux_t7#448176 AS AL_TAUX_T7_438406#448608, al_taux_t8r#448186 AS AL_TAUX_T8R_438416#448609, al_taux_t8#448177 AS AL_TAUX_T8_438407#448610, al_taux_t9r#448187 AS AL_TAUX_T9R_438417#448611, al_taux_t9#448178 AS AL_TAUX_T9_438408#448612, al_typexa#448159 AS AL_TYPEXA_438389#448613, al_type#448154 AS AL_TYPE_438384#448614, al_type_icd#448205 AS AL_TYPE_ICD_438435#448615, al_t_red#448164 AS AL_T_RED_438394#448616, al_urg#448197 AS AL_URG_438427#448617, al_valcou#448149 AS AL_VALCOU_438379#448618, null AS ORIGINE_440156#448619]
Input [59]: [al_annval#448148, al_classe#448167, al_codcha#448194, al_codsit#448157, al_coduti#448156, al_codval#448147, al_comment#448192, al_datede#448190, al_datefi#448202, al_datmaj#448155, al_envadm#448163, al_flicpt#448189, al_flsej#448188, al_fltele#448193, al_forfai#448166, al_icd#448204, al_int_spe#448199, al_int_std#448198, al_letadm#448162, al_letads#448195, al_lib30#448150, al_libmaj#448151, al_monnaie#448158, al_numbmp#448160, al_numcpt#448191, al_ordre#448161, al_primai#448203, al_prior#448153, al_rcp#448201, al_rembours#448169, al_revers#448168, al_sites#448196, al_spl_trans#448200, al_taux#448152, al_taux_r#448165, al_taux_t1r#448179, al_taux_t1#448170, al_taux_t2r#448180, al_taux_t2#448171, al_taux_t3r#448181, al_taux_t3#448172, al_taux_t4r#448182, al_taux_t4#448173, al_taux_t5r#448183, al_taux_t5#448174, al_taux_t6r#448184, al_taux_t6#448175, al_taux_t7r#448185, al_taux_t7#448176, al_taux_t8r#448186, al_taux_t8#448177, al_taux_t9r#448187, al_taux_t9#448178, al_typexa#448159, al_type#448154, al_type_icd#448205, al_t_red#448164, al_urg#448197, al_valcou#448149]

(48) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  [codegen id : 10]
Output [59]: [al_annval#448681, al_classe#448700, al_codcha#448727, al_codsit#448690, al_coduti#448689, al_codval#448680, al_comment#448725, al_datede#448723, al_datefi#448735, al_datmaj#448688, al_envadm#448696, al_flicpt#448722, al_flsej#448721, al_fltele#448726, al_forfai#448699, al_icd#448737, al_int_spe#448732, al_int_std#448731, al_letadm#448695, al_letads#448728, al_lib30#448683, al_libmaj#448684, al_monnaie#448691, al_numbmp#448693, al_numcpt#448724, al_ordre#448694, al_primai#448736, al_prior#448686, al_rcp#448734, al_rembours#448702, al_revers#448701, al_sites#448729, al_spl_trans#448733, al_taux#448685, al_taux_r#448698, al_taux_t1r#448712, al_taux_t1#448703, al_taux_t2r#448713, al_taux_t2#448704, al_taux_t3r#448714, al_taux_t3#448705, al_taux_t4r#448715, al_taux_t4#448706, al_taux_t5r#448716, al_taux_t5#448707, al_taux_t6r#448717, al_taux_t6#448708, al_taux_t7r#448718, al_taux_t7#448709, al_taux_t8r#448719, al_taux_t8#448710, al_taux_t9r#448720, al_taux_t9#448711, al_typexa#448692, al_type#448687, al_type_icd#448738, al_t_red#448697, al_urg#448730, al_valcou#448682]
PushedFilters: [*IsNotNull(al_valcou)]
ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_codval:string,al_comment:string,al_datede:string,al_datefi:string,al_datmaj:string,al_envadm:string,al_flicpt:string,al_flsej:string,al_fltele:string,al_forfai:string,al_icd:string,al_int_spe:string,al_int_std:string,al_letadm:string,al_letads:string,al_lib30:string,al_libmaj:string,al_monnaie:string,al_numbmp:string,al_numcpt:string,al_ordre:string,al_primai:string,al_prior:string,al_rcp:string,al_rembours:string,al_revers:string,al_sites:string,al_spl_trans:string,al_taux:string,al_taux_r:string,al_taux_t1r:string,al_taux_t1:string,al_taux_t2r:string,al_taux_t2:string,al_taux_t3r:string,al_taux_t3:string,al_taux_t4r:string,al_taux_t4:string,al_taux_t5r:string,al_taux_t5:string,al_taux_t6r:string,al_taux_t6:string,al_taux_t7r:string,al_taux_t7:string,al_taux_t8r:string,al_taux_t8:string,al_taux_t9r:string,al_taux_t9:string,al_typexa:string,al_type:string,al_type_icd:string,al_t_red:string,al_urg:string,al_valcou:string>

(49) Project [codegen id : 10]
Output [60]: [al_annval#448681 AS AL_ANNVAL_438378#449093, al_classe#448700 AS AL_CLASSE_438397#449094, al_codcha#448727 AS AL_CODCHA_438424#449095, al_codsit#448690 AS AL_CODSIT_438387#449096, al_coduti#448689 AS AL_CODUTI_438386#449097, al_codval#448680 AS AL_CODVAL_438377#449098, al_comment#448725 AS AL_COMMENT_438422#449099, al_datede#448723 AS AL_DATEDE_438420#449100, al_datefi#448735 AS AL_DATEFI_438432#449101, al_datmaj#448688 AS AL_DATMAJ_438385#449102, al_envadm#448696 AS AL_ENVADM_438393#449103, al_flicpt#448722 AS AL_FLICPT_438419#449104, al_flsej#448721 AS AL_FLSEJ_438418#449105, al_fltele#448726 AS AL_FLTELE_438423#449106, al_forfai#448699 AS AL_FORFAI_438396#449107, al_icd#448737 AS AL_ICD_438434#449108, al_int_spe#448732 AS AL_INT_SPE_438429#449109, al_int_std#448731 AS AL_INT_STD_438428#449110, al_letadm#448695 AS AL_LETADM_438392#449111, al_letads#448728 AS AL_LETADS_438425#449112, al_lib30#448683 AS AL_LIB30_438380#449113, al_libmaj#448684 AS AL_LIBMAJ_438381#449114, al_monnaie#448691 AS AL_MONNAIE_438388#449115, al_numbmp#448693 AS AL_NUMBMP_438390#449116, al_numcpt#448724 AS AL_NUMCPT_438421#449117, al_ordre#448694 AS AL_ORDRE_438391#449118, al_primai#448736 AS AL_PRIMAI_438433#449119, al_prior#448686 AS AL_PRIOR_438383#449120, al_rcp#448734 AS AL_RCP_438431#449121, al_rembours#448702 AS AL_REMBOURS_438399#449122, al_revers#448701 AS AL_REVERS_438398#449123, al_sites#448729 AS AL_SITES_438426#449124, al_spl_trans#448733 AS AL_SPL_TRANS_438430#449125, al_taux#448685 AS AL_TAUX_438382#449126, al_taux_r#448698 AS AL_TAUX_R_438395#449127, al_taux_t1r#448712 AS AL_TAUX_T1R_438409#449128, al_taux_t1#448703 AS AL_TAUX_T1_438400#449129, al_taux_t2r#448713 AS AL_TAUX_T2R_438410#449130, al_taux_t2#448704 AS AL_TAUX_T2_438401#449131, al_taux_t3r#448714 AS AL_TAUX_T3R_438411#449132, al_taux_t3#448705 AS AL_TAUX_T3_438402#449133, al_taux_t4r#448715 AS AL_TAUX_T4R_438412#449134, al_taux_t4#448706 AS AL_TAUX_T4_438403#449135, al_taux_t5r#448716 AS AL_TAUX_T5R_438413#449136, al_taux_t5#448707 AS AL_TAUX_T5_438404#449137, al_taux_t6r#448717 AS AL_TAUX_T6R_438414#449138, al_taux_t6#448708 AS AL_TAUX_T6_438405#449139, al_taux_t7r#448718 AS AL_TAUX_T7R_438415#449140, al_taux_t7#448709 AS AL_TAUX_T7_438406#449141, al_taux_t8r#448719 AS AL_TAUX_T8R_438416#449142, al_taux_t8#448710 AS AL_TAUX_T8_438407#449143, al_taux_t9r#448720 AS AL_TAUX_T9R_438417#449144, al_taux_t9#448711 AS AL_TAUX_T9_438408#449145, al_typexa#448692 AS AL_TYPEXA_438389#449146, al_type#448687 AS AL_TYPE_438384#449147, al_type_icd#448738 AS AL_TYPE_ICD_438435#449148, al_t_red#448697 AS AL_T_RED_438394#449149, al_urg#448730 AS AL_URG_438427#449150, al_valcou#448682 AS AL_VALCOU_438379#449151, null AS ORIGINE_440156#449152]
Input [59]: [al_annval#448681, al_classe#448700, al_codcha#448727, al_codsit#448690, al_coduti#448689, al_codval#448680, al_comment#448725, al_datede#448723, al_datefi#448735, al_datmaj#448688, al_envadm#448696, al_flicpt#448722, al_flsej#448721, al_fltele#448726, al_forfai#448699, al_icd#448737, al_int_spe#448732, al_int_std#448731, al_letadm#448695, al_letads#448728, al_lib30#448683, al_libmaj#448684, al_monnaie#448691, al_numbmp#448693, al_numcpt#448724, al_ordre#448694, al_primai#448736, al_prior#448686, al_rcp#448734, al_rembours#448702, al_revers#448701, al_sites#448729, al_spl_trans#448733, al_taux#448685, al_taux_r#448698, al_taux_t1r#448712, al_taux_t1#448703, al_taux_t2r#448713, al_taux_t2#448704, al_taux_t3r#448714, al_taux_t3#448705, al_taux_t4r#448715, al_taux_t4#448706, al_taux_t5r#448716, al_taux_t5#448707, al_taux_t6r#448717, al_taux_t6#448708, al_taux_t7r#448718, al_taux_t7#448709, al_taux_t8r#448719, al_taux_t8#448710, al_taux_t9r#448720, al_taux_t9#448711, al_typexa#448692, al_type#448687, al_type_icd#448738, al_t_red#448697, al_urg#448730, al_valcou#448682]

(50) Union

(51) HashAggregate [codegen id : 11]
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Keys [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]

(52) Exchange
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Arguments: hashpartitioning(AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=27365]

(53) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Arguments: 5

(54) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Arguments: coalesced

(55) HashAggregate [codegen id : 17]
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Keys [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#448618 AS H_VALEU_438376_AL_VALCOU_438379#459597]

(56) Exchange
Input [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Arguments: hashpartitioning(H_VALEU_438376_AL_VALCOU_438379#459597, 10), ENSURE_REQUIREMENTS, [plan_id=27767]

(57) ShuffleQueryStage
Output [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Arguments: 7

(58) AQEShuffleRead
Input [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Arguments: coalesced

(59) Sort [codegen id : 22]
Input [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Arguments: [H_VALEU_438376_AL_VALCOU_438379#459597 ASC NULLS FIRST], false, 0

(60) SortMergeJoin [codegen id : 23]
Left keys [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Right keys [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Join type: LeftOuter
Join condition: None

(61) Project [codegen id : 23]
Output: []
Input [2]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, H_VALEU_438376_AL_VALCOU_438379#459597]

(62) HashAggregate [codegen id : 23]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#460375L]
Results [1]: [count#460376L]

(63) Exchange
Input [1]: [count#460376L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=27962]

(64) ShuffleQueryStage
Output [1]: [count#460376L]
Arguments: 9

(65) HashAggregate [codegen id : 24]
Input [1]: [count#460376L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#459891L]
Results [1]: [count(1)#459891L AS count#459892L]

(66) Union

(67) Exchange
Input [2]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: hashpartitioning(COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, 10), ENSURE_REQUIREMENTS, [plan_id=27194]

(68) Sort
Input [2]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252 ASC NULLS FIRST], false, 0

(69) Union

(70) Exchange
Input [2]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, 10), ENSURE_REQUIREMENTS, [plan_id=27186]

(71) Sort
Input [2]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231 ASC NULLS FIRST], false, 0

(72) Union

(73) Exchange
Input [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#454742, 10), ENSURE_REQUIREMENTS, [plan_id=27178]

(74) Sort
Input [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742 ASC NULLS FIRST], false, 0

(75) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] 
Output [1]: [at_numdos#454803]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>

(76) Project
Output [1]: [at_numdos#454803 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Input [1]: [at_numdos#454803]

(77) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] 
Output [1]: [at_numdos#454939]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>

(78) Project
Output [1]: [at_numdos#454939 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#460374]
Input [1]: [at_numdos#454939]

(79) Union

(80) Exchange
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781, 10), ENSURE_REQUIREMENTS, [plan_id=27179]

(81) Sort
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781 ASC NULLS FIRST], false, 0

(82) SortMergeJoin
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]
Join type: LeftOuter
Join condition: None

(83) Project
Output [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]
Input [2]: [COL_499EB20D_E124_400E_A51E_F020884D243F#454742, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#454781]

(84) SortMergeJoin
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]
Join type: LeftOuter
Join condition: None

(85) Project
Output [1]: [COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234 AS H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Input [3]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#458231, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#458234, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#458269]

(86) Exchange
Input [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Arguments: hashpartitioning(H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302, 10), ENSURE_REQUIREMENTS, [plan_id=27195]

(87) Sort
Input [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Arguments: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302 ASC NULLS FIRST], false, 0

(88) SortMergeJoin
Left keys [1]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252]
Right keys [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]
Join type: LeftOuter
Join condition: None

(89) Project
Output [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Input [3]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#459252, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#459302]

(90) Exchange
Input [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: hashpartitioning(COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, 10), ENSURE_REQUIREMENTS, [plan_id=27206]

(91) Sort
Input [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Arguments: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260 ASC NULLS FIRST], false, 0

(92) Union

(93) HashAggregate
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Keys [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]

(94) Exchange
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Arguments: hashpartitioning(AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=27200]

(95) HashAggregate
Input [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Keys [60]: [AL_ANNVAL_438378#448560, AL_CLASSE_438397#448561, AL_CODCHA_438424#448562, AL_CODSIT_438387#448563, AL_CODUTI_438386#448564, AL_CODVAL_438377#448565, AL_COMMENT_438422#448566, AL_DATEDE_438420#448567, AL_DATEFI_438432#448568, AL_DATMAJ_438385#448569, AL_ENVADM_438393#448570, AL_FLICPT_438419#448571, AL_FLSEJ_438418#448572, AL_FLTELE_438423#448573, AL_FORFAI_438396#448574, AL_ICD_438434#448575, AL_INT_SPE_438429#448576, AL_INT_STD_438428#448577, AL_LETADM_438392#448578, AL_LETADS_438425#448579, AL_LIB30_438380#448580, AL_LIBMAJ_438381#448581, AL_MONNAIE_438388#448582, AL_NUMBMP_438390#448583, AL_NUMCPT_438421#448584, AL_ORDRE_438391#448585, AL_PRIMAI_438433#448586, AL_PRIOR_438383#448587, AL_RCP_438431#448588, AL_REMBOURS_438399#448589, AL_REVERS_438398#448590, AL_SITES_438426#448591, AL_SPL_TRANS_438430#448592, AL_TAUX_438382#448593, AL_TAUX_R_438395#448594, AL_TAUX_T1R_438409#448595, AL_TAUX_T1_438400#448596, AL_TAUX_T2R_438410#448597, AL_TAUX_T2_438401#448598, AL_TAUX_T3R_438411#448599, AL_TAUX_T3_438402#448600, AL_TAUX_T4R_438412#448601, AL_TAUX_T4_438403#448602, AL_TAUX_T5R_438413#448603, AL_TAUX_T5_438404#448604, AL_TAUX_T6R_438414#448605, AL_TAUX_T6_438405#448606, AL_TAUX_T7R_438415#448607, AL_TAUX_T7_438406#448608, AL_TAUX_T8R_438416#448609, AL_TAUX_T8_438407#448610, AL_TAUX_T9R_438417#448611, AL_TAUX_T9_438408#448612, AL_TYPEXA_438389#448613, AL_TYPE_438384#448614, AL_TYPE_ICD_438435#448615, AL_T_RED_438394#448616, AL_URG_438427#448617, AL_VALCOU_438379#448618, ORIGINE_440156#448619]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#448618 AS H_VALEU_438376_AL_VALCOU_438379#459597]

(96) Exchange
Input [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Arguments: hashpartitioning(H_VALEU_438376_AL_VALCOU_438379#459597, 10), ENSURE_REQUIREMENTS, [plan_id=27207]

(97) Sort
Input [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Arguments: [H_VALEU_438376_AL_VALCOU_438379#459597 ASC NULLS FIRST], false, 0

(98) SortMergeJoin
Left keys [1]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260]
Right keys [1]: [H_VALEU_438376_AL_VALCOU_438379#459597]
Join type: LeftOuter
Join condition: None

(99) Project
Output: []
Input [2]: [COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#459260, H_VALEU_438376_AL_VALCOU_438379#459597]

(100) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#460375L]
Results [1]: [count#460376L]

(101) Exchange
Input [1]: [count#460376L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=27214]

(102) HashAggregate
Input [1]: [count#460376L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#459891L]
Results [1]: [count(1)#459891L AS count#459892L]

(103) AdaptiveSparkPlan
Output [1]: [count#459892L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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