DC2 - Details for Query 99

Details for Query 99

Submitted Time: 2026/04/29 06:33:16
Duration: 0.3 s
Succeeded Jobs: 162 163 165

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n76 ms (6 ms, 10 ms, 16 ms (stage 253.0: task 777))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 4,409 number of input batches: 13"]; } 4 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 60 ms (5 ms, 7 ms, 14 ms (stage 255.0: task 790)) metadata time: 0 ms size of files read: 161.9 KiB number of output rows: 4,409"]; 2->0; 3->2; 4->3; }

CollectLimit 500000

Project [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/DAILY_HISTORIC__37809], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_137A124D_FB08_424F_888F_EF6BCC8806EC:timestamp,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24759 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24773, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24760 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24774, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24761 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24775, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24762 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24776, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24763 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24777, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24764 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24778, COL_40A87F78_1125_4622_A64B_0CD24444A630#24765 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24779]
         +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24741 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24759, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24742 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24760, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24743 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24761, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24744 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24762, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24745 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24763, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24746 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24764, COL_40A87F78_1125_4622_A64B_0CD24444A630#24747 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24765]
            +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24719 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24741, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24720 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24742, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24721 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24743, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24722 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24744, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24723 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24745, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24724 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24746, COL_40A87F78_1125_4622_A64B_0CD24444A630#24725 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24747]
               +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24697 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24719, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24698 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24720, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24699 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24721, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24700 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24722, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24701 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24723, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24702 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24724, COL_40A87F78_1125_4622_A64B_0CD24444A630#24703 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24725]
                  +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24697, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24698, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24699, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24700, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24701, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24702, COL_40A87F78_1125_4622_A64B_0CD24444A630#24650 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24703]
                     +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]
                        +- Filter true
                           +- Project [cast(DAILY_HISTORIC__37809_COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24423 as timestamp) AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, cast(DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24424 as double) AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, cast(DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24425 as double) AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, cast(DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24426 as double) AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, cast(DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24427 as double) AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, cast(DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24428 as double) AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, cast(DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24429 as double) AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]
                              +- Project [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306 AS DAILY_HISTORIC__37809_COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24423, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307 AS DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24424, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308 AS DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24425, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309 AS DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24426, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310 AS DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24427, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311 AS DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24428, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312 AS DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24429]
                                 +- SubqueryAlias DAILY_HISTORIC__37809118
                                    +- Relation[COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312] parquet

== Analyzed Logical Plan ==
COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF: timestamp, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03: double, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045: double, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49: double, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E: double, COL_36652407_9951_4B55_BC45_3C14A3EF7557: double, COL_40A87F78_1125_4622_A64B_0CD24444A630: double
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24759 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24773, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24760 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24774, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24761 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24775, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24762 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24776, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24763 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24777, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24764 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24778, COL_40A87F78_1125_4622_A64B_0CD24444A630#24765 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24779]
         +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24741 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24759, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24742 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24760, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24743 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24761, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24744 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24762, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24745 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24763, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24746 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24764, COL_40A87F78_1125_4622_A64B_0CD24444A630#24747 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24765]
            +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24719 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24741, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24720 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24742, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24721 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24743, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24722 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24744, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24723 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24745, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24724 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24746, COL_40A87F78_1125_4622_A64B_0CD24444A630#24725 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24747]
               +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24697 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24719, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24698 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24720, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24699 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24721, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24700 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24722, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24701 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24723, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24702 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24724, COL_40A87F78_1125_4622_A64B_0CD24444A630#24703 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24725]
                  +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24697, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24698, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24699, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24700, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24701, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24702, COL_40A87F78_1125_4622_A64B_0CD24444A630#24650 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24703]
                     +- Project [COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]
                        +- Filter true
                           +- Project [cast(DAILY_HISTORIC__37809_COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24423 as timestamp) AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, cast(DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24424 as double) AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, cast(DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24425 as double) AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, cast(DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24426 as double) AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, cast(DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24427 as double) AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, cast(DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24428 as double) AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, cast(DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24429 as double) AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]
                              +- Project [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306 AS DAILY_HISTORIC__37809_COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24423, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307 AS DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24424, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308 AS DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24425, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309 AS DAILY_HISTORIC__37809_COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24426, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310 AS DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24427, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311 AS DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24428, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312 AS DAILY_HISTORIC__37809_COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24429]
                                 +- SubqueryAlias DAILY_HISTORIC__37809118
                                    +- Relation[COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]
      +- Relation[COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306 AS COL_9A9DA990_BC17_4D0C_B555_AC13E486ABDF#24644, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307 AS COL_59DE1D12_C7E9_4376_85DB_F6EB70009E03#24645, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308 AS COL_9CAAEB68_CCF8_4424_8808_25FAD01E9045#24646, COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309 AS COL_A2298325_4124_4170_BC7D_9AA9C1A68B49#24647, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310 AS COL_4C681F1C_8DE7_47BE_83EB_C933A6EEF28E#24648, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311 AS COL_36652407_9951_4B55_BC45_3C14A3EF7557#24649, COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312 AS COL_40A87F78_1125_4622_A64B_0CD24444A630#24650]
   +- *(1) ColumnarToRow
      +- FileScan parquet [COL_137A124D_FB08_424F_888F_EF6BCC8806EC#24306,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24307,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24308,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE2_5E9BE534_48B8_4005_B462_1097ECD43D13#24309,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_3C92D70A_6300_4DD4_A030_954F6EEC53FD#24310,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_47DC9B01_1ECD_4DFF_8CD2_8430A1D67596#24311,COL_60AC4A59_4670_4600_A7C4_470DF0E68006_5E9BE534_48B8_4005_B462_1097ECD43D13#24312] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/DAILY_HISTORIC__37809], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_137A124D_FB08_424F_888F_EF6BCC8806EC:timestamp,COL_2F77AD02_6CB5_4EF8_A6FE_C79D8663DBE...