== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
ResultQueryStage (8), Statistics(sizeInBytes=8.0 EiB)
+- * Project (7)
+- ShuffleQueryStage (6), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
CollectLimit (13)
+- Project (12)
+- Exchange (11)
+- Project (10)
+- Filter (9)
+- Scan parquet (1)
(1) Scan parquet
Output [2]: [marketUnit#69135, handlingOfUnfulfilledDemands#69158]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit]
PushedFilters: [EqualNullSafe(marketUnit,Daily_grocery)]
ReadSchema: struct<marketUnit:string,handlingOfUnfulfilledDemands:struct<distributionCenter:struct<handlingOfUnfulfilledDemands:int>>>
(2) ColumnarToRow [codegen id : 1]
Input [2]: [marketUnit#69135, handlingOfUnfulfilledDemands#69158]
(3) Filter [codegen id : 1]
Input [2]: [marketUnit#69135, handlingOfUnfulfilledDemands#69158]
Condition : (marketUnit#69135 <=> Daily_grocery)
(4) Project [codegen id : 1]
Output [1]: [handlingOfUnfulfilledDemands#69158.distributionCenter.handlingOfUnfulfilledDemands AS _extract_handlingOfUnfulfilledDemands#78619]
Input [2]: [marketUnit#69135, handlingOfUnfulfilledDemands#69158]
(5) Exchange
Input [1]: [_extract_handlingOfUnfulfilledDemands#78619]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=32878]
(6) ShuffleQueryStage
Output [1]: [_extract_handlingOfUnfulfilledDemands#78619]
Arguments: 0
(7) Project [codegen id : 2]
Output [1]: [coalesce(_extract_handlingOfUnfulfilledDemands#78619, 1) AS coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#78617]
Input [1]: [_extract_handlingOfUnfulfilledDemands#78619]
(8) ResultQueryStage
Output [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#78617]
Arguments: 1
(9) Filter
Input [2]: [marketUnit#69135, handlingOfUnfulfilledDemands#69158]
Condition : (marketUnit#69135 <=> Daily_grocery)
(10) Project
Output [1]: [handlingOfUnfulfilledDemands#69158.distributionCenter.handlingOfUnfulfilledDemands AS _extract_handlingOfUnfulfilledDemands#78619]
Input [2]: [marketUnit#69135, handlingOfUnfulfilledDemands#69158]
(11) Exchange
Input [1]: [_extract_handlingOfUnfulfilledDemands#78619]
Arguments: RoundRobinPartitioning(25), REPARTITION_BY_NUM, [plan_id=32859]
(12) Project
Output [1]: [coalesce(_extract_handlingOfUnfulfilledDemands#78619, 1) AS coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#78617]
Input [1]: [_extract_handlingOfUnfulfilledDemands#78619]
(13) CollectLimit
Input [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#78617]
Arguments: 1
(14) AdaptiveSparkPlan
Output [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#78617]
Arguments: isFinalPlan=true