digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 19 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 270<br>number of input batches: 1"];
}
4 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 18 ms<br>metadata time: 0 ms<br>size of files read: 40.1 KiB<br>number of output rows: 270"];
2->0;
3->2;
4->3;
}
5
CollectLimit 500000
Project [COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A#797750 AS COL_E561DB98_91EF_4814_AF84_72ACBDC3945F#797888, COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC#797754 AS COL_48B7874C_E712_4F01_8E41_13A571F0B85B#797889, COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB#797755 AS COL_559621F1_4F89_4B23_9E69_E8D51C9B949E#797890, COL_5EE3A91A_15E1_478C_96C6_FE8860546617#797757 AS COL_325CCFFB_220B_4040_899E_FCD448EFDF49#797891, COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6#797756 AS COL_D4FA91FD_02CB_4C77_94E0_F74F1E250F79#797892, COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99#797749 AS COL_0FCADFF6_ACFA_41E0_A844_B81F7A3F05DA#797893, COL_4432BEBD_9A87_4E85_B626_47557CA2E70F#797759 AS COL_75726B2C_4FAA_4EE6_A57C_F0F6A5589E77#797894, COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F#797760 AS COL_F345E13E_D591_4F0A_9B8F_6B6F9D394DCC#797895, COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B#797764 AS COL_59063A94_8C05_4FBE_BD69_A7ADCAD37E07#797896, COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A#797765 AS COL_6E443F37_E2BC_4FF3_AB1E_F29E4CBED3C9#797897, COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E#797766 AS COL_7AF5BDAB_1143_4D40_BF26_6C5D1160C6BB#797898, COL_A3617909_D01B_472C_B4A2_C6540D59ECDC#797769 AS COL_C70F8647_1C86_4F94_9CEB_C254DABB747C#797899, COL_450EE4A7_2FAF_452A_A562_90217D16F93D#797762 AS COL_935E2187_8D36_4996_BC4E_BF85348B4D68#797900, COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1#797763 AS COL_A09E9579_7B25_4A2E_BBA0_C9E8B5D93201#797901]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99#797749,COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A#797750,COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC#797754,COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB#797755,COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6#797756,COL_5EE3A91A_15E1_478C_96C6_FE8860546617#797757,COL_4432BEBD_9A87_4E85_B626_47557CA2E70F#797759,COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F#797760,COL_450EE4A7_2FAF_452A_A562_90217D16F93D#797762,COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1#797763,COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B#797764,COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A#797765,COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E#797766,COL_A3617909_D01B_472C_B4A2_C6540D59ECDC#797769] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/LES_CONNECTEURS_326363], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99:string,COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A:i...
== Physical Plan ==
CollectLimit (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [14]: [COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99#797749, COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A#797750, COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC#797754, COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB#797755, COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6#797756, COL_5EE3A91A_15E1_478C_96C6_FE8860546617#797757, COL_4432BEBD_9A87_4E85_B626_47557CA2E70F#797759, COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F#797760, COL_450EE4A7_2FAF_452A_A562_90217D16F93D#797762, COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1#797763, COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B#797764, COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A#797765, COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E#797766, COL_A3617909_D01B_472C_B4A2_C6540D59ECDC#797769]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/LES_CONNECTEURS_326363]
ReadSchema: struct<COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99:string,COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A:int,COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC:string,COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB:string,COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6:string,COL_5EE3A91A_15E1_478C_96C6_FE8860546617:string,COL_4432BEBD_9A87_4E85_B626_47557CA2E70F:array<string>,COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F:int,COL_450EE4A7_2FAF_452A_A562_90217D16F93D:timestamp,COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1:timestamp,COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B:string,COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A:string,COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E:string,COL_A3617909_D01B_472C_B4A2_C6540D59ECDC:string>
(2) ColumnarToRow [codegen id : 1]
Input [14]: [COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99#797749, COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A#797750, COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC#797754, COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB#797755, COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6#797756, COL_5EE3A91A_15E1_478C_96C6_FE8860546617#797757, COL_4432BEBD_9A87_4E85_B626_47557CA2E70F#797759, COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F#797760, COL_450EE4A7_2FAF_452A_A562_90217D16F93D#797762, COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1#797763, COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B#797764, COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A#797765, COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E#797766, COL_A3617909_D01B_472C_B4A2_C6540D59ECDC#797769]
(3) Project [codegen id : 1]
Output [14]: [COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A#797750 AS COL_E561DB98_91EF_4814_AF84_72ACBDC3945F#797888, COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC#797754 AS COL_48B7874C_E712_4F01_8E41_13A571F0B85B#797889, COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB#797755 AS COL_559621F1_4F89_4B23_9E69_E8D51C9B949E#797890, COL_5EE3A91A_15E1_478C_96C6_FE8860546617#797757 AS COL_325CCFFB_220B_4040_899E_FCD448EFDF49#797891, COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6#797756 AS COL_D4FA91FD_02CB_4C77_94E0_F74F1E250F79#797892, COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99#797749 AS COL_0FCADFF6_ACFA_41E0_A844_B81F7A3F05DA#797893, COL_4432BEBD_9A87_4E85_B626_47557CA2E70F#797759 AS COL_75726B2C_4FAA_4EE6_A57C_F0F6A5589E77#797894, COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F#797760 AS COL_F345E13E_D591_4F0A_9B8F_6B6F9D394DCC#797895, COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B#797764 AS COL_59063A94_8C05_4FBE_BD69_A7ADCAD37E07#797896, COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A#797765 AS COL_6E443F37_E2BC_4FF3_AB1E_F29E4CBED3C9#797897, COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E#797766 AS COL_7AF5BDAB_1143_4D40_BF26_6C5D1160C6BB#797898, COL_A3617909_D01B_472C_B4A2_C6540D59ECDC#797769 AS COL_C70F8647_1C86_4F94_9CEB_C254DABB747C#797899, COL_450EE4A7_2FAF_452A_A562_90217D16F93D#797762 AS COL_935E2187_8D36_4996_BC4E_BF85348B4D68#797900, COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1#797763 AS COL_A09E9579_7B25_4A2E_BBA0_C9E8B5D93201#797901]
Input [14]: [COL_2F916C3F_171D_4DCE_BCD1_8AA269972E99#797749, COL_0628DD51_B2C5_40B2_8CDB_AED565E5E21A#797750, COL_BFCBC5B0_CBA1_49C3_942E_15B32D516ABC#797754, COL_FA199C59_AE12_481F_BFA5_7C02E70FC9BB#797755, COL_426E84B0_45C3_44E6_89B8_67D2AE7C12E6#797756, COL_5EE3A91A_15E1_478C_96C6_FE8860546617#797757, COL_4432BEBD_9A87_4E85_B626_47557CA2E70F#797759, COL_272B5939_66F0_4475_88E2_5C5DBEA92D1F#797760, COL_450EE4A7_2FAF_452A_A562_90217D16F93D#797762, COL_6DCB9294_2142_47B9_ACBF_FB8B9BE0A0A1#797763, COL_A5E189F7_7D4B_4DC4_B4A1_0C10407C663B#797764, COL_642DD1C9_F1DE_46DD_812A_31A9BA57084A#797765, COL_A74C8205_613D_4248_9FAA_9DD643C5BE9E#797766, COL_A3617909_D01B_472C_B4A2_C6540D59ECDC#797769]
(4) CollectLimit
Input [14]: [COL_E561DB98_91EF_4814_AF84_72ACBDC3945F#797888, COL_48B7874C_E712_4F01_8E41_13A571F0B85B#797889, COL_559621F1_4F89_4B23_9E69_E8D51C9B949E#797890, COL_325CCFFB_220B_4040_899E_FCD448EFDF49#797891, COL_D4FA91FD_02CB_4C77_94E0_F74F1E250F79#797892, COL_0FCADFF6_ACFA_41E0_A844_B81F7A3F05DA#797893, COL_75726B2C_4FAA_4EE6_A57C_F0F6A5589E77#797894, COL_F345E13E_D591_4F0A_9B8F_6B6F9D394DCC#797895, COL_59063A94_8C05_4FBE_BD69_A7ADCAD37E07#797896, COL_6E443F37_E2BC_4FF3_AB1E_F29E4CBED3C9#797897, COL_7AF5BDAB_1143_4D40_BF26_6C5D1160C6BB#797898, COL_C70F8647_1C86_4F94_9CEB_C254DABB747C#797899, COL_935E2187_8D36_4996_BC4E_BF85348B4D68#797900, COL_A09E9579_7B25_4A2E_BBA0_C9E8B5D93201#797901]
Arguments: 500000