== Physical Plan ==
AdaptiveSparkPlan (16)
+- == Final Plan ==
* HashAggregate (9)
+- AQEShuffleRead (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=72.0 B, rowCount=3)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
CollectLimit (15)
+- HashAggregate (14)
+- Exchange (13)
+- HashAggregate (12)
+- Project (11)
+- Filter (10)
+- Scan parquet (1)
(1) Scan parquet
Output [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/FINESS_ANNEE_ET_307893]
ReadSchema: struct<COL_2D4B6273_3F11_4732_BB09_9811C83B8C53:string>
(2) ColumnarToRow [codegen id : 1]
Input [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093]
(3) Filter [codegen id : 1]
Input [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_accent(COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093))), )) THEN false ELSE Contains(str_remove_accent(upper(str_remove_accent(COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093))), ) END
(4) Project [codegen id : 1]
Output [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093 AS COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Input [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093]
(5) HashAggregate [codegen id : 1]
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Keys [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
(6) Exchange
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Arguments: hashpartitioning(COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099, 10), ENSURE_REQUIREMENTS, [plan_id=13908]
(7) ShuffleQueryStage
Output [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Arguments: 0
(8) AQEShuffleRead
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Arguments: coalesced
(9) HashAggregate [codegen id : 2]
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Keys [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099 AS COL_73B076F9_1DC8_493B_B726_009DF7252249#140115]
(10) Filter
Input [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_accent(COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093))), )) THEN false ELSE Contains(str_remove_accent(upper(str_remove_accent(COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093))), ) END
(11) Project
Output [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093 AS COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Input [1]: [COL_2D4B6273_3F11_4732_BB09_9811C83B8C53#140093]
(12) HashAggregate
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Keys [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
(13) Exchange
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Arguments: hashpartitioning(COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099, 10), ENSURE_REQUIREMENTS, [plan_id=13885]
(14) HashAggregate
Input [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Keys [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0B203649_CACA_4323_9A29_AAC1B5A85B5F#140099 AS COL_73B076F9_1DC8_493B_B726_009DF7252249#140115]
(15) CollectLimit
Input [1]: [COL_73B076F9_1DC8_493B_B726_009DF7252249#140115]
Arguments: 100
(16) AdaptiveSparkPlan
Output [1]: [COL_73B076F9_1DC8_493B_B726_009DF7252249#140115]
Arguments: isFinalPlan=true