== Physical Plan ==
CollectLimit (8)
+- Union (7)
:- * LocalLimit (3)
: +- * Project (2)
: +- * Scan JDBCRelation((SELECT "st_numstu", "st_stu_id", "st_num_id", "st_datstu", "st_heustu", "st_modali", "st_fabriq", "st_instit", "st_nomdic", "st_pnodic", "st_d_ndic", "st_nb_ser", "st_nb_acq", "st_nb_ima", "st_nb_fic", "st_stueff", "st_dateff", "st_heueff", "st_comm_1", "st_comm_2", "st_droit", "st_rappro", "st_numdos", "st_numdem", "st_numper", "st_datmaj", "st_heumaj", "st_coduti", "st_pat_id", "st_accnum", "st_refphy", "st_studsc", "st_patsex", "st_reaphy", "st_perphy", "st_operat", "st_taific", "st_numexa", "st_flcd", "st_lieu", "st_numcd", "st_svcdem", "st_nb_ser_h", "st_nb_fic_h", "st_nb_ima_h", "st_taific_h", "st_locked", "st_flmanu", "st_numper_ori", "st_keyword", "st_read", "st_urgen", "st_sta_pps", "st_sop_uid", "st_codcli", "st_codsit", "st_ins", "st_cache", "st_ins_oid", "st_hidden", "st_rappro_manu", "st_codser", "st_adm_id", "st_fldcd", "st_taille", "st_poids", "st_codchk", "st_datchk", "st_heuchk", "st_typnat", "st_numper_sec", "st_numper_ori_sec", "st_stu_id_ori" FROM "xplore"."h_study") as x) [numPartitions=1] (1)
+- * LocalLimit (6)
+- * Project (5)
+- * Scan JDBCRelation((SELECT "st_numstu", "st_stu_id", "st_num_id", "st_datstu", "st_heustu", "st_modali", "st_fabriq", "st_instit", "st_nomdic", "st_pnodic", "st_d_ndic", "st_nb_ser", "st_nb_acq", "st_nb_ima", "st_nb_fic", "st_stueff", "st_dateff", "st_heueff", "st_comm_1", "st_comm_2", "st_droit", "st_rappro", "st_numdos", "st_numdem", "st_numper", "st_datmaj", "st_heumaj", "st_coduti", "st_pat_id", "st_accnum", "st_refphy", "st_studsc", "st_patsex", "st_reaphy", "st_perphy", "st_operat", "st_taific", "st_numexa", "st_flcd", "st_lieu", "st_numcd", "st_svcdem", "st_nb_ser_h", "st_nb_fic_h", "st_nb_ima_h", "st_taific_h", "st_locked", "st_flmanu", "st_numper_ori", "st_keyword", "st_read", "st_urgen", "st_sta_pps", "st_sop_uid", "st_codcli", "st_codsit", "st_ins", "st_cache", "st_ins_oid", "st_hidden", "st_rappro_manu", "st_codser", "st_adm_id", "st_fldcd", "st_taille", "st_poids", "st_codchk", "st_datchk", "st_heuchk", "st_typnat", "st_numper_sec", "st_numper_ori_sec", "st_stu_id_ori" FROM "xplore2"."h_study") as x) [numPartitions=1] (4)
(1) Scan JDBCRelation((SELECT "st_numstu", "st_stu_id", "st_num_id", "st_datstu", "st_heustu", "st_modali", "st_fabriq", "st_instit", "st_nomdic", "st_pnodic", "st_d_ndic", "st_nb_ser", "st_nb_acq", "st_nb_ima", "st_nb_fic", "st_stueff", "st_dateff", "st_heueff", "st_comm_1", "st_comm_2", "st_droit", "st_rappro", "st_numdos", "st_numdem", "st_numper", "st_datmaj", "st_heumaj", "st_coduti", "st_pat_id", "st_accnum", "st_refphy", "st_studsc", "st_patsex", "st_reaphy", "st_perphy", "st_operat", "st_taific", "st_numexa", "st_flcd", "st_lieu", "st_numcd", "st_svcdem", "st_nb_ser_h", "st_nb_fic_h", "st_nb_ima_h", "st_taific_h", "st_locked", "st_flmanu", "st_numper_ori", "st_keyword", "st_read", "st_urgen", "st_sta_pps", "st_sop_uid", "st_codcli", "st_codsit", "st_ins", "st_cache", "st_ins_oid", "st_hidden", "st_rappro_manu", "st_codser", "st_adm_id", "st_fldcd", "st_taille", "st_poids", "st_codchk", "st_datchk", "st_heuchk", "st_typnat", "st_numper_sec", "st_numper_ori_sec", "st_stu_id_ori" FROM "xplore"."h_study") as x) [numPartitions=1] [codegen id : 1]
Output [73]: [st_numstu#596035, st_stu_id#596036, st_num_id#596037, st_datstu#596038, st_heustu#596039, st_modali#596040, st_fabriq#596041, st_instit#596042, st_nomdic#596043, st_pnodic#596044, st_d_ndic#596045, st_nb_ser#596046, st_nb_acq#596047, st_nb_ima#596048, st_nb_fic#596049, st_stueff#596050, st_dateff#596051, st_heueff#596052, st_comm_1#596053, st_comm_2#596054, st_droit#596055, st_rappro#596056, st_numdos#596057, st_numdem#596058, st_numper#596059, st_datmaj#596060, st_heumaj#596061, st_coduti#596062, st_pat_id#596063, st_accnum#596064, st_refphy#596065, st_studsc#596066, st_patsex#596067, st_reaphy#596068, st_perphy#596069, st_operat#596070, st_taific#596071, st_numexa#596072, st_flcd#596073, st_lieu#596074, st_numcd#596075, st_svcdem#596076, st_nb_ser_h#596077, st_nb_fic_h#596078, st_nb_ima_h#596079, st_taific_h#596080, st_locked#596081, st_flmanu#596082, st_numper_ori#596083, st_keyword#596084, st_read#596085, st_urgen#596086, st_sta_pps#596087, st_sop_uid#596088, st_codcli#596089, st_codsit#596090, st_ins#596091, st_cache#596092, st_ins_oid#596093, st_hidden#596094, st_rappro_manu#596095, st_codser#596096, st_adm_id#596097, st_fldcd#596098, st_taille#596099, st_poids#596100, st_codchk#596101, st_datchk#596102, st_heuchk#596103, st_typnat#596104, st_numper_sec#596105, st_numper_ori_sec#596106, st_stu_id_ori#596107]
ReadSchema: struct<st_numstu:string,st_stu_id:string,st_num_id:string,st_datstu:string,st_heustu:string,st_modali:string,st_fabriq:string,st_instit:string,st_nomdic:string,st_pnodic:string,st_d_ndic:string,st_nb_ser:string,st_nb_acq:string,st_nb_ima:string,st_nb_fic:string,st_stueff:string,st_dateff:string,st_heueff:string,st_comm_1:string,st_comm_2:string,st_droit:string,st_rappro:string,st_numdos:string,st_numdem:string,st_numper:string,st_datmaj:string,st_heumaj:string,st_coduti:string,st_pat_id:string,st_accnum:string,st_refphy:string,st_studsc:string,st_patsex:string,st_reaphy:string,st_perphy:string,st_operat:string,st_taific:string,st_numexa:string,st_flcd:string,st_lieu:string,st_numcd:string,st_svcdem:string,st_nb_ser_h:string,st_nb_fic_h:string,st_nb_ima_h:string,st_taific_h:string,st_locked:string,st_flmanu:string,st_numper_ori:string,st_keyword:string,st_read:string,st_urgen:string,st_sta_pps:string,st_sop_uid:string,st_codcli:string,st_codsit:string,st_ins:string,st_cache:string,st_ins_oid:string,st_hidden:string,st_rappro_manu:string,st_codser:string,st_adm_id:string,st_fldcd:string,st_taille:string,st_poids:string,st_codchk:string,st_datchk:string,st_heuchk:string,st_typnat:string,st_numper_sec:string,st_numper_ori_sec:string,st_stu_id_ori:string>
(2) Project [codegen id : 1]
Output [74]: [st_numstu#596035 AS COL_ST_NUMSTU_438260#598021, st_stu_id#596036 AS COL_ST_STU_ID_438261#598022, st_num_id#596037 AS COL_ST_NUM_ID_438262#598023, st_datstu#596038 AS COL_ST_DATSTU_438263#598024, st_heustu#596039 AS COL_ST_HEUSTU_438264#598025, st_modali#596040 AS COL_ST_MODALI_438265#598026, st_fabriq#596041 AS COL_ST_FABRIQ_438266#598027, st_instit#596042 AS COL_ST_INSTIT_438267#598028, st_nomdic#596043 AS COL_ST_NOMDIC_438268#598029, st_pnodic#596044 AS COL_ST_PNODIC_438269#598030, st_d_ndic#596045 AS COL_ST_D_NDIC_438270#598031, st_nb_ser#596046 AS COL_ST_NB_SER_438271#598032, st_nb_acq#596047 AS COL_ST_NB_ACQ_438272#598033, st_nb_ima#596048 AS COL_ST_NB_IMA_438273#598034, st_nb_fic#596049 AS COL_ST_NB_FIC_438274#598035, st_stueff#596050 AS COL_ST_STUEFF_438275#598036, st_dateff#596051 AS COL_ST_DATEFF_438276#598037, st_heueff#596052 AS COL_ST_HEUEFF_438277#598038, st_comm_1#596053 AS COL_ST_COMM_1_438278#598039, st_comm_2#596054 AS COL_ST_COMM_2_438279#598040, st_droit#596055 AS COL_ST_DROIT_438280#598041, st_rappro#596056 AS COL_ST_RAPPRO_438281#598042, st_numdos#596057 AS COL_ST_NUMDOS_438282#598043, st_numdem#596058 AS COL_ST_NUMDEM_438283#598044, st_numper#596059 AS COL_ST_NUMPER_438284#598045, st_datmaj#596060 AS COL_ST_DATMAJ_438285#598046, st_heumaj#596061 AS COL_ST_HEUMAJ_438286#598047, st_coduti#596062 AS COL_ST_CODUTI_438287#598048, st_pat_id#596063 AS COL_ST_PAT_ID_438288#598049, st_accnum#596064 AS COL_ST_ACCNUM_438289#598050, st_refphy#596065 AS COL_ST_REFPHY_438290#598051, st_studsc#596066 AS COL_ST_STUDSC_438291#598052, st_patsex#596067 AS COL_ST_PATSEX_438292#598053, st_reaphy#596068 AS COL_ST_REAPHY_438293#598054, st_perphy#596069 AS COL_ST_PERPHY_438294#598055, st_operat#596070 AS COL_ST_OPERAT_438295#598056, st_taific#596071 AS COL_ST_TAIFIC_438296#598057, st_numexa#596072 AS COL_ST_NUMEXA_438297#598058, st_flcd#596073 AS COL_ST_FLCD_438298#598059, st_lieu#596074 AS COL_ST_LIEU_438299#598060, st_numcd#596075 AS COL_ST_NUMCD_438300#598061, st_svcdem#596076 AS COL_ST_SVCDEM_438301#598062, st_nb_ser_h#596077 AS COL_ST_NB_SER_H_438302#598063, st_nb_fic_h#596078 AS COL_ST_NB_FIC_H_438303#598064, st_nb_ima_h#596079 AS COL_ST_NB_IMA_H_438304#598065, st_taific_h#596080 AS COL_ST_TAIFIC_H_438305#598066, st_locked#596081 AS COL_ST_LOCKED_438306#598067, st_flmanu#596082 AS COL_ST_FLMANU_438307#598068, st_numper_ori#596083 AS COL_ST_NUMPER_ORI_438308#598069, st_keyword#596084 AS COL_ST_KEYWORD_438309#598070, st_read#596085 AS COL_ST_READ_438310#598071, st_urgen#596086 AS COL_ST_URGEN_438311#598072, st_sta_pps#596087 AS COL_ST_STA_PPS_438312#598073, st_sop_uid#596088 AS COL_ST_SOP_UID_438313#598074, st_codcli#596089 AS COL_ST_CODCLI_438314#598075, st_codsit#596090 AS COL_ST_CODSIT_438315#598076, st_ins#596091 AS COL_ST_INS_438316#598077, st_cache#596092 AS COL_ST_CACHE_438317#598078, st_ins_oid#596093 AS COL_ST_INS_OID_438318#598079, st_hidden#596094 AS COL_ST_HIDDEN_438319#598080, st_rappro_manu#596095 AS COL_ST_RAPPRO_MANU_438320#598081, st_codser#596096 AS COL_ST_CODSER_438321#598082, st_adm_id#596097 AS COL_ST_ADM_ID_438322#598083, st_fldcd#596098 AS COL_ST_FLDCD_438323#598084, st_taille#596099 AS COL_ST_TAILLE_438324#598085, st_poids#596100 AS COL_ST_POIDS_438325#598086, st_codchk#596101 AS COL_ST_CODCHK_438326#598087, st_datchk#596102 AS COL_ST_DATCHK_438327#598088, st_heuchk#596103 AS COL_ST_HEUCHK_438328#598089, st_typnat#596104 AS COL_ST_TYPNAT_438329#598090, st_numper_sec#596105 AS COL_ST_NUMPER_SEC_438330#598091, st_numper_ori_sec#596106 AS COL_ST_NUMPER_ORI_S_438331#598092, st_stu_id_ori#596107 AS COL_ST_STU_ID_ORI_438332#598093, str_create(Cab_A) AS COL_ORIGINE_440154#598094]
Input [73]: [st_numstu#596035, st_stu_id#596036, st_num_id#596037, st_datstu#596038, st_heustu#596039, st_modali#596040, st_fabriq#596041, st_instit#596042, st_nomdic#596043, st_pnodic#596044, st_d_ndic#596045, st_nb_ser#596046, st_nb_acq#596047, st_nb_ima#596048, st_nb_fic#596049, st_stueff#596050, st_dateff#596051, st_heueff#596052, st_comm_1#596053, st_comm_2#596054, st_droit#596055, st_rappro#596056, st_numdos#596057, st_numdem#596058, st_numper#596059, st_datmaj#596060, st_heumaj#596061, st_coduti#596062, st_pat_id#596063, st_accnum#596064, st_refphy#596065, st_studsc#596066, st_patsex#596067, st_reaphy#596068, st_perphy#596069, st_operat#596070, st_taific#596071, st_numexa#596072, st_flcd#596073, st_lieu#596074, st_numcd#596075, st_svcdem#596076, st_nb_ser_h#596077, st_nb_fic_h#596078, st_nb_ima_h#596079, st_taific_h#596080, st_locked#596081, st_flmanu#596082, st_numper_ori#596083, st_keyword#596084, st_read#596085, st_urgen#596086, st_sta_pps#596087, st_sop_uid#596088, st_codcli#596089, st_codsit#596090, st_ins#596091, st_cache#596092, st_ins_oid#596093, st_hidden#596094, st_rappro_manu#596095, st_codser#596096, st_adm_id#596097, st_fldcd#596098, st_taille#596099, st_poids#596100, st_codchk#596101, st_datchk#596102, st_heuchk#596103, st_typnat#596104, st_numper_sec#596105, st_numper_ori_sec#596106, st_stu_id_ori#596107]
(3) LocalLimit [codegen id : 1]
Input [74]: [COL_ST_NUMSTU_438260#598021, COL_ST_STU_ID_438261#598022, COL_ST_NUM_ID_438262#598023, COL_ST_DATSTU_438263#598024, COL_ST_HEUSTU_438264#598025, COL_ST_MODALI_438265#598026, COL_ST_FABRIQ_438266#598027, COL_ST_INSTIT_438267#598028, COL_ST_NOMDIC_438268#598029, COL_ST_PNODIC_438269#598030, COL_ST_D_NDIC_438270#598031, COL_ST_NB_SER_438271#598032, COL_ST_NB_ACQ_438272#598033, COL_ST_NB_IMA_438273#598034, COL_ST_NB_FIC_438274#598035, COL_ST_STUEFF_438275#598036, COL_ST_DATEFF_438276#598037, COL_ST_HEUEFF_438277#598038, COL_ST_COMM_1_438278#598039, COL_ST_COMM_2_438279#598040, COL_ST_DROIT_438280#598041, COL_ST_RAPPRO_438281#598042, COL_ST_NUMDOS_438282#598043, COL_ST_NUMDEM_438283#598044, COL_ST_NUMPER_438284#598045, COL_ST_DATMAJ_438285#598046, COL_ST_HEUMAJ_438286#598047, COL_ST_CODUTI_438287#598048, COL_ST_PAT_ID_438288#598049, COL_ST_ACCNUM_438289#598050, COL_ST_REFPHY_438290#598051, COL_ST_STUDSC_438291#598052, COL_ST_PATSEX_438292#598053, COL_ST_REAPHY_438293#598054, COL_ST_PERPHY_438294#598055, COL_ST_OPERAT_438295#598056, COL_ST_TAIFIC_438296#598057, COL_ST_NUMEXA_438297#598058, COL_ST_FLCD_438298#598059, COL_ST_LIEU_438299#598060, COL_ST_NUMCD_438300#598061, COL_ST_SVCDEM_438301#598062, COL_ST_NB_SER_H_438302#598063, COL_ST_NB_FIC_H_438303#598064, COL_ST_NB_IMA_H_438304#598065, COL_ST_TAIFIC_H_438305#598066, COL_ST_LOCKED_438306#598067, COL_ST_FLMANU_438307#598068, COL_ST_NUMPER_ORI_438308#598069, COL_ST_KEYWORD_438309#598070, COL_ST_READ_438310#598071, COL_ST_URGEN_438311#598072, COL_ST_STA_PPS_438312#598073, COL_ST_SOP_UID_438313#598074, COL_ST_CODCLI_438314#598075, COL_ST_CODSIT_438315#598076, COL_ST_INS_438316#598077, COL_ST_CACHE_438317#598078, COL_ST_INS_OID_438318#598079, COL_ST_HIDDEN_438319#598080, COL_ST_RAPPRO_MANU_438320#598081, COL_ST_CODSER_438321#598082, COL_ST_ADM_ID_438322#598083, COL_ST_FLDCD_438323#598084, COL_ST_TAILLE_438324#598085, COL_ST_POIDS_438325#598086, COL_ST_CODCHK_438326#598087, COL_ST_DATCHK_438327#598088, COL_ST_HEUCHK_438328#598089, COL_ST_TYPNAT_438329#598090, COL_ST_NUMPER_SEC_438330#598091, COL_ST_NUMPER_ORI_S_438331#598092, COL_ST_STU_ID_ORI_438332#598093, COL_ORIGINE_440154#598094]
Arguments: 1500
(4) Scan JDBCRelation((SELECT "st_numstu", "st_stu_id", "st_num_id", "st_datstu", "st_heustu", "st_modali", "st_fabriq", "st_instit", "st_nomdic", "st_pnodic", "st_d_ndic", "st_nb_ser", "st_nb_acq", "st_nb_ima", "st_nb_fic", "st_stueff", "st_dateff", "st_heueff", "st_comm_1", "st_comm_2", "st_droit", "st_rappro", "st_numdos", "st_numdem", "st_numper", "st_datmaj", "st_heumaj", "st_coduti", "st_pat_id", "st_accnum", "st_refphy", "st_studsc", "st_patsex", "st_reaphy", "st_perphy", "st_operat", "st_taific", "st_numexa", "st_flcd", "st_lieu", "st_numcd", "st_svcdem", "st_nb_ser_h", "st_nb_fic_h", "st_nb_ima_h", "st_taific_h", "st_locked", "st_flmanu", "st_numper_ori", "st_keyword", "st_read", "st_urgen", "st_sta_pps", "st_sop_uid", "st_codcli", "st_codsit", "st_ins", "st_cache", "st_ins_oid", "st_hidden", "st_rappro_manu", "st_codser", "st_adm_id", "st_fldcd", "st_taille", "st_poids", "st_codchk", "st_datchk", "st_heuchk", "st_typnat", "st_numper_sec", "st_numper_ori_sec", "st_stu_id_ori" FROM "xplore2"."h_study") as x) [numPartitions=1] [codegen id : 2]
Output [73]: [st_numstu#596695, st_stu_id#596696, st_num_id#596697, st_datstu#596698, st_heustu#596699, st_modali#596700, st_fabriq#596701, st_instit#596702, st_nomdic#596703, st_pnodic#596704, st_d_ndic#596705, st_nb_ser#596706, st_nb_acq#596707, st_nb_ima#596708, st_nb_fic#596709, st_stueff#596710, st_dateff#596711, st_heueff#596712, st_comm_1#596713, st_comm_2#596714, st_droit#596715, st_rappro#596716, st_numdos#596717, st_numdem#596718, st_numper#596719, st_datmaj#596720, st_heumaj#596721, st_coduti#596722, st_pat_id#596723, st_accnum#596724, st_refphy#596725, st_studsc#596726, st_patsex#596727, st_reaphy#596728, st_perphy#596729, st_operat#596730, st_taific#596731, st_numexa#596732, st_flcd#596733, st_lieu#596734, st_numcd#596735, st_svcdem#596736, st_nb_ser_h#596737, st_nb_fic_h#596738, st_nb_ima_h#596739, st_taific_h#596740, st_locked#596741, st_flmanu#596742, st_numper_ori#596743, st_keyword#596744, st_read#596745, st_urgen#596746, st_sta_pps#596747, st_sop_uid#596748, st_codcli#596749, st_codsit#596750, st_ins#596751, st_cache#596752, st_ins_oid#596753, st_hidden#596754, st_rappro_manu#596755, st_codser#596756, st_adm_id#596757, st_fldcd#596758, st_taille#596759, st_poids#596760, st_codchk#596761, st_datchk#596762, st_heuchk#596763, st_typnat#596764, st_numper_sec#596765, st_numper_ori_sec#596766, st_stu_id_ori#596767]
ReadSchema: struct<st_numstu:string,st_stu_id:string,st_num_id:string,st_datstu:string,st_heustu:string,st_modali:string,st_fabriq:string,st_instit:string,st_nomdic:string,st_pnodic:string,st_d_ndic:string,st_nb_ser:string,st_nb_acq:string,st_nb_ima:string,st_nb_fic:string,st_stueff:string,st_dateff:string,st_heueff:string,st_comm_1:string,st_comm_2:string,st_droit:string,st_rappro:string,st_numdos:string,st_numdem:string,st_numper:string,st_datmaj:string,st_heumaj:string,st_coduti:string,st_pat_id:string,st_accnum:string,st_refphy:string,st_studsc:string,st_patsex:string,st_reaphy:string,st_perphy:string,st_operat:string,st_taific:string,st_numexa:string,st_flcd:string,st_lieu:string,st_numcd:string,st_svcdem:string,st_nb_ser_h:string,st_nb_fic_h:string,st_nb_ima_h:string,st_taific_h:string,st_locked:string,st_flmanu:string,st_numper_ori:string,st_keyword:string,st_read:string,st_urgen:string,st_sta_pps:string,st_sop_uid:string,st_codcli:string,st_codsit:string,st_ins:string,st_cache:string,st_ins_oid:string,st_hidden:string,st_rappro_manu:string,st_codser:string,st_adm_id:string,st_fldcd:string,st_taille:string,st_poids:string,st_codchk:string,st_datchk:string,st_heuchk:string,st_typnat:string,st_numper_sec:string,st_numper_ori_sec:string,st_stu_id_ori:string>
(5) Project [codegen id : 2]
Output [74]: [st_numstu#596695 AS COL_ST_NUMSTU_438260#598243, st_stu_id#596696 AS COL_ST_STU_ID_438261#598244, st_num_id#596697 AS COL_ST_NUM_ID_438262#598245, st_datstu#596698 AS COL_ST_DATSTU_438263#598246, st_heustu#596699 AS COL_ST_HEUSTU_438264#598247, st_modali#596700 AS COL_ST_MODALI_438265#598248, st_fabriq#596701 AS COL_ST_FABRIQ_438266#598249, st_instit#596702 AS COL_ST_INSTIT_438267#598250, st_nomdic#596703 AS COL_ST_NOMDIC_438268#598251, st_pnodic#596704 AS COL_ST_PNODIC_438269#598252, st_d_ndic#596705 AS COL_ST_D_NDIC_438270#598253, st_nb_ser#596706 AS COL_ST_NB_SER_438271#598254, st_nb_acq#596707 AS COL_ST_NB_ACQ_438272#598255, st_nb_ima#596708 AS COL_ST_NB_IMA_438273#598256, st_nb_fic#596709 AS COL_ST_NB_FIC_438274#598257, st_stueff#596710 AS COL_ST_STUEFF_438275#598258, st_dateff#596711 AS COL_ST_DATEFF_438276#598259, st_heueff#596712 AS COL_ST_HEUEFF_438277#598260, st_comm_1#596713 AS COL_ST_COMM_1_438278#598261, st_comm_2#596714 AS COL_ST_COMM_2_438279#598262, st_droit#596715 AS COL_ST_DROIT_438280#598263, st_rappro#596716 AS COL_ST_RAPPRO_438281#598264, st_numdos#596717 AS COL_ST_NUMDOS_438282#598265, st_numdem#596718 AS COL_ST_NUMDEM_438283#598266, st_numper#596719 AS COL_ST_NUMPER_438284#598267, st_datmaj#596720 AS COL_ST_DATMAJ_438285#598268, st_heumaj#596721 AS COL_ST_HEUMAJ_438286#598269, st_coduti#596722 AS COL_ST_CODUTI_438287#598270, st_pat_id#596723 AS COL_ST_PAT_ID_438288#598271, st_accnum#596724 AS COL_ST_ACCNUM_438289#598272, st_refphy#596725 AS COL_ST_REFPHY_438290#598273, st_studsc#596726 AS COL_ST_STUDSC_438291#598274, st_patsex#596727 AS COL_ST_PATSEX_438292#598275, st_reaphy#596728 AS COL_ST_REAPHY_438293#598276, st_perphy#596729 AS COL_ST_PERPHY_438294#598277, st_operat#596730 AS COL_ST_OPERAT_438295#598278, st_taific#596731 AS COL_ST_TAIFIC_438296#598279, st_numexa#596732 AS COL_ST_NUMEXA_438297#598280, st_flcd#596733 AS COL_ST_FLCD_438298#598281, st_lieu#596734 AS COL_ST_LIEU_438299#598282, st_numcd#596735 AS COL_ST_NUMCD_438300#598283, st_svcdem#596736 AS COL_ST_SVCDEM_438301#598284, st_nb_ser_h#596737 AS COL_ST_NB_SER_H_438302#598285, st_nb_fic_h#596738 AS COL_ST_NB_FIC_H_438303#598286, st_nb_ima_h#596739 AS COL_ST_NB_IMA_H_438304#598287, st_taific_h#596740 AS COL_ST_TAIFIC_H_438305#598288, st_locked#596741 AS COL_ST_LOCKED_438306#598289, st_flmanu#596742 AS COL_ST_FLMANU_438307#598290, st_numper_ori#596743 AS COL_ST_NUMPER_ORI_438308#598291, st_keyword#596744 AS COL_ST_KEYWORD_438309#598292, st_read#596745 AS COL_ST_READ_438310#598293, st_urgen#596746 AS COL_ST_URGEN_438311#598294, st_sta_pps#596747 AS COL_ST_STA_PPS_438312#598295, st_sop_uid#596748 AS COL_ST_SOP_UID_438313#598296, st_codcli#596749 AS COL_ST_CODCLI_438314#598297, st_codsit#596750 AS COL_ST_CODSIT_438315#598298, st_ins#596751 AS COL_ST_INS_438316#598299, st_cache#596752 AS COL_ST_CACHE_438317#598300, st_ins_oid#596753 AS COL_ST_INS_OID_438318#598301, st_hidden#596754 AS COL_ST_HIDDEN_438319#598302, st_rappro_manu#596755 AS COL_ST_RAPPRO_MANU_438320#598303, st_codser#596756 AS COL_ST_CODSER_438321#598304, st_adm_id#596757 AS COL_ST_ADM_ID_438322#598305, st_fldcd#596758 AS COL_ST_FLDCD_438323#598306, st_taille#596759 AS COL_ST_TAILLE_438324#598307, st_poids#596760 AS COL_ST_POIDS_438325#598308, st_codchk#596761 AS COL_ST_CODCHK_438326#598309, st_datchk#596762 AS COL_ST_DATCHK_438327#598310, st_heuchk#596763 AS COL_ST_HEUCHK_438328#598311, st_typnat#596764 AS COL_ST_TYPNAT_438329#598312, st_numper_sec#596765 AS COL_ST_NUMPER_SEC_438330#598313, st_numper_ori_sec#596766 AS COL_ST_NUMPER_ORI_S_438331#598314, st_stu_id_ori#596767 AS COL_ST_STU_ID_ORI_438332#598315, str_create(Cab_B) AS COL_ORIGINE_440154#598316]
Input [73]: [st_numstu#596695, st_stu_id#596696, st_num_id#596697, st_datstu#596698, st_heustu#596699, st_modali#596700, st_fabriq#596701, st_instit#596702, st_nomdic#596703, st_pnodic#596704, st_d_ndic#596705, st_nb_ser#596706, st_nb_acq#596707, st_nb_ima#596708, st_nb_fic#596709, st_stueff#596710, st_dateff#596711, st_heueff#596712, st_comm_1#596713, st_comm_2#596714, st_droit#596715, st_rappro#596716, st_numdos#596717, st_numdem#596718, st_numper#596719, st_datmaj#596720, st_heumaj#596721, st_coduti#596722, st_pat_id#596723, st_accnum#596724, st_refphy#596725, st_studsc#596726, st_patsex#596727, st_reaphy#596728, st_perphy#596729, st_operat#596730, st_taific#596731, st_numexa#596732, st_flcd#596733, st_lieu#596734, st_numcd#596735, st_svcdem#596736, st_nb_ser_h#596737, st_nb_fic_h#596738, st_nb_ima_h#596739, st_taific_h#596740, st_locked#596741, st_flmanu#596742, st_numper_ori#596743, st_keyword#596744, st_read#596745, st_urgen#596746, st_sta_pps#596747, st_sop_uid#596748, st_codcli#596749, st_codsit#596750, st_ins#596751, st_cache#596752, st_ins_oid#596753, st_hidden#596754, st_rappro_manu#596755, st_codser#596756, st_adm_id#596757, st_fldcd#596758, st_taille#596759, st_poids#596760, st_codchk#596761, st_datchk#596762, st_heuchk#596763, st_typnat#596764, st_numper_sec#596765, st_numper_ori_sec#596766, st_stu_id_ori#596767]
(6) LocalLimit [codegen id : 2]
Input [74]: [COL_ST_NUMSTU_438260#598243, COL_ST_STU_ID_438261#598244, COL_ST_NUM_ID_438262#598245, COL_ST_DATSTU_438263#598246, COL_ST_HEUSTU_438264#598247, COL_ST_MODALI_438265#598248, COL_ST_FABRIQ_438266#598249, COL_ST_INSTIT_438267#598250, COL_ST_NOMDIC_438268#598251, COL_ST_PNODIC_438269#598252, COL_ST_D_NDIC_438270#598253, COL_ST_NB_SER_438271#598254, COL_ST_NB_ACQ_438272#598255, COL_ST_NB_IMA_438273#598256, COL_ST_NB_FIC_438274#598257, COL_ST_STUEFF_438275#598258, COL_ST_DATEFF_438276#598259, COL_ST_HEUEFF_438277#598260, COL_ST_COMM_1_438278#598261, COL_ST_COMM_2_438279#598262, COL_ST_DROIT_438280#598263, COL_ST_RAPPRO_438281#598264, COL_ST_NUMDOS_438282#598265, COL_ST_NUMDEM_438283#598266, COL_ST_NUMPER_438284#598267, COL_ST_DATMAJ_438285#598268, COL_ST_HEUMAJ_438286#598269, COL_ST_CODUTI_438287#598270, COL_ST_PAT_ID_438288#598271, COL_ST_ACCNUM_438289#598272, COL_ST_REFPHY_438290#598273, COL_ST_STUDSC_438291#598274, COL_ST_PATSEX_438292#598275, COL_ST_REAPHY_438293#598276, COL_ST_PERPHY_438294#598277, COL_ST_OPERAT_438295#598278, COL_ST_TAIFIC_438296#598279, COL_ST_NUMEXA_438297#598280, COL_ST_FLCD_438298#598281, COL_ST_LIEU_438299#598282, COL_ST_NUMCD_438300#598283, COL_ST_SVCDEM_438301#598284, COL_ST_NB_SER_H_438302#598285, COL_ST_NB_FIC_H_438303#598286, COL_ST_NB_IMA_H_438304#598287, COL_ST_TAIFIC_H_438305#598288, COL_ST_LOCKED_438306#598289, COL_ST_FLMANU_438307#598290, COL_ST_NUMPER_ORI_438308#598291, COL_ST_KEYWORD_438309#598292, COL_ST_READ_438310#598293, COL_ST_URGEN_438311#598294, COL_ST_STA_PPS_438312#598295, COL_ST_SOP_UID_438313#598296, COL_ST_CODCLI_438314#598297, COL_ST_CODSIT_438315#598298, COL_ST_INS_438316#598299, COL_ST_CACHE_438317#598300, COL_ST_INS_OID_438318#598301, COL_ST_HIDDEN_438319#598302, COL_ST_RAPPRO_MANU_438320#598303, COL_ST_CODSER_438321#598304, COL_ST_ADM_ID_438322#598305, COL_ST_FLDCD_438323#598306, COL_ST_TAILLE_438324#598307, COL_ST_POIDS_438325#598308, COL_ST_CODCHK_438326#598309, COL_ST_DATCHK_438327#598310, COL_ST_HEUCHK_438328#598311, COL_ST_TYPNAT_438329#598312, COL_ST_NUMPER_SEC_438330#598313, COL_ST_NUMPER_ORI_S_438331#598314, COL_ST_STU_ID_ORI_438332#598315, COL_ORIGINE_440154#598316]
Arguments: 1500
(7) Union
(8) CollectLimit
Input [74]: [COL_ST_NUMSTU_438260#598021, COL_ST_STU_ID_438261#598022, COL_ST_NUM_ID_438262#598023, COL_ST_DATSTU_438263#598024, COL_ST_HEUSTU_438264#598025, COL_ST_MODALI_438265#598026, COL_ST_FABRIQ_438266#598027, COL_ST_INSTIT_438267#598028, COL_ST_NOMDIC_438268#598029, COL_ST_PNODIC_438269#598030, COL_ST_D_NDIC_438270#598031, COL_ST_NB_SER_438271#598032, COL_ST_NB_ACQ_438272#598033, COL_ST_NB_IMA_438273#598034, COL_ST_NB_FIC_438274#598035, COL_ST_STUEFF_438275#598036, COL_ST_DATEFF_438276#598037, COL_ST_HEUEFF_438277#598038, COL_ST_COMM_1_438278#598039, COL_ST_COMM_2_438279#598040, COL_ST_DROIT_438280#598041, COL_ST_RAPPRO_438281#598042, COL_ST_NUMDOS_438282#598043, COL_ST_NUMDEM_438283#598044, COL_ST_NUMPER_438284#598045, COL_ST_DATMAJ_438285#598046, COL_ST_HEUMAJ_438286#598047, COL_ST_CODUTI_438287#598048, COL_ST_PAT_ID_438288#598049, COL_ST_ACCNUM_438289#598050, COL_ST_REFPHY_438290#598051, COL_ST_STUDSC_438291#598052, COL_ST_PATSEX_438292#598053, COL_ST_REAPHY_438293#598054, COL_ST_PERPHY_438294#598055, COL_ST_OPERAT_438295#598056, COL_ST_TAIFIC_438296#598057, COL_ST_NUMEXA_438297#598058, COL_ST_FLCD_438298#598059, COL_ST_LIEU_438299#598060, COL_ST_NUMCD_438300#598061, COL_ST_SVCDEM_438301#598062, COL_ST_NB_SER_H_438302#598063, COL_ST_NB_FIC_H_438303#598064, COL_ST_NB_IMA_H_438304#598065, COL_ST_TAIFIC_H_438305#598066, COL_ST_LOCKED_438306#598067, COL_ST_FLMANU_438307#598068, COL_ST_NUMPER_ORI_438308#598069, COL_ST_KEYWORD_438309#598070, COL_ST_READ_438310#598071, COL_ST_URGEN_438311#598072, COL_ST_STA_PPS_438312#598073, COL_ST_SOP_UID_438313#598074, COL_ST_CODCLI_438314#598075, COL_ST_CODSIT_438315#598076, COL_ST_INS_438316#598077, COL_ST_CACHE_438317#598078, COL_ST_INS_OID_438318#598079, COL_ST_HIDDEN_438319#598080, COL_ST_RAPPRO_MANU_438320#598081, COL_ST_CODSER_438321#598082, COL_ST_ADM_ID_438322#598083, COL_ST_FLDCD_438323#598084, COL_ST_TAILLE_438324#598085, COL_ST_POIDS_438325#598086, COL_ST_CODCHK_438326#598087, COL_ST_DATCHK_438327#598088, COL_ST_HEUCHK_438328#598089, COL_ST_TYPNAT_438329#598090, COL_ST_NUMPER_SEC_438330#598091, COL_ST_NUMPER_ORI_S_438331#598092, COL_ST_STU_ID_ORI_438332#598093, COL_ORIGINE_440154#598094]
Arguments: 1500