== 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#2066]
Arguments: [plan_id=1007]
(2) ResultQueryStage
Output [1]: [configurationVersion#2066]
Arguments: 1
(3) Scan parquet
Output [4]: [name#2045, status#2047, configurationVersion#2048, settings#2051]
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#2045, status#2047, configurationVersion#2048, settings#2051]
Condition : ((isnotnull(configurationVersion#2048) AND isnotnull(name#2045)) AND (name#2045 = OP_CALC_ITEM_DEVIATION_OF_ORDER_CONF))
(5) Exchange
Input [4]: [name#2045, status#2047, configurationVersion#2048, settings#2051]
Arguments: RoundRobinPartitioning(10), REPARTITION_BY_NUM, [plan_id=958]
(6) Sort
Input [4]: [name#2045, status#2047, configurationVersion#2048, settings#2051]
Arguments: [name#2045 ASC NULLS FIRST], false, 0
(7) SortAggregate
Input [4]: [name#2045, status#2047, configurationVersion#2048, settings#2051]
Keys [1]: [name#2045]
Functions [1]: [partial_max(struct(configurationVersion, configurationVersion#2048, status, status#2047, settings, settings#2051))]
Aggregate Attributes [1]: [max#2305]
Results [2]: [name#2045, max#2306]
(8) Exchange
Input [2]: [name#2045, max#2306]
Arguments: hashpartitioning(name#2045, 10), ENSURE_REQUIREMENTS, [plan_id=967]
(9) Sort
Input [2]: [name#2045, max#2306]
Arguments: [name#2045 ASC NULLS FIRST], false, 0
(10) SortAggregate
Input [2]: [name#2045, max#2306]
Keys [1]: [name#2045]
Functions [1]: [max(struct(configurationVersion, configurationVersion#2048, status, status#2047, settings, settings#2051))]
Aggregate Attributes [1]: [max(struct(configurationVersion, configurationVersion#2048, status, status#2047, settings, settings#2051))#2063]
Results [1]: [max(struct(configurationVersion, configurationVersion#2048, status, status#2047, settings, settings#2051))#2063 AS best#2054]
(11) Filter
Input [1]: [best#2054]
Condition : (isnotnull(best#2054.status) AND (best#2054.status = ACTIVE))
(12) Project
Output [1]: [best#2054.configurationVersion AS configurationVersion#2066]
Input [1]: [best#2054]
(13) CollectLimit
Input [1]: [configurationVersion#2066]
Arguments: 1
(14) AdaptiveSparkPlan
Output [1]: [configurationVersion#2066]
Arguments: isFinalPlan=true