crp-order-qty-opt-service - Details for Query 38111

Submitted Time: 2026/09/01 14:15:10
Duration: 1.7 min
Succeeded Jobs: 52677 52710 52711
Failed Jobs: 52752

Plan Visualization

Show the Stage ID and Task ID that corresponds to the max metric

Details

== Physical Plan ==
* ColumnarToRow (2)
+- Scan parquet  (1)


(1) Scan parquet 
Output [7]: [shardId#10205520, worklistShardItemId#10205521L, version#10205522, qty#10205523, demandChannel#10205524, demandStream#10205525, kpis#10205526]
Batched: true
Location: TahoeBatchFileIndex [hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/out/kpi-curve-update/10000000540/stream-10000000540-2]
ReadSchema: struct<shardId:string,worklistShardItemId:bigint,version:int,qty:double,demandChannel:string,demandStream:string,kpis:array<struct<label:string,dateTime:timestamp,value:double>>>

(2) ColumnarToRow [codegen id : 1]
Input [7]: [shardId#10205520, worklistShardItemId#10205521L, version#10205522, qty#10205523, demandChannel#10205524, demandStream#10205525, kpis#10205526]

SQL / DataFrame Properties

Name	Value
spark.activity.clearDeltaLogCache	false
spark.activity.clearSqlCache	false
spark.activity.hdlfsEnabled	true
spark.activity.isolateSession	true
spark.databricks.delta.lastCommitVersionInSession	57
spark.sql.adaptive.enabled	false
spark.sql.cbo.enabled	false
spark.sql.optimizer.pruneFiltersCanPruneStreamingSubplan	false
spark.sql.parquet.fieldId.read.enabled	true
spark.sql.parquet.fieldId.write.enabled	true
spark.sql.requireAllClusterKeysForDistribution	false
spark.sql.shuffle.partitions	30
spark.sql.streaming.aggregation.stateFormatVersion	2
spark.sql.streaming.flatMapGroupsWithState.stateFormatVersion	2
spark.sql.streaming.join.stateFormatVersion	2
spark.sql.streaming.multipleWatermarkPolicy	min
spark.sql.streaming.stateStore.compression.codec	lz4
spark.sql.streaming.stateStore.encodingFormat	unsaferow
spark.sql.streaming.stateStore.providerClass	org.apache.spark.sql.execution.streaming.state.HDFSBackedStateStoreProvider
spark.sql.streaming.stateStore.rocksdb.formatVersion	5
spark.sql.streaming.statefulOperator.useStrictDistribution	true
temporal.activity.id	00d3eb0a-adfc-38e7-9c66-6b5de73f4f90
temporal.activity.type	RunStreamWithId