digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 21 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: 810<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 100.6 KiB"];
2->0;
3->2;
}
4
CollectLimit 1500
Project [EXTERNAL_DOCUMENT_ID#2299 AS COL_C8E19FC1_569F_4F86_8927_0F1131F285D7#2555, TITRE#2305 AS COL_15526598_CADB_43B8_ACA0_6F08708A2BA3#2556, THESAURUS_CODE#2306 AS COL_303EAEBA_097E_4E50_ADEE_17B845D37293#2557, THESAURUS_LIBELLE#2307 AS COL_6871CA3A_9A45_444C_AA2A_04686B0AD7A1#2558, SIGNATAIRE#2308 AS COL_49B9D9D2_1308_4859_A6C5_BAC10C867FFC#2559, str_to_datez(DATE_MODIFICATION#2310, ISO 8601, null, null) AS COL_154FB0EB_BCA9_4D4C_9D6B_12E9E18E085C#2560, CHEMIN_FICHIER#2311 AS COL_D1530343_6EDF_4CE1_A67D_67BBC2F02F20#2561, CHEMIN_HTML#2312 AS COL_8DFAA189_BC7C_4B8F_B500_8DFDFCF4BD34#2562, CHEMIN_TXT#2313 AS COL_8A814758_969B_4A15_BB5C_0EFA085B6553#2563, cast(IPP#2300 as int) AS COL_EF34162B_FAF8_48A9_B82E_4DB57A3057A3#2564, cast(IEP#2301 as int) AS COL_D116C23C_E452_49CE_9D28_D32C05CD46AE#2565, cast(UF#2302 as int) AS COL_19077D83_3A98_4E4C_972A_BD82597CFE80#2566, cast(UF_EXEC#2303 as int) AS COL_C8D68BDF_382D_46EF_AD4C_4A5DD5BE90EA#2567, cast(UM#2304 as int) AS COL_B87A199A_779F_4385_844C_ACACEEBDB2AA#2568, cast(DATE_DOCUMENT#2309 as bigint) AS COL_07AE4300_D198_4572_B794_A0AC29656D4C#2569L]
WholeStageCodegen (1)
FileScan csv [EXTERNAL_DOCUMENT_ID#2299,IPP#2300,IEP#2301,UF#2302,UF_EXEC#2303,UM#2304,TITRE#2305,THESAURUS_CODE#2306,THESAURUS_LIBELLE#2307,SIGNATAIRE#2308,DATE_DOCUMENT#2309,DATE_MODIFICATION#2310,CHEMIN_FICHIER#2311,CHEMIN_HTML#2312,CHEMIN_TXT#2313] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/F15719B3_BBE7_495B_A19D_571E1EEEA..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<EXTERNAL_DOCUMENT_ID:string,IPP:string,IEP:string,UF:string,UF_EXEC:string,UM:string,TITRE...
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [15]: [EXTERNAL_DOCUMENT_ID#2299, IPP#2300, IEP#2301, UF#2302, UF_EXEC#2303, UM#2304, TITRE#2305, THESAURUS_CODE#2306, THESAURUS_LIBELLE#2307, SIGNATAIRE#2308, DATE_DOCUMENT#2309, DATE_MODIFICATION#2310, CHEMIN_FICHIER#2311, CHEMIN_HTML#2312, CHEMIN_TXT#2313]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/F15719B3_BBE7_495B_A19D_571E1EEEA915/current/labo_doc.csv]
ReadSchema: struct<EXTERNAL_DOCUMENT_ID:string,IPP:string,IEP:string,UF:string,UF_EXEC:string,UM:string,TITRE:string,THESAURUS_CODE:string,THESAURUS_LIBELLE:string,SIGNATAIRE:string,DATE_DOCUMENT:string,DATE_MODIFICATION:string,CHEMIN_FICHIER:string,CHEMIN_HTML:string,CHEMIN_TXT:string>
(2) Project [codegen id : 1]
Output [15]: [EXTERNAL_DOCUMENT_ID#2299 AS COL_C8E19FC1_569F_4F86_8927_0F1131F285D7#2555, TITRE#2305 AS COL_15526598_CADB_43B8_ACA0_6F08708A2BA3#2556, THESAURUS_CODE#2306 AS COL_303EAEBA_097E_4E50_ADEE_17B845D37293#2557, THESAURUS_LIBELLE#2307 AS COL_6871CA3A_9A45_444C_AA2A_04686B0AD7A1#2558, SIGNATAIRE#2308 AS COL_49B9D9D2_1308_4859_A6C5_BAC10C867FFC#2559, str_to_datez(DATE_MODIFICATION#2310, ISO 8601, null, null) AS COL_154FB0EB_BCA9_4D4C_9D6B_12E9E18E085C#2560, CHEMIN_FICHIER#2311 AS COL_D1530343_6EDF_4CE1_A67D_67BBC2F02F20#2561, CHEMIN_HTML#2312 AS COL_8DFAA189_BC7C_4B8F_B500_8DFDFCF4BD34#2562, CHEMIN_TXT#2313 AS COL_8A814758_969B_4A15_BB5C_0EFA085B6553#2563, cast(IPP#2300 as int) AS COL_EF34162B_FAF8_48A9_B82E_4DB57A3057A3#2564, cast(IEP#2301 as int) AS COL_D116C23C_E452_49CE_9D28_D32C05CD46AE#2565, cast(UF#2302 as int) AS COL_19077D83_3A98_4E4C_972A_BD82597CFE80#2566, cast(UF_EXEC#2303 as int) AS COL_C8D68BDF_382D_46EF_AD4C_4A5DD5BE90EA#2567, cast(UM#2304 as int) AS COL_B87A199A_779F_4385_844C_ACACEEBDB2AA#2568, cast(DATE_DOCUMENT#2309 as bigint) AS COL_07AE4300_D198_4572_B794_A0AC29656D4C#2569L]
Input [15]: [EXTERNAL_DOCUMENT_ID#2299, IPP#2300, IEP#2301, UF#2302, UF_EXEC#2303, UM#2304, TITRE#2305, THESAURUS_CODE#2306, THESAURUS_LIBELLE#2307, SIGNATAIRE#2308, DATE_DOCUMENT#2309, DATE_MODIFICATION#2310, CHEMIN_FICHIER#2311, CHEMIN_HTML#2312, CHEMIN_TXT#2313]
(3) CollectLimit
Input [15]: [COL_C8E19FC1_569F_4F86_8927_0F1131F285D7#2555, COL_15526598_CADB_43B8_ACA0_6F08708A2BA3#2556, COL_303EAEBA_097E_4E50_ADEE_17B845D37293#2557, COL_6871CA3A_9A45_444C_AA2A_04686B0AD7A1#2558, COL_49B9D9D2_1308_4859_A6C5_BAC10C867FFC#2559, COL_154FB0EB_BCA9_4D4C_9D6B_12E9E18E085C#2560, COL_D1530343_6EDF_4CE1_A67D_67BBC2F02F20#2561, COL_8DFAA189_BC7C_4B8F_B500_8DFDFCF4BD34#2562, COL_8A814758_969B_4A15_BB5C_0EFA085B6553#2563, COL_EF34162B_FAF8_48A9_B82E_4DB57A3057A3#2564, COL_D116C23C_E452_49CE_9D28_D32C05CD46AE#2565, COL_19077D83_3A98_4E4C_972A_BD82597CFE80#2566, COL_C8D68BDF_382D_46EF_AD4C_4A5DD5BE90EA#2567, COL_B87A199A_779F_4385_844C_ACACEEBDB2AA#2568, COL_07AE4300_D198_4572_B794_A0AC29656D4C#2569L]
Arguments: 1500