DC2 - Details for Query 9

Details for Query 9

Submitted Time: 2026/03/05 07:13:21
Duration: 0.4 s
Succeeded Jobs: 13 15 16

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n24 ms (3 ms, 4 ms, 17 ms (stage 24.0: task 75))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 1 ms (stage 24.0: task 76)) peak memory total (min, med, max (stageId: taskId)) 64.8 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 24.0: task 76)) number of output rows: 1 avg hash probe bucket list iters: 1"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 7 shuffle write time total (min, med, max (stageId: taskId)) 58 ms (3 ms, 5 ms, 21 ms (stage 19.0: task 64)) records read: 7 local bytes read: 434.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)) 168.0 B (24.0 B, 24.0 B, 24.0 B (stage 19.0: task 69)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 434.0 B (62.0 B, 62.0 B, 62.0 B (stage 19.0: task 69))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n291 ms (25 ms, 36 ms, 65 ms (stage 19.0: task 63))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 172 ms (14 ms, 21 ms, 57 ms (stage 19.0: task 63)) peak memory total (min, med, max (stageId: taskId)) 1792.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 19.0: task 69)) number of output rows: 7 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="ColumnarToRow number of output rows: 5,372 number of input batches: 13"]; } 10 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 142 ms (10 ms, 16 ms, 51 ms (stage 19.0: task 63)) metadata time: 13 ms size of files read: 797.5 KiB number of output rows: 5,372"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

HashAggregate(keys=[COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], functions=[count(1)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195, 200), true, [id=#335]

HashAggregate(keys=[COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], functions=[partial_count(1)])

Project [str_create() AS COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/SIREN_BI_BRUTE_39629], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2488L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2492L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2489 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2493]
      +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2430L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2488L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2431 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2489]
         +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2426L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2430L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2427 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2431]
            +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2422L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2426L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2423 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2427]
               +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2361L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2422L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2277 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2423]
                  +- Project [COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2277, COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2361L]
                     +- Aggregate [COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], [COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2277, 1 AS NULL_1#2362, count(1) AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2361L]
                        +- Project [COL_8FAB150E_B4CB_4729_A8A0_C55AD21D385B#2009, COL_9FEB7712_4D93_4591_A11D_E174757A0C1B#2010, COL_0099BDA8_2867_45BA_AD58_BA0791D8DE16#2011, COL_226C9244_30C1_4129_8CB7_5B91A4904B3C#2012, COL_2683185C_E2C2_4143_8218_D71427B08891#2013, COL_4C45AE63_A224_4D0B_BB19_1763D95BA99C#2014, COL_274D6F00_F6F3_4B9E_94A3_BED9AA11CA9E#2015, COL_0CED7BEB_8DDF_486B_99F9_BDBE9F5E149E#2016, COL_A3F75F38_4E92_4FA0_B864_D412C99571DB#2017, COL_461D25BD_FDF8_490B_A5F7_245F4F005D2F#2018, COL_85CF9A7D_2432_415F_9EA3_236FA2FD3737#2019, COL_210F1335_3124_4326_9954_DF3F99085F8B#2020, COL_BBD0CB3A_C129_464E_84E9_D44658C1C749#2021, COL_F384F49E_99A6_4837_8CDB_9F269628E04A#2022, COL_29DF05F1_5D81_4DAD_85A8_1C3D9EF1457E#2023, COL_DEA384E0_B0E2_4689_920F_0462E9656C4F#2024, COL_01FBC062_BB38_4EF1_80AE_63F2379CFDB1#2025, COL_3C153283_4D49_4173_BD2C_B813E2703BC3#2026, COL_3F63F97D_D8F2_4C16_9344_42712BB0AA3F#2027, COL_EA21019A_5171_4A34_A7AB_1DF63D751411#2028, COL_6F85C36A_034B_4117_AB7E_C7CB5574E4F4#2029, COL_5707EA3E_8082_4DA2_B8F1_7A76698CDE91#2030, COL_DB89BE78_6FB1_420B_A603_B3DB224AD207#2031, COL_67E4689D_5FA0_427E_A2C0_55C07377B6C4#2032, ... 3 more fields]
                           +- Project [COL_8FAB150E_B4CB_4729_A8A0_C55AD21D385B#2009, COL_9FEB7712_4D93_4591_A11D_E174757A0C1B#2010, COL_0099BDA8_2867_45BA_AD58_BA0791D8DE16#2011, COL_226C9244_30C1_4129_8CB7_5B91A4904B3C#2012, COL_2683185C_E2C2_4143_8218_D71427B08891#2013, COL_4C45AE63_A224_4D0B_BB19_1763D95BA99C#2014, COL_274D6F00_F6F3_4B9E_94A3_BED9AA11CA9E#2015, COL_0CED7BEB_8DDF_486B_99F9_BDBE9F5E149E#2016, COL_A3F75F38_4E92_4FA0_B864_D412C99571DB#2017, COL_461D25BD_FDF8_490B_A5F7_245F4F005D2F#2018, COL_85CF9A7D_2432_415F_9EA3_236FA2FD3737#2019, COL_210F1335_3124_4326_9954_DF3F99085F8B#2020, COL_BBD0CB3A_C129_464E_84E9_D44658C1C749#2021, COL_F384F49E_99A6_4837_8CDB_9F269628E04A#2022, COL_29DF05F1_5D81_4DAD_85A8_1C3D9EF1457E#2023, COL_DEA384E0_B0E2_4689_920F_0462E9656C4F#2024, COL_01FBC062_BB38_4EF1_80AE_63F2379CFDB1#2025, COL_3C153283_4D49_4173_BD2C_B813E2703BC3#2026, COL_3F63F97D_D8F2_4C16_9344_42712BB0AA3F#2027, COL_EA21019A_5171_4A34_A7AB_1DF63D751411#2028, COL_6F85C36A_034B_4117_AB7E_C7CB5574E4F4#2029, COL_5707EA3E_8082_4DA2_B8F1_7A76698CDE91#2030, COL_DB89BE78_6FB1_420B_A603_B3DB224AD207#2031, COL_67E4689D_5FA0_427E_A2C0_55C07377B6C4#2032, ... 2 more fields]
                              +- Project [cast(SIREN_BI_BRUTE_39629_COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1842 as string) AS COL_8FAB150E_B4CB_4729_A8A0_C55AD21D385B#2009, cast(SIREN_BI_BRUTE_39629_COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1843 as string) AS COL_9FEB7712_4D93_4591_A11D_E174757A0C1B#2010, cast(SIREN_BI_BRUTE_39629_COL_77E6C77B_3354_4507_894C_98722A687570#1844 as string) AS COL_0099BDA8_2867_45BA_AD58_BA0791D8DE16#2011, cast(SIREN_BI_BRUTE_39629_COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1845 as string) AS COL_226C9244_30C1_4129_8CB7_5B91A4904B3C#2012, cast(SIREN_BI_BRUTE_39629_COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1846 as string) AS COL_2683185C_E2C2_4143_8218_D71427B08891#2013, cast(SIREN_BI_BRUTE_39629_COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1847 as string) AS COL_4C45AE63_A224_4D0B_BB19_1763D95BA99C#2014, cast(SIREN_BI_BRUTE_39629_COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1848 as string) AS COL_274D6F00_F6F3_4B9E_94A3_BED9AA11CA9E#2015, cast(SIREN_BI_BRUTE_39629_COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1849 as string) AS COL_0CED7BEB_8DDF_486B_99F9_BDBE9F5E149E#2016, cast(SIREN_BI_BRUTE_39629_COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1850 as string) AS COL_A3F75F38_4E92_4FA0_B864_D412C99571DB#2017, cast(SIREN_BI_BRUTE_39629_COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1851 as string) AS COL_461D25BD_FDF8_490B_A5F7_245F4F005D2F#2018, cast(SIREN_BI_BRUTE_39629_COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1852 as string) AS COL_85CF9A7D_2432_415F_9EA3_236FA2FD3737#2019, cast(SIREN_BI_BRUTE_39629_COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1853 as string) AS COL_210F1335_3124_4326_9954_DF3F99085F8B#2020, cast(SIREN_BI_BRUTE_39629_COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1854 as string) AS COL_BBD0CB3A_C129_464E_84E9_D44658C1C749#2021, cast(SIREN_BI_BRUTE_39629_COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1855 as string) AS COL_F384F49E_99A6_4837_8CDB_9F269628E04A#2022, cast(SIREN_BI_BRUTE_39629_COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1856 as string) AS COL_29DF05F1_5D81_4DAD_85A8_1C3D9EF1457E#2023, cast(SIREN_BI_BRUTE_39629_COL_59431422_9393_436F_B5D2_9F45BC721D8A#1857 as string) AS COL_DEA384E0_B0E2_4689_920F_0462E9656C4F#2024, cast(SIREN_BI_BRUTE_39629_COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1858 as string) AS COL_01FBC062_BB38_4EF1_80AE_63F2379CFDB1#2025, cast(SIREN_BI_BRUTE_39629_COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1859 as string) AS COL_3C153283_4D49_4173_BD2C_B813E2703BC3#2026, cast(SIREN_BI_BRUTE_39629_COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1860 as string) AS COL_3F63F97D_D8F2_4C16_9344_42712BB0AA3F#2027, cast(SIREN_BI_BRUTE_39629_COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1861 as string) AS COL_EA21019A_5171_4A34_A7AB_1DF63D751411#2028, cast(SIREN_BI_BRUTE_39629_COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1862 as string) AS COL_6F85C36A_034B_4117_AB7E_C7CB5574E4F4#2029, cast(SIREN_BI_BRUTE_39629_COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1863 as string) AS COL_5707EA3E_8082_4DA2_B8F1_7A76698CDE91#2030, cast(SIREN_BI_BRUTE_39629_COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1864 as string) AS COL_DB89BE78_6FB1_420B_A603_B3DB224AD207#2031, cast(SIREN_BI_BRUTE_39629_COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1865 as string) AS COL_67E4689D_5FA0_427E_A2C0_55C07377B6C4#2032, ... 2 more fields]
                                 +- Project [COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1697 AS SIREN_BI_BRUTE_39629_COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1842, COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1698 AS SIREN_BI_BRUTE_39629_COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1843, COL_77E6C77B_3354_4507_894C_98722A687570#1699 AS SIREN_BI_BRUTE_39629_COL_77E6C77B_3354_4507_894C_98722A687570#1844, COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1700 AS SIREN_BI_BRUTE_39629_COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1845, COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1701 AS SIREN_BI_BRUTE_39629_COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1846, COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1702 AS SIREN_BI_BRUTE_39629_COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1847, COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1703 AS SIREN_BI_BRUTE_39629_COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1848, COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1704 AS SIREN_BI_BRUTE_39629_COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1849, COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1705 AS SIREN_BI_BRUTE_39629_COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1850, COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1706 AS SIREN_BI_BRUTE_39629_COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1851, COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1707 AS SIREN_BI_BRUTE_39629_COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1852, COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1708 AS SIREN_BI_BRUTE_39629_COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1853, COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1709 AS SIREN_BI_BRUTE_39629_COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1854, COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1710 AS SIREN_BI_BRUTE_39629_COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1855, COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1711 AS SIREN_BI_BRUTE_39629_COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1856, COL_59431422_9393_436F_B5D2_9F45BC721D8A#1712 AS SIREN_BI_BRUTE_39629_COL_59431422_9393_436F_B5D2_9F45BC721D8A#1857, COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1713 AS SIREN_BI_BRUTE_39629_COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1858, COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1714 AS SIREN_BI_BRUTE_39629_COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1859, COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1715 AS SIREN_BI_BRUTE_39629_COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1860, COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1716 AS SIREN_BI_BRUTE_39629_COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1861, COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1717 AS SIREN_BI_BRUTE_39629_COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1862, COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1718 AS SIREN_BI_BRUTE_39629_COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1863, COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1719 AS SIREN_BI_BRUTE_39629_COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1864, COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1720 AS SIREN_BI_BRUTE_39629_COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1865, ... 5 more fields]
                                    +- SubqueryAlias SIREN_BI_BRUTE_39629114
                                       +- Relation[COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1697,COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1698,COL_77E6C77B_3354_4507_894C_98722A687570#1699,COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1700,COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1701,COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1702,COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1703,COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1704,COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1705,COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1706,COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1707,COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1708,COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1709,COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1710,COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1711,COL_59431422_9393_436F_B5D2_9F45BC721D8A#1712,COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1713,COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1714,COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1715,COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1716,COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1717,COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1718,COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1719,COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1720,... 5 more fields] parquet

== Analyzed Logical Plan ==
COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93: bigint, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2488L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2492L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2489 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2493]
      +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2430L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2488L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2431 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2489]
         +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2426L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2430L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2427 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2431]
            +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2422L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2426L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2423 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2427]
               +- Project [COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2361L AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2422L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2277 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2423]
                  +- Project [COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2277, COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2361L]
                     +- Aggregate [COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], [COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2277, 1 AS NULL_1#2362, count(1) AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2361L]
                        +- Project [COL_8FAB150E_B4CB_4729_A8A0_C55AD21D385B#2009, COL_9FEB7712_4D93_4591_A11D_E174757A0C1B#2010, COL_0099BDA8_2867_45BA_AD58_BA0791D8DE16#2011, COL_226C9244_30C1_4129_8CB7_5B91A4904B3C#2012, COL_2683185C_E2C2_4143_8218_D71427B08891#2013, COL_4C45AE63_A224_4D0B_BB19_1763D95BA99C#2014, COL_274D6F00_F6F3_4B9E_94A3_BED9AA11CA9E#2015, COL_0CED7BEB_8DDF_486B_99F9_BDBE9F5E149E#2016, COL_A3F75F38_4E92_4FA0_B864_D412C99571DB#2017, COL_461D25BD_FDF8_490B_A5F7_245F4F005D2F#2018, COL_85CF9A7D_2432_415F_9EA3_236FA2FD3737#2019, COL_210F1335_3124_4326_9954_DF3F99085F8B#2020, COL_BBD0CB3A_C129_464E_84E9_D44658C1C749#2021, COL_F384F49E_99A6_4837_8CDB_9F269628E04A#2022, COL_29DF05F1_5D81_4DAD_85A8_1C3D9EF1457E#2023, COL_DEA384E0_B0E2_4689_920F_0462E9656C4F#2024, COL_01FBC062_BB38_4EF1_80AE_63F2379CFDB1#2025, COL_3C153283_4D49_4173_BD2C_B813E2703BC3#2026, COL_3F63F97D_D8F2_4C16_9344_42712BB0AA3F#2027, COL_EA21019A_5171_4A34_A7AB_1DF63D751411#2028, COL_6F85C36A_034B_4117_AB7E_C7CB5574E4F4#2029, COL_5707EA3E_8082_4DA2_B8F1_7A76698CDE91#2030, COL_DB89BE78_6FB1_420B_A603_B3DB224AD207#2031, COL_67E4689D_5FA0_427E_A2C0_55C07377B6C4#2032, ... 3 more fields]
                           +- Project [COL_8FAB150E_B4CB_4729_A8A0_C55AD21D385B#2009, COL_9FEB7712_4D93_4591_A11D_E174757A0C1B#2010, COL_0099BDA8_2867_45BA_AD58_BA0791D8DE16#2011, COL_226C9244_30C1_4129_8CB7_5B91A4904B3C#2012, COL_2683185C_E2C2_4143_8218_D71427B08891#2013, COL_4C45AE63_A224_4D0B_BB19_1763D95BA99C#2014, COL_274D6F00_F6F3_4B9E_94A3_BED9AA11CA9E#2015, COL_0CED7BEB_8DDF_486B_99F9_BDBE9F5E149E#2016, COL_A3F75F38_4E92_4FA0_B864_D412C99571DB#2017, COL_461D25BD_FDF8_490B_A5F7_245F4F005D2F#2018, COL_85CF9A7D_2432_415F_9EA3_236FA2FD3737#2019, COL_210F1335_3124_4326_9954_DF3F99085F8B#2020, COL_BBD0CB3A_C129_464E_84E9_D44658C1C749#2021, COL_F384F49E_99A6_4837_8CDB_9F269628E04A#2022, COL_29DF05F1_5D81_4DAD_85A8_1C3D9EF1457E#2023, COL_DEA384E0_B0E2_4689_920F_0462E9656C4F#2024, COL_01FBC062_BB38_4EF1_80AE_63F2379CFDB1#2025, COL_3C153283_4D49_4173_BD2C_B813E2703BC3#2026, COL_3F63F97D_D8F2_4C16_9344_42712BB0AA3F#2027, COL_EA21019A_5171_4A34_A7AB_1DF63D751411#2028, COL_6F85C36A_034B_4117_AB7E_C7CB5574E4F4#2029, COL_5707EA3E_8082_4DA2_B8F1_7A76698CDE91#2030, COL_DB89BE78_6FB1_420B_A603_B3DB224AD207#2031, COL_67E4689D_5FA0_427E_A2C0_55C07377B6C4#2032, ... 2 more fields]
                              +- Project [cast(SIREN_BI_BRUTE_39629_COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1842 as string) AS COL_8FAB150E_B4CB_4729_A8A0_C55AD21D385B#2009, cast(SIREN_BI_BRUTE_39629_COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1843 as string) AS COL_9FEB7712_4D93_4591_A11D_E174757A0C1B#2010, cast(SIREN_BI_BRUTE_39629_COL_77E6C77B_3354_4507_894C_98722A687570#1844 as string) AS COL_0099BDA8_2867_45BA_AD58_BA0791D8DE16#2011, cast(SIREN_BI_BRUTE_39629_COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1845 as string) AS COL_226C9244_30C1_4129_8CB7_5B91A4904B3C#2012, cast(SIREN_BI_BRUTE_39629_COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1846 as string) AS COL_2683185C_E2C2_4143_8218_D71427B08891#2013, cast(SIREN_BI_BRUTE_39629_COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1847 as string) AS COL_4C45AE63_A224_4D0B_BB19_1763D95BA99C#2014, cast(SIREN_BI_BRUTE_39629_COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1848 as string) AS COL_274D6F00_F6F3_4B9E_94A3_BED9AA11CA9E#2015, cast(SIREN_BI_BRUTE_39629_COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1849 as string) AS COL_0CED7BEB_8DDF_486B_99F9_BDBE9F5E149E#2016, cast(SIREN_BI_BRUTE_39629_COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1850 as string) AS COL_A3F75F38_4E92_4FA0_B864_D412C99571DB#2017, cast(SIREN_BI_BRUTE_39629_COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1851 as string) AS COL_461D25BD_FDF8_490B_A5F7_245F4F005D2F#2018, cast(SIREN_BI_BRUTE_39629_COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1852 as string) AS COL_85CF9A7D_2432_415F_9EA3_236FA2FD3737#2019, cast(SIREN_BI_BRUTE_39629_COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1853 as string) AS COL_210F1335_3124_4326_9954_DF3F99085F8B#2020, cast(SIREN_BI_BRUTE_39629_COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1854 as string) AS COL_BBD0CB3A_C129_464E_84E9_D44658C1C749#2021, cast(SIREN_BI_BRUTE_39629_COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1855 as string) AS COL_F384F49E_99A6_4837_8CDB_9F269628E04A#2022, cast(SIREN_BI_BRUTE_39629_COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1856 as string) AS COL_29DF05F1_5D81_4DAD_85A8_1C3D9EF1457E#2023, cast(SIREN_BI_BRUTE_39629_COL_59431422_9393_436F_B5D2_9F45BC721D8A#1857 as string) AS COL_DEA384E0_B0E2_4689_920F_0462E9656C4F#2024, cast(SIREN_BI_BRUTE_39629_COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1858 as string) AS COL_01FBC062_BB38_4EF1_80AE_63F2379CFDB1#2025, cast(SIREN_BI_BRUTE_39629_COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1859 as string) AS COL_3C153283_4D49_4173_BD2C_B813E2703BC3#2026, cast(SIREN_BI_BRUTE_39629_COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1860 as string) AS COL_3F63F97D_D8F2_4C16_9344_42712BB0AA3F#2027, cast(SIREN_BI_BRUTE_39629_COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1861 as string) AS COL_EA21019A_5171_4A34_A7AB_1DF63D751411#2028, cast(SIREN_BI_BRUTE_39629_COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1862 as string) AS COL_6F85C36A_034B_4117_AB7E_C7CB5574E4F4#2029, cast(SIREN_BI_BRUTE_39629_COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1863 as string) AS COL_5707EA3E_8082_4DA2_B8F1_7A76698CDE91#2030, cast(SIREN_BI_BRUTE_39629_COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1864 as string) AS COL_DB89BE78_6FB1_420B_A603_B3DB224AD207#2031, cast(SIREN_BI_BRUTE_39629_COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1865 as string) AS COL_67E4689D_5FA0_427E_A2C0_55C07377B6C4#2032, ... 2 more fields]
                                 +- Project [COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1697 AS SIREN_BI_BRUTE_39629_COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1842, COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1698 AS SIREN_BI_BRUTE_39629_COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1843, COL_77E6C77B_3354_4507_894C_98722A687570#1699 AS SIREN_BI_BRUTE_39629_COL_77E6C77B_3354_4507_894C_98722A687570#1844, COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1700 AS SIREN_BI_BRUTE_39629_COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1845, COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1701 AS SIREN_BI_BRUTE_39629_COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1846, COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1702 AS SIREN_BI_BRUTE_39629_COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1847, COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1703 AS SIREN_BI_BRUTE_39629_COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1848, COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1704 AS SIREN_BI_BRUTE_39629_COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1849, COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1705 AS SIREN_BI_BRUTE_39629_COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1850, COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1706 AS SIREN_BI_BRUTE_39629_COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1851, COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1707 AS SIREN_BI_BRUTE_39629_COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1852, COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1708 AS SIREN_BI_BRUTE_39629_COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1853, COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1709 AS SIREN_BI_BRUTE_39629_COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1854, COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1710 AS SIREN_BI_BRUTE_39629_COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1855, COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1711 AS SIREN_BI_BRUTE_39629_COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1856, COL_59431422_9393_436F_B5D2_9F45BC721D8A#1712 AS SIREN_BI_BRUTE_39629_COL_59431422_9393_436F_B5D2_9F45BC721D8A#1857, COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1713 AS SIREN_BI_BRUTE_39629_COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1858, COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1714 AS SIREN_BI_BRUTE_39629_COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1859, COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1715 AS SIREN_BI_BRUTE_39629_COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1860, COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1716 AS SIREN_BI_BRUTE_39629_COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1861, COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1717 AS SIREN_BI_BRUTE_39629_COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1862, COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1718 AS SIREN_BI_BRUTE_39629_COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1863, COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1719 AS SIREN_BI_BRUTE_39629_COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1864, COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1720 AS SIREN_BI_BRUTE_39629_COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1865, ... 5 more fields]
                                    +- SubqueryAlias SIREN_BI_BRUTE_39629114
                                       +- Relation[COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1697,COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1698,COL_77E6C77B_3354_4507_894C_98722A687570#1699,COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1700,COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1701,COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1702,COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1703,COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1704,COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1705,COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1706,COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1707,COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1708,COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1709,COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1710,COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1711,COL_59431422_9393_436F_B5D2_9F45BC721D8A#1712,COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1713,COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1714,COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1715,COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1716,COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1717,COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1718,COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1719,COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1720,... 5 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], [count(1) AS COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2492L, COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195 AS COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2493]
      +- Project [str_create() AS COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195]
         +- Relation[COL_DA8638AB_B0B7_409E_A516_228A453C6FA5#1697,COL_3EEB4206_2D95_4CF7_B5FF_5D3B913B77A1#1698,COL_77E6C77B_3354_4507_894C_98722A687570#1699,COL_3E6980F0_01FB_4C4E_ACC9_1D4C21DCCA9C#1700,COL_FEB98131_2AFA_452A_861D_9CC2B4571D5C#1701,COL_15824F31_C57F_4F40_B7E6_CE8E6AEB2404#1702,COL_E07AA980_E700_4285_B797_F2A6AF9BCB71#1703,COL_C514133E_31A2_494A_A46F_0B14ACC71EF6#1704,COL_CA7063DE_1935_4BFD_A468_29818B13AEEA#1705,COL_6E6B488E_76CD_4707_9F32_39F2A93435F4#1706,COL_ED2D0632_29B4_4297_BCF4_4F50CBBD84E5#1707,COL_DCA54FEE_336D_46F5_89F5_4C15C6DBAA98#1708,COL_FE1DD44B_468F_4884_980E_B77EFFD0C95C#1709,COL_208B3C56_DBC8_4FE1_B9B0_0E27130A9515#1710,COL_6075F498_E72F_47DC_B65B_CAF4F1BD345E#1711,COL_59431422_9393_436F_B5D2_9F45BC721D8A#1712,COL_CD65F9B2_4C01_4B30_B24B_A5208B1711A5#1713,COL_2B895B19_B3A9_4755_A464_1B7391E17A07#1714,COL_943D7AD8_30F2_43AE_AC8D_2E5F5ADF16C6#1715,COL_574AF51C_6B94_4EDF_B753_CD74357CDF37#1716,COL_A0B8287A_E5AE_4AFE_B1ED_B8095F2CE27F#1717,COL_538FFE35_D4E1_4988_A08F_3EC76F4F8600#1718,COL_2F0FAE3C_110B_4C81_BE46_C603D814CED3#1719,COL_528978CB_8971_4DD8_A7BB_C2E7EBD94CA5#1720,... 5 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(2) HashAggregate(keys=[COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], functions=[count(1)], output=[COL_DF8ECE43_D480_4C09_BFAF_8E4110B0AB93#2492L, COL_085F5CF1_8821_441C_B2F7_3D02BE119F4E#2493])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195, 200), true, [id=#335]
               +- *(1) HashAggregate(keys=[COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195], functions=[partial_count(1)], output=[COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195, count#2524L])
                  +- *(1) Project [str_create() AS COL_5FDAED70_8FBC_4B75_8B40_C544FBF614AE#2195]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/SIREN_BI_BRUTE_39629], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>