== 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#51509]
Arguments: [plan_id=218525]
(2) ResultQueryStage
Output [1]: [configurationVersion#51509]
Arguments: 1
(3) Scan parquet
Output [4]: [name#51488, status#51490, configurationVersion#51491, settings#51494]
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#51488, status#51490, configurationVersion#51491, settings#51494]
Condition : ((isnotnull(configurationVersion#51491) AND isnotnull(name#51488)) AND (name#51488 = OP_CALC_ITEM_DEVIATION_OF_ORDER_CONF))
(5) Exchange
Input [4]: [name#51488, status#51490, configurationVersion#51491, settings#51494]
Arguments: RoundRobinPartitioning(10), REPARTITION_BY_NUM, [plan_id=218476]
(6) Sort
Input [4]: [name#51488, status#51490, configurationVersion#51491, settings#51494]
Arguments: [name#51488 ASC NULLS FIRST], false, 0
(7) SortAggregate
Input [4]: [name#51488, status#51490, configurationVersion#51491, settings#51494]
Keys [1]: [name#51488]
Functions [1]: [partial_max(struct(configurationVersion, configurationVersion#51491, status, status#51490, settings, settings#51494))]
Aggregate Attributes [1]: [max#51744]
Results [2]: [name#51488, max#51745]
(8) Exchange
Input [2]: [name#51488, max#51745]
Arguments: hashpartitioning(name#51488, 10), ENSURE_REQUIREMENTS, [plan_id=218485]
(9) Sort
Input [2]: [name#51488, max#51745]
Arguments: [name#51488 ASC NULLS FIRST], false, 0
(10) SortAggregate
Input [2]: [name#51488, max#51745]
Keys [1]: [name#51488]
Functions [1]: [max(struct(configurationVersion, configurationVersion#51491, status, status#51490, settings, settings#51494))]
Aggregate Attributes [1]: [max(struct(configurationVersion, configurationVersion#51491, status, status#51490, settings, settings#51494))#51506]
Results [1]: [max(struct(configurationVersion, configurationVersion#51491, status, status#51490, settings, settings#51494))#51506 AS best#51497]
(11) Filter
Input [1]: [best#51497]
Condition : (isnotnull(best#51497.status) AND (best#51497.status = ACTIVE))
(12) Project
Output [1]: [best#51497.configurationVersion AS configurationVersion#51509]
Input [1]: [best#51497]
(13) CollectLimit
Input [1]: [configurationVersion#51509]
Arguments: 1
(14) AdaptiveSparkPlan
Output [1]: [configurationVersion#51509]
Arguments: isFinalPlan=true