digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 1 ms<br>number of written files: 1<br>job commit time: 11 ms<br>number of output rows: 330<br>number of dynamic part: 0<br>written output: 13.2 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 43 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 330<br>number of input batches: 1"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 7 ms<br>metadata time: 0 ms<br>size of files read: 16.6 KiB<br>number of output rows: 330"];
1->0;
3->1;
4->3;
5->4;
}
6
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/DB_RECAP_ALL_AN_414152, false, Parquet, [path=file:///data/output/cache/parquet/datablock/DB_RECAP_ALL_AN_414152], Overwrite, [COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C, COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC, COL_EC44F690_4E62_4006_8455_86DADB54D177, COL_20910473_1096_4BE0_B0BF_F16398F64680, COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F, COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8, COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B, COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15, COL_07588D11_451F_4A60_8F6B_5D908E37B2D4]
WriteFiles
Project [url#17886 AS COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C#18004, nameapi#17887 AS COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC#18005, statut#17888 AS COL_EC44F690_4E62_4006_8455_86DADB54D177#18006, detail#17889 AS COL_20910473_1096_4BE0_B0BF_F16398F64680#18007, id_expo#17890 AS COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F#18008, project_label#17891 AS COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8#18009, project_id#17892 AS COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B#18010, nb_lignes#17893 AS COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15#18011, nb_colonnes#17894 AS COL_07588D11_451F_4A60_8F6B_5D908E37B2D4#18012]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [url#17886,nameapi#17887,statut#17888,detail#17889,id_expo#17890,project_label#17891,project_id#17892,nb_lignes#17893,nb_colonnes#17894] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/parquet/execution/RECAP_ALL_ANALYSE_API/current..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<url:string,nameapi:string,statut:string,detail:string,id_expo:string,project_label:string,...
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (5)
+- WriteFiles (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [9]: [url#17886, nameapi#17887, statut#17888, detail#17889, id_expo#17890, project_label#17891, project_id#17892, nb_lignes#17893, nb_colonnes#17894]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/parquet/execution/RECAP_ALL_ANALYSE_API/current/pydc_shw1a45r.parquet]
ReadSchema: struct<url:string,nameapi:string,statut:string,detail:string,id_expo:string,project_label:string,project_id:string,nb_lignes:double,nb_colonnes:double>
(2) ColumnarToRow [codegen id : 1]
Input [9]: [url#17886, nameapi#17887, statut#17888, detail#17889, id_expo#17890, project_label#17891, project_id#17892, nb_lignes#17893, nb_colonnes#17894]
(3) Project [codegen id : 1]
Output [9]: [url#17886 AS COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C#18004, nameapi#17887 AS COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC#18005, statut#17888 AS COL_EC44F690_4E62_4006_8455_86DADB54D177#18006, detail#17889 AS COL_20910473_1096_4BE0_B0BF_F16398F64680#18007, id_expo#17890 AS COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F#18008, project_label#17891 AS COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8#18009, project_id#17892 AS COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B#18010, nb_lignes#17893 AS COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15#18011, nb_colonnes#17894 AS COL_07588D11_451F_4A60_8F6B_5D908E37B2D4#18012]
Input [9]: [url#17886, nameapi#17887, statut#17888, detail#17889, id_expo#17890, project_label#17891, project_id#17892, nb_lignes#17893, nb_colonnes#17894]
(4) WriteFiles
Input [9]: [COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C#18004, COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC#18005, COL_EC44F690_4E62_4006_8455_86DADB54D177#18006, COL_20910473_1096_4BE0_B0BF_F16398F64680#18007, COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F#18008, COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8#18009, COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B#18010, COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15#18011, COL_07588D11_451F_4A60_8F6B_5D908E37B2D4#18012]
(5) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/DB_RECAP_ALL_AN_414152, false, Parquet, [path=file:///data/output/cache/parquet/datablock/DB_RECAP_ALL_AN_414152], Overwrite, [COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C, COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC, COL_EC44F690_4E62_4006_8455_86DADB54D177, COL_20910473_1096_4BE0_B0BF_F16398F64680, COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F, COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8, COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B, COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15, COL_07588D11_451F_4A60_8F6B_5D908E37B2D4]