digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 101 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"VISIT_ID\", \"PATIENT_ID\", \"ID_SEJ\", \"ID_PAT\", \"IN_DATE\", \"OUT_DATE\", \"IN_MODE\", \"OUT_MODE\", \"IN_UNIT\", \"OUT_UNIT\", \"VISIT_TYPE\", \"CHAMP_PMSI\", \"UNIT_PATH\", \"EMERGENCY\", \"CANCELED\" FROM \"DTM_261\".\"VISIT\") x) [numPartitions=1] </b><br><br>number of output rows: 82"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [null AS COL_VISIT_ID_2942#616, null AS COL_PATIENT_ID_2943#617, cast(ID_SEJ#226 as int) AS COL_ID_SEJ_2944#621, cast(ID_PAT#227 as int) AS COL_ID_PAT_2945#623, IN_DATE#228 AS COL_IN_DATE_2946#625, OUT_DATE#229 AS COL_OUT_DATE_2947#627, IN_MODE#230 AS COL_IN_MODE_2948#628, OUT_MODE#231 AS COL_OUT_MODE_2949#630, IN_UNIT#232 AS COL_IN_UNIT_2950#632, OUT_UNIT#233 AS COL_OUT_UNIT_2951#634, VISIT_TYPE#234 AS COL_VISIT_TYPE_2952#636, CHAMP_PMSI#235 AS COL_CHAMP_PMSI_2953#638, UNIT_PATH#236 AS COL_UNIT_PATH_2954#640, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#237, 1, true, false, true) AS COL_EMERGENCY_2955#642, cast(CANCELED#238 as int) AS COL_CANCELED_2956#644]
Scan JDBCRelation((SELECT "VISIT_ID", "PATIENT_ID", "ID_SEJ", "ID_PAT", "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_261"."VISIT") x) [numPartitions=1] [ID_SEJ#226,ID_PAT#227,IN_DATE#228,OUT_DATE#229,IN_MODE#230,OUT_MODE#231,IN_UNIT#232,OUT_UNIT#233,VISIT_TYPE#234,CHAMP_PMSI#235,UNIT_PATH#236,EMERGENCY#237,CANCELED#238] PushedFilters: [], ReadSchema: struct<ID_SEJ:decimal(38,0),ID_PAT:decimal(38,0),IN_DATE:timestamp,OUT_DATE:timestamp,IN_MODE:str...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "VISIT_ID", "PATIENT_ID", "ID_SEJ", "ID_PAT", "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_261"."VISIT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT "VISIT_ID", "PATIENT_ID", "ID_SEJ", "ID_PAT", "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_261"."VISIT") x) [numPartitions=1] [codegen id : 1]
Output [13]: [ID_SEJ#226, ID_PAT#227, IN_DATE#228, OUT_DATE#229, IN_MODE#230, OUT_MODE#231, IN_UNIT#232, OUT_UNIT#233, VISIT_TYPE#234, CHAMP_PMSI#235, UNIT_PATH#236, EMERGENCY#237, CANCELED#238]
ReadSchema: struct<ID_SEJ:decimal(38,0),ID_PAT:decimal(38,0),IN_DATE:timestamp,OUT_DATE:timestamp,IN_MODE:string,OUT_MODE:string,IN_UNIT:string,OUT_UNIT:string,VISIT_TYPE:string,CHAMP_PMSI:string,UNIT_PATH:string,EMERGENCY:string,CANCELED:decimal(1,0)>
(2) Project [codegen id : 1]
Output [15]: [null AS COL_VISIT_ID_2942#616, null AS COL_PATIENT_ID_2943#617, cast(ID_SEJ#226 as int) AS COL_ID_SEJ_2944#621, cast(ID_PAT#227 as int) AS COL_ID_PAT_2945#623, IN_DATE#228 AS COL_IN_DATE_2946#625, OUT_DATE#229 AS COL_OUT_DATE_2947#627, IN_MODE#230 AS COL_IN_MODE_2948#628, OUT_MODE#231 AS COL_OUT_MODE_2949#630, IN_UNIT#232 AS COL_IN_UNIT_2950#632, OUT_UNIT#233 AS COL_OUT_UNIT_2951#634, VISIT_TYPE#234 AS COL_VISIT_TYPE_2952#636, CHAMP_PMSI#235 AS COL_CHAMP_PMSI_2953#638, UNIT_PATH#236 AS COL_UNIT_PATH_2954#640, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#237, 1, true, false, true) AS COL_EMERGENCY_2955#642, cast(CANCELED#238 as int) AS COL_CANCELED_2956#644]
Input [13]: [ID_SEJ#226, ID_PAT#227, IN_DATE#228, OUT_DATE#229, IN_MODE#230, OUT_MODE#231, IN_UNIT#232, OUT_UNIT#233, VISIT_TYPE#234, CHAMP_PMSI#235, UNIT_PATH#236, EMERGENCY#237, CANCELED#238]
(3) CollectLimit
Input [15]: [COL_VISIT_ID_2942#616, COL_PATIENT_ID_2943#617, COL_ID_SEJ_2944#621, COL_ID_PAT_2945#623, COL_IN_DATE_2946#625, COL_OUT_DATE_2947#627, COL_IN_MODE_2948#628, COL_OUT_MODE_2949#630, COL_IN_UNIT_2950#632, COL_OUT_UNIT_2951#634, COL_VISIT_TYPE_2952#636, COL_CHAMP_PMSI_2953#638, COL_UNIT_PATH_2954#640, COL_EMERGENCY_2955#642, COL_CANCELED_2956#644]
Arguments: 1500