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: 9 ms<br>number of output rows: 322<br>number of dynamic part: 0<br>written output: 12.7 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 41 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 322<br>number of input batches: 1"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 9 ms<br>metadata time: 0 ms<br>size of files read: 16.0 KiB<br>number of output rows: 322"];
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#130133 AS COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C#130251, nameapi#130134 AS COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC#130252, statut#130135 AS COL_EC44F690_4E62_4006_8455_86DADB54D177#130253, detail#130141 AS COL_20910473_1096_4BE0_B0BF_F16398F64680#130254, id_expo#130138 AS COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F#130255, project_label#130139 AS COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8#130256, project_id#130140 AS COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B#130257, nb_lignes#130136 AS COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15#130258, nb_colonnes#130137 AS COL_07588D11_451F_4A60_8F6B_5D908E37B2D4#130259]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [url#130133,nameapi#130134,statut#130135,nb_lignes#130136,nb_colonnes#130137,id_expo#130138,project_label#130139,project_id#130140,detail#130141] 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,nb_lignes:double,nb_colonnes:double,id_expo:string...
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (5)
+- WriteFiles (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [9]: [url#130133, nameapi#130134, statut#130135, nb_lignes#130136, nb_colonnes#130137, id_expo#130138, project_label#130139, project_id#130140, detail#130141]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/parquet/execution/RECAP_ALL_ANALYSE_API/current/pydc_1hqaqpzd.parquet]
ReadSchema: struct<url:string,nameapi:string,statut:string,nb_lignes:double,nb_colonnes:double,id_expo:string,project_label:string,project_id:string,detail:string>
(2) ColumnarToRow [codegen id : 1]
Input [9]: [url#130133, nameapi#130134, statut#130135, nb_lignes#130136, nb_colonnes#130137, id_expo#130138, project_label#130139, project_id#130140, detail#130141]
(3) Project [codegen id : 1]
Output [9]: [url#130133 AS COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C#130251, nameapi#130134 AS COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC#130252, statut#130135 AS COL_EC44F690_4E62_4006_8455_86DADB54D177#130253, detail#130141 AS COL_20910473_1096_4BE0_B0BF_F16398F64680#130254, id_expo#130138 AS COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F#130255, project_label#130139 AS COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8#130256, project_id#130140 AS COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B#130257, nb_lignes#130136 AS COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15#130258, nb_colonnes#130137 AS COL_07588D11_451F_4A60_8F6B_5D908E37B2D4#130259]
Input [9]: [url#130133, nameapi#130134, statut#130135, nb_lignes#130136, nb_colonnes#130137, id_expo#130138, project_label#130139, project_id#130140, detail#130141]
(4) WriteFiles
Input [9]: [COL_86894070_3A82_45A3_AF6F_E1A81B4AE44C#130251, COL_9FA9421B_B41E_44BF_97DA_951FE9BA4EFC#130252, COL_EC44F690_4E62_4006_8455_86DADB54D177#130253, COL_20910473_1096_4BE0_B0BF_F16398F64680#130254, COL_983EB6E2_734D_4ACF_BE18_71F0D3CFBE3F#130255, COL_DEA7AFA9_7DC4_42E3_AD33_9316ED1084F8#130256, COL_3AD7AA07_87EC_496D_B3DB_6F665B8BBA6B#130257, COL_C867ED2F_91C4_47AD_8E9C_5042030CAB15#130258, COL_07588D11_451F_4A60_8F6B_5D908E37B2D4#130259]
(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]