== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
* HashAggregate (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
HashAggregate (13)
+- Exchange (12)
+- HashAggregate (11)
+- Project (10)
+- Filter (9)
+- Scan parquet (1)
(1) Scan parquet
Output [1]: [Alarm+Value#118722]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/0A2CF169_565C_40A9_8C97_AF52B8017F78_e757cb73fb40347be872e450e0045e28/1._Alarm_Sample_Data.xlsx_ace13a7404815253302346182a49e79c]
ReadSchema: struct<Alarm+Value:string>
(2) ColumnarToRow [codegen id : 1]
Input [1]: [Alarm+Value#118722]
(3) Filter [codegen id : 1]
Input [1]: [Alarm+Value#118722]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(Alarm+Value#118722)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Alarm+Value#118722)), ME) END
(4) Project [codegen id : 1]
Output: []
Input [1]: [Alarm+Value#118722]
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#118791L]
Results [1]: [count#118792L]
(6) Exchange
Input [1]: [count#118792L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8868]
(7) ShuffleQueryStage
Output [1]: [count#118792L]
Arguments: 0
(8) HashAggregate [codegen id : 2]
Input [1]: [count#118792L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#118781L]
Results [1]: [count(1)#118781L AS COL_bbe67d76-98c3-4800-b3a6-14bb97e61689#118783L]
(9) Filter
Input [1]: [Alarm+Value#118722]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(Alarm+Value#118722)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Alarm+Value#118722)), ME) END
(10) Project
Output: []
Input [1]: [Alarm+Value#118722]
(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#118791L]
Results [1]: [count#118792L]
(12) Exchange
Input [1]: [count#118792L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8848]
(13) HashAggregate
Input [1]: [count#118792L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#118781L]
Results [1]: [count(1)#118781L AS COL_bbe67d76-98c3-4800-b3a6-14bb97e61689#118783L]
(14) AdaptiveSparkPlan
Output [1]: [COL_bbe67d76-98c3-4800-b3a6-14bb97e61689#118783L]
Arguments: isFinalPlan=true