digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 102 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), \"IN_DATE\", \"OUT_DATE\", \"IN_MODE\", \"OUT_MODE\", \"IN_UNIT\", \"OUT_UNIT\", \"VISIT_TYPE\", \"CHAMP_PMSI\", \"UNIT_PATH\", \"EMERGENCY\", \"CANCELED\" FROM \"DTM_622\".\"VISIT\") x) [numPartitions=1] </b><br><br>number of output rows: 717"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [RAWTOHEX(VISIT_ID)#114684 AS COL_E7A10ED9_1790_4719_B1B6_FAA15D035CB8#114873, RAWTOHEX(PATIENT_ID)#114685 AS COL_250578DF_CAD1_40F3_8EF7_09E99AC843A0#114874, IN_DATE#114686 AS COL_1118E418_5410_4DE3_B805_4EDAFDD340EA#114875, OUT_DATE#114687 AS COL_5E4B938E_4D5C_4C99_842D_1433A793DC2F#114876, IN_MODE#114688 AS COL_8533859E_CA0E_4D74_9588_09E146E29F8F#114877, OUT_MODE#114689 AS COL_BE46E6B4_0114_49AE_A1A6_E69C87926E43#114878, IN_UNIT#114690 AS COL_ACB9EBCB_0C1E_40E3_A99A_4BF5582EA889#114879, OUT_UNIT#114691 AS COL_C2552693_5E75_4DD5_9F1B_0E8D69029131#114880, VISIT_TYPE#114692 AS COL_4492D92E_39F3_4726_8168_27A2C89197CD#114881, CHAMP_PMSI#114693 AS COL_216F1184_233D_4FD2_8517_CD7A5EEC298B#114882, UNIT_PATH#114694 AS COL_32E4B9FB_0DD4_4A55_8C75_7141B3933E86#114883, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#114695, 1, true, false, true) AS COL_A5718A42_16D9_4FB5_AF83_FBC6343B541E#114884, cast(CANCELED#114696 as int) AS COL_68D82A2A_6C78_4416_9D7D_02E747AEA1D0#114885, str_encrypt(RAWTOHEX(VISIT_ID)#114684) AS COL_C58C9484_03D4_4E8C_B4E5_78EC80E6265B#114886]
Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1] [RAWTOHEX(VISIT_ID)#114684,RAWTOHEX(PATIENT_ID)#114685,IN_DATE#114686,OUT_DATE#114687,IN_MODE#114688,OUT_MODE#114689,IN_UNIT#114690,OUT_UNIT#114691,VISIT_TYPE#114692,CHAMP_PMSI#114693,UNIT_PATH#114694,EMERGENCY#114695,CANCELED#114696] PushedFilters: [], ReadSchema: struct<RAWTOHEX(VISIT_ID):string,RAWTOHEX(PATIENT_ID):string,IN_DATE:timestamp,OUT_DATE:timestamp...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1] [codegen id : 1]
Output [13]: [RAWTOHEX(VISIT_ID)#114684, RAWTOHEX(PATIENT_ID)#114685, IN_DATE#114686, OUT_DATE#114687, IN_MODE#114688, OUT_MODE#114689, IN_UNIT#114690, OUT_UNIT#114691, VISIT_TYPE#114692, CHAMP_PMSI#114693, UNIT_PATH#114694, EMERGENCY#114695, CANCELED#114696]
ReadSchema: struct<RAWTOHEX(VISIT_ID):string,RAWTOHEX(PATIENT_ID):string,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 [14]: [RAWTOHEX(VISIT_ID)#114684 AS COL_E7A10ED9_1790_4719_B1B6_FAA15D035CB8#114873, RAWTOHEX(PATIENT_ID)#114685 AS COL_250578DF_CAD1_40F3_8EF7_09E99AC843A0#114874, IN_DATE#114686 AS COL_1118E418_5410_4DE3_B805_4EDAFDD340EA#114875, OUT_DATE#114687 AS COL_5E4B938E_4D5C_4C99_842D_1433A793DC2F#114876, IN_MODE#114688 AS COL_8533859E_CA0E_4D74_9588_09E146E29F8F#114877, OUT_MODE#114689 AS COL_BE46E6B4_0114_49AE_A1A6_E69C87926E43#114878, IN_UNIT#114690 AS COL_ACB9EBCB_0C1E_40E3_A99A_4BF5582EA889#114879, OUT_UNIT#114691 AS COL_C2552693_5E75_4DD5_9F1B_0E8D69029131#114880, VISIT_TYPE#114692 AS COL_4492D92E_39F3_4726_8168_27A2C89197CD#114881, CHAMP_PMSI#114693 AS COL_216F1184_233D_4FD2_8517_CD7A5EEC298B#114882, UNIT_PATH#114694 AS COL_32E4B9FB_0DD4_4A55_8C75_7141B3933E86#114883, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#114695, 1, true, false, true) AS COL_A5718A42_16D9_4FB5_AF83_FBC6343B541E#114884, cast(CANCELED#114696 as int) AS COL_68D82A2A_6C78_4416_9D7D_02E747AEA1D0#114885, str_encrypt(RAWTOHEX(VISIT_ID)#114684) AS COL_C58C9484_03D4_4E8C_B4E5_78EC80E6265B#114886]
Input [13]: [RAWTOHEX(VISIT_ID)#114684, RAWTOHEX(PATIENT_ID)#114685, IN_DATE#114686, OUT_DATE#114687, IN_MODE#114688, OUT_MODE#114689, IN_UNIT#114690, OUT_UNIT#114691, VISIT_TYPE#114692, CHAMP_PMSI#114693, UNIT_PATH#114694, EMERGENCY#114695, CANCELED#114696]
(3) CollectLimit
Input [14]: [COL_E7A10ED9_1790_4719_B1B6_FAA15D035CB8#114873, COL_250578DF_CAD1_40F3_8EF7_09E99AC843A0#114874, COL_1118E418_5410_4DE3_B805_4EDAFDD340EA#114875, COL_5E4B938E_4D5C_4C99_842D_1433A793DC2F#114876, COL_8533859E_CA0E_4D74_9588_09E146E29F8F#114877, COL_BE46E6B4_0114_49AE_A1A6_E69C87926E43#114878, COL_ACB9EBCB_0C1E_40E3_A99A_4BF5582EA889#114879, COL_C2552693_5E75_4DD5_9F1B_0E8D69029131#114880, COL_4492D92E_39F3_4726_8168_27A2C89197CD#114881, COL_216F1184_233D_4FD2_8517_CD7A5EEC298B#114882, COL_32E4B9FB_0DD4_4A55_8C75_7141B3933E86#114883, COL_A5718A42_16D9_4FB5_AF83_FBC6343B541E#114884, COL_68D82A2A_6C78_4416_9D7D_02E747AEA1D0#114885, COL_C58C9484_03D4_4E8C_B4E5_78EC80E6265B#114886]
Arguments: 1500