== 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#1101271, handlingOfUnfulfilledDemands#1101289]
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#1101271, handlingOfUnfulfilledDemands#1101289]
(3) Filter [codegen id : 1]
Input [2]: [marketUnit#1101271, handlingOfUnfulfilledDemands#1101289]
Condition : (marketUnit#1101271 <=> AUTO_ALL_ProdLoc)
(4) Project [codegen id : 1]
Output [1]: [handlingOfUnfulfilledDemands#1101289.distributionCenter.handlingOfUnfulfilledDemands AS _extract_handlingOfUnfulfilledDemands#1104349]
Input [2]: [marketUnit#1101271, handlingOfUnfulfilledDemands#1101289]
(5) Exchange
Input [1]: [_extract_handlingOfUnfulfilledDemands#1104349]
Arguments: RoundRobinPartitioning(37), REPARTITION_BY_NUM, [plan_id=1701015]
(6) ShuffleQueryStage
Output [1]: [_extract_handlingOfUnfulfilledDemands#1104349]
Arguments: 0
(7) Project [codegen id : 2]
Output [1]: [coalesce(_extract_handlingOfUnfulfilledDemands#1104349, 1) AS coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#1104348]
Input [1]: [_extract_handlingOfUnfulfilledDemands#1104349]
(8) ResultQueryStage
Output [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#1104348]
Arguments: 1
(9) Filter
Input [2]: [marketUnit#1101271, handlingOfUnfulfilledDemands#1101289]
Condition : (marketUnit#1101271 <=> AUTO_ALL_ProdLoc)
(10) Project
Output [1]: [handlingOfUnfulfilledDemands#1101289.distributionCenter.handlingOfUnfulfilledDemands AS _extract_handlingOfUnfulfilledDemands#1104349]
Input [2]: [marketUnit#1101271, handlingOfUnfulfilledDemands#1101289]
(11) Exchange
Input [1]: [_extract_handlingOfUnfulfilledDemands#1104349]
Arguments: RoundRobinPartitioning(37), REPARTITION_BY_NUM, [plan_id=1700996]
(12) Project
Output [1]: [coalesce(_extract_handlingOfUnfulfilledDemands#1104349, 1) AS coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#1104348]
Input [1]: [_extract_handlingOfUnfulfilledDemands#1104349]
(13) CollectLimit
Input [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#1104348]
Arguments: 1
(14) AdaptiveSparkPlan
Output [1]: [coalesce(handlingOfUnfulfilledDemands.distributionCenter.handlingOfUnfulfilledDemands, 1)#1104348]
Arguments: isFinalPlan=true