digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 2 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 0<br>number of input batches: 0"];
}
4 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 5.5 KiB<br>number of output rows: 0"];
2->0;
3->2;
4->3;
}
5
CollectLimit 1500
Project [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1372937 AS COL_0040D753_ADC3_4324_A2C0_349701B6A4C0#1373128, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1372938 AS COL_245EDD91_373E_48A5_9D08_2C1DFDE1621E#1373129, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1372939 AS COL_2CD824D6_61CD_4D43_A540_7B36A2BF32BF#1373130, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1372940 AS COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1373131, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1372941 AS COL_4C0C1178_DAB5_4C8C_A841_DB7BF77CB7FD#1373132, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1372942 AS COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1373133, COL_351EE403_0229_4432_B273_A1F41BC78672#1372943 AS COL_E13F5B7C_12AA_42A7_B8FD_2B65D343EB16#1373134, COL_12B44094_B64E_4779_A967_D983CDAB1370#1372944 AS COL_833D6037_CBAB_4B2F_BC2B_7FA74C15C6B1#1373135, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1372945 AS COL_11315EF7_5579_4742_A940_0985D2DD4555#1373136, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1372946 AS COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1373137, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1372947 AS COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1373138, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1372948 AS COL_7596460D_329E_49C3_BB64_5051E0F4BCBF#1373139, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1372949 AS COL_2F7EC080_FBE0_44AD_B197_DD0B07E55D45#1373140, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1372950 AS COL_A5ACBEDA_0991_4CF7_A5D3_6FDB4D58D595#1373141, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1372951 AS COL_FB5C26CB_D8AA_45B3_8A82_5C77D625B42E#1373142, COL_43523D61_1E4B_4377_998B_7E898D87B867#1372952 AS COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1373143, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1372953 AS COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1373144, COL_60F7C888_9836_4535_A22F_D43D2994E019#1372954 AS COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1373145, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1372955 AS COL_2B12C23D_4474_4D0A_A1D8_E8003A7E92A7#1373146, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1372956 AS COL_9ABC3876_8A13_42F6_8F9E_CF60DB67797D#1373147, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1372957 AS COL_8EB7BCE7_3ADF_4A31_B113_12BEA0FBDA9D#1373148]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1372937,COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1372938,COL_2C57AE56_072C_4967_B155_3BCF550AC929#1372939,COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1372940,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1372941,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1372942,COL_351EE403_0229_4432_B273_A1F41BC78672#1372943,COL_12B44094_B64E_4779_A967_D983CDAB1370#1372944,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1372945,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1372946,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1372947,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1372948,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1372949,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1372950,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1372951,COL_43523D61_1E4B_4377_998B_7E898D87B867#1372952,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1372953,COL_60F7C888_9836_4535_A22F_D43D2994E019#1372954,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1372955,COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1372956,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1372957] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_205179], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_B0A29476_8712_4938_9AAA_2B3FED3AA843:string,COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B:s...
== Physical Plan ==
CollectLimit (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1372937, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1372938, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1372939, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1372940, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1372941, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1372942, COL_351EE403_0229_4432_B273_A1F41BC78672#1372943, COL_12B44094_B64E_4779_A967_D983CDAB1370#1372944, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1372945, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1372946, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1372947, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1372948, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1372949, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1372950, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1372951, COL_43523D61_1E4B_4377_998B_7E898D87B867#1372952, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1372953, COL_60F7C888_9836_4535_A22F_D43D2994E019#1372954, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1372955, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1372956, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1372957]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_205179]
ReadSchema: struct<COL_B0A29476_8712_4938_9AAA_2B3FED3AA843:string,COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B:string,COL_2C57AE56_072C_4967_B155_3BCF550AC929:string,COL_1856697C_8DD2_425F_AA61_054524CA3E4B:int,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F:string,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_351EE403_0229_4432_B273_A1F41BC78672:string,COL_12B44094_B64E_4779_A967_D983CDAB1370:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00:string,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720:string,COL_43523D61_1E4B_4377_998B_7E898D87B867:string,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94:string,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506:string,COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB:array<string>,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3:array<string>>
(2) ColumnarToRow [codegen id : 1]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1372937, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1372938, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1372939, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1372940, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1372941, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1372942, COL_351EE403_0229_4432_B273_A1F41BC78672#1372943, COL_12B44094_B64E_4779_A967_D983CDAB1370#1372944, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1372945, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1372946, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1372947, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1372948, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1372949, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1372950, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1372951, COL_43523D61_1E4B_4377_998B_7E898D87B867#1372952, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1372953, COL_60F7C888_9836_4535_A22F_D43D2994E019#1372954, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1372955, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1372956, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1372957]
(3) Project [codegen id : 1]
Output [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1372937 AS COL_0040D753_ADC3_4324_A2C0_349701B6A4C0#1373128, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1372938 AS COL_245EDD91_373E_48A5_9D08_2C1DFDE1621E#1373129, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1372939 AS COL_2CD824D6_61CD_4D43_A540_7B36A2BF32BF#1373130, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1372940 AS COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1373131, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1372941 AS COL_4C0C1178_DAB5_4C8C_A841_DB7BF77CB7FD#1373132, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1372942 AS COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1373133, COL_351EE403_0229_4432_B273_A1F41BC78672#1372943 AS COL_E13F5B7C_12AA_42A7_B8FD_2B65D343EB16#1373134, COL_12B44094_B64E_4779_A967_D983CDAB1370#1372944 AS COL_833D6037_CBAB_4B2F_BC2B_7FA74C15C6B1#1373135, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1372945 AS COL_11315EF7_5579_4742_A940_0985D2DD4555#1373136, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1372946 AS COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1373137, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1372947 AS COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1373138, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1372948 AS COL_7596460D_329E_49C3_BB64_5051E0F4BCBF#1373139, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1372949 AS COL_2F7EC080_FBE0_44AD_B197_DD0B07E55D45#1373140, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1372950 AS COL_A5ACBEDA_0991_4CF7_A5D3_6FDB4D58D595#1373141, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1372951 AS COL_FB5C26CB_D8AA_45B3_8A82_5C77D625B42E#1373142, COL_43523D61_1E4B_4377_998B_7E898D87B867#1372952 AS COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1373143, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1372953 AS COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1373144, COL_60F7C888_9836_4535_A22F_D43D2994E019#1372954 AS COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1373145, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1372955 AS COL_2B12C23D_4474_4D0A_A1D8_E8003A7E92A7#1373146, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1372956 AS COL_9ABC3876_8A13_42F6_8F9E_CF60DB67797D#1373147, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1372957 AS COL_8EB7BCE7_3ADF_4A31_B113_12BEA0FBDA9D#1373148]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1372937, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1372938, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1372939, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1372940, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1372941, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1372942, COL_351EE403_0229_4432_B273_A1F41BC78672#1372943, COL_12B44094_B64E_4779_A967_D983CDAB1370#1372944, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1372945, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1372946, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1372947, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1372948, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1372949, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1372950, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1372951, COL_43523D61_1E4B_4377_998B_7E898D87B867#1372952, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1372953, COL_60F7C888_9836_4535_A22F_D43D2994E019#1372954, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1372955, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1372956, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1372957]
(4) CollectLimit
Input [21]: [COL_0040D753_ADC3_4324_A2C0_349701B6A4C0#1373128, COL_245EDD91_373E_48A5_9D08_2C1DFDE1621E#1373129, COL_2CD824D6_61CD_4D43_A540_7B36A2BF32BF#1373130, COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1373131, COL_4C0C1178_DAB5_4C8C_A841_DB7BF77CB7FD#1373132, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1373133, COL_E13F5B7C_12AA_42A7_B8FD_2B65D343EB16#1373134, COL_833D6037_CBAB_4B2F_BC2B_7FA74C15C6B1#1373135, COL_11315EF7_5579_4742_A940_0985D2DD4555#1373136, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1373137, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1373138, COL_7596460D_329E_49C3_BB64_5051E0F4BCBF#1373139, COL_2F7EC080_FBE0_44AD_B197_DD0B07E55D45#1373140, COL_A5ACBEDA_0991_4CF7_A5D3_6FDB4D58D595#1373141, COL_FB5C26CB_D8AA_45B3_8A82_5C77D625B42E#1373142, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1373143, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1373144, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1373145, COL_2B12C23D_4474_4D0A_A1D8_E8003A7E92A7#1373146, COL_9ABC3876_8A13_42F6_8F9E_CF60DB67797D#1373147, COL_8EB7BCE7_3ADF_4A31_B113_12BEA0FBDA9D#1373148]
Arguments: 1500