== 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]: [COL_F57F1581_453A_4B69_B684_886731A3566A#305845]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/DB_META_ALL_ANA_398939]
ReadSchema: struct<COL_F57F1581_453A_4B69_B684_886731A3566A:string>
(2) ColumnarToRow [codegen id : 1]
Input [1]: [COL_F57F1581_453A_4B69_B684_886731A3566A#305845]
(3) Filter [codegen id : 1]
Input [1]: [COL_F57F1581_453A_4B69_B684_886731A3566A#305845]
Condition : CASE WHEN isnull(StartsWith(COL_F57F1581_453A_4B69_B684_886731A3566A#305845, UNPU)) THEN false ELSE StartsWith(COL_F57F1581_453A_4B69_B684_886731A3566A#305845, UNPU) END
(4) Project [codegen id : 1]
Output: []
Input [1]: [COL_F57F1581_453A_4B69_B684_886731A3566A#305845]
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#306106L]
Results [1]: [count#306107L]
(6) Exchange
Input [1]: [count#306107L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=41830]
(7) ShuffleQueryStage
Output [1]: [count#306107L]
Arguments: 0
(8) HashAggregate [codegen id : 2]
Input [1]: [count#306107L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#305956L]
Results [1]: [count(1)#305956L AS COL_F98F0FE6_4CE3_4300_B0F1_E960E4FD9201#306022L]
(9) Filter
Input [1]: [COL_F57F1581_453A_4B69_B684_886731A3566A#305845]
Condition : CASE WHEN isnull(StartsWith(COL_F57F1581_453A_4B69_B684_886731A3566A#305845, UNPU)) THEN false ELSE StartsWith(COL_F57F1581_453A_4B69_B684_886731A3566A#305845, UNPU) END
(10) Project
Output: []
Input [1]: [COL_F57F1581_453A_4B69_B684_886731A3566A#305845]
(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#306106L]
Results [1]: [count#306107L]
(12) Exchange
Input [1]: [count#306107L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=41810]
(13) HashAggregate
Input [1]: [count#306107L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#305956L]
Results [1]: [count(1)#305956L AS COL_F98F0FE6_4CE3_4300_B0F1_E960E4FD9201#306022L]
(14) AdaptiveSparkPlan
Output [1]: [COL_F98F0FE6_4CE3_4300_B0F1_E960E4FD9201#306022L]
Arguments: isFinalPlan=true