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>Scan csv </b><br><br>number of output rows: 1,500<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 7.8 MiB"];
2->0;
3->2;
}
4
CollectLimit 1500
Project [hash_patient#4038 AS COL_1EA6961C_1A59_44F5_8376_9C40655D1D25#4299, hash_dossier#4039 AS COL_EE2FA615_AEF1_4417_80E1_055AD089CEF3#4300, sexe#4040 AS COL_98C3F04F_4DA2_4905_81E3_3EDAB5AE1D66#4301, age#4042 AS COL_DF169057_8856_44D9_9911_4EFC5790F9DF#4302, identifiant_examen_code_adicap#4043 AS COL_E51F3AEA_12C0_44B8_BCE9_50312A630440#4303, code_secteur#4044 AS COL_6B64A48F_D45F_4031_BE9B_ED483C3D212C#4304, code_analyse#4045 AS COL_1F62EE63_7A1D_4154_A537_D18AB8ACB0D5#4305, display_analyse#4046 AS COL_5B91570E_952F_41D6_B52B_331CD0D6F4CE#4306, code_adicap#4047 AS COL_341ED7B2_4493_4708_8EA7_2AC7086D19E1#4307, code_mode_prelevement#4048 AS COL_E273D6E4_7C3A_4604_A868_C0D92CD2C557#4308, display_mode_prelevement#4049 AS COL_C4C93C5D_A8CE_4557_B5B0_CECA1B8B7190#4309, code_type_technique#4050 AS COL_69BE8A2C_3A17_4B3D_BA18_0EC534D2087E#4310, display_type_technique#4051 AS COL_5F62C53A_2CE6_49EA_A5F3_A86904908190#4311, code_organe_appareil_region#4052 AS COL_6D49860E_15AB_463D_B55F_FBC2AA63E3B2#4312, display_appareil_organe_region#4053 AS COL_3FBB3FA3_3BF1_4DE5_9AEC_384A9E082B86#4313, code_pathologie#4054 AS COL_1142F40A_FA6A_4D32_A63E_DB91AF54CD1A#4314, display_pathologie#4055 AS COL_B01E2138_EA54_49CC_8B51_326590AF84C9#4315, batchtag#4056 AS COL_2FFC14B8_96F4_4289_8C73_CCC54B3E6945#4316, id_observation#4057 AS COL_F915FB27_4743_4562_A7F2_4ECEC4BCE282#4317, cast(date_prelevement#4041 as string) AS COL_463B4475_6A97_476E_AD48_9D5F5BD201ED#4318]
WholeStageCodegen (1)
FileScan csv [hash_patient#4038,hash_dossier#4039,sexe#4040,date_prelevement#4041,age#4042,identifiant_examen_code_adicap#4043,code_secteur#4044,code_analyse#4045,display_analyse#4046,code_adicap#4047,code_mode_prelevement#4048,display_mode_prelevement#4049,code_type_technique#4050,display_type_technique#4051,code_organe_appareil_region#4052,display_appareil_organe_region#4053,code_pathologie#4054,display_pathologie#4055,batchtag#4056,id_observation#4057] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/896BF8A6_A1AF_4A61_8C3D_F16266D0B..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<hash_patient:string,hash_dossier:string,sexe:string,date_prelevement:timestamp,age:int,ide...
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [20]: [hash_patient#4038, hash_dossier#4039, sexe#4040, date_prelevement#4041, age#4042, identifiant_examen_code_adicap#4043, code_secteur#4044, code_analyse#4045, display_analyse#4046, code_adicap#4047, code_mode_prelevement#4048, display_mode_prelevement#4049, code_type_technique#4050, display_type_technique#4051, code_organe_appareil_region#4052, display_appareil_organe_region#4053, code_pathologie#4054, display_pathologie#4055, batchtag#4056, id_observation#4057]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/896BF8A6_A1AF_4A61_8C3D_F16266D0BCCA/current/anapath.csv]
ReadSchema: struct<hash_patient:string,hash_dossier:string,sexe:string,date_prelevement:timestamp,age:int,identifiant_examen_code_adicap:string,code_secteur:string,code_analyse:string,display_analyse:string,code_adicap:string,code_mode_prelevement:string,display_mode_prelevement:string,code_type_technique:string,display_type_technique:string,code_organe_appareil_region:string,display_appareil_organe_region:string,code_pathologie:string,display_pathologie:string,batchtag:string,id_observation:string>
(2) Project [codegen id : 1]
Output [20]: [hash_patient#4038 AS COL_1EA6961C_1A59_44F5_8376_9C40655D1D25#4299, hash_dossier#4039 AS COL_EE2FA615_AEF1_4417_80E1_055AD089CEF3#4300, sexe#4040 AS COL_98C3F04F_4DA2_4905_81E3_3EDAB5AE1D66#4301, age#4042 AS COL_DF169057_8856_44D9_9911_4EFC5790F9DF#4302, identifiant_examen_code_adicap#4043 AS COL_E51F3AEA_12C0_44B8_BCE9_50312A630440#4303, code_secteur#4044 AS COL_6B64A48F_D45F_4031_BE9B_ED483C3D212C#4304, code_analyse#4045 AS COL_1F62EE63_7A1D_4154_A537_D18AB8ACB0D5#4305, display_analyse#4046 AS COL_5B91570E_952F_41D6_B52B_331CD0D6F4CE#4306, code_adicap#4047 AS COL_341ED7B2_4493_4708_8EA7_2AC7086D19E1#4307, code_mode_prelevement#4048 AS COL_E273D6E4_7C3A_4604_A868_C0D92CD2C557#4308, display_mode_prelevement#4049 AS COL_C4C93C5D_A8CE_4557_B5B0_CECA1B8B7190#4309, code_type_technique#4050 AS COL_69BE8A2C_3A17_4B3D_BA18_0EC534D2087E#4310, display_type_technique#4051 AS COL_5F62C53A_2CE6_49EA_A5F3_A86904908190#4311, code_organe_appareil_region#4052 AS COL_6D49860E_15AB_463D_B55F_FBC2AA63E3B2#4312, display_appareil_organe_region#4053 AS COL_3FBB3FA3_3BF1_4DE5_9AEC_384A9E082B86#4313, code_pathologie#4054 AS COL_1142F40A_FA6A_4D32_A63E_DB91AF54CD1A#4314, display_pathologie#4055 AS COL_B01E2138_EA54_49CC_8B51_326590AF84C9#4315, batchtag#4056 AS COL_2FFC14B8_96F4_4289_8C73_CCC54B3E6945#4316, id_observation#4057 AS COL_F915FB27_4743_4562_A7F2_4ECEC4BCE282#4317, cast(date_prelevement#4041 as string) AS COL_463B4475_6A97_476E_AD48_9D5F5BD201ED#4318]
Input [20]: [hash_patient#4038, hash_dossier#4039, sexe#4040, date_prelevement#4041, age#4042, identifiant_examen_code_adicap#4043, code_secteur#4044, code_analyse#4045, display_analyse#4046, code_adicap#4047, code_mode_prelevement#4048, display_mode_prelevement#4049, code_type_technique#4050, display_type_technique#4051, code_organe_appareil_region#4052, display_appareil_organe_region#4053, code_pathologie#4054, display_pathologie#4055, batchtag#4056, id_observation#4057]
(3) CollectLimit
Input [20]: [COL_1EA6961C_1A59_44F5_8376_9C40655D1D25#4299, COL_EE2FA615_AEF1_4417_80E1_055AD089CEF3#4300, COL_98C3F04F_4DA2_4905_81E3_3EDAB5AE1D66#4301, COL_DF169057_8856_44D9_9911_4EFC5790F9DF#4302, COL_E51F3AEA_12C0_44B8_BCE9_50312A630440#4303, COL_6B64A48F_D45F_4031_BE9B_ED483C3D212C#4304, COL_1F62EE63_7A1D_4154_A537_D18AB8ACB0D5#4305, COL_5B91570E_952F_41D6_B52B_331CD0D6F4CE#4306, COL_341ED7B2_4493_4708_8EA7_2AC7086D19E1#4307, COL_E273D6E4_7C3A_4604_A868_C0D92CD2C557#4308, COL_C4C93C5D_A8CE_4557_B5B0_CECA1B8B7190#4309, COL_69BE8A2C_3A17_4B3D_BA18_0EC534D2087E#4310, COL_5F62C53A_2CE6_49EA_A5F3_A86904908190#4311, COL_6D49860E_15AB_463D_B55F_FBC2AA63E3B2#4312, COL_3FBB3FA3_3BF1_4DE5_9AEC_384A9E082B86#4313, COL_1142F40A_FA6A_4D32_A63E_DB91AF54CD1A#4314, COL_B01E2138_EA54_49CC_8B51_326590AF84C9#4315, COL_2FFC14B8_96F4_4289_8C73_CCC54B3E6945#4316, COL_F915FB27_4743_4562_A7F2_4ECEC4BCE282#4317, COL_463B4475_6A97_476E_AD48_9D5F5BD201ED#4318]
Arguments: 1500