hdh-spark-job - Details for Query 1261

Submitted Time: 2026/10/23 13:15:47
Duration: 1 s
Succeeded Jobs: 1254 1255 1256 1257 1258 1259 1260

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: 153 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 2,769 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 165 ms"; 6 [labelType="html" label=" LocalLimit "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="SortMergeJoin number of output rows: 2,769 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 182 ms"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 1 ms (0 ms, 1 ms, 1 ms (stage 1810.0: task 1571)) peak memory total (min, med, max (stageId: taskId)) 128.1 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 1804.0: task 1570)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1102.3 KiB (462.0 KiB, 640.3 KiB, 640.3 KiB (driver)) number of coalesced partitions: 2"]; 12 [labelType="html" label="Exchange shuffle records written: 3,000 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (3 ms, 3 ms, 3 ms (stage 1793.0: task 1562)) 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: 3,000 local bytes read total (min, med, max (stageId: taskId)) 1048.3 KiB (442.2 KiB, 606.2 KiB, 606.2 KiB (stage 1810.0: task 1571)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1804.0: task 1570)) 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)) 2.3 MiB (1162.6 KiB, 1162.6 KiB, 1162.6 KiB (stage 1793.0: task 1562)) 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)) 1048.3 KiB (523.3 KiB, 525.0 KiB, 525.0 KiB (stage 1793.0: task 1561))"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n54 ms (26 ms, 28 ms, 28 ms (stage 1793.0: task 1562))"; 14 [labelType="html" label=" LocalLimit "]; } 15 [labelType="html" label=" Union "]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; 17 [labelType="html" label=" LocalLimit "]; 18 [labelType="html" label=" Project "]; 19 [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: 1,500"]; } subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 21 [labelType="html" label=" LocalLimit "]; 22 [labelType="html" label=" Project "]; 23 [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: 1,500"]; } subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 25 [labelType="html" label=" Project "]; 26 [labelType="html" label="SortMergeJoin number of output rows: 48,715 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 0 ms"; 28 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 32 ms (15 ms, 17 ms, 17 ms (stage 1810.0: task 1571)) peak memory total (min, med, max (stageId: taskId)) 129.5 MiB (64.5 MiB, 65.0 MiB, 65.0 MiB (stage 1810.0: task 1571)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } 29 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.6 MiB (1086.9 KiB, 1603.9 KiB, 1603.9 KiB (driver)) number of coalesced partitions: 2"]; 30 [labelType="html" label="Exchange shuffle records written: 47,008 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 12 ms (6 ms, 6 ms, 6 ms (stage 1794.0: task 1564)) 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: 47,008 local bytes read total (min, med, max (stageId: taskId)) 2.5 MiB (1051.9 KiB, 1552.4 KiB, 1552.4 KiB (stage 1810.0: task 1571)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1804.0: task 1570)) 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)) 4.5 MiB (2.3 MiB, 2.3 MiB, 2.3 MiB (stage 1794.0: task 1563)) 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)) 2.5 MiB (1301.3 KiB, 1303.0 KiB, 1303.0 KiB (stage 1794.0: task 1564))"]; 31 [labelType="html" label=" Union "]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 306 ms"; 33 [labelType="html" label=" Project "]; 34 [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 cluster35 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 338 ms"; 36 [labelType="html" label=" Project "]; 37 [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 cluster38 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 0 ms"; 39 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 33 ms (16 ms, 17 ms, 17 ms (stage 1810.0: task 1571)) peak memory total (min, med, max (stageId: taskId)) 129.5 MiB (64.5 MiB, 65.0 MiB, 65.0 MiB (stage 1810.0: task 1571)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } 40 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 376.1 KiB (154.0 KiB, 222.1 KiB, 222.1 KiB (driver)) number of coalesced partitions: 2"]; 41 [labelType="html" label="Exchange shuffle records written: 47,008 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 1 ms, 1 ms (stage 1795.0: task 1565)) 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: 47,008 local bytes read total (min, med, max (stageId: taskId)) 359.0 KiB (145.0 KiB, 214.0 KiB, 214.0 KiB (stage 1810.0: task 1571)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1804.0: task 1570)) 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 1795.0: task 1565)) 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 1795.0: task 1565))"]; 42 [labelType="html" label=" Union "]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 13 ms"; 44 [labelType="html" label=" Project "]; 45 [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 cluster46 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 13 ms"; 47 [labelType="html" label=" Project "]; 48 [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 cluster49 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: 0 ms"; 50 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 35 ms (16 ms, 19 ms, 19 ms (stage 1804.0: task 1570)) peak memory total (min, med, max (stageId: taskId)) 129.5 MiB (64.5 MiB, 65.0 MiB, 65.0 MiB (stage 1810.0: task 1571)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1804.0: task 1570))"]; } 51 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 680.2 KiB (272.1 KiB, 408.1 KiB, 408.1 KiB (driver)) number of coalesced partitions: 2"]; 52 [labelType="html" label="Exchange shuffle records written: 47,008 local merged chunks fetched: 0 shuffle write time: 3 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: 47,008 local bytes read total (min, med, max (stageId: taskId)) 654.8 KiB (264.5 KiB, 390.3 KiB, 390.3 KiB (stage 1810.0: task 1571)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1804.0: task 1570)) 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: 2.4 MiB 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: 654.8 KiB"]; subgraph cluster53 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 137 ms"; 54 [labelType="html" label=" Project "]; 55 [labelType="html" label="Filter number of output rows: 47,008"]; } 56 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster57 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 30 ms"; 58 [labelType="html" label="Sort sort time: 1 ms peak memory: 66.0 MiB spill size: 0.0 B"]; } 59 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 352.9 KiB number of coalesced partitions: 1"]; 60 [labelType="html" label="Exchange shuffle records written: 47,008 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 2 ms (0 ms, 1 ms, 1 ms (stage 1796.0: task 1567)) 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: 47,008 local bytes read: 326.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)) 1403.6 KiB (701.8 KiB, 701.8 KiB, 701.8 KiB (stage 1796.0: task 1567)) 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)) 326.6 KiB (163.3 KiB, 163.3 KiB, 163.3 KiB (stage 1796.0: task 1568))"]; 61 [labelType="html" label=" Union "]; subgraph cluster62 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 12 ms"; 63 [labelType="html" label=" Project "]; 64 [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 cluster65 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 12 ms"; 66 [labelType="html" label=" Project "]; 67 [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"]; } 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 17->15; 18->17; 19->18; 21->15; 22->21; 23->22; 25->8; 26->25; 28->26; 29->28; 30->29; 31->30; 33->31; 34->33; 36->31; 37->36; 39->26; 40->39; 41->40; 42->41; 44->42; 45->44; 47->42; 48->47; 50->4; 51->50; 52->51; 54->52; 55->54; 56->55; 58->56; 59->58; 60->59; 61->60; 63->61; 64->63; 66->61; 67->66; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731 AS COL_7B408B85_6B18_4636_BDFC_7443587829F7#593171, null AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593172]

SortMergeJoin [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721], LeftOuter

WholeStageCodegen (18)

LocalLimit 1500

Project [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526)) AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523 AS COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524 AS COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525 AS COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526 AS COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691]

SortMergeJoin [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482], [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520], LeftOuter

WholeStageCodegen (16)

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

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, 10), ENSURE_REQUIREMENTS, [plan_id=32533]

LocalLimit 1500

WholeStageCodegen (3)

Union

LocalLimit 1500

Project [cr_numcr#589422 AS COL_29272194_C362_4B1A_871B_827530BCD34B#592481, cr_numdos#589423 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, cr_nomdic#589424 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, cr_numdem#589425 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, cr_numexa#589426 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, cr_typdoc#589427 AS COL_B9580440_50FB_4495_B82E_8046068EB218#592486, cr_prior#589428 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, cr_nomdcr#589429 AS COL_087DC335_6719_4B78_B354_10A3D546B347#592488, cr_taidcr#589430 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, cr_nomdos#589433 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, cr_for_cr#589434 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, cr_cr#589435 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]

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_numcr#589422,cr_numdos#589423,cr_nomdic#589424,cr_numdem#589425,cr_numexa#589426,cr_typdoc#589427,cr_prior#589428,cr_nomdcr#589429,cr_taidcr#589430,cr_nomdos#589433,cr_for_cr#589434,cr_cr#589435] PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...

WholeStageCodegen (1)

LocalLimit 1500

Project [cr_numcr#590397 AS COL_29272194_C362_4B1A_871B_827530BCD34B#593710, cr_numdos#590398 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593711, cr_nomdic#590399 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#593712, cr_numdem#590400 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#593713, cr_numexa#590401 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#593714, cr_typdoc#590402 AS COL_B9580440_50FB_4495_B82E_8046068EB218#593715, cr_prior#590403 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#593716, cr_nomdcr#590404 AS COL_087DC335_6719_4B78_B354_10A3D546B347#593717, cr_taidcr#590405 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#593718, cr_nomdos#590408 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#593719, cr_for_cr#590409 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#593720, cr_cr#590410 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#593721]

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_numcr#590397,cr_numdos#590398,cr_nomdic#590399,cr_numdem#590400,cr_numexa#590401,cr_typdoc#590402,cr_prior#590403,cr_nomdcr#590404,cr_taidcr#590405,cr_nomdos#590408,cr_for_cr#590409,cr_cr#590410] PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...

WholeStageCodegen (2)

Project [COL_499EB20D_E124_400E_A51E_F020884D243F#588912 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997 AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999 AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526]

SortMergeJoin [COL_499EB20D_E124_400E_A51E_F020884D243F#588912], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032], LeftOuter

WholeStageCodegen (15)

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

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#588912, 10), ENSURE_REQUIREMENTS, [plan_id=32556]

Union

Project [at_numdos#583824 AS COL_499EB20D_E124_400E_A51E_F020884D243F#588912, at_nompat#583827 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, str_replace_extend(str_replace_extend(at_nompat#583827, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, at_pnopat#583828 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, str_replace_extend(str_replace_extend(at_pnopat#583828, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]

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#583824,at_nompat#583827,at_pnopat#583828] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>

WholeStageCodegen (4)

Project [at_numdos#585051 AS COL_499EB20D_E124_400E_A51E_F020884D243F#593722, at_nompat#585054 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#593723, str_replace_extend(str_replace_extend(at_nompat#585054, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#593728, at_pnopat#585055 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#593724, str_replace_extend(str_replace_extend(at_pnopat#585055, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#593729]

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#585051,at_nompat#585054,at_pnopat#585055] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>

WholeStageCodegen (5)

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

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032, 10), ENSURE_REQUIREMENTS, [plan_id=32576]

Union

Project [at_numdos#589054 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]

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#589054] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string>

WholeStageCodegen (6)

Project [at_numdos#589190 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#593725]

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#589190] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string>

WholeStageCodegen (7)

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

WholeStageCodegen (17)

AQEShuffleRead coalesced

Exchange hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, 10), ENSURE_REQUIREMENTS, [plan_id=32891]

Project [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]

Filter isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666)

WholeStageCodegen (11)

Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=32609]

Union

Project [at_numdos#592743 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]

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#592743] PushedFilters: [], ReadSchema: struct<at_numdos:string>

WholeStageCodegen (8)

Project [at_numdos#592879 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#593726]

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#592879] PushedFilters: [], ReadSchema: struct<at_numdos:string>

WholeStageCodegen (9)

Details

== Physical Plan ==
AdaptiveSparkPlan (81)
+- == Final Plan ==
   CollectLimit (54)
   +- * Project (53)
      +- * SortMergeJoin LeftOuter (52)
         :- * LocalLimit (35)
         :  +- * Project (34)
         :     +- * SortMergeJoin LeftOuter (33)
         :        :- * Sort (12)
         :        :  +- AQEShuffleRead (11)
         :        :     +- ShuffleQueryStage (10), Statistics(sizeInBytes=2.3 MiB, rowCount=3.00E+3)
         :        :        +- Exchange (9)
         :        :           +- * LocalLimit (8)
         :        :              +- Union (7)
         :        :                 :- * LocalLimit (3)
         :        :                 :  +- * Project (2)
         :        :                 :     +- * 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]  (1)
         :        :                 +- * LocalLimit (6)
         :        :                    +- * Project (5)
         :        :                       +- * 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]  (4)
         :        +- * Project (32)
         :           +- * SortMergeJoin LeftOuter (31)
         :              :- * Sort (21)
         :              :  +- AQEShuffleRead (20)
         :              :     +- ShuffleQueryStage (19), Statistics(sizeInBytes=4.5 MiB, rowCount=4.70E+4)
         :              :        +- Exchange (18)
         :              :           +- Union (17)
         :              :              :- * Project (14)
         :              :              :  +- * 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]  (13)
         :              :              +- * Project (16)
         :              :                 +- * 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]  (15)
         :              +- * Sort (30)
         :                 +- AQEShuffleRead (29)
         :                    +- ShuffleQueryStage (28), Statistics(sizeInBytes=1403.6 KiB, rowCount=4.70E+4)
         :                       +- Exchange (27)
         :                          +- Union (26)
         :                             :- * Project (23)
         :                             :  +- * 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]  (22)
         :                             +- * Project (25)
         :                                +- * 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]  (24)
         +- * Sort (51)
            +- AQEShuffleRead (50)
               +- ShuffleQueryStage (49), Statistics(sizeInBytes=2.4 MiB, rowCount=4.70E+4)
                  +- Exchange (48)
                     +- * Project (47)
                        +- * Filter (46)
                           +- Window (45)
                              +- * Sort (44)
                                 +- AQEShuffleRead (43)
                                    +- ShuffleQueryStage (42), Statistics(sizeInBytes=1403.6 KiB, rowCount=4.70E+4)
                                       +- Exchange (41)
                                          +- Union (40)
                                             :- * Project (37)
                                             :  +- * 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]  (36)
                                             +- * Project (39)
                                                +- * 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]  (38)
+- == Initial Plan ==
   CollectLimit (80)
   +- Project (79)
      +- SortMergeJoin LeftOuter (78)
         :- LocalLimit (69)
         :  +- Project (68)
         :     +- SortMergeJoin LeftOuter (67)
         :        :- Sort (58)
         :        :  +- Exchange (57)
         :        :     +- LocalLimit (56)
         :        :        +- Union (55)
         :        :           :- LocalLimit (3)
         :        :           :  +- Project (2)
         :        :           :     +- 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]  (1)
         :        :           +- LocalLimit (6)
         :        :              +- Project (5)
         :        :                 +- 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]  (4)
         :        +- Project (66)
         :           +- SortMergeJoin LeftOuter (65)
         :              :- Sort (61)
         :              :  +- Exchange (60)
         :              :     +- Union (59)
         :              :        :- Project (14)
         :              :        :  +- 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]  (13)
         :              :        +- Project (16)
         :              :           +- 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]  (15)
         :              +- Sort (64)
         :                 +- Exchange (63)
         :                    +- Union (62)
         :                       :- Project (23)
         :                       :  +- 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]  (22)
         :                       +- Project (25)
         :                          +- 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]  (24)
         +- Sort (77)
            +- Exchange (76)
               +- Project (75)
                  +- Filter (74)
                     +- Window (73)
                        +- Sort (72)
                           +- Exchange (71)
                              +- Union (70)
                                 :- Project (37)
                                 :  +- 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]  (36)
                                 +- Project (39)
                                    +- 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]  (38)


(1) 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 : 1]
Output [12]: [cr_numcr#589422, cr_numdos#589423, cr_nomdic#589424, cr_numdem#589425, cr_numexa#589426, cr_typdoc#589427, cr_prior#589428, cr_nomdcr#589429, cr_taidcr#589430, cr_nomdos#589433, cr_for_cr#589434, cr_cr#589435]
PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))]
ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typdoc:string,cr_prior:string,cr_nomdcr:string,cr_taidcr:string,cr_nomdos:string,cr_for_cr:string,cr_cr:string>

(2) Project [codegen id : 1]
Output [12]: [cr_numcr#589422 AS COL_29272194_C362_4B1A_871B_827530BCD34B#592481, cr_numdos#589423 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, cr_nomdic#589424 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, cr_numdem#589425 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, cr_numexa#589426 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, cr_typdoc#589427 AS COL_B9580440_50FB_4495_B82E_8046068EB218#592486, cr_prior#589428 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, cr_nomdcr#589429 AS COL_087DC335_6719_4B78_B354_10A3D546B347#592488, cr_taidcr#589430 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, cr_nomdos#589433 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, cr_for_cr#589434 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, cr_cr#589435 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Input [12]: [cr_numcr#589422, cr_numdos#589423, cr_nomdic#589424, cr_numdem#589425, cr_numexa#589426, cr_typdoc#589427, cr_prior#589428, cr_nomdcr#589429, cr_taidcr#589430, cr_nomdos#589433, cr_for_cr#589434, cr_cr#589435]

(3) LocalLimit [codegen id : 1]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: 1500

(4) 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 : 2]
Output [12]: [cr_numcr#590397, cr_numdos#590398, cr_nomdic#590399, cr_numdem#590400, cr_numexa#590401, cr_typdoc#590402, cr_prior#590403, cr_nomdcr#590404, cr_taidcr#590405, cr_nomdos#590408, cr_for_cr#590409, cr_cr#590410]
PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))]
ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typdoc:string,cr_prior:string,cr_nomdcr:string,cr_taidcr:string,cr_nomdos:string,cr_for_cr:string,cr_cr:string>

(5) Project [codegen id : 2]
Output [12]: [cr_numcr#590397 AS COL_29272194_C362_4B1A_871B_827530BCD34B#593710, cr_numdos#590398 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593711, cr_nomdic#590399 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#593712, cr_numdem#590400 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#593713, cr_numexa#590401 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#593714, cr_typdoc#590402 AS COL_B9580440_50FB_4495_B82E_8046068EB218#593715, cr_prior#590403 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#593716, cr_nomdcr#590404 AS COL_087DC335_6719_4B78_B354_10A3D546B347#593717, cr_taidcr#590405 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#593718, cr_nomdos#590408 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#593719, cr_for_cr#590409 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#593720, cr_cr#590410 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#593721]
Input [12]: [cr_numcr#590397, cr_numdos#590398, cr_nomdic#590399, cr_numdem#590400, cr_numexa#590401, cr_typdoc#590402, cr_prior#590403, cr_nomdcr#590404, cr_taidcr#590405, cr_nomdos#590408, cr_for_cr#590409, cr_cr#590410]

(6) LocalLimit [codegen id : 2]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#593710, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593711, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#593712, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#593713, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#593714, COL_B9580440_50FB_4495_B82E_8046068EB218#593715, COL_4906EFC1_6283_4227_936D_FFA86F51D118#593716, COL_087DC335_6719_4B78_B354_10A3D546B347#593717, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#593718, COL_FA993954_05FA_428A_9A75_26EE63771B33#593719, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#593720, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#593721]
Arguments: 1500

(7) Union

(8) LocalLimit [codegen id : 3]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: 1500

(9) Exchange
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, 10), ENSURE_REQUIREMENTS, [plan_id=32533]

(10) ShuffleQueryStage
Output [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: 0

(11) AQEShuffleRead
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: coalesced

(12) Sort [codegen id : 12]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482 ASC NULLS FIRST], false, 0

(13) 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 : 4]
Output [3]: [at_numdos#583824, at_nompat#583827, at_pnopat#583828]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>

(14) Project [codegen id : 4]
Output [5]: [at_numdos#583824 AS COL_499EB20D_E124_400E_A51E_F020884D243F#588912, at_nompat#583827 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, str_replace_extend(str_replace_extend(at_nompat#583827, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, at_pnopat#583828 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, str_replace_extend(str_replace_extend(at_pnopat#583828, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Input [3]: [at_numdos#583824, at_nompat#583827, at_pnopat#583828]

(15) 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 : 5]
Output [3]: [at_numdos#585051, at_nompat#585054, at_pnopat#585055]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>

(16) Project [codegen id : 5]
Output [5]: [at_numdos#585051 AS COL_499EB20D_E124_400E_A51E_F020884D243F#593722, at_nompat#585054 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#593723, str_replace_extend(str_replace_extend(at_nompat#585054, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#593728, at_pnopat#585055 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#593724, str_replace_extend(str_replace_extend(at_pnopat#585055, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#593729]
Input [3]: [at_numdos#585051, at_nompat#585054, at_pnopat#585055]

(17) Union

(18) Exchange
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#588912, 10), ENSURE_REQUIREMENTS, [plan_id=32556]

(19) ShuffleQueryStage
Output [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Arguments: 1

(20) AQEShuffleRead
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Arguments: coalesced

(21) Sort [codegen id : 13]
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912 ASC NULLS FIRST], false, 0

(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 "xplore"."h_patien") as x) [numPartitions=1]  [codegen id : 6]
Output [1]: [at_numdos#589054]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>

(23) Project [codegen id : 6]
Output [1]: [at_numdos#589054 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Input [1]: [at_numdos#589054]

(24) 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 : 7]
Output [1]: [at_numdos#589190]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>

(25) Project [codegen id : 7]
Output [1]: [at_numdos#589190 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#593725]
Input [1]: [at_numdos#589190]

(26) Union

(27) Exchange
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032, 10), ENSURE_REQUIREMENTS, [plan_id=32576]

(28) ShuffleQueryStage
Output [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Arguments: 2

(29) AQEShuffleRead
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Arguments: coalesced

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

(31) SortMergeJoin [codegen id : 15]
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Join type: LeftOuter
Join condition: None

(32) Project [codegen id : 15]
Output [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997 AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999 AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526]
Input [6]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]

(33) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520]
Join type: LeftOuter
Join condition: None

(34) Project [codegen id : 16]
Output [16]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526)) AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523 AS COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524 AS COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525 AS COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526 AS COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691]
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526]

(35) LocalLimit [codegen id : 16]
Input [16]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691]
Arguments: 1500

(36) 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 : 8]
Output [1]: [at_numdos#592743]
ReadSchema: struct<at_numdos:string>

(37) Project [codegen id : 8]
Output [1]: [at_numdos#592743 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Input [1]: [at_numdos#592743]

(38) 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 : 9]
Output [1]: [at_numdos#592879]
ReadSchema: struct<at_numdos:string>

(39) Project [codegen id : 9]
Output [1]: [at_numdos#592879 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#593726]
Input [1]: [at_numdos#592879]

(40) Union

(41) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=32609]

(42) ShuffleQueryStage
Output [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: 3

(43) AQEShuffleRead
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: coalesced

(44) Sort [codegen id : 10]
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(45) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696], [1], [1 DESC NULLS LAST]

(46) Filter [codegen id : 11]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666)

(47) Project [codegen id : 11]
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696]

(48) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, 10), ENSURE_REQUIREMENTS, [plan_id=32891]

(49) ShuffleQueryStage
Output [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Arguments: 4

(50) AQEShuffleRead
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Arguments: coalesced

(51) Sort [codegen id : 17]
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721 ASC NULLS FIRST], false, 0

(52) SortMergeJoin [codegen id : 18]
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721]
Join type: LeftOuter
Join condition: None

(53) Project [codegen id : 18]
Output [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731 AS COL_7B408B85_6B18_4636_BDFC_7443587829F7#593171, null AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593172]
Input [18]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]

(54) CollectLimit
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, COL_7B408B85_6B18_4636_BDFC_7443587829F7#593171, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593172]
Arguments: 1500

(55) Union

(56) LocalLimit
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: 1500

(57) Exchange
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, 10), ENSURE_REQUIREMENTS, [plan_id=32498]

(58) Sort
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482 ASC NULLS FIRST], false, 0

(59) Union

(60) Exchange
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#588912, 10), ENSURE_REQUIREMENTS, [plan_id=32490]

(61) Sort
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912 ASC NULLS FIRST], false, 0

(62) Union

(63) Exchange
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032, 10), ENSURE_REQUIREMENTS, [plan_id=32491]

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

(65) SortMergeJoin
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]
Join type: LeftOuter
Join condition: None

(66) Project
Output [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997 AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999 AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526]
Input [6]: [COL_499EB20D_E124_400E_A51E_F020884D243F#588912, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#588915, COL_D741682E_18A7_4E09_96D0_47ED855868ED#588997, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#588916, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#588999, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#589032]

(67) SortMergeJoin
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520]
Join type: LeftOuter
Join condition: None

(68) Project
Output [16]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526)) AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523 AS COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524 AS COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525 AS COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526 AS COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691]
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592492, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#592520, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#592523, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#592524, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#592525, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#592526]

(69) LocalLimit
Input [16]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691]
Arguments: 1500

(70) Union

(71) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=32503]

(72) Sort
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(73) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696], [1], [1 DESC NULLS LAST]

(74) Filter
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666)

(75) Project
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#587666, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#587696]

(76) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, 10), ENSURE_REQUIREMENTS, [plan_id=32510]

(77) Sort
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721 ASC NULLS FIRST], false, 0

(78) SortMergeJoin
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721]
Join type: LeftOuter
Join condition: None

(79) Project
Output [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731 AS COL_7B408B85_6B18_4636_BDFC_7443587829F7#593171, null AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593172]
Input [18]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#592482, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#592721, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#592731]

(80) CollectLimit
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, COL_7B408B85_6B18_4636_BDFC_7443587829F7#593171, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593172]
Arguments: 1500

(81) AdaptiveSparkPlan
Output [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#592481, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#592483, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#592484, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#592485, COL_B9580440_50FB_4495_B82E_8046068EB218#592486, COL_4906EFC1_6283_4227_936D_FFA86F51D118#592487, COL_087DC335_6719_4B78_B354_10A3D546B347#592488, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#592489, COL_FA993954_05FA_428A_9A75_26EE63771B33#592490, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#592491, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#592687, COL_11A13087_17FF_425D_98AA_BB90471CEB71#592688, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#592689, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#592690, COL_B0A974FF_C195_4FB8_BF35_301119518B73#592691, COL_7B408B85_6B18_4636_BDFC_7443587829F7#593171, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#593172]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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