==========================[QUERY]=============================== 2018-01-24 16:48:42,803 INFO [pool-8-thread-1] threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0 actual running, 0 stopped, 0 ready, 55 already succeed, 15 error, 0 discarded, 0 others 2018-01-24 16:49:05,231 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] service.QueryService:396 : Using project: Anovadata 2018-01-24 16:49:05,231 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] service.QueryService:397 : The original query: select a.imsiid,d_device_v.manufacturer_name,d_cell_v.region_3,sum(a.event_count),sum(a.sig_event_count),sum(a.sig_event_duration),sum(a.vl_call_duration),sum(a.retransmission_count),sum(a.succ_call_flg),sum(a.fail_call_flg),sum(a.ow_call_flg),sum(a.lost_call_flg),sum(a.volte_call_flg),count( distinct a.active_call_id),sum(a.urp_lost),sum(a.urp_expected),sum(a.ur_jitter_time),sum(a.ur_jitter_count),sum(a.drp_lost),sum(a.drp_expected),sum(a.dr_jitter_time),sum(a.dr_jitter_count),sum(a.no_media_call_flg),count(distinct a.media_gap_call_id),sum(a.vl_ul_first_resp_delay),sum(a.vl_dl_first_resp_delay),sum(a.vl_ul_call_prog_delay),sum(a.vl_dl_call_prog_delay),sum(a.ul_mos_class0_count),sum(a.ul_mos_class1_count),sum(a.ul_mos_class2_count),sum(a.ul_mos_class3_count),sum(a.ul_mos_class4_count),sum(a.ul_mos_class5_count),sum(a.dl_mos_class0_count),sum(a.dl_mos_class1_count),sum(a.dl_mos_class2_count),sum(a.dl_mos_class3_count),sum(a.dl_mos_class4_count),sum(a.dl_mos_class5_count),sum(a.reg_succ_call_flg),sum(a.reg_fail_call_flg),sum(a.vl_ul_first_resp_delay_count),sum(a.vl_dl_first_resp_delay_count),sum(a.vl_ul_call_prog_delay_count),sum(a.vl_dl_call_prog_delay_count),sum(a.ul_mos_sum),sum(a.dl_mos_sum),sum(a.ul_mos_count),sum(a.dl_mos_count),sum(a.internw_succ_call_flg),sum(a.internw_fail_call_flg),sum(a.ul_ow_call_flg),sum(a.dl_ow_call_flg),count(distinct a.ul_media_gap_call_id),count(distinct a.dl_media_gap_call_id) from a_vl_hourly_v a inner join d_device_v on a.device_key = d_device_v.device_key inner join d_cell_v on a.cell_key = d_cell_v.cell_key where a.time_key >= '201711200100' and a.time_key < '201711200400' group by a.imsiid,d_device_v.manufacturer_name,d_cell_v.region_3 2018-01-24 16:49:05,231 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] util.CheckUtil:35 : query cache disabled in KylinConfig 2018-01-24 16:49:05,232 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPSchemaFactory:116 : Schema json:{ "version": "1.0", "defaultSchema": "ZETTICSDW", "schemas": [ { "type": "custom", "name": "ZETTICSDW", "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory", "operand": { "project": "ANOVADATA" }, "functions": [ { name: 'PERCENTILE_APPROX', className: 'org.apache.kylin.measure.percentile.PercentileAggFunc' }, { name: 'PERCENTILE', className: 'org.apache.kylin.measure.percentile.PercentileAggFunc' }, { name: 'INTERSECT_COUNT', className: 'org.apache.kylin.measure.bitmap.BitmapIntersectDistinctCountAggFunc' }, { name: 'MASSIN', className: 'org.apache.kylin.query.udf.MassInUDF' }, { name: 'CONCAT', className: 'org.apache.kylin.query.udf.ConcatUDF' }, { name: 'VERSION', className: 'org.apache.kylin.query.udf.VersionUDF' } ] } ] } 2018-01-24 16:49:05,239 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] service.QueryService:547 : The corrected query: select a.imsiid,d_device_v.manufacturer_name,d_cell_v.region_3,sum(a.event_count),sum(a.sig_event_count),sum(a.sig_event_duration),sum(a.vl_call_duration),sum(a.retransmission_count),sum(a.succ_call_flg),sum(a.fail_call_flg),sum(a.ow_call_flg),sum(a.lost_call_flg),sum(a.volte_call_flg),count( distinct a.active_call_id),sum(a.urp_lost),sum(a.urp_expected),sum(a.ur_jitter_time),sum(a.ur_jitter_count),sum(a.drp_lost),sum(a.drp_expected),sum(a.dr_jitter_time),sum(a.dr_jitter_count),sum(a.no_media_call_flg),count(distinct a.media_gap_call_id),sum(a.vl_ul_first_resp_delay),sum(a.vl_dl_first_resp_delay),sum(a.vl_ul_call_prog_delay),sum(a.vl_dl_call_prog_delay),sum(a.ul_mos_class0_count),sum(a.ul_mos_class1_count),sum(a.ul_mos_class2_count),sum(a.ul_mos_class3_count),sum(a.ul_mos_class4_count),sum(a.ul_mos_class5_count),sum(a.dl_mos_class0_count),sum(a.dl_mos_class1_count),sum(a.dl_mos_class2_count),sum(a.dl_mos_class3_count),sum(a.dl_mos_class4_count),sum(a.dl_mos_class5_count),sum(a.reg_succ_call_flg),sum(a.reg_fail_call_flg),sum(a.vl_ul_first_resp_delay_count),sum(a.vl_dl_first_resp_delay_count),sum(a.vl_ul_call_prog_delay_count),sum(a.vl_dl_call_prog_delay_count),sum(a.ul_mos_sum),sum(a.dl_mos_sum),sum(a.ul_mos_count),sum(a.dl_mos_count),sum(a.internw_succ_call_flg),sum(a.internw_fail_call_flg),sum(a.ul_ow_call_flg),sum(a.dl_ow_call_flg),count(distinct a.ul_media_gap_call_id),count(distinct a.dl_media_gap_call_id) from a_vl_hourly_v a inner join d_device_v on a.device_key = d_device_v.device_key inner join d_cell_v on a.cell_key = d_cell_v.cell_key where a.time_key >= '201711200100' and a.time_key < '201711200400' group by a.imsiid,d_device_v.manufacturer_name,d_cell_v.region_3 LIMIT 50000 2018-01-24 16:49:05,262 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='58', name='INTERNW_SUCC_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,262 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='48', name='REG_FAIL_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,262 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='47', name='REG_SUCC_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,263 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='59', name='INTERNW_FAIL_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,263 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='62', name='DL_OW_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,263 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='61', name='UL_OW_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,263 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='11', name='OW_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,263 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='12', name='NO_MEDIA_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,263 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='9', name='SUCC_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,264 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='15', name='VOLTE_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,264 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='10', name='FAIL_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,264 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='14', name='LOST_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,273 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='58', name='INTERNW_SUCC_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,273 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='48', name='REG_FAIL_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,273 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='47', name='REG_SUCC_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,273 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='59', name='INTERNW_FAIL_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,273 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='62', name='DL_OW_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,274 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='61', name='UL_OW_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,274 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='11', name='OW_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,274 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='12', name='NO_MEDIA_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,274 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='9', name='SUCC_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,274 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='15', name='VOLTE_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,275 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='10', name='FAIL_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,275 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] schema.OLAPTable:233 : To avoid overflow, upgraded ColumnDesc{id='14', name='LOST_CALL_FLG', datatype='integer', comment='null'}'s type from integer to bigint 2018-01-24 16:49:05,307 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] routing.QueryRouter:57 : Find candidates by table ZETTICSDW.A_VL_HOURLY_V and project=ANOVADATA : CUBE[name=vl_aggs_timekey_cube] 2018-01-24 16:49:05,308 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule, realizations before: [vl_aggs_timekey_cube(CUBE)], realizations after: [vl_aggs_timekey_cube(CUBE)] 2018-01-24 16:49:05,308 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule, realizations before: [vl_aggs_timekey_cube(CUBE)], realizations after: [vl_aggs_timekey_cube(CUBE)] 2018-01-24 16:49:05,308 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] rules.RealizationSortRule:40 : CUBE[name=vl_aggs_timekey_cube] priority 1 cost 985. 2018-01-24 16:49:05,308 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before: [vl_aggs_timekey_cube(CUBE)], realizations after: [vl_aggs_timekey_cube(CUBE)] 2018-01-24 16:49:05,309 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] routing.QueryRouter:74 : The realizations remaining: [vl_aggs_timekey_cube(CUBE)] And the final chosen one is the first one 2018-01-24 16:49:05,389 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] enumerator.OLAPEnumerator:109 : query storage... 2018-01-24 16:49:05,390 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.GTCubeStorageQueryBase:284 : Need storage aggregation 2018-01-24 16:49:05,390 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.GTCubeStorageQueryBase:503 : exactAggregation is false because need storage aggregation 2018-01-24 16:49:05,390 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] storage.StorageContext:146 : Enabling limit push down: 50000 at level: LIMIT_ON_SCAN 2018-01-24 16:49:05,390 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.GTCubeStorageQueryBase:429 : Aggregate partition results is not beneficial because shard by columns in groupD: [ZETTICSDW.A_VL_HOURLY_V.IMSIID] 2018-01-24 16:49:05,390 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.GTCubeStorageQueryBase:166 : Cuboid identified: cube=vl_aggs_timekey_cube, cuboidId=136193, groupsD=[ZETTICSDW.D_CELL_V.REGION_3, ZETTICSDW.A_VL_HOURLY_V.IMSIID, ZETTICSDW.D_DEVICE_V.MANUFACTURER_NAME], filterD=[ZETTICSDW.A_VL_HOURLY_V.TIME_KEY], limitPushdown=50000, limitLevel=LIMIT_ON_SCAN, storageAggr=true 2018-01-24 16:49:05,391 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120000000_20171120010000 2018-01-24 16:49:05,391 ERROR [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] dict.TrieDictionary:155 : Not a valid value: 201711200100 2018-01-24 16:49:05,392 ERROR [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] dict.TrieDictionary:155 : Not a valid value: 201711200400 2018-01-24 16:49:05,392 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] filter.FilterOptimizeTransformer:98 : Optimized {AND [[], [null]]} to ConstantTupleFilter.FALSE 2018-01-24 16:49:05,392 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.ScannerWorker:44 : Segment vl_aggs_timekey_cube[20171120000000_20171120010000] will be skipped 2018-01-24 16:49:05,393 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120010000_20171120020000 2018-01-24 16:49:05,393 ERROR [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] dict.TrieDictionary:155 : Not a valid value: 201711200400 2018-01-24 16:49:05,394 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,394 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1572 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,394 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 4f48f3d9 for segment vl_aggs_timekey_cube[20171120010000_20171120020000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,395 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_C5BCJ8SAZS: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\xFF\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\xFF\x00), No Fuzzy Key 2018-01-24 16:49:05,395 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 2 shards starting from shard 1, scan range count 1 2018-01-24 16:49:05,395 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,401 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,401 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120020000_20171120030000 2018-01-24 16:49:05,402 ERROR [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] dict.TrieDictionary:155 : Not a valid value: 201711200400 2018-01-24 16:49:05,403 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,403 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1572 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,403 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 2ec1ad1a for segment vl_aggs_timekey_cube[20171120020000_20171120030000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,403 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_J8RURCM1NP: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\xFF\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\xFF\x00), No Fuzzy Key 2018-01-24 16:49:05,404 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 2 shards starting from shard 1, scan range count 1 2018-01-24 16:49:05,404 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,410 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,411 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120030000_20171120040000 2018-01-24 16:49:05,411 ERROR [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] dict.TrieDictionary:155 : Not a valid value: 201711200400 2018-01-24 16:49:05,412 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,413 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1572 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,413 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan fc1d08d for segment vl_aggs_timekey_cube[20171120030000_20171120040000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,413 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_TYWXW6I254: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\xFF\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\xFF\x00), No Fuzzy Key 2018-01-24 16:49:05,413 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,414 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,420 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,421 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120040000_20171120050000 2018-01-24 16:49:05,422 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,423 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,423 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 789c4f26 for segment vl_aggs_timekey_cube[20171120040000_20171120050000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,423 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_U5EPNROT29: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,424 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,424 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,430 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,431 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120050000_20171120060000 2018-01-24 16:49:05,434 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,435 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,435 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 7544457 for segment vl_aggs_timekey_cube[20171120050000_20171120060000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,436 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_27BN0H29KE: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,436 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,436 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,447 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,448 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120060000_20171120070000 2018-01-24 16:49:05,450 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,451 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,451 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 44ffa5ea for segment vl_aggs_timekey_cube[20171120060000_20171120070000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,452 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_L845LR2E3H: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,452 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,453 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,463 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,464 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120070000_20171120080000 2018-01-24 16:49:05,467 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,468 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,468 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan fe2a580 for segment vl_aggs_timekey_cube[20171120070000_20171120080000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,469 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_F4NN9LLVYN: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,469 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,470 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,481 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,482 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120080000_20171120090000 2018-01-24 16:49:05,484 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,485 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,485 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 669ad849 for segment vl_aggs_timekey_cube[20171120080000_20171120090000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,486 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_TLEBD8NUI0: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,486 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,487 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,497 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,498 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120090000_20171120100000 2018-01-24 16:49:05,502 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,502 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,502 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 259fa0e1 for segment vl_aggs_timekey_cube[20171120090000_20171120100000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,503 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_EZZ3UR33IP: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,503 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,503 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,510 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:05,510 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20171120100000_20171120110000 2018-01-24 16:49:05,512 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:313 : hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor 2018-01-24 16:49:05,512 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:140 : Serialized scanRequestBytes 1617 bytes, rawScanBytesString 55 bytes 2018-01-24 16:49:05,512 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:142 : The scan 19d58508 for segment vl_aggs_timekey_cube[20171120100000_20171120110000] is as below with 1 separate raw scans, shard part of start/end key is set to 0 2018-01-24 16:49:05,513 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseRPC:287 : Visiting hbase table ANOVA_KYLIN_22X_3XRU46YM0M: cuboid exact match, from 136193 to 136193 Start: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\x00\x00\x00\x00\x00\x00) Stop: \x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00 (\x00\x00\x00\x00\x00\x00\x00\x02\x14\x01\xFF\xFF\xFF\xFF\xFF\x00\x00), No Fuzzy Key 2018-01-24 16:49:05,513 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] v2.CubeHBaseEndpointRPC:147 : Submitting rpc to 1 shards starting from shard 0, scan range count 1 2018-01-24 16:49:05,513 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:315 : Loading kylin-defaults.properties from file:/home/zettics/kylin/apache-kylin-2.2.1-anovadata-bin-20180124/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.2.1-anovadata.jar!/kylin-defaults.properties 2018-01-24 16:49:05,520 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] common.KylinConfig:274 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable 2018-01-24 16:49:06,486 INFO [kylin-coproc--pool58-t215] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_C5BCJ8SAZS Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x43\x35\x42\x43\x4A\x38\x53\x41\x5A\x53\x2C\x2C\x31\x35\x31\x36\x38\x32\x34\x31\x34\x36\x31\x35\x33\x2E\x62\x33\x31\x31\x36\x66\x31\x33\x34\x63\x30\x62\x62\x36\x37\x39\x64\x33\x66\x61\x34\x36\x34\x32\x63\x39\x64\x37\x65\x33\x35\x37\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 50001. Total scanned bytes: 9111146. Total filtered/aggred row: 1. Time elapsed in EP: 1080(ms). Server CPU usage: 0.13716365646885367, server physical mem left: 4.0688197632E10, server swap mem left:3.3498525696E10.Etc message: start latency: 9@1,agg done@1024,compress done@1079,server stats done@1080, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 946427 2018-01-24 16:49:06,518 DEBUG [kylin-coproc--pool58-t215] util.CompressionUtils:67 : Original: 946427 bytes. Decompressed: 4710963 bytes. Time: 30 2018-01-24 16:49:06,828 INFO [kylin-coproc--pool58-t218] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_J8RURCM1NP Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x4A\x38\x52\x55\x52\x43\x4D\x31\x4E\x50\x2C\x00\x01\x2C\x31\x35\x31\x36\x38\x32\x34\x38\x31\x32\x38\x39\x35\x2E\x34\x32\x63\x37\x65\x62\x39\x66\x63\x35\x30\x32\x62\x61\x30\x64\x39\x36\x62\x35\x37\x30\x63\x64\x30\x63\x34\x34\x38\x33\x30\x62\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 50001. Total scanned bytes: 9109912. Total filtered/aggred row: 1. Time elapsed in EP: 1414(ms). Server CPU usage: 0.9975786924939468, server physical mem left: 4.0688197632E10, server swap mem left:3.3498525696E10.Etc message: start latency: 10@2,agg done@1359,compress done@1414,server stats done@1414, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 941375 2018-01-24 16:49:06,858 DEBUG [kylin-coproc--pool58-t218] util.CompressionUtils:67 : Original: 941375 bytes. Decompressed: 4709732 bytes. Time: 29 2018-01-24 16:49:06,882 INFO [kylin-coproc--pool58-t217] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_J8RURCM1NP Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x4A\x38\x52\x55\x52\x43\x4D\x31\x4E\x50\x2C\x2C\x31\x35\x31\x36\x38\x32\x34\x38\x31\x32\x38\x39\x35\x2E\x63\x66\x36\x66\x65\x65\x31\x61\x62\x39\x33\x61\x35\x35\x62\x66\x36\x36\x33\x64\x32\x62\x35\x66\x38\x64\x62\x30\x34\x31\x30\x64\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 50001. Total scanned bytes: 9109408. Total filtered/aggred row: 1. Time elapsed in EP: 1464(ms). Server CPU usage: 0.9523809523809523, server physical mem left: 4.0688607232E10, server swap mem left:3.3498525696E10.Etc message: start latency: 13@2,agg done@1406,compress done@1464,server stats done@1464, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 940845 2018-01-24 16:49:06,896 INFO [kylin-coproc--pool58-t219] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_TYWXW6I254 Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x54\x59\x57\x58\x57\x36\x49\x32\x35\x34\x2C\x2C\x31\x35\x31\x36\x38\x32\x35\x33\x36\x35\x34\x34\x39\x2E\x30\x32\x32\x31\x30\x31\x64\x37\x32\x34\x62\x36\x65\x37\x33\x61\x63\x64\x37\x63\x35\x34\x61\x37\x64\x39\x63\x33\x32\x64\x62\x64\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 50001. Total scanned bytes: 9109296. Total filtered/aggred row: 1. Time elapsed in EP: 1471(ms). Server CPU usage: 0.8823529411764706, server physical mem left: 4.0688181248E10, server swap mem left:3.3498525696E10.Etc message: start latency: 10@2,agg done@1413,compress done@1471,server stats done@1471, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 931526 2018-01-24 16:49:06,912 DEBUG [kylin-coproc--pool58-t217] util.CompressionUtils:67 : Original: 940845 bytes. Decompressed: 4709228 bytes. Time: 30 2018-01-24 16:49:06,916 INFO [kylin-coproc--pool58-t216] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_C5BCJ8SAZS Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x43\x35\x42\x43\x4A\x38\x53\x41\x5A\x53\x2C\x00\x01\x2C\x31\x35\x31\x36\x38\x32\x34\x31\x34\x36\x31\x35\x33\x2E\x30\x31\x37\x65\x31\x31\x66\x65\x34\x30\x31\x39\x62\x63\x34\x62\x64\x66\x36\x66\x38\x39\x33\x35\x34\x64\x34\x32\x65\x63\x32\x62\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 50001. Total scanned bytes: 9111730. Total filtered/aggred row: 1. Time elapsed in EP: 1510(ms). Server CPU usage: 0.9166666666666666, server physical mem left: 4.0688181248E10, server swap mem left:3.3498525696E10.Etc message: start latency: 9@1,agg done@1454,compress done@1510,server stats done@1510, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 949194 2018-01-24 16:49:06,927 DEBUG [kylin-coproc--pool58-t219] util.CompressionUtils:67 : Original: 931526 bytes. Decompressed: 4709115 bytes. Time: 31 2018-01-24 16:49:06,944 DEBUG [kylin-coproc--pool58-t216] util.CompressionUtils:67 : Original: 949194 bytes. Decompressed: 4711550 bytes. Time: 28 2018-01-24 16:49:06,944 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.StorageResponseGTScatter:88 : Using SortMergedPartitionResultIterator to merge 2 partition results 2018-01-24 16:49:06,945 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.StorageResponseGTScatter:88 : Using SortMergedPartitionResultIterator to merge 2 partition results 2018-01-24 16:49:07,395 INFO [kylin-coproc--pool58-t222] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_L845LR2E3H Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x4C\x38\x34\x35\x4C\x52\x32\x45\x33\x48\x2C\x2C\x31\x35\x31\x36\x38\x32\x36\x37\x39\x31\x35\x39\x36\x2E\x31\x32\x33\x30\x65\x38\x35\x31\x36\x32\x38\x35\x64\x34\x38\x66\x62\x33\x65\x32\x65\x38\x32\x65\x66\x30\x36\x33\x64\x35\x63\x37\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326115. Total scanned bytes: 59417120. Total filtered/aggred row: 326115. Time elapsed in EP: 1927(ms). Server CPU usage: 0.686411149825784, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 16@1,agg done@1927,compress done@1927,server stats done@1927, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,395 DEBUG [kylin-coproc--pool58-t222] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,402 INFO [kylin-coproc--pool58-t220] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_U5EPNROT29 Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x55\x35\x45\x50\x4E\x52\x4F\x54\x32\x39\x2C\x2C\x31\x35\x31\x36\x38\x32\x35\x38\x33\x30\x34\x34\x36\x2E\x61\x63\x66\x37\x62\x61\x31\x62\x36\x66\x62\x65\x33\x33\x38\x37\x35\x62\x34\x66\x32\x36\x63\x30\x33\x38\x65\x64\x63\x65\x65\x39\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326111. Total scanned bytes: 59416403. Total filtered/aggred row: 326111. Time elapsed in EP: 1970(ms). Server CPU usage: 0.6363636363636364, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 10@1,agg done@1970,compress done@1970,server stats done@1970, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,403 DEBUG [kylin-coproc--pool58-t220] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,452 INFO [kylin-coproc--pool58-t221] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_27BN0H29KE Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x32\x37\x42\x4E\x30\x48\x32\x39\x4B\x45\x2C\x2C\x31\x35\x31\x36\x38\x32\x36\x33\x32\x35\x31\x30\x33\x2E\x31\x63\x66\x63\x34\x36\x31\x34\x66\x64\x62\x34\x33\x39\x66\x32\x36\x33\x32\x62\x33\x62\x34\x34\x38\x33\x35\x65\x65\x30\x65\x33\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326117. Total scanned bytes: 59417479. Total filtered/aggred row: 326117. Time elapsed in EP: 2001(ms). Server CPU usage: 0.5172413793103449, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 16@2,agg done@2001,compress done@2001,server stats done@2001, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,452 DEBUG [kylin-coproc--pool58-t221] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,496 INFO [kylin-coproc--pool58-t223] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_F4NN9LLVYN Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x46\x34\x4E\x4E\x39\x4C\x4C\x56\x59\x4E\x2C\x2C\x31\x35\x31\x36\x38\x32\x37\x32\x38\x37\x39\x34\x30\x2E\x65\x63\x39\x31\x32\x62\x38\x39\x63\x33\x65\x32\x63\x39\x32\x63\x30\x63\x62\x37\x61\x36\x66\x38\x66\x31\x31\x65\x62\x31\x61\x63\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326113. Total scanned bytes: 59416755. Total filtered/aggred row: 326113. Time elapsed in EP: 2012(ms). Server CPU usage: 0.41509433962264153, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 16@3,agg done@2012,compress done@2012,server stats done@2012, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,497 DEBUG [kylin-coproc--pool58-t223] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,550 INFO [kylin-coproc--pool58-t225] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_EZZ3UR33IP Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x45\x5A\x5A\x33\x55\x52\x33\x33\x49\x50\x2C\x2C\x31\x35\x31\x36\x38\x32\x38\x32\x33\x35\x32\x38\x31\x2E\x64\x66\x65\x35\x38\x38\x32\x30\x66\x66\x39\x30\x38\x39\x37\x38\x30\x37\x30\x31\x33\x65\x39\x30\x37\x37\x61\x37\x39\x63\x65\x63\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326117. Total scanned bytes: 59417455. Total filtered/aggred row: 326117. Time elapsed in EP: 2031(ms). Server CPU usage: 0.34375, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 17@2,agg done@2031,compress done@2031,server stats done@2031, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,550 DEBUG [kylin-coproc--pool58-t225] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,641 INFO [kylin-coproc--pool58-t226] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_3XRU46YM0M Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x33\x58\x52\x55\x34\x36\x59\x4D\x30\x4D\x2C\x2C\x31\x35\x31\x36\x38\x32\x38\x37\x30\x30\x36\x33\x32\x2E\x39\x31\x30\x37\x36\x39\x65\x36\x61\x61\x61\x66\x62\x63\x36\x39\x39\x61\x62\x30\x63\x32\x31\x61\x64\x35\x37\x32\x35\x64\x61\x33\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326113. Total scanned bytes: 59416761. Total filtered/aggred row: 326113. Time elapsed in EP: 2101(ms). Server CPU usage: 0.25688073394495414, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 29@1,agg done@2100,compress done@2100,server stats done@2101, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,642 DEBUG [kylin-coproc--pool58-t226] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,699 INFO [kylin-coproc--pool58-t224] v2.CubeHBaseEndpointRPC:202 : Endpoint RPC returned from HTable ANOVA_KYLIN_22X_TLEBD8NUI0 Shard \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x32\x58\x5F\x54\x4C\x45\x42\x44\x38\x4E\x55\x49\x30\x2C\x2C\x31\x35\x31\x36\x38\x32\x37\x37\x36\x36\x33\x36\x38\x2E\x36\x63\x37\x64\x63\x31\x32\x31\x39\x36\x32\x36\x64\x63\x62\x63\x37\x65\x39\x34\x38\x66\x32\x64\x33\x64\x32\x34\x30\x62\x62\x62\x2E on host: dmrm-pool1-3.zettics.com.Total scanned row: 326118. Total scanned bytes: 59417653. Total filtered/aggred row: 326118. Time elapsed in EP: 2198(ms). Server CPU usage: 0.17391304347826086, server physical mem left: 4.0688136192E10, server swap mem left:3.3498525696E10.Etc message: start latency: 16@2,agg done@2198,compress done@2198,server stats done@2198, debugGitTag:7ab549ead297179a0467957f4e5f72487482e744;.Normal Complete: true.Compressed row size: 8 2018-01-24 16:49:07,699 DEBUG [kylin-coproc--pool58-t224] util.CompressionUtils:67 : Original: 8 bytes. Decompressed: 0 bytes. Time: 0 2018-01-24 16:49:07,700 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] gtrecord.SequentialCubeTupleIterator:68 : Using SortedIteratorMergerWithLimit to merge segment results 2018-01-24 16:49:07,700 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] enumerator.OLAPEnumerator:121 : return TupleIterator... 2018-01-24 16:49:09,952 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] service.QueryService:964 : Processed rows for each storageContext: 50018 2018-01-24 16:49:09,952 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] service.QueryService:428 : Stats of SQL response: isException: false, duration: 4721, total scan count 2532809 2018-01-24 16:49:09,952 DEBUG [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] util.CheckUtil:35 : query cache is disabled 2018-01-24 16:49:09,953 INFO [Query d4645dba-0100-48f5-816e-61eed0b2da4d-149] service.QueryService:313 : ==========================[QUERY]=============================== Query Id: d4645dba-0100-48f5-816e-61eed0b2da4d SQL: select a.imsiid,d_device_v.manufacturer_name,d_cell_v.region_3,sum(a.event_count),sum(a.sig_event_count),sum(a.sig_event_duration),sum(a.vl_call_duration),sum(a.retransmission_count),sum(a.succ_call_flg),sum(a.fail_call_flg),sum(a.ow_call_flg),sum(a.lost_call_flg),sum(a.volte_call_flg),count( distinct a.active_call_id),sum(a.urp_lost),sum(a.urp_expected),sum(a.ur_jitter_time),sum(a.ur_jitter_count),sum(a.drp_lost),sum(a.drp_expected),sum(a.dr_jitter_time),sum(a.dr_jitter_count),sum(a.no_media_call_flg),count(distinct a.media_gap_call_id),sum(a.vl_ul_first_resp_delay),sum(a.vl_dl_first_resp_delay),sum(a.vl_ul_call_prog_delay),sum(a.vl_dl_call_prog_delay),sum(a.ul_mos_class0_count),sum(a.ul_mos_class1_count),sum(a.ul_mos_class2_count),sum(a.ul_mos_class3_count),sum(a.ul_mos_class4_count),sum(a.ul_mos_class5_count),sum(a.dl_mos_class0_count),sum(a.dl_mos_class1_count),sum(a.dl_mos_class2_count),sum(a.dl_mos_class3_count),sum(a.dl_mos_class4_count),sum(a.dl_mos_class5_count),sum(a.reg_succ_call_flg),sum(a.reg_fail_call_flg),sum(a.vl_ul_first_resp_delay_count),sum(a.vl_dl_first_resp_delay_count),sum(a.vl_ul_call_prog_delay_count),sum(a.vl_dl_call_prog_delay_count),sum(a.ul_mos_sum),sum(a.dl_mos_sum),sum(a.ul_mos_count),sum(a.dl_mos_count),sum(a.internw_succ_call_flg),sum(a.internw_fail_call_flg),sum(a.ul_ow_call_flg),sum(a.dl_ow_call_flg),count(distinct a.ul_media_gap_call_id),count(distinct a.dl_media_gap_call_id) from a_vl_hourly_v a inner join d_device_v on a.device_key = d_device_v.device_key inner join d_cell_v on a.cell_key = d_cell_v.cell_key where a.time_key >= '201711200100' and a.time_key < '201711200400' group by a.imsiid,d_device_v.manufacturer_name,d_cell_v.region_3 User: ADMIN Success: true Duration: 4.721 Project: Anovadata Realization Names: [CUBE[name=vl_aggs_timekey_cube]] Cuboid Ids: [136193] Total scan count: 2532809 Total scan bytes: 461471118 Result row count: 50000 Accept Partial: true Is Partial Result: false Hit Exception Cache: false Storage cache used: false Is Query Push-Down: false Message: null