DC2 - Details for Query 19

Details for Query 19

Submitted Time: 2025/11/03 07:22:29
Duration: 25 s
Succeeded Jobs: 25 26 30
Show the Stage ID and Task ID that corresponds to the max metric
digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 7 shuffle write time total (min, med, max (stageId: taskId)) 4 ms (0 ms, 0 ms, 0 ms (stage 26.0: task 51)) records read: 7 local bytes read: 413.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 7 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 112.0 B (16.0 B, 16.0 B, 16.0 B (stage 26.0: task 57)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 413.0 B (59.0 B, 59.0 B, 59.0 B (stage 26.0: task 57))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.6 m (8.2 s, 24.8 s, 25.2 s (stage 26.0: task 53))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 2.6 m (8.2 s, 24.8 s, 25.2 s (stage 26.0: task 53)) number of output rows: 7"]; } 6 [labelType="html" label="BroadcastNestedLoopJoin number of output rows: 2,056,125,736"]; 7 [labelType="html" label="BroadcastExchange data size: 0.0 B time to collect: 41 ms time to build: 2 ms time to broadcast: 8 ms"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 5 ms"; 9 [labelType="html" label="ColumnarToRow number of output rows: 15,398 number of input batches: 4"]; } 10 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 478.2 KiB number of output rows: 15,398"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n2.6 m (8.2 s, 24.8 s, 25.2 s (stage 26.0: task 53))"; 12 [labelType="html" label="ColumnarToRow number of output rows: 133,532 number of input batches: 38"]; } 13 [labelType="html" label="Scan parquet number of files read: 7 scan time total (min, med, max (stageId: taskId)) 37 ms (2 ms, 6 ms, 8 ms (stage 26.0: task 53)) metadata time: 0 ms size of files read: 7.4 MiB number of output rows: 133,532"]; 2->0; 3->2; 5->3; 6->5; 7->6; 9->7; 10->9; 12->6; 13->12; }
AdaptiveSparkPlan isFinalPlan=true
HashAggregate(keys=[], functions=[count(1)])
WholeStageCodegen (4)
Exchange SinglePartition, true, [id=#674]
HashAggregate(keys=[], functions=[partial_count(1)])
WholeStageCodegen (3)
BroadcastNestedLoopJoin BuildLeft, Cross
BroadcastExchange IdentityBroadcastMode, [id=#635]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_PATIENT_21791], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>
ColumnarToRow
WholeStageCodegen (2)
FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>
Details
== Parsed Logical Plan ==
Aggregate [count(1) AS count#8786L]
+- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8639, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8640, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8641, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8642, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8643, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8644, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8645, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8646, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8647, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8648, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8649, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8650, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8651, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8652, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8653, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8654, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8655, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8656, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8657, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8658, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8659, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8660, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8661, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8662, ... 15 more fields]
   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 15 more fields]
      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 14 more fields]
         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 13 more fields]
            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 12 more fields]
               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 11 more fields]
                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 10 more fields]
                     +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 9 more fields]
                        +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 8 more fields]
                           +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 7 more fields]
                              +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 6 more fields]
                                 +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 5 more fields]
                                    +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 4 more fields]
                                       +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 3 more fields]
                                          +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 2 more fields]
                                             +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, str_if_with_rule((COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567 <=> COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576), cast(1 as string), cast(0 as string)) AS COL_78E288B2_7753_442C_B16A_E52F4C57C5CF#7614]
                                                +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7518 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7519 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7520 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7521 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7522 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7523 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7524 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7525 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7526 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7527 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7528 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7529 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7530 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7531 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7532 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7533 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7534 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7535 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7536 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7537 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7538 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7539 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7540 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7541 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589]
                                                   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7518, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7519, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7520, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7521, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7522, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7523, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7524, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7525, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7526, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7527, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7528, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7529, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7530, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7531, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7532, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7533, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7534, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7535, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7536, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7537, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7538, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7539, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7469 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7540, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7493 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7541]
                                                      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7469, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, cast(LEFT as string), cast(1 as bigint)) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7493]
                                                         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, cast(LEFT as string), cast(1 as bigint)) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7469]
                                                            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7381 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7382 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7383 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7384 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7385 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7386 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7387 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7388 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7389 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7390 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7391 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7392 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7393 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7394 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7395 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7396 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7397 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7398 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7399 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7400 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7401 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7402 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446]
                                                               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7237 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7381, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7238 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7382, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7239 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7383, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7240 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7384, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7241 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7385, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7242 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7386, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7243 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7387, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7244 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7388, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7245 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7389, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7246 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7390, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7347 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7391, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7348 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7392, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7349 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7393, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7350 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7394, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7351 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7395, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7352 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7396, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7353 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7397, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7354 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7398, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7355 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7399, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7356 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7400, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7357 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7401, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7358 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7402]
                                                                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7237, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7238, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7239, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7240, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7241, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7242, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7243, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7244, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7245, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7246, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7277 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7347, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7279 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7348, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7281 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7349, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7282 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7350, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7285 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7351, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7288 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7352, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7291 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7353, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7292 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7354, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7293 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7355, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7294 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7356, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7295 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7357, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7296 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7358]
                                                                     +- Join Cross
                                                                        :- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7217 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7237, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7218 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7238, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7219 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7239, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7220 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7240, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7221 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7241, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7222 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7242, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7223 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7243, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7224 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7244, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7225 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7245, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7226 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7246]
                                                                        :  +- Project [cast(BASE_PATIENT_21791_IPP_PATIENT_21792#7191 as string) AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7217, cast(BASE_PATIENT_21791_NOM_NAISSANCE_21793#7193 as string) AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7218, cast(BASE_PATIENT_21791_PRENOM_21794#7194 as string) AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7219, cast(BASE_PATIENT_21791_NOM_21795#7192 as string) AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7220, cast(BASE_PATIENT_21791_SEXE_21796#7195 as int) AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7221, cast(BASE_PATIENT_21791_DATENAISINT_21797#7190 as string) AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7222, cast(BASE_PATIENT_21791_CP_NAISSANCE_21798#7189 as string) AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7223, cast(BASE_PATIENT_21791_ADRESSE_21799#7187 as string) AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7224, cast(BASE_PATIENT_21791_CPO_21800#7188 as string) AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7225, cast(BASE_PATIENT_21791_VILLE_21801#7196 as string) AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7226]
                                                                        :     +- Project [ADRESSE_21799#7097 AS BASE_PATIENT_21791_ADRESSE_21799#7187, CPO_21800#7098 AS BASE_PATIENT_21791_CPO_21800#7188, CP_NAISSANCE_21798#7099 AS BASE_PATIENT_21791_CP_NAISSANCE_21798#7189, DATENAISINT_21797#7100 AS BASE_PATIENT_21791_DATENAISINT_21797#7190, IPP_PATIENT_21792#7101 AS BASE_PATIENT_21791_IPP_PATIENT_21792#7191, NOM_21795#7102 AS BASE_PATIENT_21791_NOM_21795#7192, NOM_NAISSANCE_21793#7103 AS BASE_PATIENT_21791_NOM_NAISSANCE_21793#7193, PRENOM_21794#7104 AS BASE_PATIENT_21791_PRENOM_21794#7194, SEXE_21796#7105 AS BASE_PATIENT_21791_SEXE_21796#7195, VILLE_21801#7106 AS BASE_PATIENT_21791_VILLE_21801#7196]
                                                                        :        +- SubqueryAlias BASE_PATIENT_21791118
                                                                        :           +- Relation[ADRESSE_21799#7097,CPO_21800#7098,CP_NAISSANCE_21798#7099,DATENAISINT_21797#7100,IPP_PATIENT_21792#7101,NOM_21795#7102,NOM_NAISSANCE_21793#7103,PRENOM_21794#7104,SEXE_21796#7105,VILLE_21801#7106] parquet
                                                                        +- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7127 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7277, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7128 AS BASE_INSEE_PERS_21802_COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7278, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7129 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7279, COL_E841813D_AC74_4154_9681_2401BF551CEB#7130 AS BASE_INSEE_PERS_21802_COL_E841813D_AC74_4154_9681_2401BF551CEB#7280, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7131 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7281, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7132 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7282, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7133 AS BASE_INSEE_PERS_21802_COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7283, COL_894EC6EE_C475_4057_9220_CD3490C6C246#7134 AS BASE_INSEE_PERS_21802_COL_894EC6EE_C475_4057_9220_CD3490C6C246#7284, COL_BE212348_11C6_412B_A80B_97C0091C8459#7135 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7285, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7136 AS BASE_INSEE_PERS_21802_COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7286, COL_B9C166B6_7C93_44BB_B249_608260D22E08#7137 AS BASE_INSEE_PERS_21802_COL_B9C166B6_7C93_44BB_B249_608260D22E08#7287, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7138 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7288, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7139 AS BASE_INSEE_PERS_21802_COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7289, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7140 AS BASE_INSEE_PERS_21802_COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7290, COL_043C0997_E848_48D4_A718_CB0593090678#7141 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7291, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7142 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7292, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7143 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7293, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7144 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7294, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7145 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7295, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7146 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7296]
                                                                           +- SubqueryAlias BASE_INSEE_PERS_21802118
                                                                              +- Relation[COL_6335C019_5574_4384_9DF0_52A3633FA003#7127,COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7128,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7129,COL_E841813D_AC74_4154_9681_2401BF551CEB#7130,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7131,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7132,COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7133,COL_894EC6EE_C475_4057_9220_CD3490C6C246#7134,COL_BE212348_11C6_412B_A80B_97C0091C8459#7135,COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7136,COL_B9C166B6_7C93_44BB_B249_608260D22E08#7137,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7138,COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7139,COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7140,COL_043C0997_E848_48D4_A718_CB0593090678#7141,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7142,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7143,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7144,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7145,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7146] parquet

== Analyzed Logical Plan ==
count: bigint
Aggregate [count(1) AS count#8786L]
+- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8639, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8640, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8641, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8642, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8643, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8644, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8645, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8646, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8647, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8648, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8649, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8650, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8651, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8652, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8653, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8654, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8655, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8656, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8657, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8658, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8659, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8660, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8661, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8662, ... 15 more fields]
   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 15 more fields]
      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 14 more fields]
         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 13 more fields]
            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 12 more fields]
               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 11 more fields]
                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 10 more fields]
                     +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 9 more fields]
                        +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 8 more fields]
                           +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 7 more fields]
                              +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 6 more fields]
                                 +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 5 more fields]
                                    +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 4 more fields]
                                       +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 3 more fields]
                                          +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, ... 2 more fields]
                                             +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589, str_if_with_rule((COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567 <=> COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576), cast(1 as string), cast(0 as string)) AS COL_78E288B2_7753_442C_B16A_E52F4C57C5CF#7614]
                                                +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7518 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7566, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7519 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7567, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7520 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7568, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7521 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7569, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7522 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7570, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7523 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7571, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7524 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7572, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7525 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7573, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7526 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7574, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7527 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7575, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7528 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7576, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7529 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7577, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7530 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7578, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7531 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7579, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7532 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7580, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7533 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7581, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7534 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7582, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7535 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7583, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7536 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7584, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7537 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7585, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7538 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7586, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7539 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7587, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7540 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7588, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7541 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7589]
                                                   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7518, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7519, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7520, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7521, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7522, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7523, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7524, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7525, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7526, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7527, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7528, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7529, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7530, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7531, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7532, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7533, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7534, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7535, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7536, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7537, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7538, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7539, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7469 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7540, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7493 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7541]
                                                      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7469, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, cast(LEFT as string), cast(1 as bigint)) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#7493]
                                                         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, cast(LEFT as string), cast(1 as bigint)) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#7469]
                                                            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7381 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7425, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7382 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7426, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7383 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7427, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7384 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7428, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7385 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7429, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7386 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7430, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7387 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7431, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7388 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7432, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7389 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7433, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7390 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7434, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7391 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7435, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7392 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7436, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7393 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7437, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7394 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7438, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7395 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7439, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7396 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7440, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7397 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7441, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7398 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7442, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7399 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7443, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7400 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7444, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7401 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7445, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7402 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7446]
                                                               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7237 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7381, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7238 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7382, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7239 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7383, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7240 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7384, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7241 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7385, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7242 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7386, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7243 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7387, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7244 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7388, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7245 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7389, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7246 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7390, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7347 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7391, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7348 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7392, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7349 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7393, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7350 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7394, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7351 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7395, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7352 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7396, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7353 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7397, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7354 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7398, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7355 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7399, COL_AD676D86_951F_4EAA_A649_D4EB88596605#7356 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7400, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7357 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7401, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7358 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7402]
                                                                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7237, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7238, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7239, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7240, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7241, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7242, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7243, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7244, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7245, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7246, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7277 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#7347, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7279 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#7348, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7281 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#7349, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7282 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#7350, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7285 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#7351, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7288 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#7352, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7291 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#7353, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7292 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#7354, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7293 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#7355, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7294 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#7356, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7295 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#7357, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7296 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#7358]
                                                                     +- Join Cross
                                                                        :- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7217 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7237, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7218 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7238, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7219 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7239, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7220 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7240, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7221 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7241, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7222 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7242, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7223 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7243, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7224 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7244, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7225 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7245, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7226 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7246]
                                                                        :  +- Project [cast(BASE_PATIENT_21791_IPP_PATIENT_21792#7191 as string) AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7217, cast(BASE_PATIENT_21791_NOM_NAISSANCE_21793#7193 as string) AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7218, cast(BASE_PATIENT_21791_PRENOM_21794#7194 as string) AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7219, cast(BASE_PATIENT_21791_NOM_21795#7192 as string) AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7220, cast(BASE_PATIENT_21791_SEXE_21796#7195 as int) AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7221, cast(BASE_PATIENT_21791_DATENAISINT_21797#7190 as string) AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7222, cast(BASE_PATIENT_21791_CP_NAISSANCE_21798#7189 as string) AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7223, cast(BASE_PATIENT_21791_ADRESSE_21799#7187 as string) AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7224, cast(BASE_PATIENT_21791_CPO_21800#7188 as string) AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7225, cast(BASE_PATIENT_21791_VILLE_21801#7196 as string) AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7226]
                                                                        :     +- Project [ADRESSE_21799#7097 AS BASE_PATIENT_21791_ADRESSE_21799#7187, CPO_21800#7098 AS BASE_PATIENT_21791_CPO_21800#7188, CP_NAISSANCE_21798#7099 AS BASE_PATIENT_21791_CP_NAISSANCE_21798#7189, DATENAISINT_21797#7100 AS BASE_PATIENT_21791_DATENAISINT_21797#7190, IPP_PATIENT_21792#7101 AS BASE_PATIENT_21791_IPP_PATIENT_21792#7191, NOM_21795#7102 AS BASE_PATIENT_21791_NOM_21795#7192, NOM_NAISSANCE_21793#7103 AS BASE_PATIENT_21791_NOM_NAISSANCE_21793#7193, PRENOM_21794#7104 AS BASE_PATIENT_21791_PRENOM_21794#7194, SEXE_21796#7105 AS BASE_PATIENT_21791_SEXE_21796#7195, VILLE_21801#7106 AS BASE_PATIENT_21791_VILLE_21801#7196]
                                                                        :        +- SubqueryAlias BASE_PATIENT_21791118
                                                                        :           +- Relation[ADRESSE_21799#7097,CPO_21800#7098,CP_NAISSANCE_21798#7099,DATENAISINT_21797#7100,IPP_PATIENT_21792#7101,NOM_21795#7102,NOM_NAISSANCE_21793#7103,PRENOM_21794#7104,SEXE_21796#7105,VILLE_21801#7106] parquet
                                                                        +- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7127 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7277, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7128 AS BASE_INSEE_PERS_21802_COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7278, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7129 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7279, COL_E841813D_AC74_4154_9681_2401BF551CEB#7130 AS BASE_INSEE_PERS_21802_COL_E841813D_AC74_4154_9681_2401BF551CEB#7280, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7131 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7281, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7132 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7282, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7133 AS BASE_INSEE_PERS_21802_COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7283, COL_894EC6EE_C475_4057_9220_CD3490C6C246#7134 AS BASE_INSEE_PERS_21802_COL_894EC6EE_C475_4057_9220_CD3490C6C246#7284, COL_BE212348_11C6_412B_A80B_97C0091C8459#7135 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7285, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7136 AS BASE_INSEE_PERS_21802_COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7286, COL_B9C166B6_7C93_44BB_B249_608260D22E08#7137 AS BASE_INSEE_PERS_21802_COL_B9C166B6_7C93_44BB_B249_608260D22E08#7287, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7138 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7288, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7139 AS BASE_INSEE_PERS_21802_COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7289, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7140 AS BASE_INSEE_PERS_21802_COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7290, COL_043C0997_E848_48D4_A718_CB0593090678#7141 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7291, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7142 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7292, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7143 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7293, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7144 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7294, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7145 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7295, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7146 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7296]
                                                                           +- SubqueryAlias BASE_INSEE_PERS_21802118
                                                                              +- Relation[COL_6335C019_5574_4384_9DF0_52A3633FA003#7127,COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7128,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7129,COL_E841813D_AC74_4154_9681_2401BF551CEB#7130,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7131,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7132,COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7133,COL_894EC6EE_C475_4057_9220_CD3490C6C246#7134,COL_BE212348_11C6_412B_A80B_97C0091C8459#7135,COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7136,COL_B9C166B6_7C93_44BB_B249_608260D22E08#7137,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7138,COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7139,COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7140,COL_043C0997_E848_48D4_A718_CB0593090678#7141,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7142,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7143,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7144,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7145,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7146] parquet

== Optimized Logical Plan ==
Aggregate [count(1) AS count#8786L]
+- Join Cross
   :- Project
   :  +- Relation[ADRESSE_21799#7097,CPO_21800#7098,CP_NAISSANCE_21798#7099,DATENAISINT_21797#7100,IPP_PATIENT_21792#7101,NOM_21795#7102,NOM_NAISSANCE_21793#7103,PRENOM_21794#7104,SEXE_21796#7105,VILLE_21801#7106] parquet
   +- Project
      +- Relation[COL_6335C019_5574_4384_9DF0_52A3633FA003#7127,COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7128,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7129,COL_E841813D_AC74_4154_9681_2401BF551CEB#7130,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7131,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7132,COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7133,COL_894EC6EE_C475_4057_9220_CD3490C6C246#7134,COL_BE212348_11C6_412B_A80B_97C0091C8459#7135,COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7136,COL_B9C166B6_7C93_44BB_B249_608260D22E08#7137,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7138,COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7139,COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7140,COL_043C0997_E848_48D4_A718_CB0593090678#7141,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7142,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7143,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7144,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7145,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7146] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- *(4) HashAggregate(keys=[], functions=[count(1)], output=[count#8786L])
   +- ShuffleQueryStage 1
      +- Exchange SinglePartition, true, [id=#674]
         +- *(3) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#8879L])
            +- BroadcastNestedLoopJoin BuildLeft, Cross
               :- BroadcastQueryStage 0
               :  +- BroadcastExchange IdentityBroadcastMode, [id=#635]
               :     +- *(1) ColumnarToRow
               :        +- FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_PATIENT_21791], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>
               +- *(2) ColumnarToRow
                  +- FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>