== Physical Plan ==
CollectLimit (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [6]: [Code+CIM+10#1106806, Libell%C3%A9+long#1106807, Responsable+MAJ#1106808, Source#1106809, Date_effet#1106810, Date_r%C3%A9vocation#1106811]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE2__232731_3f61f47cf25f2cffe6faba07f2a57dc7/DP_PE2.xlsx_8e052a790a9bc5b8446216002454c960]
ReadSchema: struct<Code+CIM+10:string,Libell%C3%A9+long:string,Responsable+MAJ:string,Source:string,Date_effet:timestamp,Date_r%C3%A9vocation:timestamp>
(2) ColumnarToRow [codegen id : 1]
Input [6]: [Code+CIM+10#1106806, Libell%C3%A9+long#1106807, Responsable+MAJ#1106808, Source#1106809, Date_effet#1106810, Date_r%C3%A9vocation#1106811]
(3) Project [codegen id : 1]
Output [7]: [str_remove_space(str_remove_extend(Code+CIM+10#1106806, [.]), RIGHT) AS COL_CODE_CIM_10_232850#1106968, Libell%C3%A9+long#1106807 AS COL_LIBELLE_LONG_232851#1106969, Date_effet#1106810 AS COL_DATE_EFFET_232852#1106970, Date_r%C3%A9vocation#1106811 AS COL_DATE_REVOCATION_232853#1106971, Responsable+MAJ#1106808 AS COL_RESPONSABLE_MAJ_232854#1106972, Source#1106809 AS COL_SOURCE_232855#1106973, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1106806, [.]), RIGHT), [.]), RIGHT) AS COL_CODE_CIM10_NORM_232856#1106974]
Input [6]: [Code+CIM+10#1106806, Libell%C3%A9+long#1106807, Responsable+MAJ#1106808, Source#1106809, Date_effet#1106810, Date_r%C3%A9vocation#1106811]
(4) CollectLimit
Input [7]: [COL_CODE_CIM_10_232850#1106968, COL_LIBELLE_LONG_232851#1106969, COL_DATE_EFFET_232852#1106970, COL_DATE_REVOCATION_232853#1106971, COL_RESPONSABLE_MAJ_232854#1106972, COL_SOURCE_232855#1106973, COL_CODE_CIM10_NORM_232856#1106974]
Arguments: 1500