digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 4,096<br>number of input batches: 1"];
}
4 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 17 ms<br>metadata time: 0 ms<br>size of files read: 1358.1 KiB<br>number of output rows: 4,096"];
2->0;
3->2;
4->3;
}
5
CollectLimit 1500
Project [NJ_NUMPER_437940#207374 AS COL_NJ_NUMPER_437940#207614, NJ_SIGMA_437941#207378 AS COL_NJ_SIGMA_437941#207615, NJ_NUMDOS_437942#207372 AS COL_NJ_NUMDOS_437942#207616, NJ_CODSER_437943#207357 AS COL_NJ_CODSER_437943#207617, NJ_CODUFL_437944#207358 AS COL_NJ_CODUFL_437944#207618, NJ_DATEDE_437945#207361 AS COL_NJ_DATEDE_437945#207619, NJ_DATEFI_437946#207362 AS COL_NJ_DATEFI_437946#207620, NJ_CODUTI_437947#207359 AS COL_NJ_CODUTI_437947#207621, NJ_DATMAJ_437948#207363 AS COL_NJ_DATMAJ_437948#207622, NJ_DATCRE_437949#207360 AS COL_NJ_DATCRE_437949#207623, NJ_NATURE_437950#207370 AS COL_NJ_NATURE_437950#207624, NJ_HEUDEB_437951#207365 AS COL_NJ_HEUDEB_437951#207625, NJ_HEUFIN_437952#207366 AS COL_NJ_HEUFIN_437952#207626, NJ_NUMCHA_437953#207371 AS COL_NJ_NUMCHA_437953#207627, NJ_CODIPS_437954#207356 AS COL_NJ_CODIPS_437954#207628, NJ_DATMVT_437955#207364 AS COL_NJ_DATMVT_437955#207629, NJ_HEUMVT_437956#207367 AS COL_NJ_HEUMVT_437956#207630, NJ_OLDCODSER_437957#207376 AS COL_NJ_OLDCODSER_437957#207631, NJ_OLDCODUFL_437958#207377 AS COL_NJ_OLDCODUFL_437958#207632, NJ_NUMLIT_437959#207373 AS COL_NJ_NUMLIT_437959#207633, NJ_CLASSE_437960#207354 AS COL_NJ_CLASSE_437960#207634, NJ_NUMPER_ORI_437961#207375 AS COL_NJ_NUMPER_ORI_437961#207635, NJ_TYPORG_437962#207380 AS COL_NJ_TYPORG_437962#207636, NJ_NATASS_437963#207369 AS COL_NJ_NATASS_437963#207637, ... 5 more fields]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [NJ_ALTVISITID_437968#207353,NJ_CLASSE_437960#207354,NJ_CODICD_437964#207355,NJ_CODIPS_437954#207356,NJ_CODSER_437943#207357,NJ_CODUFL_437944#207358,NJ_CODUTI_437947#207359,NJ_DATCRE_437949#207360,NJ_DATEDE_437945#207361,NJ_DATEFI_437946#207362,NJ_DATMAJ_437948#207363,NJ_DATMVT_437955#207364,NJ_HEUDEB_437951#207365,NJ_HEUFIN_437952#207366,NJ_HEUMVT_437956#207367,NJ_MOTIFHOSP_437965#207368,NJ_NATASS_437963#207369,NJ_NATURE_437950#207370,NJ_NUMCHA_437953#207371,NJ_NUMDOS_437942#207372,NJ_NUMLIT_437959#207373,NJ_NUMPER_437940#207374,NJ_NUMPER_ORI_437961#207375,NJ_OLDCODSER_437957#207376,... 5 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_NUMSEJ_437939], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<NJ_ALTVISITID_437968:string,NJ_CLASSE_437960:string,NJ_CODICD_437964:string,NJ_CODIPS_4379...
== Physical Plan ==
CollectLimit (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [29]: [NJ_ALTVISITID_437968#207353, NJ_CLASSE_437960#207354, NJ_CODICD_437964#207355, NJ_CODIPS_437954#207356, NJ_CODSER_437943#207357, NJ_CODUFL_437944#207358, NJ_CODUTI_437947#207359, NJ_DATCRE_437949#207360, NJ_DATEDE_437945#207361, NJ_DATEFI_437946#207362, NJ_DATMAJ_437948#207363, NJ_DATMVT_437955#207364, NJ_HEUDEB_437951#207365, NJ_HEUFIN_437952#207366, NJ_HEUMVT_437956#207367, NJ_MOTIFHOSP_437965#207368, NJ_NATASS_437963#207369, NJ_NATURE_437950#207370, NJ_NUMCHA_437953#207371, NJ_NUMDOS_437942#207372, NJ_NUMLIT_437959#207373, NJ_NUMPER_437940#207374, NJ_NUMPER_ORI_437961#207375, NJ_OLDCODSER_437957#207376, NJ_OLDCODUFL_437958#207377, NJ_SIGMA_437941#207378, NJ_TYPE_ICD_437966#207379, NJ_TYPORG_437962#207380, NJ_VER_ICD_437967#207381]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_NUMSEJ_437939]
ReadSchema: struct<NJ_ALTVISITID_437968:string,NJ_CLASSE_437960:string,NJ_CODICD_437964:string,NJ_CODIPS_437954:string,NJ_CODSER_437943:string,NJ_CODUFL_437944:string,NJ_CODUTI_437947:string,NJ_DATCRE_437949:string,NJ_DATEDE_437945:string,NJ_DATEFI_437946:string,NJ_DATMAJ_437948:string,NJ_DATMVT_437955:string,NJ_HEUDEB_437951:string,NJ_HEUFIN_437952:string,NJ_HEUMVT_437956:string,NJ_MOTIFHOSP_437965:string,NJ_NATASS_437963:string,NJ_NATURE_437950:string,NJ_NUMCHA_437953:string,NJ_NUMDOS_437942:string,NJ_NUMLIT_437959:string,NJ_NUMPER_437940:string,NJ_NUMPER_ORI_437961:string,NJ_OLDCODSER_437957:string,NJ_OLDCODUFL_437958:string,NJ_SIGMA_437941:string,NJ_TYPE_ICD_437966:string,NJ_TYPORG_437962:string,NJ_VER_ICD_437967:string>
(2) ColumnarToRow [codegen id : 1]
Input [29]: [NJ_ALTVISITID_437968#207353, NJ_CLASSE_437960#207354, NJ_CODICD_437964#207355, NJ_CODIPS_437954#207356, NJ_CODSER_437943#207357, NJ_CODUFL_437944#207358, NJ_CODUTI_437947#207359, NJ_DATCRE_437949#207360, NJ_DATEDE_437945#207361, NJ_DATEFI_437946#207362, NJ_DATMAJ_437948#207363, NJ_DATMVT_437955#207364, NJ_HEUDEB_437951#207365, NJ_HEUFIN_437952#207366, NJ_HEUMVT_437956#207367, NJ_MOTIFHOSP_437965#207368, NJ_NATASS_437963#207369, NJ_NATURE_437950#207370, NJ_NUMCHA_437953#207371, NJ_NUMDOS_437942#207372, NJ_NUMLIT_437959#207373, NJ_NUMPER_437940#207374, NJ_NUMPER_ORI_437961#207375, NJ_OLDCODSER_437957#207376, NJ_OLDCODUFL_437958#207377, NJ_SIGMA_437941#207378, NJ_TYPE_ICD_437966#207379, NJ_TYPORG_437962#207380, NJ_VER_ICD_437967#207381]
(3) Project [codegen id : 1]
Output [29]: [NJ_NUMPER_437940#207374 AS COL_NJ_NUMPER_437940#207614, NJ_SIGMA_437941#207378 AS COL_NJ_SIGMA_437941#207615, NJ_NUMDOS_437942#207372 AS COL_NJ_NUMDOS_437942#207616, NJ_CODSER_437943#207357 AS COL_NJ_CODSER_437943#207617, NJ_CODUFL_437944#207358 AS COL_NJ_CODUFL_437944#207618, NJ_DATEDE_437945#207361 AS COL_NJ_DATEDE_437945#207619, NJ_DATEFI_437946#207362 AS COL_NJ_DATEFI_437946#207620, NJ_CODUTI_437947#207359 AS COL_NJ_CODUTI_437947#207621, NJ_DATMAJ_437948#207363 AS COL_NJ_DATMAJ_437948#207622, NJ_DATCRE_437949#207360 AS COL_NJ_DATCRE_437949#207623, NJ_NATURE_437950#207370 AS COL_NJ_NATURE_437950#207624, NJ_HEUDEB_437951#207365 AS COL_NJ_HEUDEB_437951#207625, NJ_HEUFIN_437952#207366 AS COL_NJ_HEUFIN_437952#207626, NJ_NUMCHA_437953#207371 AS COL_NJ_NUMCHA_437953#207627, NJ_CODIPS_437954#207356 AS COL_NJ_CODIPS_437954#207628, NJ_DATMVT_437955#207364 AS COL_NJ_DATMVT_437955#207629, NJ_HEUMVT_437956#207367 AS COL_NJ_HEUMVT_437956#207630, NJ_OLDCODSER_437957#207376 AS COL_NJ_OLDCODSER_437957#207631, NJ_OLDCODUFL_437958#207377 AS COL_NJ_OLDCODUFL_437958#207632, NJ_NUMLIT_437959#207373 AS COL_NJ_NUMLIT_437959#207633, NJ_CLASSE_437960#207354 AS COL_NJ_CLASSE_437960#207634, NJ_NUMPER_ORI_437961#207375 AS COL_NJ_NUMPER_ORI_437961#207635, NJ_TYPORG_437962#207380 AS COL_NJ_TYPORG_437962#207636, NJ_NATASS_437963#207369 AS COL_NJ_NATASS_437963#207637, NJ_CODICD_437964#207355 AS COL_NJ_CODICD_437964#207638, NJ_MOTIFHOSP_437965#207368 AS COL_NJ_MOTIFHOSP_437965#207639, NJ_TYPE_ICD_437966#207379 AS COL_NJ_TYPE_ICD_437966#207640, NJ_VER_ICD_437967#207381 AS COL_NJ_VER_ICD_437967#207641, NJ_ALTVISITID_437968#207353 AS COL_NJ_ALTVISITID_437968#207642]
Input [29]: [NJ_ALTVISITID_437968#207353, NJ_CLASSE_437960#207354, NJ_CODICD_437964#207355, NJ_CODIPS_437954#207356, NJ_CODSER_437943#207357, NJ_CODUFL_437944#207358, NJ_CODUTI_437947#207359, NJ_DATCRE_437949#207360, NJ_DATEDE_437945#207361, NJ_DATEFI_437946#207362, NJ_DATMAJ_437948#207363, NJ_DATMVT_437955#207364, NJ_HEUDEB_437951#207365, NJ_HEUFIN_437952#207366, NJ_HEUMVT_437956#207367, NJ_MOTIFHOSP_437965#207368, NJ_NATASS_437963#207369, NJ_NATURE_437950#207370, NJ_NUMCHA_437953#207371, NJ_NUMDOS_437942#207372, NJ_NUMLIT_437959#207373, NJ_NUMPER_437940#207374, NJ_NUMPER_ORI_437961#207375, NJ_OLDCODSER_437957#207376, NJ_OLDCODUFL_437958#207377, NJ_SIGMA_437941#207378, NJ_TYPE_ICD_437966#207379, NJ_TYPORG_437962#207380, NJ_VER_ICD_437967#207381]
(4) CollectLimit
Input [29]: [COL_NJ_NUMPER_437940#207614, COL_NJ_SIGMA_437941#207615, COL_NJ_NUMDOS_437942#207616, COL_NJ_CODSER_437943#207617, COL_NJ_CODUFL_437944#207618, COL_NJ_DATEDE_437945#207619, COL_NJ_DATEFI_437946#207620, COL_NJ_CODUTI_437947#207621, COL_NJ_DATMAJ_437948#207622, COL_NJ_DATCRE_437949#207623, COL_NJ_NATURE_437950#207624, COL_NJ_HEUDEB_437951#207625, COL_NJ_HEUFIN_437952#207626, COL_NJ_NUMCHA_437953#207627, COL_NJ_CODIPS_437954#207628, COL_NJ_DATMVT_437955#207629, COL_NJ_HEUMVT_437956#207630, COL_NJ_OLDCODSER_437957#207631, COL_NJ_OLDCODUFL_437958#207632, COL_NJ_NUMLIT_437959#207633, COL_NJ_CLASSE_437960#207634, COL_NJ_NUMPER_ORI_437961#207635, COL_NJ_TYPORG_437962#207636, COL_NJ_NATASS_437963#207637, COL_NJ_CODICD_437964#207638, COL_NJ_MOTIFHOSP_437965#207639, COL_NJ_TYPE_ICD_437966#207640, COL_NJ_VER_ICD_437967#207641, COL_NJ_ALTVISITID_437968#207642]
Arguments: 1500