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: 2 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 \"xa_codexa\", \"xa_lib30\", \"xa_libuti\", \"xa_typexa\", \"xa_contra\", \"xa_durava\", \"xa_durpen\", \"xa_durapr\", \"xa_durtot\", \"xa_durmed\", \"xa_protoc\", \"xa_datmaj\", \"xa_coduti\", \"xa_codpro\", \"xa_coulstd\", \"xa_couleur\", \"xa_flmedobl\", \"xa_flatsobl\", \"xa_flvalplanif\", \"xa_flvalaccueil\", \"xa_nivvcr\", \"xa_flrtcclq\", \"xa_fllabochaud\", \"xa_datede\", \"xa_datefi\", \"xa_flgrpjour\", \"xa_primai\", \"xa_codpros\", \"xa_codconv\", \"xa_later\", \"xa_incidence\", \"xa_position\", \"xa_flgrve\", \"xa_flexainj\", \"xa_contrapat\", \"xa_flprore\", \"xa_flcacheinet\", \"xa_flnocot\", \"xa_codadm\", \"xa_flgrvi\", \"xa_reganas\", \"xa_flrecist\", \"xa_flnocr\", \"xa_icd\", \"xa_type_icd\", \"xa_flrecist_ec\", \"xa_codloinc\" FROM \"xplore\".\"h_examen\") as x) [numPartitions=1] </b><br><br>number of output rows: 253"];
}
subgraph cluster6 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 3 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 \"xa_codexa\", \"xa_lib30\", \"xa_libuti\", \"xa_typexa\", \"xa_contra\", \"xa_durava\", \"xa_durpen\", \"xa_durapr\", \"xa_durtot\", \"xa_durmed\", \"xa_protoc\", \"xa_datmaj\", \"xa_coduti\", \"xa_codpro\", \"xa_coulstd\", \"xa_couleur\", \"xa_flmedobl\", \"xa_flatsobl\", \"xa_flvalplanif\", \"xa_flvalaccueil\", \"xa_nivvcr\", \"xa_flrtcclq\", \"xa_fllabochaud\", \"xa_datede\", \"xa_datefi\", \"xa_flgrpjour\", \"xa_primai\", \"xa_codpros\", \"xa_codconv\", \"xa_later\", \"xa_incidence\", \"xa_position\", \"xa_flgrve\", \"xa_flexainj\", \"xa_contrapat\", \"xa_flprore\", \"xa_flcacheinet\", \"xa_flnocot\", \"xa_codadm\", \"xa_flgrvi\", \"xa_reganas\", \"xa_flrecist\", \"xa_flnocr\", \"xa_icd\", \"xa_type_icd\", \"xa_flrecist_ec\", \"xa_codloinc\" FROM \"xplore2\".\"h_examen\") as x) [numPartitions=1] </b><br><br>number of output rows: 253"];
}
1->0;
3->1;
4->3;
5->4;
7->1;
8->7;
9->8;
}
10
CollectLimit 1500
Union
LocalLimit 1500
Project [xa_codexa#786620 AS COL_XA_CODEXA_437820#787904, xa_lib30#786621 AS COL_XA_LIB30_437821#787905, xa_libuti#786622 AS COL_XA_LIBUTI_437822#787906, xa_typexa#786623 AS COL_XA_TYPEXA_437823#787907, xa_contra#786624 AS COL_XA_CONTRA_437824#787908, xa_durava#786625 AS COL_XA_DURAVA_437825#787909, xa_durpen#786626 AS COL_XA_DURPEN_437826#787910, xa_durapr#786627 AS COL_XA_DURAPR_437827#787911, xa_durtot#786628 AS COL_XA_DURTOT_437828#787912, xa_durmed#786629 AS COL_XA_DURMED_437829#787913, xa_protoc#786630 AS COL_XA_PROTOC_437830#787914, xa_datmaj#786631 AS COL_XA_DATMAJ_437831#787915, xa_coduti#786632 AS COL_XA_CODUTI_437832#787916, xa_codpro#786633 AS COL_XA_CODPRO_437833#787917, xa_coulstd#786634 AS COL_XA_COULSTD_437834#787918, xa_couleur#786635 AS COL_XA_COULEUR_437835#787919, xa_flmedobl#786636 AS COL_XA_FLMEDOBL_437836#787920, xa_flatsobl#786637 AS COL_XA_FLATSOBL_437837#787921, xa_flvalplanif#786638 AS COL_XA_FLVALPLANIF_437838#787922, xa_flvalaccueil#786639 AS COL_XA_FLVALACCUEIL_437839#787923, xa_nivvcr#786640 AS COL_XA_NIVVCR_437840#787924, xa_flrtcclq#786641 AS COL_XA_FLRTCCLQ_437841#787925, xa_fllabochaud#786642 AS COL_XA_FLLABOCHAUD_437842#787926, xa_datede#786643 AS COL_XA_DATEDE_437843#787927, ... 24 more fields]
Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1] [xa_codexa#786620,xa_lib30#786621,xa_libuti#786622,xa_typexa#786623,xa_contra#786624,xa_durava#786625,xa_durpen#786626,xa_durapr#786627,xa_durtot#786628,xa_durmed#786629,xa_protoc#786630,xa_datmaj#786631,xa_coduti#786632,xa_codpro#786633,xa_coulstd#786634,xa_couleur#786635,xa_flmedobl#786636,xa_flatsobl#786637,xa_flvalplanif#786638,xa_flvalaccueil#786639,xa_nivvcr#786640,xa_flrtcclq#786641,xa_fllabochaud#786642,xa_datede#786643,... 23 more fields] PushedFilters: [], ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_dur...
WholeStageCodegen (1)
LocalLimit 1500
Project [xa_codexa#787046 AS COL_XA_CODEXA_437820#788048, xa_lib30#787047 AS COL_XA_LIB30_437821#788049, xa_libuti#787048 AS COL_XA_LIBUTI_437822#788050, xa_typexa#787049 AS COL_XA_TYPEXA_437823#788051, xa_contra#787050 AS COL_XA_CONTRA_437824#788052, xa_durava#787051 AS COL_XA_DURAVA_437825#788053, xa_durpen#787052 AS COL_XA_DURPEN_437826#788054, xa_durapr#787053 AS COL_XA_DURAPR_437827#788055, xa_durtot#787054 AS COL_XA_DURTOT_437828#788056, xa_durmed#787055 AS COL_XA_DURMED_437829#788057, xa_protoc#787056 AS COL_XA_PROTOC_437830#788058, xa_datmaj#787057 AS COL_XA_DATMAJ_437831#788059, xa_coduti#787058 AS COL_XA_CODUTI_437832#788060, xa_codpro#787059 AS COL_XA_CODPRO_437833#788061, xa_coulstd#787060 AS COL_XA_COULSTD_437834#788062, xa_couleur#787061 AS COL_XA_COULEUR_437835#788063, xa_flmedobl#787062 AS COL_XA_FLMEDOBL_437836#788064, xa_flatsobl#787063 AS COL_XA_FLATSOBL_437837#788065, xa_flvalplanif#787064 AS COL_XA_FLVALPLANIF_437838#788066, xa_flvalaccueil#787065 AS COL_XA_FLVALACCUEIL_437839#788067, xa_nivvcr#787066 AS COL_XA_NIVVCR_437840#788068, xa_flrtcclq#787067 AS COL_XA_FLRTCCLQ_437841#788069, xa_fllabochaud#787068 AS COL_XA_FLLABOCHAUD_437842#788070, xa_datede#787069 AS COL_XA_DATEDE_437843#788071, ... 24 more fields]
Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1] [xa_codexa#787046,xa_lib30#787047,xa_libuti#787048,xa_typexa#787049,xa_contra#787050,xa_durava#787051,xa_durpen#787052,xa_durapr#787053,xa_durtot#787054,xa_durmed#787055,xa_protoc#787056,xa_datmaj#787057,xa_coduti#787058,xa_codpro#787059,xa_coulstd#787060,xa_couleur#787061,xa_flmedobl#787062,xa_flatsobl#787063,xa_flvalplanif#787064,xa_flvalaccueil#787065,xa_nivvcr#787066,xa_flrtcclq#787067,xa_fllabochaud#787068,xa_datede#787069,... 23 more fields] PushedFilters: [], ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_dur...
WholeStageCodegen (2)
== Physical Plan ==
CollectLimit (8)
+- Union (7)
:- * LocalLimit (3)
: +- * Project (2)
: +- * Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1] (1)
+- * LocalLimit (6)
+- * Project (5)
+- * Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1] (4)
(1) Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1] [codegen id : 1]
Output [47]: [xa_codexa#786620, xa_lib30#786621, xa_libuti#786622, xa_typexa#786623, xa_contra#786624, xa_durava#786625, xa_durpen#786626, xa_durapr#786627, xa_durtot#786628, xa_durmed#786629, xa_protoc#786630, xa_datmaj#786631, xa_coduti#786632, xa_codpro#786633, xa_coulstd#786634, xa_couleur#786635, xa_flmedobl#786636, xa_flatsobl#786637, xa_flvalplanif#786638, xa_flvalaccueil#786639, xa_nivvcr#786640, xa_flrtcclq#786641, xa_fllabochaud#786642, xa_datede#786643, xa_datefi#786644, xa_flgrpjour#786645, xa_primai#786646, xa_codpros#786647, xa_codconv#786648, xa_later#786649, xa_incidence#786650, xa_position#786651, xa_flgrve#786652, xa_flexainj#786653, xa_contrapat#786654, xa_flprore#786655, xa_flcacheinet#786656, xa_flnocot#786657, xa_codadm#786658, xa_flgrvi#786659, xa_reganas#786660, xa_flrecist#786661, xa_flnocr#786662, xa_icd#786663, xa_type_icd#786664, xa_flrecist_ec#786665, xa_codloinc#786666]
ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_durava:string,xa_durpen:string,xa_durapr:string,xa_durtot:string,xa_durmed:string,xa_protoc:string,xa_datmaj:string,xa_coduti:string,xa_codpro:string,xa_coulstd:string,xa_couleur:string,xa_flmedobl:string,xa_flatsobl:string,xa_flvalplanif:string,xa_flvalaccueil:string,xa_nivvcr:string,xa_flrtcclq:string,xa_fllabochaud:string,xa_datede:string,xa_datefi:string,xa_flgrpjour:string,xa_primai:string,xa_codpros:string,xa_codconv:string,xa_later:string,xa_incidence:string,xa_position:string,xa_flgrve:string,xa_flexainj:string,xa_contrapat:string,xa_flprore:string,xa_flcacheinet:string,xa_flnocot:string,xa_codadm:string,xa_flgrvi:string,xa_reganas:string,xa_flrecist:string,xa_flnocr:string,xa_icd:string,xa_type_icd:string,xa_flrecist_ec:string,xa_codloinc:string>
(2) Project [codegen id : 1]
Output [48]: [xa_codexa#786620 AS COL_XA_CODEXA_437820#787904, xa_lib30#786621 AS COL_XA_LIB30_437821#787905, xa_libuti#786622 AS COL_XA_LIBUTI_437822#787906, xa_typexa#786623 AS COL_XA_TYPEXA_437823#787907, xa_contra#786624 AS COL_XA_CONTRA_437824#787908, xa_durava#786625 AS COL_XA_DURAVA_437825#787909, xa_durpen#786626 AS COL_XA_DURPEN_437826#787910, xa_durapr#786627 AS COL_XA_DURAPR_437827#787911, xa_durtot#786628 AS COL_XA_DURTOT_437828#787912, xa_durmed#786629 AS COL_XA_DURMED_437829#787913, xa_protoc#786630 AS COL_XA_PROTOC_437830#787914, xa_datmaj#786631 AS COL_XA_DATMAJ_437831#787915, xa_coduti#786632 AS COL_XA_CODUTI_437832#787916, xa_codpro#786633 AS COL_XA_CODPRO_437833#787917, xa_coulstd#786634 AS COL_XA_COULSTD_437834#787918, xa_couleur#786635 AS COL_XA_COULEUR_437835#787919, xa_flmedobl#786636 AS COL_XA_FLMEDOBL_437836#787920, xa_flatsobl#786637 AS COL_XA_FLATSOBL_437837#787921, xa_flvalplanif#786638 AS COL_XA_FLVALPLANIF_437838#787922, xa_flvalaccueil#786639 AS COL_XA_FLVALACCUEIL_437839#787923, xa_nivvcr#786640 AS COL_XA_NIVVCR_437840#787924, xa_flrtcclq#786641 AS COL_XA_FLRTCCLQ_437841#787925, xa_fllabochaud#786642 AS COL_XA_FLLABOCHAUD_437842#787926, xa_datede#786643 AS COL_XA_DATEDE_437843#787927, xa_datefi#786644 AS COL_XA_DATEFI_437844#787928, xa_flgrpjour#786645 AS COL_XA_FLGRPJOUR_437845#787929, xa_primai#786646 AS COL_XA_PRIMAI_437846#787930, xa_codpros#786647 AS COL_XA_CODPROS_437847#787931, xa_codconv#786648 AS COL_XA_CODCONV_437848#787932, xa_later#786649 AS COL_XA_LATER_437849#787933, xa_incidence#786650 AS COL_XA_INCIDENCE_437850#787934, xa_position#786651 AS COL_XA_POSITION_437851#787935, xa_flgrve#786652 AS COL_XA_FLGRVE_437852#787936, xa_flexainj#786653 AS COL_XA_FLEXAINJ_437853#787937, xa_contrapat#786654 AS COL_XA_CONTRAPAT_437854#787938, xa_flprore#786655 AS COL_XA_FLPRORE_437855#787939, xa_flcacheinet#786656 AS COL_XA_FLCACHEINET_437856#787940, xa_flnocot#786657 AS COL_XA_FLNOCOT_437857#787941, xa_codadm#786658 AS COL_XA_CODADM_437858#787942, xa_flgrvi#786659 AS COL_XA_FLGRVI_437859#787943, xa_reganas#786660 AS COL_XA_REGANAS_437860#787944, xa_flrecist#786661 AS COL_XA_FLRECIST_437861#787945, xa_flnocr#786662 AS COL_XA_FLNOCR_437862#787946, xa_icd#786663 AS COL_XA_ICD_437863#787947, xa_type_icd#786664 AS COL_XA_TYPE_ICD_437864#787948, xa_flrecist_ec#786665 AS COL_XA_FLRECIST_EC_437865#787949, xa_codloinc#786666 AS COL_XA_CODLOINC_437866#787950, str_create(Cab_A) AS COL_ORIGINE_440144#787951]
Input [47]: [xa_codexa#786620, xa_lib30#786621, xa_libuti#786622, xa_typexa#786623, xa_contra#786624, xa_durava#786625, xa_durpen#786626, xa_durapr#786627, xa_durtot#786628, xa_durmed#786629, xa_protoc#786630, xa_datmaj#786631, xa_coduti#786632, xa_codpro#786633, xa_coulstd#786634, xa_couleur#786635, xa_flmedobl#786636, xa_flatsobl#786637, xa_flvalplanif#786638, xa_flvalaccueil#786639, xa_nivvcr#786640, xa_flrtcclq#786641, xa_fllabochaud#786642, xa_datede#786643, xa_datefi#786644, xa_flgrpjour#786645, xa_primai#786646, xa_codpros#786647, xa_codconv#786648, xa_later#786649, xa_incidence#786650, xa_position#786651, xa_flgrve#786652, xa_flexainj#786653, xa_contrapat#786654, xa_flprore#786655, xa_flcacheinet#786656, xa_flnocot#786657, xa_codadm#786658, xa_flgrvi#786659, xa_reganas#786660, xa_flrecist#786661, xa_flnocr#786662, xa_icd#786663, xa_type_icd#786664, xa_flrecist_ec#786665, xa_codloinc#786666]
(3) LocalLimit [codegen id : 1]
Input [48]: [COL_XA_CODEXA_437820#787904, COL_XA_LIB30_437821#787905, COL_XA_LIBUTI_437822#787906, COL_XA_TYPEXA_437823#787907, COL_XA_CONTRA_437824#787908, COL_XA_DURAVA_437825#787909, COL_XA_DURPEN_437826#787910, COL_XA_DURAPR_437827#787911, COL_XA_DURTOT_437828#787912, COL_XA_DURMED_437829#787913, COL_XA_PROTOC_437830#787914, COL_XA_DATMAJ_437831#787915, COL_XA_CODUTI_437832#787916, COL_XA_CODPRO_437833#787917, COL_XA_COULSTD_437834#787918, COL_XA_COULEUR_437835#787919, COL_XA_FLMEDOBL_437836#787920, COL_XA_FLATSOBL_437837#787921, COL_XA_FLVALPLANIF_437838#787922, COL_XA_FLVALACCUEIL_437839#787923, COL_XA_NIVVCR_437840#787924, COL_XA_FLRTCCLQ_437841#787925, COL_XA_FLLABOCHAUD_437842#787926, COL_XA_DATEDE_437843#787927, COL_XA_DATEFI_437844#787928, COL_XA_FLGRPJOUR_437845#787929, COL_XA_PRIMAI_437846#787930, COL_XA_CODPROS_437847#787931, COL_XA_CODCONV_437848#787932, COL_XA_LATER_437849#787933, COL_XA_INCIDENCE_437850#787934, COL_XA_POSITION_437851#787935, COL_XA_FLGRVE_437852#787936, COL_XA_FLEXAINJ_437853#787937, COL_XA_CONTRAPAT_437854#787938, COL_XA_FLPRORE_437855#787939, COL_XA_FLCACHEINET_437856#787940, COL_XA_FLNOCOT_437857#787941, COL_XA_CODADM_437858#787942, COL_XA_FLGRVI_437859#787943, COL_XA_REGANAS_437860#787944, COL_XA_FLRECIST_437861#787945, COL_XA_FLNOCR_437862#787946, COL_XA_ICD_437863#787947, COL_XA_TYPE_ICD_437864#787948, COL_XA_FLRECIST_EC_437865#787949, COL_XA_CODLOINC_437866#787950, COL_ORIGINE_440144#787951]
Arguments: 1500
(4) Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1] [codegen id : 2]
Output [47]: [xa_codexa#787046, xa_lib30#787047, xa_libuti#787048, xa_typexa#787049, xa_contra#787050, xa_durava#787051, xa_durpen#787052, xa_durapr#787053, xa_durtot#787054, xa_durmed#787055, xa_protoc#787056, xa_datmaj#787057, xa_coduti#787058, xa_codpro#787059, xa_coulstd#787060, xa_couleur#787061, xa_flmedobl#787062, xa_flatsobl#787063, xa_flvalplanif#787064, xa_flvalaccueil#787065, xa_nivvcr#787066, xa_flrtcclq#787067, xa_fllabochaud#787068, xa_datede#787069, xa_datefi#787070, xa_flgrpjour#787071, xa_primai#787072, xa_codpros#787073, xa_codconv#787074, xa_later#787075, xa_incidence#787076, xa_position#787077, xa_flgrve#787078, xa_flexainj#787079, xa_contrapat#787080, xa_flprore#787081, xa_flcacheinet#787082, xa_flnocot#787083, xa_codadm#787084, xa_flgrvi#787085, xa_reganas#787086, xa_flrecist#787087, xa_flnocr#787088, xa_icd#787089, xa_type_icd#787090, xa_flrecist_ec#787091, xa_codloinc#787092]
ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_durava:string,xa_durpen:string,xa_durapr:string,xa_durtot:string,xa_durmed:string,xa_protoc:string,xa_datmaj:string,xa_coduti:string,xa_codpro:string,xa_coulstd:string,xa_couleur:string,xa_flmedobl:string,xa_flatsobl:string,xa_flvalplanif:string,xa_flvalaccueil:string,xa_nivvcr:string,xa_flrtcclq:string,xa_fllabochaud:string,xa_datede:string,xa_datefi:string,xa_flgrpjour:string,xa_primai:string,xa_codpros:string,xa_codconv:string,xa_later:string,xa_incidence:string,xa_position:string,xa_flgrve:string,xa_flexainj:string,xa_contrapat:string,xa_flprore:string,xa_flcacheinet:string,xa_flnocot:string,xa_codadm:string,xa_flgrvi:string,xa_reganas:string,xa_flrecist:string,xa_flnocr:string,xa_icd:string,xa_type_icd:string,xa_flrecist_ec:string,xa_codloinc:string>
(5) Project [codegen id : 2]
Output [48]: [xa_codexa#787046 AS COL_XA_CODEXA_437820#788048, xa_lib30#787047 AS COL_XA_LIB30_437821#788049, xa_libuti#787048 AS COL_XA_LIBUTI_437822#788050, xa_typexa#787049 AS COL_XA_TYPEXA_437823#788051, xa_contra#787050 AS COL_XA_CONTRA_437824#788052, xa_durava#787051 AS COL_XA_DURAVA_437825#788053, xa_durpen#787052 AS COL_XA_DURPEN_437826#788054, xa_durapr#787053 AS COL_XA_DURAPR_437827#788055, xa_durtot#787054 AS COL_XA_DURTOT_437828#788056, xa_durmed#787055 AS COL_XA_DURMED_437829#788057, xa_protoc#787056 AS COL_XA_PROTOC_437830#788058, xa_datmaj#787057 AS COL_XA_DATMAJ_437831#788059, xa_coduti#787058 AS COL_XA_CODUTI_437832#788060, xa_codpro#787059 AS COL_XA_CODPRO_437833#788061, xa_coulstd#787060 AS COL_XA_COULSTD_437834#788062, xa_couleur#787061 AS COL_XA_COULEUR_437835#788063, xa_flmedobl#787062 AS COL_XA_FLMEDOBL_437836#788064, xa_flatsobl#787063 AS COL_XA_FLATSOBL_437837#788065, xa_flvalplanif#787064 AS COL_XA_FLVALPLANIF_437838#788066, xa_flvalaccueil#787065 AS COL_XA_FLVALACCUEIL_437839#788067, xa_nivvcr#787066 AS COL_XA_NIVVCR_437840#788068, xa_flrtcclq#787067 AS COL_XA_FLRTCCLQ_437841#788069, xa_fllabochaud#787068 AS COL_XA_FLLABOCHAUD_437842#788070, xa_datede#787069 AS COL_XA_DATEDE_437843#788071, xa_datefi#787070 AS COL_XA_DATEFI_437844#788072, xa_flgrpjour#787071 AS COL_XA_FLGRPJOUR_437845#788073, xa_primai#787072 AS COL_XA_PRIMAI_437846#788074, xa_codpros#787073 AS COL_XA_CODPROS_437847#788075, xa_codconv#787074 AS COL_XA_CODCONV_437848#788076, xa_later#787075 AS COL_XA_LATER_437849#788077, xa_incidence#787076 AS COL_XA_INCIDENCE_437850#788078, xa_position#787077 AS COL_XA_POSITION_437851#788079, xa_flgrve#787078 AS COL_XA_FLGRVE_437852#788080, xa_flexainj#787079 AS COL_XA_FLEXAINJ_437853#788081, xa_contrapat#787080 AS COL_XA_CONTRAPAT_437854#788082, xa_flprore#787081 AS COL_XA_FLPRORE_437855#788083, xa_flcacheinet#787082 AS COL_XA_FLCACHEINET_437856#788084, xa_flnocot#787083 AS COL_XA_FLNOCOT_437857#788085, xa_codadm#787084 AS COL_XA_CODADM_437858#788086, xa_flgrvi#787085 AS COL_XA_FLGRVI_437859#788087, xa_reganas#787086 AS COL_XA_REGANAS_437860#788088, xa_flrecist#787087 AS COL_XA_FLRECIST_437861#788089, xa_flnocr#787088 AS COL_XA_FLNOCR_437862#788090, xa_icd#787089 AS COL_XA_ICD_437863#788091, xa_type_icd#787090 AS COL_XA_TYPE_ICD_437864#788092, xa_flrecist_ec#787091 AS COL_XA_FLRECIST_EC_437865#788093, xa_codloinc#787092 AS COL_XA_CODLOINC_437866#788094, str_create(Cab_B) AS COL_ORIGINE_440144#788095]
Input [47]: [xa_codexa#787046, xa_lib30#787047, xa_libuti#787048, xa_typexa#787049, xa_contra#787050, xa_durava#787051, xa_durpen#787052, xa_durapr#787053, xa_durtot#787054, xa_durmed#787055, xa_protoc#787056, xa_datmaj#787057, xa_coduti#787058, xa_codpro#787059, xa_coulstd#787060, xa_couleur#787061, xa_flmedobl#787062, xa_flatsobl#787063, xa_flvalplanif#787064, xa_flvalaccueil#787065, xa_nivvcr#787066, xa_flrtcclq#787067, xa_fllabochaud#787068, xa_datede#787069, xa_datefi#787070, xa_flgrpjour#787071, xa_primai#787072, xa_codpros#787073, xa_codconv#787074, xa_later#787075, xa_incidence#787076, xa_position#787077, xa_flgrve#787078, xa_flexainj#787079, xa_contrapat#787080, xa_flprore#787081, xa_flcacheinet#787082, xa_flnocot#787083, xa_codadm#787084, xa_flgrvi#787085, xa_reganas#787086, xa_flrecist#787087, xa_flnocr#787088, xa_icd#787089, xa_type_icd#787090, xa_flrecist_ec#787091, xa_codloinc#787092]
(6) LocalLimit [codegen id : 2]
Input [48]: [COL_XA_CODEXA_437820#788048, COL_XA_LIB30_437821#788049, COL_XA_LIBUTI_437822#788050, COL_XA_TYPEXA_437823#788051, COL_XA_CONTRA_437824#788052, COL_XA_DURAVA_437825#788053, COL_XA_DURPEN_437826#788054, COL_XA_DURAPR_437827#788055, COL_XA_DURTOT_437828#788056, COL_XA_DURMED_437829#788057, COL_XA_PROTOC_437830#788058, COL_XA_DATMAJ_437831#788059, COL_XA_CODUTI_437832#788060, COL_XA_CODPRO_437833#788061, COL_XA_COULSTD_437834#788062, COL_XA_COULEUR_437835#788063, COL_XA_FLMEDOBL_437836#788064, COL_XA_FLATSOBL_437837#788065, COL_XA_FLVALPLANIF_437838#788066, COL_XA_FLVALACCUEIL_437839#788067, COL_XA_NIVVCR_437840#788068, COL_XA_FLRTCCLQ_437841#788069, COL_XA_FLLABOCHAUD_437842#788070, COL_XA_DATEDE_437843#788071, COL_XA_DATEFI_437844#788072, COL_XA_FLGRPJOUR_437845#788073, COL_XA_PRIMAI_437846#788074, COL_XA_CODPROS_437847#788075, COL_XA_CODCONV_437848#788076, COL_XA_LATER_437849#788077, COL_XA_INCIDENCE_437850#788078, COL_XA_POSITION_437851#788079, COL_XA_FLGRVE_437852#788080, COL_XA_FLEXAINJ_437853#788081, COL_XA_CONTRAPAT_437854#788082, COL_XA_FLPRORE_437855#788083, COL_XA_FLCACHEINET_437856#788084, COL_XA_FLNOCOT_437857#788085, COL_XA_CODADM_437858#788086, COL_XA_FLGRVI_437859#788087, COL_XA_REGANAS_437860#788088, COL_XA_FLRECIST_437861#788089, COL_XA_FLNOCR_437862#788090, COL_XA_ICD_437863#788091, COL_XA_TYPE_ICD_437864#788092, COL_XA_FLRECIST_EC_437865#788093, COL_XA_CODLOINC_437866#788094, COL_ORIGINE_440144#788095]
Arguments: 1500
(7) Union
(8) CollectLimit
Input [48]: [COL_XA_CODEXA_437820#787904, COL_XA_LIB30_437821#787905, COL_XA_LIBUTI_437822#787906, COL_XA_TYPEXA_437823#787907, COL_XA_CONTRA_437824#787908, COL_XA_DURAVA_437825#787909, COL_XA_DURPEN_437826#787910, COL_XA_DURAPR_437827#787911, COL_XA_DURTOT_437828#787912, COL_XA_DURMED_437829#787913, COL_XA_PROTOC_437830#787914, COL_XA_DATMAJ_437831#787915, COL_XA_CODUTI_437832#787916, COL_XA_CODPRO_437833#787917, COL_XA_COULSTD_437834#787918, COL_XA_COULEUR_437835#787919, COL_XA_FLMEDOBL_437836#787920, COL_XA_FLATSOBL_437837#787921, COL_XA_FLVALPLANIF_437838#787922, COL_XA_FLVALACCUEIL_437839#787923, COL_XA_NIVVCR_437840#787924, COL_XA_FLRTCCLQ_437841#787925, COL_XA_FLLABOCHAUD_437842#787926, COL_XA_DATEDE_437843#787927, COL_XA_DATEFI_437844#787928, COL_XA_FLGRPJOUR_437845#787929, COL_XA_PRIMAI_437846#787930, COL_XA_CODPROS_437847#787931, COL_XA_CODCONV_437848#787932, COL_XA_LATER_437849#787933, COL_XA_INCIDENCE_437850#787934, COL_XA_POSITION_437851#787935, COL_XA_FLGRVE_437852#787936, COL_XA_FLEXAINJ_437853#787937, COL_XA_CONTRAPAT_437854#787938, COL_XA_FLPRORE_437855#787939, COL_XA_FLCACHEINET_437856#787940, COL_XA_FLNOCOT_437857#787941, COL_XA_CODADM_437858#787942, COL_XA_FLGRVI_437859#787943, COL_XA_REGANAS_437860#787944, COL_XA_FLRECIST_437861#787945, COL_XA_FLNOCR_437862#787946, COL_XA_ICD_437863#787947, COL_XA_TYPE_ICD_437864#787948, COL_XA_FLRECIST_EC_437865#787949, COL_XA_CODLOINC_437866#787950, COL_ORIGINE_440144#787951]
Arguments: 1500