== 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#905528, handlingOfUnfulfilledDemands#905546]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit]
PushedFilters: [EqualNullSafe(marketUnit,AUTO_ALL_ProdLoc)]
ReadSchema: struct<marketUnit:string,handlingOfUnfulfilledDemands:struct<distributionCenter:struct<handlingOfUnfulfilledDemands:int>>>
(2) ColumnarToRow [codegen id : 1]
Input [2]: [marketUnit#905528, handlingOfUnfulfilledDemands#905546]
(3) Filter [codegen id : 1]
Input [2]: [marketUnit#905528, handlingOfUnfulfilledDemands#905546]
Condition : (marketUnit#905528 <=> AUTO_ALL_ProdLoc)
(4) Project [codegen id : 1]
Output [1]: [handlingOfUnfulfilledDemands#905546.distributionCenter.handlingOfUnfulfilledDemands AS _extract_handlingOfUnfulfilledDemands#908606]
Input [2]: [marketUnit#905528, handlingOfUnfulfilledDemands#905546]
(5) Exchange
Input [1]: [_extract_handlingOfUnfulfilledDemands#908606]
Arguments: RoundRobinPartitioning(37), REPARTITION_BY_NUM, [plan_id=1396295]
(6) ShuffleQueryStage
Output [1]: [_extract_handlingOfUnfulfilledDemands#908606]
Arguments: 0
(7) Project [codegen id : 2]
Output [1]: [coalesce(_extract_handlingOfUnfulfilledDemands#908606, 1) AS coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#908605]
Input [1]: [_extract_handlingOfUnfulfilledDemands#908606]
(8) ResultQueryStage
Output [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#908605]
Arguments: 1
(9) Filter
Input [2]: [marketUnit#905528, handlingOfUnfulfilledDemands#905546]
Condition : (marketUnit#905528 <=> AUTO_ALL_ProdLoc)
(10) Project
Output [1]: [handlingOfUnfulfilledDemands#905546.distributionCenter.handlingOfUnfulfilledDemands AS _extract_handlingOfUnfulfilledDemands#908606]
Input [2]: [marketUnit#905528, handlingOfUnfulfilledDemands#905546]
(11) Exchange
Input [1]: [_extract_handlingOfUnfulfilledDemands#908606]
Arguments: RoundRobinPartitioning(37), REPARTITION_BY_NUM, [plan_id=1396276]
(12) Project
Output [1]: [coalesce(_extract_handlingOfUnfulfilledDemands#908606, 1) AS coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#908605]
Input [1]: [_extract_handlingOfUnfulfilledDemands#908606]
(13) CollectLimit
Input [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#908605]
Arguments: 1
(14) AdaptiveSparkPlan
Output [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#908605]
Arguments: isFinalPlan=true