== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
ResultQueryStage (2), Statistics(sizeInBytes=8.0 EiB)
+- EmptyRelation (1)
+- GlobalLimit (unknown)
+- EmptyRelation (unknown)
+- == Initial Plan ==
CollectLimit (13)
+- Project (12)
+- Filter (11)
+- SortAggregate (10)
+- Sort (9)
+- Exchange (8)
+- SortAggregate (7)
+- Sort (6)
+- Exchange (5)
+- Filter (4)
+- Scan parquet (3)
(1) EmptyRelation
Output [1]: [configurationVersion#26875]
Arguments: [plan_id=112994]
(2) ResultQueryStage
Output [1]: [configurationVersion#26875]
Arguments: 1
(3) Scan parquet
Output [4]: [name#26854, status#26856, configurationVersion#26857, settings#26860]
Batched: true
Location: PreparedDeltaFileIndex [hdlfs://9b46f9d5-066e-49af-bc5c-7af37534ca4d.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/insight-configuration]
PushedFilters: [IsNotNull(configurationVersion), IsNotNull(name), EqualTo(name,OP_CALC_ITEM_DEVIATION_OF_ORDER_CONF)]
ReadSchema: struct<name:string,status:string,configurationVersion:string,settings:array<struct<name:string,type:string,value:string>>>
(4) Filter
Input [4]: [name#26854, status#26856, configurationVersion#26857, settings#26860]
Condition : ((isnotnull(configurationVersion#26857) AND isnotnull(name#26854)) AND (name#26854 = OP_CALC_ITEM_DEVIATION_OF_ORDER_CONF))
(5) Exchange
Input [4]: [name#26854, status#26856, configurationVersion#26857, settings#26860]
Arguments: RoundRobinPartitioning(10), REPARTITION_BY_NUM, [plan_id=112945]
(6) Sort
Input [4]: [name#26854, status#26856, configurationVersion#26857, settings#26860]
Arguments: [name#26854 ASC NULLS FIRST], false, 0
(7) SortAggregate
Input [4]: [name#26854, status#26856, configurationVersion#26857, settings#26860]
Keys [1]: [name#26854]
Functions [1]: [partial_max(struct(configurationVersion, configurationVersion#26857, status, status#26856, settings, settings#26860))]
Aggregate Attributes [1]: [max#27110]
Results [2]: [name#26854, max#27111]
(8) Exchange
Input [2]: [name#26854, max#27111]
Arguments: hashpartitioning(name#26854, 10), ENSURE_REQUIREMENTS, [plan_id=112954]
(9) Sort
Input [2]: [name#26854, max#27111]
Arguments: [name#26854 ASC NULLS FIRST], false, 0
(10) SortAggregate
Input [2]: [name#26854, max#27111]
Keys [1]: [name#26854]
Functions [1]: [max(struct(configurationVersion, configurationVersion#26857, status, status#26856, settings, settings#26860))]
Aggregate Attributes [1]: [max(struct(configurationVersion, configurationVersion#26857, status, status#26856, settings, settings#26860))#26872]
Results [1]: [max(struct(configurationVersion, configurationVersion#26857, status, status#26856, settings, settings#26860))#26872 AS best#26863]
(11) Filter
Input [1]: [best#26863]
Condition : (isnotnull(best#26863.status) AND (best#26863.status = ACTIVE))
(12) Project
Output [1]: [best#26863.configurationVersion AS configurationVersion#26875]
Input [1]: [best#26863]
(13) CollectLimit
Input [1]: [configurationVersion#26875]
Arguments: 1
(14) AdaptiveSparkPlan
Output [1]: [configurationVersion#26875]
Arguments: isFinalPlan=true