== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (35)
+- Project (34)
+- Project (33)
+- Project (32)
+- Generate (31)
+- Project (30)
+- Project (29)
+- Sort (28)
+- Project (27)
+- Project (26)
+- Project (25)
+- Window (24)
+- Project (23)
+- Project (22)
+- Project (21)
+- Project (20)
+- Project (19)
+- Window (18)
+- Project (17)
+- Project (16)
+- Project (15)
+- Project (14)
+- SubqueryAlias (13)
+- View (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `ALARM_DATA_25181173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Time+Stamp#119059, Alarm+Value#119060, 0A2CF169_565C_40A9_8C97_AF52B8017F78HEADER_COL_DETAIL_DEPOT#119061], false
(4) Project
Arguments: [Time+Stamp#119059 AS Time Stamp#119109, Alarm+Value#119060, 0A2CF169_565C_40A9_8C97_AF52B8017F78HEADER_COL_DETAIL_DEPOT#119061]
(5) Project
Arguments: [Time Stamp#119109, Alarm+Value#119060 AS Alarm Value#119114, 0A2CF169_565C_40A9_8C97_AF52B8017F78HEADER_COL_DETAIL_DEPOT#119061]
(6) Project
Arguments: [Time Stamp#119109, Alarm Value#119114, 0A2CF169_565C_40A9_8C97_AF52B8017F78HEADER_COL_DETAIL_DEPOT#119061 AS 0A2CF169_565C_40A9_8C97_AF52B8017F78HEADER_COL_DETAIL_DEPOT#119118]
(7) Project
Arguments: [Time Stamp#119109 AS COLL0#119144, Alarm Value#119114 AS COLL1#119159, 0A2CF169_565C_40A9_8C97_AF52B8017F78HEADER_COL_DETAIL_DEPOT#119118 AS COLL2#119168]
(8) Project
Arguments: [COLL0#119144 AS COLL0#119184, COLL1#119159 AS COLL1#119185, COLL2#119168 AS COLL2#119186]
(9) Project
Arguments: [COLL0#119184, COLL1#119185, COLL2#119186]
(10) Project
Arguments: [COLL1#119185 AS ALARM_VALUE_25179#119193, cast(COLL0#119184 as timestamp) AS TIME_STAMP_25178#119194]
(11) Project
Arguments: [ALARM_VALUE_25179#119193, TIME_STAMP_25178#119194, str_split(ALARM_VALUE_25179#119193, cast(| as string)) AS SPLIT_ALARM_25180#119197]
(12) View
Arguments: `ALARM_DATA_25177173`, true
(13) SubqueryAlias
Arguments: ALARM_DATA_25177173
(14) Project
Arguments: [ALARM_VALUE_25179#119193 AS ALARM_DATA_25177_ALARM_VALUE_25179#119292, TIME_STAMP_25178#119194 AS ALARM_DATA_25177_TIME_STAMP_25178#119293, SPLIT_ALARM_25180#119197 AS ALARM_DATA_25177_SPLIT_ALARM_25180#119294]
(15) Project
Arguments: [cast(ALARM_DATA_25177_TIME_STAMP_25178#119293 as timestamp) AS COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, cast(ALARM_DATA_25177_ALARM_VALUE_25179#119292 as string) AS COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, cast(ALARM_DATA_25177_SPLIT_ALARM_25180#119294 as array<string>) AS COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303]
(16) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, 1 AS CONST#119308]
(17) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, CONST#119308]
(18) Window
Arguments: [row_number() windowspecdefinition(COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, CONST#119308 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314], [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301], [CONST#119308 DESC NULLS LAST]
(19) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, CONST#119308, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314]
(20) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, CONST#119308, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314]
(21) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314]
(22) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314, 1 AS CONST#119325]
(23) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314, CONST#119325]
(24) Window
Arguments: [count(1) windowspecdefinition(COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, CONST#119325 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_972E4812_88F6_4BBA_B6B1_508462088A43#119333L], [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301], [CONST#119325 DESC NULLS LAST]
(25) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314, CONST#119325, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119333L, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119333L]
(26) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314, CONST#119325, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119333L]
(27) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119333L]
(28) Sort
Arguments: true
(29) Project
Arguments: [COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119314 AS COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119333L AS COL_972E4812_88F6_4BBA_B6B1_508462088A43#119346L, COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119301 AS COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119347, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119302 AS COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119348, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119303 AS COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119349]
(30) Project
Arguments: [COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119346L, COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119347, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119348, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119349, str_concat(array(int_to_str(COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345), cast(- as string), date_to_str(COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119347, cast(yyyy/MM/dd HH:mm:ss as string)))) AS COL_5AF236A9_794D_487C_A16C_5785B7578EF7#119355]
(31) Generate
Arguments: explode(COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119349), false, [COL_B2D48770_3265_46F1_969A_743C0908972E#119364]
(32) Project
Arguments: [COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119346L, COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119347, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119348, COL_7C6D3146_DAB6_42AA_B7D6_F23300F36C1A#119349, COL_5AF236A9_794D_487C_A16C_5785B7578EF7#119355, COL_B2D48770_3265_46F1_969A_743C0908972E#119364]
(33) Project
Arguments: [COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119346L, COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119347, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119348, COL_5AF236A9_794D_487C_A16C_5785B7578EF7#119355, COL_B2D48770_3265_46F1_969A_743C0908972E#119364]
(34) Project
Arguments: [COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119347 AS COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119405, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119348 AS COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119406, COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119346L, COL_5AF236A9_794D_487C_A16C_5785B7578EF7#119355, COL_B2D48770_3265_46F1_969A_743C0908972E#119364]
(35) Project
Arguments: [COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119345 AS COL_D5A2A2BF_D10D_4F90_A9FD_D8D678447721#119413, COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119405 AS COL_C0D8F3D6_A9FC_4A90_99ED_408955F75775#119414, COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119406 AS COL_1B4EBDB5_53D8_4CBF_A267_58D2B3C7F25E#119415, COL_B2D48770_3265_46F1_969A_743C0908972E#119364 AS COL_B2D48770_3265_46F1_969A_743C0908972E#119416, COL_972E4812_88F6_4BBA_B6B1_508462088A43#119346L AS COL_972E4812_88F6_4BBA_B6B1_508462088A43#119417L, COL_5AF236A9_794D_487C_A16C_5785B7578EF7#119355 AS COL_5AF236A9_794D_487C_A16C_5785B7578EF7#119418]