You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Maciej Bryński (Jira)" <ji...@apache.org> on 2022/06/30 13:00:00 UTC
[jira] [Comment Edited] (FLINK-27246) Code of method "processElement(Lorg/apache/flink/streaming/runtime/streamrecord/StreamRecord;)V" of class "HashAggregateWithKeys$9211" grows beyond 64 KB
[ https://issues.apache.org/jira/browse/FLINK-27246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17561031#comment-17561031 ]
Maciej Bryński edited comment on FLINK-27246 at 6/30/22 12:59 PM:
------------------------------------------------------------------
[~jingge]
Please find following example from our production (with change to datagen)
Tested on 1.14.4 sql-client
{code:java}
SET 'execution.runtime-mode' = 'batch';
CREATE TABLE `SA_NSN5G_PM.GSITE_PDCP2_R` (
`DAY_WH_ID` DECIMAL(10, 0),
`GSITE_WH_ID` DECIMAL(10, 0),
`START_TIME` TIMESTAMP(6),
`INSERTION_TIME` TIMESTAMP(6),
`MRBTS_ID` DECIMAL(10, 0),
`NRBTS_ID` DECIMAL(10, 0),
`DURATION` DECIMAL(10, 0),
`MEAS_PERIOD_NR_PDCP_REPORT2` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_20` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_20` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_20` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_20` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_01` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_02` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_03` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_04` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_05` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_06` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_07` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_08` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_09` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_10` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_11` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_12` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_13` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_14` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_15` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_16` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_17` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_18` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_19` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_20` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_01` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_02` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_03` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_04` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_05` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_06` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_07` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_08` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_09` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_10` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_11` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_12` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_13` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_14` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_15` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_16` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_17` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_18` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_19` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_20` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_01` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_02` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_03` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_04` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_05` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_06` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_07` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_08` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_09` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_10` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_11` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_12` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_13` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_14` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_15` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_16` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_17` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_18` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_19` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_20` DECIMAL(10, 0),
`MAX_NUM_OF_DRB` DECIMAL(10, 0),
`DL_NUM_ROHC_COMP_HEADER` DECIMAL(10, 0),
`DL_VOL_ROHC_COMP_HEADER` DECIMAL(10, 0),
`UL_NUM_ROHC_DECOMP_HEADER` DECIMAL(10, 0),
`UL_VOL_ROHC_DECOMP_HEADER` DECIMAL(10, 0),
`KAFKA_PARTID` DECIMAL(10, 0),
`KAFKA_OFFSET` INT
)
COMMENT ''
WITH (
'connector' = 'datagen',
'number-of-rows' = '100'
);
SELECT
MINUTE(T1.START_TIME) as `DAY_WH_ID`,
HOUR(T1.START_TIME) as `START_TIME`,
GSITE_WH_ID as `GSITE_WH_ID`,
T1.MRBTS_ID as `MRBTS_ID`,
T1.NRBTS_ID as `NRBTS_ID`,
SUM(T1.DURATION) as `DURATION`, SUM(MEAS_PERIOD_NR_PDCP_REPORT2) as `MEAS_PERIOD_NR_PDCP_REPORT2`, SUM(DL_VOL_DISC_REL_QOS_GRP_01) as `DL_VOL_DISC_REL_QOS_GRP_01`, SUM(DL_VOL_DISC_REL_QOS_GRP_02) as `DL_VOL_DISC_REL_QOS_GRP_02`, SUM(DL_VOL_DISC_REL_QOS_GRP_03) as `DL_VOL_DISC_REL_QOS_GRP_03`, SUM(DL_VOL_DISC_REL_QOS_GRP_04) as `DL_VOL_DISC_REL_QOS_GRP_04`, SUM(DL_VOL_DISC_REL_QOS_GRP_05) as `DL_VOL_DISC_REL_QOS_GRP_05`, SUM(DL_VOL_DISC_REL_QOS_GRP_06) as `DL_VOL_DISC_REL_QOS_GRP_06`, SUM(DL_VOL_DISC_REL_QOS_GRP_07) as `DL_VOL_DISC_REL_QOS_GRP_07`, SUM(DL_VOL_DISC_REL_QOS_GRP_08) as `DL_VOL_DISC_REL_QOS_GRP_08`, SUM(DL_VOL_DISC_REL_QOS_GRP_09) as `DL_VOL_DISC_REL_QOS_GRP_09`, SUM(DL_VOL_DISC_REL_QOS_GRP_10) as `DL_VOL_DISC_REL_QOS_GRP_10`, SUM(DL_VOL_DISC_REL_QOS_GRP_11) as `DL_VOL_DISC_REL_QOS_GRP_11`, SUM(DL_VOL_DISC_REL_QOS_GRP_12) as `DL_VOL_DISC_REL_QOS_GRP_12`, SUM(DL_VOL_DISC_REL_QOS_GRP_13) as `DL_VOL_DISC_REL_QOS_GRP_13`, SUM(DL_VOL_DISC_REL_QOS_GRP_14) as `DL_VOL_DISC_REL_QOS_GRP_14`, SUM(DL_VOL_DISC_REL_QOS_GRP_15) as `DL_VOL_DISC_REL_QOS_GRP_15`, SUM(DL_VOL_DISC_REL_QOS_GRP_16) as `DL_VOL_DISC_REL_QOS_GRP_16`, SUM(DL_VOL_DISC_REL_QOS_GRP_17) as `DL_VOL_DISC_REL_QOS_GRP_17`, SUM(DL_VOL_DISC_REL_QOS_GRP_18) as `DL_VOL_DISC_REL_QOS_GRP_18`, SUM(DL_VOL_DISC_REL_QOS_GRP_19) as `DL_VOL_DISC_REL_QOS_GRP_19`, SUM(DL_VOL_DISC_REL_QOS_GRP_20) as `DL_VOL_DISC_REL_QOS_GRP_20`, SUM(DL_SDU_DISC_REL_QOS_GRP_01) as `DL_SDU_DISC_REL_QOS_GRP_01`, SUM(DL_SDU_DISC_REL_QOS_GRP_02) as `DL_SDU_DISC_REL_QOS_GRP_02`, SUM(DL_SDU_DISC_REL_QOS_GRP_03) as `DL_SDU_DISC_REL_QOS_GRP_03`, SUM(DL_SDU_DISC_REL_QOS_GRP_04) as `DL_SDU_DISC_REL_QOS_GRP_04`, SUM(DL_SDU_DISC_REL_QOS_GRP_05) as `DL_SDU_DISC_REL_QOS_GRP_05`, SUM(DL_SDU_DISC_REL_QOS_GRP_06) as `DL_SDU_DISC_REL_QOS_GRP_06`, SUM(DL_SDU_DISC_REL_QOS_GRP_07) as `DL_SDU_DISC_REL_QOS_GRP_07`, SUM(DL_SDU_DISC_REL_QOS_GRP_08) as `DL_SDU_DISC_REL_QOS_GRP_08`, SUM(DL_SDU_DISC_REL_QOS_GRP_09) as `DL_SDU_DISC_REL_QOS_GRP_09`, SUM(DL_SDU_DISC_REL_QOS_GRP_10) as `DL_SDU_DISC_REL_QOS_GRP_10`, SUM(DL_SDU_DISC_REL_QOS_GRP_11) as `DL_SDU_DISC_REL_QOS_GRP_11`, SUM(DL_SDU_DISC_REL_QOS_GRP_12) as `DL_SDU_DISC_REL_QOS_GRP_12`, SUM(DL_SDU_DISC_REL_QOS_GRP_13) as `DL_SDU_DISC_REL_QOS_GRP_13`, SUM(DL_SDU_DISC_REL_QOS_GRP_14) as `DL_SDU_DISC_REL_QOS_GRP_14`, SUM(DL_SDU_DISC_REL_QOS_GRP_15) as `DL_SDU_DISC_REL_QOS_GRP_15`, SUM(DL_SDU_DISC_REL_QOS_GRP_16) as `DL_SDU_DISC_REL_QOS_GRP_16`, SUM(DL_SDU_DISC_REL_QOS_GRP_17) as `DL_SDU_DISC_REL_QOS_GRP_17`, SUM(DL_SDU_DISC_REL_QOS_GRP_18) as `DL_SDU_DISC_REL_QOS_GRP_18`, SUM(DL_SDU_DISC_REL_QOS_GRP_19) as `DL_SDU_DISC_REL_QOS_GRP_19`, SUM(DL_SDU_DISC_REL_QOS_GRP_20) as `DL_SDU_DISC_REL_QOS_GRP_20`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_01) as `DL_VOL_DISC_OTHER_QOS_GRP_01`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_02) as `DL_VOL_DISC_OTHER_QOS_GRP_02`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_03) as `DL_VOL_DISC_OTHER_QOS_GRP_03`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_04) as `DL_VOL_DISC_OTHER_QOS_GRP_04`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_05) as `DL_VOL_DISC_OTHER_QOS_GRP_05`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_06) as `DL_VOL_DISC_OTHER_QOS_GRP_06`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_07) as `DL_VOL_DISC_OTHER_QOS_GRP_07`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_08) as `DL_VOL_DISC_OTHER_QOS_GRP_08`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_09) as `DL_VOL_DISC_OTHER_QOS_GRP_09`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_10) as `DL_VOL_DISC_OTHER_QOS_GRP_10`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_11) as `DL_VOL_DISC_OTHER_QOS_GRP_11`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_12) as `DL_VOL_DISC_OTHER_QOS_GRP_12`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_13) as `DL_VOL_DISC_OTHER_QOS_GRP_13`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_14) as `DL_VOL_DISC_OTHER_QOS_GRP_14`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_15) as `DL_VOL_DISC_OTHER_QOS_GRP_15`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_16) as `DL_VOL_DISC_OTHER_QOS_GRP_16`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_17) as `DL_VOL_DISC_OTHER_QOS_GRP_17`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_18) as `DL_VOL_DISC_OTHER_QOS_GRP_18`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_19) as `DL_VOL_DISC_OTHER_QOS_GRP_19`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_20) as `DL_VOL_DISC_OTHER_QOS_GRP_20`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_01) as `DL_SDU_DISC_OTHER_QOS_GRP_01`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_02) as `DL_SDU_DISC_OTHER_QOS_GRP_02`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_03) as `DL_SDU_DISC_OTHER_QOS_GRP_03`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_04) as `DL_SDU_DISC_OTHER_QOS_GRP_04`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_05) as `DL_SDU_DISC_OTHER_QOS_GRP_05`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_06) as `DL_SDU_DISC_OTHER_QOS_GRP_06`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_07) as `DL_SDU_DISC_OTHER_QOS_GRP_07`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_08) as `DL_SDU_DISC_OTHER_QOS_GRP_08`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_09) as `DL_SDU_DISC_OTHER_QOS_GRP_09`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_10) as `DL_SDU_DISC_OTHER_QOS_GRP_10`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_11) as `DL_SDU_DISC_OTHER_QOS_GRP_11`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_12) as `DL_SDU_DISC_OTHER_QOS_GRP_12`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_13) as `DL_SDU_DISC_OTHER_QOS_GRP_13`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_14) as `DL_SDU_DISC_OTHER_QOS_GRP_14`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_15) as `DL_SDU_DISC_OTHER_QOS_GRP_15`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_16) as `DL_SDU_DISC_OTHER_QOS_GRP_16`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_17) as `DL_SDU_DISC_OTHER_QOS_GRP_17`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_18) as `DL_SDU_DISC_OTHER_QOS_GRP_18`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_19) as `DL_SDU_DISC_OTHER_QOS_GRP_19`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_20) as `DL_SDU_DISC_OTHER_QOS_GRP_20`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_01) as `DL_VOL_DISC_BUFTH_QOS_GRP_01`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_02) as `DL_VOL_DISC_BUFTH_QOS_GRP_02`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_03) as `DL_VOL_DISC_BUFTH_QOS_GRP_03`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_04) as `DL_VOL_DISC_BUFTH_QOS_GRP_04`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_05) as `DL_VOL_DISC_BUFTH_QOS_GRP_05`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_06) as `DL_VOL_DISC_BUFTH_QOS_GRP_06`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_07) as `DL_VOL_DISC_BUFTH_QOS_GRP_07`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_08) as `DL_VOL_DISC_BUFTH_QOS_GRP_08`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_09) as `DL_VOL_DISC_BUFTH_QOS_GRP_09`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_10) as `DL_VOL_DISC_BUFTH_QOS_GRP_10`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_11) as `DL_VOL_DISC_BUFTH_QOS_GRP_11`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_12) as `DL_VOL_DISC_BUFTH_QOS_GRP_12`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_13) as `DL_VOL_DISC_BUFTH_QOS_GRP_13`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_14) as `DL_VOL_DISC_BUFTH_QOS_GRP_14`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_15) as `DL_VOL_DISC_BUFTH_QOS_GRP_15`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_16) as `DL_VOL_DISC_BUFTH_QOS_GRP_16`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_17) as `DL_VOL_DISC_BUFTH_QOS_GRP_17`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_18) as `DL_VOL_DISC_BUFTH_QOS_GRP_18`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_19) as `DL_VOL_DISC_BUFTH_QOS_GRP_19`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_20) as `DL_VOL_DISC_BUFTH_QOS_GRP_20`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_01) as `DL_SDU_DISC_BUFTH_QOS_GRP_01`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_02) as `DL_SDU_DISC_BUFTH_QOS_GRP_02`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_03) as `DL_SDU_DISC_BUFTH_QOS_GRP_03`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_04) as `DL_SDU_DISC_BUFTH_QOS_GRP_04`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_05) as `DL_SDU_DISC_BUFTH_QOS_GRP_05`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_06) as `DL_SDU_DISC_BUFTH_QOS_GRP_06`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_07) as `DL_SDU_DISC_BUFTH_QOS_GRP_07`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_08) as `DL_SDU_DISC_BUFTH_QOS_GRP_08`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_09) as `DL_SDU_DISC_BUFTH_QOS_GRP_09`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_10) as `DL_SDU_DISC_BUFTH_QOS_GRP_10`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_11) as `DL_SDU_DISC_BUFTH_QOS_GRP_11`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_12) as `DL_SDU_DISC_BUFTH_QOS_GRP_12`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_13) as `DL_SDU_DISC_BUFTH_QOS_GRP_13`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_14) as `DL_SDU_DISC_BUFTH_QOS_GRP_14`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_15) as `DL_SDU_DISC_BUFTH_QOS_GRP_15`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_16) as `DL_SDU_DISC_BUFTH_QOS_GRP_16`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_17) as `DL_SDU_DISC_BUFTH_QOS_GRP_17`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_18) as `DL_SDU_DISC_BUFTH_QOS_GRP_18`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_19) as `DL_SDU_DISC_BUFTH_QOS_GRP_19`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_20) as `DL_SDU_DISC_BUFTH_QOS_GRP_20`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_01) as `UL_VOL_DISC_OTHER_QOS_GRP_01`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_02) as `UL_VOL_DISC_OTHER_QOS_GRP_02`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_03) as `UL_VOL_DISC_OTHER_QOS_GRP_03`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_04) as `UL_VOL_DISC_OTHER_QOS_GRP_04`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_05) as `UL_VOL_DISC_OTHER_QOS_GRP_05`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_06) as `UL_VOL_DISC_OTHER_QOS_GRP_06`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_07) as `UL_VOL_DISC_OTHER_QOS_GRP_07`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_08) as `UL_VOL_DISC_OTHER_QOS_GRP_08`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_09) as `UL_VOL_DISC_OTHER_QOS_GRP_09`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_10) as `UL_VOL_DISC_OTHER_QOS_GRP_10`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_11) as `UL_VOL_DISC_OTHER_QOS_GRP_11`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_12) as `UL_VOL_DISC_OTHER_QOS_GRP_12`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_13) as `UL_VOL_DISC_OTHER_QOS_GRP_13`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_14) as `UL_VOL_DISC_OTHER_QOS_GRP_14`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_15) as `UL_VOL_DISC_OTHER_QOS_GRP_15`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_16) as `UL_VOL_DISC_OTHER_QOS_GRP_16`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_17) as `UL_VOL_DISC_OTHER_QOS_GRP_17`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_18) as `UL_VOL_DISC_OTHER_QOS_GRP_18`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_19) as `UL_VOL_DISC_OTHER_QOS_GRP_19`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_20) as `UL_VOL_DISC_OTHER_QOS_GRP_20`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_01) as `UL_SDU_DISC_OTHER_QOS_GRP_01`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_02) as `UL_SDU_DISC_OTHER_QOS_GRP_02`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_03) as `UL_SDU_DISC_OTHER_QOS_GRP_03`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_04) as `UL_SDU_DISC_OTHER_QOS_GRP_04`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_05) as `UL_SDU_DISC_OTHER_QOS_GRP_05`,
SUM(UL_SDU_DISC_OTHER_QOS_GRP_06) as `UL_SDU_DISC_OTHER_QOS_GRP_06`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_07) as `UL_SDU_DISC_OTHER_QOS_GRP_07`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_08) as `UL_SDU_DISC_OTHER_QOS_GRP_08`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_09) as `UL_SDU_DISC_OTHER_QOS_GRP_09`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_10) as `UL_SDU_DISC_OTHER_QOS_GRP_10`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_11) as `UL_SDU_DISC_OTHER_QOS_GRP_11`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_12) as `UL_SDU_DISC_OTHER_QOS_GRP_12`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_13) as `UL_SDU_DISC_OTHER_QOS_GRP_13`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_14) as `UL_SDU_DISC_OTHER_QOS_GRP_14`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_15) as `UL_SDU_DISC_OTHER_QOS_GRP_15`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_16) as `UL_SDU_DISC_OTHER_QOS_GRP_16`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_17) as `UL_SDU_DISC_OTHER_QOS_GRP_17`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_18) as `UL_SDU_DISC_OTHER_QOS_GRP_18`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_19) as `UL_SDU_DISC_OTHER_QOS_GRP_19`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_20) as `UL_SDU_DISC_OTHER_QOS_GRP_20`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_01) as `DL_SDU_DISC_QUEDLY_QOS_GRP_01`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_02) as `DL_SDU_DISC_QUEDLY_QOS_GRP_02`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_03) as `DL_SDU_DISC_QUEDLY_QOS_GRP_03`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_04) as `DL_SDU_DISC_QUEDLY_QOS_GRP_04`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_05) as `DL_SDU_DISC_QUEDLY_QOS_GRP_05`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_06) as `DL_SDU_DISC_QUEDLY_QOS_GRP_06`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_07) as `DL_SDU_DISC_QUEDLY_QOS_GRP_07`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_08) as `DL_SDU_DISC_QUEDLY_QOS_GRP_08`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_09) as `DL_SDU_DISC_QUEDLY_QOS_GRP_09`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_10) as `DL_SDU_DISC_QUEDLY_QOS_GRP_10`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_11) as `DL_SDU_DISC_QUEDLY_QOS_GRP_11`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_12) as `DL_SDU_DISC_QUEDLY_QOS_GRP_12`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_13) as `DL_SDU_DISC_QUEDLY_QOS_GRP_13`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_14) as `DL_SDU_DISC_QUEDLY_QOS_GRP_14`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_15) as `DL_SDU_DISC_QUEDLY_QOS_GRP_15`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_16) as `DL_SDU_DISC_QUEDLY_QOS_GRP_16`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_17) as `DL_SDU_DISC_QUEDLY_QOS_GRP_17`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_18) as `DL_SDU_DISC_QUEDLY_QOS_GRP_18`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_19) as `DL_SDU_DISC_QUEDLY_QOS_GRP_19`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_20) as `DL_SDU_DISC_QUEDLY_QOS_GRP_20`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_01) as `DL_VOL_DISC_QUEDLY_QOS_GRP_01`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_02) as `DL_VOL_DISC_QUEDLY_QOS_GRP_02`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_03) as `DL_VOL_DISC_QUEDLY_QOS_GRP_03`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_04) as `DL_VOL_DISC_QUEDLY_QOS_GRP_04`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_05) as `DL_VOL_DISC_QUEDLY_QOS_GRP_05`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_06) as `DL_VOL_DISC_QUEDLY_QOS_GRP_06`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_07) as `DL_VOL_DISC_QUEDLY_QOS_GRP_07`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_08) as `DL_VOL_DISC_QUEDLY_QOS_GRP_08`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_09) as `DL_VOL_DISC_QUEDLY_QOS_GRP_09`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_10) as `DL_VOL_DISC_QUEDLY_QOS_GRP_10`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_11) as `DL_VOL_DISC_QUEDLY_QOS_GRP_11`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_12) as `DL_VOL_DISC_QUEDLY_QOS_GRP_12`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_13) as `DL_VOL_DISC_QUEDLY_QOS_GRP_13`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_14) as `DL_VOL_DISC_QUEDLY_QOS_GRP_14`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_15) as `DL_VOL_DISC_QUEDLY_QOS_GRP_15`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_16) as `DL_VOL_DISC_QUEDLY_QOS_GRP_16`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_17) as `DL_VOL_DISC_QUEDLY_QOS_GRP_17`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_18) as `DL_VOL_DISC_QUEDLY_QOS_GRP_18`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_19) as `DL_VOL_DISC_QUEDLY_QOS_GRP_19`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_20) as `DL_VOL_DISC_QUEDLY_QOS_GRP_20`, SUM(DL_DELAY_DISC_QOS_GRP_01) as `DL_DELAY_DISC_QOS_GRP_01`, SUM(DL_DELAY_DISC_QOS_GRP_02) as `DL_DELAY_DISC_QOS_GRP_02`, SUM(DL_DELAY_DISC_QOS_GRP_03) as `DL_DELAY_DISC_QOS_GRP_03`, SUM(DL_DELAY_DISC_QOS_GRP_04) as `DL_DELAY_DISC_QOS_GRP_04`, SUM(DL_DELAY_DISC_QOS_GRP_05) as `DL_DELAY_DISC_QOS_GRP_05`, SUM(DL_DELAY_DISC_QOS_GRP_06) as `DL_DELAY_DISC_QOS_GRP_06`, SUM(DL_DELAY_DISC_QOS_GRP_07) as `DL_DELAY_DISC_QOS_GRP_07`, SUM(DL_DELAY_DISC_QOS_GRP_08) as `DL_DELAY_DISC_QOS_GRP_08`, SUM(DL_DELAY_DISC_QOS_GRP_09) as `DL_DELAY_DISC_QOS_GRP_09`, SUM(DL_DELAY_DISC_QOS_GRP_10) as `DL_DELAY_DISC_QOS_GRP_10`, SUM(DL_DELAY_DISC_QOS_GRP_11) as `DL_DELAY_DISC_QOS_GRP_11`, SUM(DL_DELAY_DISC_QOS_GRP_12) as `DL_DELAY_DISC_QOS_GRP_12`, SUM(DL_DELAY_DISC_QOS_GRP_13) as `DL_DELAY_DISC_QOS_GRP_13`, SUM(DL_DELAY_DISC_QOS_GRP_14) as `DL_DELAY_DISC_QOS_GRP_14`, SUM(DL_DELAY_DISC_QOS_GRP_15) as `DL_DELAY_DISC_QOS_GRP_15`, SUM(DL_DELAY_DISC_QOS_GRP_16) as `DL_DELAY_DISC_QOS_GRP_16`, SUM(DL_DELAY_DISC_QOS_GRP_17) as `DL_DELAY_DISC_QOS_GRP_17`, SUM(DL_DELAY_DISC_QOS_GRP_18) as `DL_DELAY_DISC_QOS_GRP_18`, SUM(DL_DELAY_DISC_QOS_GRP_19) as `DL_DELAY_DISC_QOS_GRP_19`, SUM(DL_DELAY_DISC_QOS_GRP_20) as `DL_DELAY_DISC_QOS_GRP_20`, SUM(NUM_RETRANS_QOS_GRP_01) as `NUM_RETRANS_QOS_GRP_01`, SUM(NUM_RETRANS_QOS_GRP_02) as `NUM_RETRANS_QOS_GRP_02`, SUM(NUM_RETRANS_QOS_GRP_03) as `NUM_RETRANS_QOS_GRP_03`, SUM(NUM_RETRANS_QOS_GRP_04) as `NUM_RETRANS_QOS_GRP_04`, SUM(NUM_RETRANS_QOS_GRP_05) as `NUM_RETRANS_QOS_GRP_05`, SUM(NUM_RETRANS_QOS_GRP_06) as `NUM_RETRANS_QOS_GRP_06`, SUM(NUM_RETRANS_QOS_GRP_07) as `NUM_RETRANS_QOS_GRP_07`, SUM(NUM_RETRANS_QOS_GRP_08) as `NUM_RETRANS_QOS_GRP_08`, SUM(NUM_RETRANS_QOS_GRP_09) as `NUM_RETRANS_QOS_GRP_09`, SUM(NUM_RETRANS_QOS_GRP_10) as `NUM_RETRANS_QOS_GRP_10`, SUM(NUM_RETRANS_QOS_GRP_11) as `NUM_RETRANS_QOS_GRP_11`, SUM(NUM_RETRANS_QOS_GRP_12) as `NUM_RETRANS_QOS_GRP_12`, SUM(NUM_RETRANS_QOS_GRP_13) as `NUM_RETRANS_QOS_GRP_13`, SUM(NUM_RETRANS_QOS_GRP_14) as `NUM_RETRANS_QOS_GRP_14`, SUM(NUM_RETRANS_QOS_GRP_15) as `NUM_RETRANS_QOS_GRP_15`, SUM(NUM_RETRANS_QOS_GRP_16) as `NUM_RETRANS_QOS_GRP_16`, SUM(NUM_RETRANS_QOS_GRP_17) as `NUM_RETRANS_QOS_GRP_17`, SUM(NUM_RETRANS_QOS_GRP_18) as `NUM_RETRANS_QOS_GRP_18`, SUM(NUM_RETRANS_QOS_GRP_19) as `NUM_RETRANS_QOS_GRP_19`, SUM(NUM_RETRANS_QOS_GRP_20) as `NUM_RETRANS_QOS_GRP_20`, SUM(VOL_RETRANS_QOS_GRP_01) as `VOL_RETRANS_QOS_GRP_01`, SUM(VOL_RETRANS_QOS_GRP_02) as `VOL_RETRANS_QOS_GRP_02`, SUM(VOL_RETRANS_QOS_GRP_03) as `VOL_RETRANS_QOS_GRP_03`, SUM(VOL_RETRANS_QOS_GRP_04) as `VOL_RETRANS_QOS_GRP_04`, SUM(VOL_RETRANS_QOS_GRP_05) as `VOL_RETRANS_QOS_GRP_05`, SUM(VOL_RETRANS_QOS_GRP_06) as `VOL_RETRANS_QOS_GRP_06`, SUM(VOL_RETRANS_QOS_GRP_07) as `VOL_RETRANS_QOS_GRP_07`, SUM(VOL_RETRANS_QOS_GRP_08) as `VOL_RETRANS_QOS_GRP_08`, SUM(VOL_RETRANS_QOS_GRP_09) as `VOL_RETRANS_QOS_GRP_09`, SUM(VOL_RETRANS_QOS_GRP_10) as `VOL_RETRANS_QOS_GRP_10`, SUM(VOL_RETRANS_QOS_GRP_11) as `VOL_RETRANS_QOS_GRP_11`, SUM(VOL_RETRANS_QOS_GRP_12) as `VOL_RETRANS_QOS_GRP_12`, SUM(VOL_RETRANS_QOS_GRP_13) as `VOL_RETRANS_QOS_GRP_13`, SUM(VOL_RETRANS_QOS_GRP_14) as `VOL_RETRANS_QOS_GRP_14`, SUM(VOL_RETRANS_QOS_GRP_15) as `VOL_RETRANS_QOS_GRP_15`, SUM(VOL_RETRANS_QOS_GRP_16) as `VOL_RETRANS_QOS_GRP_16`, SUM(VOL_RETRANS_QOS_GRP_17) as `VOL_RETRANS_QOS_GRP_17`, SUM(VOL_RETRANS_QOS_GRP_18) as `VOL_RETRANS_QOS_GRP_18`, SUM(VOL_RETRANS_QOS_GRP_19) as `VOL_RETRANS_QOS_GRP_19`, SUM(VOL_RETRANS_QOS_GRP_20) as `VOL_RETRANS_QOS_GRP_20`, MAX(MAX_NUM_OF_DRB) as `MAX_NUM_OF_DRB`, SUM(DL_NUM_ROHC_COMP_HEADER) as `DL_NUM_ROHC_COMP_HEADER`, SUM(DL_VOL_ROHC_COMP_HEADER) as `DL_VOL_ROHC_COMP_HEADER`, SUM(UL_NUM_ROHC_DECOMP_HEADER) as `UL_NUM_ROHC_DECOMP_HEADER`, SUM(UL_VOL_ROHC_DECOMP_HEADER) as `UL_VOL_ROHC_DECOMP_HEADER`, sum(`DURATION`) * 60 as __duration
FROM `SA_NSN5G_PM.GSITE_PDCP2_R` T1
GROUP BY MINUTE(T1.START_TIME), HOUR(T1.START_TIME), GSITE_WH_ID, T1.MRBTS_ID, T1.NRBTS_ID;
{code}
was (Author: maver1ck):
[~jingge]
Please find following example from our production (with change to datagen)
{code:java}
SET 'execution.runtime-mode' = 'batch';
CREATE TABLE `SA_NSN5G_PM.GSITE_PDCP2_R` (
`DAY_WH_ID` DECIMAL(10, 0),
`GSITE_WH_ID` DECIMAL(10, 0),
`START_TIME` TIMESTAMP(6),
`INSERTION_TIME` TIMESTAMP(6),
`MRBTS_ID` DECIMAL(10, 0),
`NRBTS_ID` DECIMAL(10, 0),
`DURATION` DECIMAL(10, 0),
`MEAS_PERIOD_NR_PDCP_REPORT2` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_REL_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_REL_QOS_GRP_20` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_BUFTH_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_BUFTH_QOS_GRP_20` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`UL_VOL_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_01` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_02` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_03` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_04` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_05` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_06` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_07` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_08` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_09` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_10` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_11` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_12` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_13` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_14` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_15` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_16` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_17` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_18` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_19` DECIMAL(10, 0),
`UL_SDU_DISC_OTHER_QOS_GRP_20` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_01` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_02` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_03` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_04` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_05` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_06` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_07` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_08` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_09` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_10` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_11` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_12` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_13` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_14` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_15` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_16` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_17` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_18` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_19` DECIMAL(10, 0),
`DL_SDU_DISC_QUEDLY_QOS_GRP_20` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_01` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_02` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_03` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_04` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_05` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_06` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_07` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_08` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_09` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_10` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_11` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_12` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_13` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_14` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_15` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_16` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_17` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_18` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_19` DECIMAL(10, 0),
`DL_VOL_DISC_QUEDLY_QOS_GRP_20` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_01` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_02` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_03` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_04` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_05` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_06` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_07` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_08` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_09` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_10` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_11` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_12` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_13` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_14` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_15` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_16` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_17` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_18` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_19` DECIMAL(10, 0),
`DL_DELAY_DISC_QOS_GRP_20` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_01` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_02` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_03` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_04` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_05` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_06` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_07` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_08` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_09` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_10` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_11` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_12` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_13` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_14` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_15` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_16` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_17` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_18` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_19` DECIMAL(10, 0),
`NUM_RETRANS_QOS_GRP_20` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_01` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_02` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_03` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_04` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_05` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_06` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_07` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_08` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_09` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_10` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_11` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_12` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_13` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_14` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_15` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_16` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_17` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_18` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_19` DECIMAL(10, 0),
`VOL_RETRANS_QOS_GRP_20` DECIMAL(10, 0),
`MAX_NUM_OF_DRB` DECIMAL(10, 0),
`DL_NUM_ROHC_COMP_HEADER` DECIMAL(10, 0),
`DL_VOL_ROHC_COMP_HEADER` DECIMAL(10, 0),
`UL_NUM_ROHC_DECOMP_HEADER` DECIMAL(10, 0),
`UL_VOL_ROHC_DECOMP_HEADER` DECIMAL(10, 0),
`KAFKA_PARTID` DECIMAL(10, 0),
`KAFKA_OFFSET` INT
)
COMMENT ''
WITH (
'connector' = 'datagen',
'number-of-rows' = '100'
);
SELECT
MINUTE(T1.START_TIME) as `DAY_WH_ID`,
HOUR(T1.START_TIME) as `START_TIME`,
GSITE_WH_ID as `GSITE_WH_ID`,
T1.MRBTS_ID as `MRBTS_ID`,
T1.NRBTS_ID as `NRBTS_ID`,
SUM(T1.DURATION) as `DURATION`, SUM(MEAS_PERIOD_NR_PDCP_REPORT2) as `MEAS_PERIOD_NR_PDCP_REPORT2`, SUM(DL_VOL_DISC_REL_QOS_GRP_01) as `DL_VOL_DISC_REL_QOS_GRP_01`, SUM(DL_VOL_DISC_REL_QOS_GRP_02) as `DL_VOL_DISC_REL_QOS_GRP_02`, SUM(DL_VOL_DISC_REL_QOS_GRP_03) as `DL_VOL_DISC_REL_QOS_GRP_03`, SUM(DL_VOL_DISC_REL_QOS_GRP_04) as `DL_VOL_DISC_REL_QOS_GRP_04`, SUM(DL_VOL_DISC_REL_QOS_GRP_05) as `DL_VOL_DISC_REL_QOS_GRP_05`, SUM(DL_VOL_DISC_REL_QOS_GRP_06) as `DL_VOL_DISC_REL_QOS_GRP_06`, SUM(DL_VOL_DISC_REL_QOS_GRP_07) as `DL_VOL_DISC_REL_QOS_GRP_07`, SUM(DL_VOL_DISC_REL_QOS_GRP_08) as `DL_VOL_DISC_REL_QOS_GRP_08`, SUM(DL_VOL_DISC_REL_QOS_GRP_09) as `DL_VOL_DISC_REL_QOS_GRP_09`, SUM(DL_VOL_DISC_REL_QOS_GRP_10) as `DL_VOL_DISC_REL_QOS_GRP_10`, SUM(DL_VOL_DISC_REL_QOS_GRP_11) as `DL_VOL_DISC_REL_QOS_GRP_11`, SUM(DL_VOL_DISC_REL_QOS_GRP_12) as `DL_VOL_DISC_REL_QOS_GRP_12`, SUM(DL_VOL_DISC_REL_QOS_GRP_13) as `DL_VOL_DISC_REL_QOS_GRP_13`, SUM(DL_VOL_DISC_REL_QOS_GRP_14) as `DL_VOL_DISC_REL_QOS_GRP_14`, SUM(DL_VOL_DISC_REL_QOS_GRP_15) as `DL_VOL_DISC_REL_QOS_GRP_15`, SUM(DL_VOL_DISC_REL_QOS_GRP_16) as `DL_VOL_DISC_REL_QOS_GRP_16`, SUM(DL_VOL_DISC_REL_QOS_GRP_17) as `DL_VOL_DISC_REL_QOS_GRP_17`, SUM(DL_VOL_DISC_REL_QOS_GRP_18) as `DL_VOL_DISC_REL_QOS_GRP_18`, SUM(DL_VOL_DISC_REL_QOS_GRP_19) as `DL_VOL_DISC_REL_QOS_GRP_19`, SUM(DL_VOL_DISC_REL_QOS_GRP_20) as `DL_VOL_DISC_REL_QOS_GRP_20`, SUM(DL_SDU_DISC_REL_QOS_GRP_01) as `DL_SDU_DISC_REL_QOS_GRP_01`, SUM(DL_SDU_DISC_REL_QOS_GRP_02) as `DL_SDU_DISC_REL_QOS_GRP_02`, SUM(DL_SDU_DISC_REL_QOS_GRP_03) as `DL_SDU_DISC_REL_QOS_GRP_03`, SUM(DL_SDU_DISC_REL_QOS_GRP_04) as `DL_SDU_DISC_REL_QOS_GRP_04`, SUM(DL_SDU_DISC_REL_QOS_GRP_05) as `DL_SDU_DISC_REL_QOS_GRP_05`, SUM(DL_SDU_DISC_REL_QOS_GRP_06) as `DL_SDU_DISC_REL_QOS_GRP_06`, SUM(DL_SDU_DISC_REL_QOS_GRP_07) as `DL_SDU_DISC_REL_QOS_GRP_07`, SUM(DL_SDU_DISC_REL_QOS_GRP_08) as `DL_SDU_DISC_REL_QOS_GRP_08`, SUM(DL_SDU_DISC_REL_QOS_GRP_09) as `DL_SDU_DISC_REL_QOS_GRP_09`, SUM(DL_SDU_DISC_REL_QOS_GRP_10) as `DL_SDU_DISC_REL_QOS_GRP_10`, SUM(DL_SDU_DISC_REL_QOS_GRP_11) as `DL_SDU_DISC_REL_QOS_GRP_11`, SUM(DL_SDU_DISC_REL_QOS_GRP_12) as `DL_SDU_DISC_REL_QOS_GRP_12`, SUM(DL_SDU_DISC_REL_QOS_GRP_13) as `DL_SDU_DISC_REL_QOS_GRP_13`, SUM(DL_SDU_DISC_REL_QOS_GRP_14) as `DL_SDU_DISC_REL_QOS_GRP_14`, SUM(DL_SDU_DISC_REL_QOS_GRP_15) as `DL_SDU_DISC_REL_QOS_GRP_15`, SUM(DL_SDU_DISC_REL_QOS_GRP_16) as `DL_SDU_DISC_REL_QOS_GRP_16`, SUM(DL_SDU_DISC_REL_QOS_GRP_17) as `DL_SDU_DISC_REL_QOS_GRP_17`, SUM(DL_SDU_DISC_REL_QOS_GRP_18) as `DL_SDU_DISC_REL_QOS_GRP_18`, SUM(DL_SDU_DISC_REL_QOS_GRP_19) as `DL_SDU_DISC_REL_QOS_GRP_19`, SUM(DL_SDU_DISC_REL_QOS_GRP_20) as `DL_SDU_DISC_REL_QOS_GRP_20`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_01) as `DL_VOL_DISC_OTHER_QOS_GRP_01`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_02) as `DL_VOL_DISC_OTHER_QOS_GRP_02`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_03) as `DL_VOL_DISC_OTHER_QOS_GRP_03`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_04) as `DL_VOL_DISC_OTHER_QOS_GRP_04`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_05) as `DL_VOL_DISC_OTHER_QOS_GRP_05`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_06) as `DL_VOL_DISC_OTHER_QOS_GRP_06`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_07) as `DL_VOL_DISC_OTHER_QOS_GRP_07`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_08) as `DL_VOL_DISC_OTHER_QOS_GRP_08`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_09) as `DL_VOL_DISC_OTHER_QOS_GRP_09`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_10) as `DL_VOL_DISC_OTHER_QOS_GRP_10`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_11) as `DL_VOL_DISC_OTHER_QOS_GRP_11`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_12) as `DL_VOL_DISC_OTHER_QOS_GRP_12`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_13) as `DL_VOL_DISC_OTHER_QOS_GRP_13`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_14) as `DL_VOL_DISC_OTHER_QOS_GRP_14`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_15) as `DL_VOL_DISC_OTHER_QOS_GRP_15`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_16) as `DL_VOL_DISC_OTHER_QOS_GRP_16`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_17) as `DL_VOL_DISC_OTHER_QOS_GRP_17`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_18) as `DL_VOL_DISC_OTHER_QOS_GRP_18`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_19) as `DL_VOL_DISC_OTHER_QOS_GRP_19`, SUM(DL_VOL_DISC_OTHER_QOS_GRP_20) as `DL_VOL_DISC_OTHER_QOS_GRP_20`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_01) as `DL_SDU_DISC_OTHER_QOS_GRP_01`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_02) as `DL_SDU_DISC_OTHER_QOS_GRP_02`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_03) as `DL_SDU_DISC_OTHER_QOS_GRP_03`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_04) as `DL_SDU_DISC_OTHER_QOS_GRP_04`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_05) as `DL_SDU_DISC_OTHER_QOS_GRP_05`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_06) as `DL_SDU_DISC_OTHER_QOS_GRP_06`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_07) as `DL_SDU_DISC_OTHER_QOS_GRP_07`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_08) as `DL_SDU_DISC_OTHER_QOS_GRP_08`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_09) as `DL_SDU_DISC_OTHER_QOS_GRP_09`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_10) as `DL_SDU_DISC_OTHER_QOS_GRP_10`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_11) as `DL_SDU_DISC_OTHER_QOS_GRP_11`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_12) as `DL_SDU_DISC_OTHER_QOS_GRP_12`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_13) as `DL_SDU_DISC_OTHER_QOS_GRP_13`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_14) as `DL_SDU_DISC_OTHER_QOS_GRP_14`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_15) as `DL_SDU_DISC_OTHER_QOS_GRP_15`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_16) as `DL_SDU_DISC_OTHER_QOS_GRP_16`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_17) as `DL_SDU_DISC_OTHER_QOS_GRP_17`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_18) as `DL_SDU_DISC_OTHER_QOS_GRP_18`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_19) as `DL_SDU_DISC_OTHER_QOS_GRP_19`, SUM(DL_SDU_DISC_OTHER_QOS_GRP_20) as `DL_SDU_DISC_OTHER_QOS_GRP_20`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_01) as `DL_VOL_DISC_BUFTH_QOS_GRP_01`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_02) as `DL_VOL_DISC_BUFTH_QOS_GRP_02`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_03) as `DL_VOL_DISC_BUFTH_QOS_GRP_03`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_04) as `DL_VOL_DISC_BUFTH_QOS_GRP_04`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_05) as `DL_VOL_DISC_BUFTH_QOS_GRP_05`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_06) as `DL_VOL_DISC_BUFTH_QOS_GRP_06`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_07) as `DL_VOL_DISC_BUFTH_QOS_GRP_07`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_08) as `DL_VOL_DISC_BUFTH_QOS_GRP_08`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_09) as `DL_VOL_DISC_BUFTH_QOS_GRP_09`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_10) as `DL_VOL_DISC_BUFTH_QOS_GRP_10`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_11) as `DL_VOL_DISC_BUFTH_QOS_GRP_11`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_12) as `DL_VOL_DISC_BUFTH_QOS_GRP_12`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_13) as `DL_VOL_DISC_BUFTH_QOS_GRP_13`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_14) as `DL_VOL_DISC_BUFTH_QOS_GRP_14`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_15) as `DL_VOL_DISC_BUFTH_QOS_GRP_15`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_16) as `DL_VOL_DISC_BUFTH_QOS_GRP_16`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_17) as `DL_VOL_DISC_BUFTH_QOS_GRP_17`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_18) as `DL_VOL_DISC_BUFTH_QOS_GRP_18`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_19) as `DL_VOL_DISC_BUFTH_QOS_GRP_19`, SUM(DL_VOL_DISC_BUFTH_QOS_GRP_20) as `DL_VOL_DISC_BUFTH_QOS_GRP_20`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_01) as `DL_SDU_DISC_BUFTH_QOS_GRP_01`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_02) as `DL_SDU_DISC_BUFTH_QOS_GRP_02`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_03) as `DL_SDU_DISC_BUFTH_QOS_GRP_03`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_04) as `DL_SDU_DISC_BUFTH_QOS_GRP_04`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_05) as `DL_SDU_DISC_BUFTH_QOS_GRP_05`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_06) as `DL_SDU_DISC_BUFTH_QOS_GRP_06`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_07) as `DL_SDU_DISC_BUFTH_QOS_GRP_07`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_08) as `DL_SDU_DISC_BUFTH_QOS_GRP_08`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_09) as `DL_SDU_DISC_BUFTH_QOS_GRP_09`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_10) as `DL_SDU_DISC_BUFTH_QOS_GRP_10`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_11) as `DL_SDU_DISC_BUFTH_QOS_GRP_11`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_12) as `DL_SDU_DISC_BUFTH_QOS_GRP_12`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_13) as `DL_SDU_DISC_BUFTH_QOS_GRP_13`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_14) as `DL_SDU_DISC_BUFTH_QOS_GRP_14`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_15) as `DL_SDU_DISC_BUFTH_QOS_GRP_15`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_16) as `DL_SDU_DISC_BUFTH_QOS_GRP_16`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_17) as `DL_SDU_DISC_BUFTH_QOS_GRP_17`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_18) as `DL_SDU_DISC_BUFTH_QOS_GRP_18`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_19) as `DL_SDU_DISC_BUFTH_QOS_GRP_19`, SUM(DL_SDU_DISC_BUFTH_QOS_GRP_20) as `DL_SDU_DISC_BUFTH_QOS_GRP_20`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_01) as `UL_VOL_DISC_OTHER_QOS_GRP_01`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_02) as `UL_VOL_DISC_OTHER_QOS_GRP_02`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_03) as `UL_VOL_DISC_OTHER_QOS_GRP_03`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_04) as `UL_VOL_DISC_OTHER_QOS_GRP_04`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_05) as `UL_VOL_DISC_OTHER_QOS_GRP_05`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_06) as `UL_VOL_DISC_OTHER_QOS_GRP_06`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_07) as `UL_VOL_DISC_OTHER_QOS_GRP_07`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_08) as `UL_VOL_DISC_OTHER_QOS_GRP_08`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_09) as `UL_VOL_DISC_OTHER_QOS_GRP_09`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_10) as `UL_VOL_DISC_OTHER_QOS_GRP_10`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_11) as `UL_VOL_DISC_OTHER_QOS_GRP_11`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_12) as `UL_VOL_DISC_OTHER_QOS_GRP_12`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_13) as `UL_VOL_DISC_OTHER_QOS_GRP_13`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_14) as `UL_VOL_DISC_OTHER_QOS_GRP_14`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_15) as `UL_VOL_DISC_OTHER_QOS_GRP_15`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_16) as `UL_VOL_DISC_OTHER_QOS_GRP_16`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_17) as `UL_VOL_DISC_OTHER_QOS_GRP_17`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_18) as `UL_VOL_DISC_OTHER_QOS_GRP_18`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_19) as `UL_VOL_DISC_OTHER_QOS_GRP_19`, SUM(UL_VOL_DISC_OTHER_QOS_GRP_20) as `UL_VOL_DISC_OTHER_QOS_GRP_20`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_01) as `UL_SDU_DISC_OTHER_QOS_GRP_01`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_02) as `UL_SDU_DISC_OTHER_QOS_GRP_02`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_03) as `UL_SDU_DISC_OTHER_QOS_GRP_03`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_04) as `UL_SDU_DISC_OTHER_QOS_GRP_04`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_05) as `UL_SDU_DISC_OTHER_QOS_GRP_05`,
SUM(UL_SDU_DISC_OTHER_QOS_GRP_06) as `UL_SDU_DISC_OTHER_QOS_GRP_06`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_07) as `UL_SDU_DISC_OTHER_QOS_GRP_07`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_08) as `UL_SDU_DISC_OTHER_QOS_GRP_08`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_09) as `UL_SDU_DISC_OTHER_QOS_GRP_09`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_10) as `UL_SDU_DISC_OTHER_QOS_GRP_10`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_11) as `UL_SDU_DISC_OTHER_QOS_GRP_11`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_12) as `UL_SDU_DISC_OTHER_QOS_GRP_12`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_13) as `UL_SDU_DISC_OTHER_QOS_GRP_13`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_14) as `UL_SDU_DISC_OTHER_QOS_GRP_14`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_15) as `UL_SDU_DISC_OTHER_QOS_GRP_15`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_16) as `UL_SDU_DISC_OTHER_QOS_GRP_16`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_17) as `UL_SDU_DISC_OTHER_QOS_GRP_17`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_18) as `UL_SDU_DISC_OTHER_QOS_GRP_18`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_19) as `UL_SDU_DISC_OTHER_QOS_GRP_19`, SUM(UL_SDU_DISC_OTHER_QOS_GRP_20) as `UL_SDU_DISC_OTHER_QOS_GRP_20`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_01) as `DL_SDU_DISC_QUEDLY_QOS_GRP_01`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_02) as `DL_SDU_DISC_QUEDLY_QOS_GRP_02`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_03) as `DL_SDU_DISC_QUEDLY_QOS_GRP_03`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_04) as `DL_SDU_DISC_QUEDLY_QOS_GRP_04`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_05) as `DL_SDU_DISC_QUEDLY_QOS_GRP_05`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_06) as `DL_SDU_DISC_QUEDLY_QOS_GRP_06`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_07) as `DL_SDU_DISC_QUEDLY_QOS_GRP_07`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_08) as `DL_SDU_DISC_QUEDLY_QOS_GRP_08`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_09) as `DL_SDU_DISC_QUEDLY_QOS_GRP_09`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_10) as `DL_SDU_DISC_QUEDLY_QOS_GRP_10`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_11) as `DL_SDU_DISC_QUEDLY_QOS_GRP_11`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_12) as `DL_SDU_DISC_QUEDLY_QOS_GRP_12`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_13) as `DL_SDU_DISC_QUEDLY_QOS_GRP_13`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_14) as `DL_SDU_DISC_QUEDLY_QOS_GRP_14`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_15) as `DL_SDU_DISC_QUEDLY_QOS_GRP_15`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_16) as `DL_SDU_DISC_QUEDLY_QOS_GRP_16`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_17) as `DL_SDU_DISC_QUEDLY_QOS_GRP_17`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_18) as `DL_SDU_DISC_QUEDLY_QOS_GRP_18`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_19) as `DL_SDU_DISC_QUEDLY_QOS_GRP_19`, SUM(DL_SDU_DISC_QUEDLY_QOS_GRP_20) as `DL_SDU_DISC_QUEDLY_QOS_GRP_20`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_01) as `DL_VOL_DISC_QUEDLY_QOS_GRP_01`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_02) as `DL_VOL_DISC_QUEDLY_QOS_GRP_02`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_03) as `DL_VOL_DISC_QUEDLY_QOS_GRP_03`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_04) as `DL_VOL_DISC_QUEDLY_QOS_GRP_04`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_05) as `DL_VOL_DISC_QUEDLY_QOS_GRP_05`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_06) as `DL_VOL_DISC_QUEDLY_QOS_GRP_06`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_07) as `DL_VOL_DISC_QUEDLY_QOS_GRP_07`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_08) as `DL_VOL_DISC_QUEDLY_QOS_GRP_08`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_09) as `DL_VOL_DISC_QUEDLY_QOS_GRP_09`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_10) as `DL_VOL_DISC_QUEDLY_QOS_GRP_10`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_11) as `DL_VOL_DISC_QUEDLY_QOS_GRP_11`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_12) as `DL_VOL_DISC_QUEDLY_QOS_GRP_12`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_13) as `DL_VOL_DISC_QUEDLY_QOS_GRP_13`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_14) as `DL_VOL_DISC_QUEDLY_QOS_GRP_14`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_15) as `DL_VOL_DISC_QUEDLY_QOS_GRP_15`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_16) as `DL_VOL_DISC_QUEDLY_QOS_GRP_16`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_17) as `DL_VOL_DISC_QUEDLY_QOS_GRP_17`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_18) as `DL_VOL_DISC_QUEDLY_QOS_GRP_18`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_19) as `DL_VOL_DISC_QUEDLY_QOS_GRP_19`, SUM(DL_VOL_DISC_QUEDLY_QOS_GRP_20) as `DL_VOL_DISC_QUEDLY_QOS_GRP_20`, SUM(DL_DELAY_DISC_QOS_GRP_01) as `DL_DELAY_DISC_QOS_GRP_01`, SUM(DL_DELAY_DISC_QOS_GRP_02) as `DL_DELAY_DISC_QOS_GRP_02`, SUM(DL_DELAY_DISC_QOS_GRP_03) as `DL_DELAY_DISC_QOS_GRP_03`, SUM(DL_DELAY_DISC_QOS_GRP_04) as `DL_DELAY_DISC_QOS_GRP_04`, SUM(DL_DELAY_DISC_QOS_GRP_05) as `DL_DELAY_DISC_QOS_GRP_05`, SUM(DL_DELAY_DISC_QOS_GRP_06) as `DL_DELAY_DISC_QOS_GRP_06`, SUM(DL_DELAY_DISC_QOS_GRP_07) as `DL_DELAY_DISC_QOS_GRP_07`, SUM(DL_DELAY_DISC_QOS_GRP_08) as `DL_DELAY_DISC_QOS_GRP_08`, SUM(DL_DELAY_DISC_QOS_GRP_09) as `DL_DELAY_DISC_QOS_GRP_09`, SUM(DL_DELAY_DISC_QOS_GRP_10) as `DL_DELAY_DISC_QOS_GRP_10`, SUM(DL_DELAY_DISC_QOS_GRP_11) as `DL_DELAY_DISC_QOS_GRP_11`, SUM(DL_DELAY_DISC_QOS_GRP_12) as `DL_DELAY_DISC_QOS_GRP_12`, SUM(DL_DELAY_DISC_QOS_GRP_13) as `DL_DELAY_DISC_QOS_GRP_13`, SUM(DL_DELAY_DISC_QOS_GRP_14) as `DL_DELAY_DISC_QOS_GRP_14`, SUM(DL_DELAY_DISC_QOS_GRP_15) as `DL_DELAY_DISC_QOS_GRP_15`, SUM(DL_DELAY_DISC_QOS_GRP_16) as `DL_DELAY_DISC_QOS_GRP_16`, SUM(DL_DELAY_DISC_QOS_GRP_17) as `DL_DELAY_DISC_QOS_GRP_17`, SUM(DL_DELAY_DISC_QOS_GRP_18) as `DL_DELAY_DISC_QOS_GRP_18`, SUM(DL_DELAY_DISC_QOS_GRP_19) as `DL_DELAY_DISC_QOS_GRP_19`, SUM(DL_DELAY_DISC_QOS_GRP_20) as `DL_DELAY_DISC_QOS_GRP_20`, SUM(NUM_RETRANS_QOS_GRP_01) as `NUM_RETRANS_QOS_GRP_01`, SUM(NUM_RETRANS_QOS_GRP_02) as `NUM_RETRANS_QOS_GRP_02`, SUM(NUM_RETRANS_QOS_GRP_03) as `NUM_RETRANS_QOS_GRP_03`, SUM(NUM_RETRANS_QOS_GRP_04) as `NUM_RETRANS_QOS_GRP_04`, SUM(NUM_RETRANS_QOS_GRP_05) as `NUM_RETRANS_QOS_GRP_05`, SUM(NUM_RETRANS_QOS_GRP_06) as `NUM_RETRANS_QOS_GRP_06`, SUM(NUM_RETRANS_QOS_GRP_07) as `NUM_RETRANS_QOS_GRP_07`, SUM(NUM_RETRANS_QOS_GRP_08) as `NUM_RETRANS_QOS_GRP_08`, SUM(NUM_RETRANS_QOS_GRP_09) as `NUM_RETRANS_QOS_GRP_09`, SUM(NUM_RETRANS_QOS_GRP_10) as `NUM_RETRANS_QOS_GRP_10`, SUM(NUM_RETRANS_QOS_GRP_11) as `NUM_RETRANS_QOS_GRP_11`, SUM(NUM_RETRANS_QOS_GRP_12) as `NUM_RETRANS_QOS_GRP_12`, SUM(NUM_RETRANS_QOS_GRP_13) as `NUM_RETRANS_QOS_GRP_13`, SUM(NUM_RETRANS_QOS_GRP_14) as `NUM_RETRANS_QOS_GRP_14`, SUM(NUM_RETRANS_QOS_GRP_15) as `NUM_RETRANS_QOS_GRP_15`, SUM(NUM_RETRANS_QOS_GRP_16) as `NUM_RETRANS_QOS_GRP_16`, SUM(NUM_RETRANS_QOS_GRP_17) as `NUM_RETRANS_QOS_GRP_17`, SUM(NUM_RETRANS_QOS_GRP_18) as `NUM_RETRANS_QOS_GRP_18`, SUM(NUM_RETRANS_QOS_GRP_19) as `NUM_RETRANS_QOS_GRP_19`, SUM(NUM_RETRANS_QOS_GRP_20) as `NUM_RETRANS_QOS_GRP_20`, SUM(VOL_RETRANS_QOS_GRP_01) as `VOL_RETRANS_QOS_GRP_01`, SUM(VOL_RETRANS_QOS_GRP_02) as `VOL_RETRANS_QOS_GRP_02`, SUM(VOL_RETRANS_QOS_GRP_03) as `VOL_RETRANS_QOS_GRP_03`, SUM(VOL_RETRANS_QOS_GRP_04) as `VOL_RETRANS_QOS_GRP_04`, SUM(VOL_RETRANS_QOS_GRP_05) as `VOL_RETRANS_QOS_GRP_05`, SUM(VOL_RETRANS_QOS_GRP_06) as `VOL_RETRANS_QOS_GRP_06`, SUM(VOL_RETRANS_QOS_GRP_07) as `VOL_RETRANS_QOS_GRP_07`, SUM(VOL_RETRANS_QOS_GRP_08) as `VOL_RETRANS_QOS_GRP_08`, SUM(VOL_RETRANS_QOS_GRP_09) as `VOL_RETRANS_QOS_GRP_09`, SUM(VOL_RETRANS_QOS_GRP_10) as `VOL_RETRANS_QOS_GRP_10`, SUM(VOL_RETRANS_QOS_GRP_11) as `VOL_RETRANS_QOS_GRP_11`, SUM(VOL_RETRANS_QOS_GRP_12) as `VOL_RETRANS_QOS_GRP_12`, SUM(VOL_RETRANS_QOS_GRP_13) as `VOL_RETRANS_QOS_GRP_13`, SUM(VOL_RETRANS_QOS_GRP_14) as `VOL_RETRANS_QOS_GRP_14`, SUM(VOL_RETRANS_QOS_GRP_15) as `VOL_RETRANS_QOS_GRP_15`, SUM(VOL_RETRANS_QOS_GRP_16) as `VOL_RETRANS_QOS_GRP_16`, SUM(VOL_RETRANS_QOS_GRP_17) as `VOL_RETRANS_QOS_GRP_17`, SUM(VOL_RETRANS_QOS_GRP_18) as `VOL_RETRANS_QOS_GRP_18`, SUM(VOL_RETRANS_QOS_GRP_19) as `VOL_RETRANS_QOS_GRP_19`, SUM(VOL_RETRANS_QOS_GRP_20) as `VOL_RETRANS_QOS_GRP_20`, MAX(MAX_NUM_OF_DRB) as `MAX_NUM_OF_DRB`, SUM(DL_NUM_ROHC_COMP_HEADER) as `DL_NUM_ROHC_COMP_HEADER`, SUM(DL_VOL_ROHC_COMP_HEADER) as `DL_VOL_ROHC_COMP_HEADER`, SUM(UL_NUM_ROHC_DECOMP_HEADER) as `UL_NUM_ROHC_DECOMP_HEADER`, SUM(UL_VOL_ROHC_DECOMP_HEADER) as `UL_VOL_ROHC_DECOMP_HEADER`, sum(`DURATION`) * 60 as __duration
FROM `SA_NSN5G_PM.GSITE_PDCP2_R` T1
GROUP BY MINUTE(T1.START_TIME), HOUR(T1.START_TIME), GSITE_WH_ID, T1.MRBTS_ID, T1.NRBTS_ID;
{code}
> Code of method "processElement(Lorg/apache/flink/streaming/runtime/streamrecord/StreamRecord;)V" of class "HashAggregateWithKeys$9211" grows beyond 64 KB
> ---------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: FLINK-27246
> URL: https://issues.apache.org/jira/browse/FLINK-27246
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Runtime
> Affects Versions: 1.14.3
> Reporter: Maciej Bryński
> Priority: Major
>
> I think this bug should get fixed in https://issues.apache.org/jira/browse/FLINK-23007
> Unfortunately I spotted it on Flink 1.14.3
> {code}
> java.lang.RuntimeException: Could not instantiate generated class 'HashAggregateWithKeys$9211'
> at org.apache.flink.table.runtime.generated.GeneratedClass.newInstance(GeneratedClass.java:85) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.operators.CodeGenOperatorFactory.createStreamOperator(CodeGenOperatorFactory.java:40) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.streaming.api.operators.StreamOperatorFactoryUtil.createOperator(StreamOperatorFactoryUtil.java:81) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.streaming.runtime.tasks.OperatorChain.<init>(OperatorChain.java:198) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.streaming.runtime.tasks.RegularOperatorChain.<init>(RegularOperatorChain.java:63) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.streaming.runtime.tasks.StreamTask.restoreInternal(StreamTask.java:666) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.streaming.runtime.tasks.StreamTask.restore(StreamTask.java:654) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:958) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:927) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.runtime.taskmanager.Task.doRun(Task.java:766) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.runtime.taskmanager.Task.run(Task.java:575) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at java.lang.Thread.run(Unknown Source) ~[?:?]
> Caused by: org.apache.flink.util.FlinkRuntimeException: org.apache.flink.api.common.InvalidProgramException: Table program cannot be compiled. This is a bug. Please file an issue.
> at org.apache.flink.table.runtime.generated.CompileUtils.compile(CompileUtils.java:76) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.compile(GeneratedClass.java:102) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.newInstance(GeneratedClass.java:83) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> ... 11 more
> Caused by: org.apache.flink.shaded.guava30.com.google.common.util.concurrent.UncheckedExecutionException: org.apache.flink.api.common.InvalidProgramException: Table program cannot be compiled. This is a bug. Please file an issue.
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2051) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache.get(LocalCache.java:3962) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4859) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.compile(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.compile(GeneratedClass.java:102) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.newInstance(GeneratedClass.java:83) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> ... 11 more
> Caused by: org.apache.flink.api.common.InvalidProgramException: Table program cannot be compiled. This is a bug. Please file an issue.
> at org.apache.flink.table.runtime.generated.CompileUtils.doCompile(CompileUtils.java:89) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.lambda$compile$1(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4864) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache.get(LocalCache.java:3962) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4859) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.compile(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.compile(GeneratedClass.java:102) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.newInstance(GeneratedClass.java:83) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> ... 11 more
> Caused by: org.codehaus.janino.InternalCompilerException: Compiling "HashAggregateWithKeys$9211": Code of method "processElement(Lorg/apache/flink/streaming/runtime/streamrecord/StreamRecord;)V" of class "HashAggregateWithKeys$9211" grows beyond 64 KB
> at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:382) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:237) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:465) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:216) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:207) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:80) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:75) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.doCompile(CompileUtils.java:86) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.lambda$compile$1(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4864) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache.get(LocalCache.java:3962) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4859) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.compile(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.compile(GeneratedClass.java:102) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.newInstance(GeneratedClass.java:83) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> ... 11 more
> Caused by: org.codehaus.janino.InternalCompilerException: Code of method "processElement(Lorg/apache/flink/streaming/runtime/streamrecord/StreamRecord;)V" of class "HashAggregateWithKeys$9211" grows beyond 64 KB
> at org.codehaus.janino.CodeContext.makeSpace(CodeContext.java:1048) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.CodeContext.write(CodeContext.java:940) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.writeShort(UnitCompiler.java:12282) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.load(UnitCompiler.java:11941) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.load(UnitCompiler.java:11926) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4465) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$8000(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16$1.visitLocalVariableAccess(UnitCompiler.java:4408) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16$1.visitLocalVariableAccess(UnitCompiler.java:4400) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$LocalVariableAccess.accept(Java.java:4274) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitLvalue(UnitCompiler.java:4400) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitLvalue(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Lvalue.accept(Java.java:4148) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4461) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$7500(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16$1.visitAmbiguousName(UnitCompiler.java:4403) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16$1.visitAmbiguousName(UnitCompiler.java:4400) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$AmbiguousName.accept(Java.java:4224) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitLvalue(UnitCompiler.java:4400) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitLvalue(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Lvalue.accept(Java.java:4148) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:5662) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileBoolean2(UnitCompiler.java:4120) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$6600(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$14.visitBinaryOperation(UnitCompiler.java:3957) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$14.visitBinaryOperation(UnitCompiler.java:3935) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$BinaryOperation.accept(Java.java:4864) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileBoolean(UnitCompiler.java:3935) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4448) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:5004) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$8500(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitBinaryOperation(UnitCompiler.java:4417) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitBinaryOperation(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$BinaryOperation.accept(Java.java:4864) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:5057) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$8100(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16$1.visitParenthesizedExpression(UnitCompiler.java:4409) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16$1.visitParenthesizedExpression(UnitCompiler.java:4400) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$ParenthesizedExpression.accept(Java.java:4924) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitLvalue(UnitCompiler.java:4400) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$16.visitLvalue(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Lvalue.accept(Java.java:4148) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:4396) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:5662) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:3792) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$6100(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$13.visitAssignment(UnitCompiler.java:3754) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$13.visitAssignment(UnitCompiler.java:3734) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Assignment.accept(Java.java:4477) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:3734) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2360) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1800(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitExpressionStatement(UnitCompiler.java:1494) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitExpressionStatement(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$ExpressionStatement.accept(Java.java:2874) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1553) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1700(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1493) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Block.accept(Java.java:2779) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2476) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1900(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1495) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$IfStatement.accept(Java.java:2950) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1553) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1700(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1493) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Block.accept(Java.java:2779) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2468) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1900(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1495) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$IfStatement.accept(Java.java:2950) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1553) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1700(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1493) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Block.accept(Java.java:2779) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2468) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1900(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1495) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$IfStatement.accept(Java.java:2950) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1553) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1700(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1493) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$Block.accept(Java.java:2779) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2468) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$1900(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1495) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$6.visitIfStatement(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$IfStatement.accept(Java.java:2950) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:3388) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:1357) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:1330) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:822) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:432) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:215) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:411) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:406) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1414) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:406) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:378) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:237) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:465) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:216) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:207) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:80) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:75) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.doCompile(CompileUtils.java:86) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.lambda$compile$1(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4864) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache.get(LocalCache.java:3962) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.shaded.guava30.com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4859) ~[flink-dist_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.CompileUtils.compile(CompileUtils.java:74) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.compile(GeneratedClass.java:102) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> at org.apache.flink.table.runtime.generated.GeneratedClass.newInstance(GeneratedClass.java:83) ~[flink-table_2.12-1.14.3-stream1.jar:1.14.3-stream1]
> ... 11 more
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)