digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
1 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
3 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<b>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] </b><br><br>number of output rows: 1,500"];
}
subgraph cluster6 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 0 ms";
7 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
9 [labelType="html" label="<b>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] </b><br><br>number of output rows: 0"];
}
1->0;
3->1;
4->3;
5->4;
7->1;
8->7;
9->8;
}
10
CollectLimit 1500
Union
LocalLimit 1500
Project [at_numdos#519784 AS COL_499EB20D_E124_400E_A51E_F020884D243F#523632, at_stapat#519785 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523633, at_prefix#519786 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#523634, at_nompat#519787 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523635, str_replace_extend(str_replace_extend(at_nompat#519787, [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#523689, at_pnopat#519788 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523636, str_replace_extend(str_replace_extend(at_pnopat#519788, [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#523691, at_njfpat#519789 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523637, at_datnai#519790 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#523638, at_datnaiss#519791 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523639, at_sexe#519792 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523640, at_codpos#519802 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523641, at_ville#519803 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523642, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523643]
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#519784,at_stapat#519785,at_prefix#519786,at_nompat#519787,at_pnopat#519788,at_njfpat#519789,at_datnai#519790,at_datnaiss#519791,at_sexe#519792,at_codpos#519802,at_ville#519803] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...
WholeStageCodegen (1)
LocalLimit 1500
Project [at_numdos#521011 AS COL_499EB20D_E124_400E_A51E_F020884D243F#523850, at_stapat#521012 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523851, at_prefix#521013 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#523852, at_nompat#521014 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523853, str_replace_extend(str_replace_extend(at_nompat#521014, [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#523862, at_pnopat#521015 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523854, str_replace_extend(str_replace_extend(at_pnopat#521015, [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#523863, at_njfpat#521016 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523855, at_datnai#521017 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#523856, at_datnaiss#521018 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523857, at_sexe#521019 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523858, at_codpos#521029 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523859, at_ville#521030 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523860, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523861]
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#521011,at_stapat#521012,at_prefix#521013,at_nompat#521014,at_pnopat#521015,at_njfpat#521016,at_datnai#521017,at_datnaiss#521018,at_sexe#521019,at_codpos#521029,at_ville#521030] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...
WholeStageCodegen (2)
== Physical Plan ==
CollectLimit (8)
+- Union (7)
:- * LocalLimit (3)
: +- * Project (2)
: +- * 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] (1)
+- * LocalLimit (6)
+- * Project (5)
+- * 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] (4)
(1) 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 : 1]
Output [11]: [at_numdos#519784, at_stapat#519785, at_prefix#519786, at_nompat#519787, at_pnopat#519788, at_njfpat#519789, at_datnai#519790, at_datnaiss#519791, at_sexe#519792, at_codpos#519802, at_ville#519803]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_codpos:string,at_ville:string>
(2) Project [codegen id : 1]
Output [14]: [at_numdos#519784 AS COL_499EB20D_E124_400E_A51E_F020884D243F#523632, at_stapat#519785 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523633, at_prefix#519786 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#523634, at_nompat#519787 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523635, str_replace_extend(str_replace_extend(at_nompat#519787, [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#523689, at_pnopat#519788 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523636, str_replace_extend(str_replace_extend(at_pnopat#519788, [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#523691, at_njfpat#519789 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523637, at_datnai#519790 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#523638, at_datnaiss#519791 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523639, at_sexe#519792 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523640, at_codpos#519802 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523641, at_ville#519803 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523642, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523643]
Input [11]: [at_numdos#519784, at_stapat#519785, at_prefix#519786, at_nompat#519787, at_pnopat#519788, at_njfpat#519789, at_datnai#519790, at_datnaiss#519791, at_sexe#519792, at_codpos#519802, at_ville#519803]
(3) LocalLimit [codegen id : 1]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#523632, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523633, COL_2B7D9197_D824_41CE_9E49_C420C3822425#523634, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523635, COL_D741682E_18A7_4E09_96D0_47ED855868ED#523689, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523636, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#523691, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523637, COL_CB4739E1_E2F6_48D7_9602_079F56460634#523638, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523639, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523640, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523641, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523642, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523643]
Arguments: 1500
(4) 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 : 2]
Output [11]: [at_numdos#521011, at_stapat#521012, at_prefix#521013, at_nompat#521014, at_pnopat#521015, at_njfpat#521016, at_datnai#521017, at_datnaiss#521018, at_sexe#521019, at_codpos#521029, at_ville#521030]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_codpos:string,at_ville:string>
(5) Project [codegen id : 2]
Output [14]: [at_numdos#521011 AS COL_499EB20D_E124_400E_A51E_F020884D243F#523850, at_stapat#521012 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523851, at_prefix#521013 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#523852, at_nompat#521014 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523853, str_replace_extend(str_replace_extend(at_nompat#521014, [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#523862, at_pnopat#521015 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523854, str_replace_extend(str_replace_extend(at_pnopat#521015, [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#523863, at_njfpat#521016 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523855, at_datnai#521017 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#523856, at_datnaiss#521018 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523857, at_sexe#521019 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523858, at_codpos#521029 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523859, at_ville#521030 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523860, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523861]
Input [11]: [at_numdos#521011, at_stapat#521012, at_prefix#521013, at_nompat#521014, at_pnopat#521015, at_njfpat#521016, at_datnai#521017, at_datnaiss#521018, at_sexe#521019, at_codpos#521029, at_ville#521030]
(6) LocalLimit [codegen id : 2]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#523850, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523851, COL_2B7D9197_D824_41CE_9E49_C420C3822425#523852, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523853, COL_D741682E_18A7_4E09_96D0_47ED855868ED#523862, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523854, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#523863, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523855, COL_CB4739E1_E2F6_48D7_9602_079F56460634#523856, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523857, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523858, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523859, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523860, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523861]
Arguments: 1500
(7) Union
(8) CollectLimit
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#523632, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#523633, COL_2B7D9197_D824_41CE_9E49_C420C3822425#523634, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#523635, COL_D741682E_18A7_4E09_96D0_47ED855868ED#523689, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#523636, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#523691, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#523637, COL_CB4739E1_E2F6_48D7_9602_079F56460634#523638, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#523639, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#523640, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#523641, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#523642, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#523643]
Arguments: 1500