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: 4.9 MiB"];
2->0;
3->2;
}
4
CollectLimit 1500
Project [code_commune#335325 AS COL_62EC3C52_A8FC_44B0_8E2D_1CE4E3D39DD5#335560, nom_commune#335326 AS COL_B1B79BE3_286E_4D46_BF1B_67BE13E0E736#335561, code_arrondissement#335327 AS COL_272F124F_C055_4DF8_8A83_08E09093E3F2#335562, nom_arrondissement#335328 AS COL_DFAF51CB_557A_4CD1_936F_1EC748922F10#335563, code_departement#335329 AS COL_31D51564_C738_498A_976D_243A2FEDA252#335564, nom_departement#335330 AS COL_F3822469_3330_459B_AA8A_59D5C2D45247#335565, code_epci#335331 AS COL_B4645486_AE76_4E98_96C5_0DC4EECAB5DA#335566, nom_epci#335332 AS COL_9C648EB3_D3EE_4C68_B5B3_5E556491577D#335567, code_region#335333 AS COL_0EFEF1A8_486D_48F1_9788_CA57921CDB6D#335568, nom_region#335334 AS COL_9F47DFB7_B9F2_41B1_B67A_1F41351C00ED#335569, code_aire_d_attraction_des_villes#335335 AS COL_69C3DD7A_79D5_4B1B_8197_91541B9A67FC#335570, nom_aire_d_attraction_des_villes#335336 AS COL_8CE26555_43CA_42BB_92B3_B933FA8C4D43#335571, code_bassin_de_vie#335337 AS COL_B6995073_4218_4DF2_BD2B_8EF492D82441#335572, nom_bassin_de_vie#335338 AS COL_AAB67A77_C0A7_4F31_A32A_71E54880AFB4#335573, code_unite_urbaine#335339 AS COL_56FFAA94_A799_4BAB_9DE4_5DAEE3B3582E#335574, nom_unite_urbaine#335340 AS COL_7082CC9E_AC91_4D34_87F8_C963F5883824#335575, code_zone_d_emploi#335341 AS COL_7A825FD2_C5F8_4D5A_9DC6_219050CD2137#335576, nom_zone_d_emploi#335342 AS COL_06AA291A_972E_4561_8F10_A1A2D4D9EBA4#335577]
WholeStageCodegen (1)
FileScan csv [code_commune#335325,nom_commune#335326,code_arrondissement#335327,nom_arrondissement#335328,code_departement#335329,nom_departement#335330,code_epci#335331,nom_epci#335332,code_region#335333,nom_region#335334,code_aire_d_attraction_des_villes#335335,nom_aire_d_attraction_des_villes#335336,code_bassin_de_vie#335337,nom_bassin_de_vie#335338,code_unite_urbaine#335339,nom_unite_urbaine#335340,code_zone_d_emploi#335341,nom_zone_d_emploi#335342] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/COMMUNES_DE_FRA_425669147/HTTP_FILE_0.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<code_commune:string,nom_commune:string,code_arrondissement:string,nom_arrondissement:strin...
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [18]: [code_commune#335325, nom_commune#335326, code_arrondissement#335327, nom_arrondissement#335328, code_departement#335329, nom_departement#335330, code_epci#335331, nom_epci#335332, code_region#335333, nom_region#335334, code_aire_d_attraction_des_villes#335335, nom_aire_d_attraction_des_villes#335336, code_bassin_de_vie#335337, nom_bassin_de_vie#335338, code_unite_urbaine#335339, nom_unite_urbaine#335340, code_zone_d_emploi#335341, nom_zone_d_emploi#335342]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/COMMUNES_DE_FRA_425669147/HTTP_FILE_0.csv]
ReadSchema: struct<code_commune:string,nom_commune:string,code_arrondissement:string,nom_arrondissement:string,code_departement:string,nom_departement:string,code_epci:string,nom_epci:string,code_region:string,nom_region:string,code_aire_d_attraction_des_villes:string,nom_aire_d_attraction_des_villes:string,code_bassin_de_vie:string,nom_bassin_de_vie:string,code_unite_urbaine:string,nom_unite_urbaine:string,code_zone_d_emploi:string,nom_zone_d_emploi:string>
(2) Project [codegen id : 1]
Output [18]: [code_commune#335325 AS COL_62EC3C52_A8FC_44B0_8E2D_1CE4E3D39DD5#335560, nom_commune#335326 AS COL_B1B79BE3_286E_4D46_BF1B_67BE13E0E736#335561, code_arrondissement#335327 AS COL_272F124F_C055_4DF8_8A83_08E09093E3F2#335562, nom_arrondissement#335328 AS COL_DFAF51CB_557A_4CD1_936F_1EC748922F10#335563, code_departement#335329 AS COL_31D51564_C738_498A_976D_243A2FEDA252#335564, nom_departement#335330 AS COL_F3822469_3330_459B_AA8A_59D5C2D45247#335565, code_epci#335331 AS COL_B4645486_AE76_4E98_96C5_0DC4EECAB5DA#335566, nom_epci#335332 AS COL_9C648EB3_D3EE_4C68_B5B3_5E556491577D#335567, code_region#335333 AS COL_0EFEF1A8_486D_48F1_9788_CA57921CDB6D#335568, nom_region#335334 AS COL_9F47DFB7_B9F2_41B1_B67A_1F41351C00ED#335569, code_aire_d_attraction_des_villes#335335 AS COL_69C3DD7A_79D5_4B1B_8197_91541B9A67FC#335570, nom_aire_d_attraction_des_villes#335336 AS COL_8CE26555_43CA_42BB_92B3_B933FA8C4D43#335571, code_bassin_de_vie#335337 AS COL_B6995073_4218_4DF2_BD2B_8EF492D82441#335572, nom_bassin_de_vie#335338 AS COL_AAB67A77_C0A7_4F31_A32A_71E54880AFB4#335573, code_unite_urbaine#335339 AS COL_56FFAA94_A799_4BAB_9DE4_5DAEE3B3582E#335574, nom_unite_urbaine#335340 AS COL_7082CC9E_AC91_4D34_87F8_C963F5883824#335575, code_zone_d_emploi#335341 AS COL_7A825FD2_C5F8_4D5A_9DC6_219050CD2137#335576, nom_zone_d_emploi#335342 AS COL_06AA291A_972E_4561_8F10_A1A2D4D9EBA4#335577]
Input [18]: [code_commune#335325, nom_commune#335326, code_arrondissement#335327, nom_arrondissement#335328, code_departement#335329, nom_departement#335330, code_epci#335331, nom_epci#335332, code_region#335333, nom_region#335334, code_aire_d_attraction_des_villes#335335, nom_aire_d_attraction_des_villes#335336, code_bassin_de_vie#335337, nom_bassin_de_vie#335338, code_unite_urbaine#335339, nom_unite_urbaine#335340, code_zone_d_emploi#335341, nom_zone_d_emploi#335342]
(3) CollectLimit
Input [18]: [COL_62EC3C52_A8FC_44B0_8E2D_1CE4E3D39DD5#335560, COL_B1B79BE3_286E_4D46_BF1B_67BE13E0E736#335561, COL_272F124F_C055_4DF8_8A83_08E09093E3F2#335562, COL_DFAF51CB_557A_4CD1_936F_1EC748922F10#335563, COL_31D51564_C738_498A_976D_243A2FEDA252#335564, COL_F3822469_3330_459B_AA8A_59D5C2D45247#335565, COL_B4645486_AE76_4E98_96C5_0DC4EECAB5DA#335566, COL_9C648EB3_D3EE_4C68_B5B3_5E556491577D#335567, COL_0EFEF1A8_486D_48F1_9788_CA57921CDB6D#335568, COL_9F47DFB7_B9F2_41B1_B67A_1F41351C00ED#335569, COL_69C3DD7A_79D5_4B1B_8197_91541B9A67FC#335570, COL_8CE26555_43CA_42BB_92B3_B933FA8C4D43#335571, COL_B6995073_4218_4DF2_BD2B_8EF492D82441#335572, COL_AAB67A77_C0A7_4F31_A32A_71E54880AFB4#335573, COL_56FFAA94_A799_4BAB_9DE4_5DAEE3B3582E#335574, COL_7082CC9E_AC91_4D34_87F8_C963F5883824#335575, COL_7A825FD2_C5F8_4D5A_9DC6_219050CD2137#335576, COL_06AA291A_972E_4561_8F10_A1A2D4D9EBA4#335577]
Arguments: 1500