== Physical Plan ==
AppendData (14)
+- AdaptiveSparkPlan (13)
+- == Final Plan ==
ResultQueryStage (9), Statistics(sizeInBytes=8.0 EiB)
+- * Project (8)
+- * BroadcastNestedLoopJoin Cross BuildRight (7)
:- * Project (2)
: +- * Range (1)
+- BroadcastQueryStage (6), Statistics(sizeInBytes=0.0 B, rowCount=1.00E+3)
+- BroadcastExchange (5)
+- * Project (4)
+- * Range (3)
+- == Initial Plan ==
Project (12)
+- BroadcastNestedLoopJoin Cross BuildRight (11)
:- Project (2)
: +- Range (1)
+- BroadcastExchange (10)
+- Project (4)
+- Range (3)
(1) Range [codegen id : 2]
Output [1]: [id#140L]
Arguments: Range (0, 1000, step=1)
(2) Project [codegen id : 2]
Output [4]: [id#140L AS raw_id#141L, uuid(Some(-8494042533888377216)) AS session_id#142, cast((rand(-1344500920868723772) * 10000.0) as int) AS category_id#143, CASE WHEN (rand(-8306668123157099645) > 0.5) THEN ACTIVE ELSE INACTIVE END AS status#144]
Input [1]: [id#140L]
(3) Range [codegen id : 1]
Output [1]: [id#146L]
Arguments: Range (0, 1000, step=1)
(4) Project [codegen id : 1]
Output: []
Input [1]: [id#146L]
(5) BroadcastExchange
Input: []
Arguments: IdentityBroadcastMode, [plan_id=178]
(6) BroadcastQueryStage
Output: []
Arguments: 0
(7) BroadcastNestedLoopJoin [codegen id : 2]
Join type: Cross
Join condition: None
(8) Project [codegen id : 2]
Output [8]: [raw_id#141L, session_id#142, sha2(cast(concat(cast(raw_id#141L as string), session_id#142) as binary), 256) AS record_hash#103, sha2(cast(reverse(session_id#142) as binary), 512) AS security_token#104, category_id#143, status#144, 2026-05-11 04:34:40.996605 AS ts#117, repeat(sha2(cast(cast(raw_id#141L as string) as binary), 256), 5) AS padding_data#105]
Input [4]: [raw_id#141L, session_id#142, category_id#143, status#144]
(9) ResultQueryStage
Output [8]: [raw_id#141L, session_id#142, record_hash#103, security_token#104, category_id#143, status#144, ts#117, padding_data#105]
Arguments: 1
(10) BroadcastExchange
Input: []
Arguments: IdentityBroadcastMode, [plan_id=170]
(11) BroadcastNestedLoopJoin
Join type: Cross
Join condition: None
(12) Project
Output [8]: [raw_id#141L, session_id#142, sha2(cast(concat(cast(raw_id#141L as string), session_id#142) as binary), 256) AS record_hash#103, sha2(cast(reverse(session_id#142) as binary), 512) AS security_token#104, category_id#143, status#144, 2026-05-11 04:34:40.996605 AS ts#117, repeat(sha2(cast(cast(raw_id#141L as string) as binary), 256), 5) AS padding_data#105]
Input [4]: [raw_id#141L, session_id#142, category_id#143, status#144]
(13) AdaptiveSparkPlan
Output [8]: [raw_id#141L, session_id#142, record_hash#103, security_token#104, category_id#143, status#144, ts#117, padding_data#105]
Arguments: isFinalPlan=true
(14) AppendData
Input [8]: [raw_id#141L, session_id#142, record_hash#103, security_token#104, category_id#143, status#144, ts#117, padding_data#105]