[
https://issues.apache.org/jira/browse/KYLIN-4442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082105#comment-17082105
]
Sonu Singh commented on KYLIN-4442:
-----------------------------------
Query Id: 88e29596-4e92-276b-96c5-05c885857080
SQL: select REALIZATION,count(*) from KYLIN.HIVE_METRICS_QUERY_QA where
KDAY_DATE >= '2020-03-12' and KDAY_DATE <= '2020-04-10' and PROJECT
='NEWREDSHIFT' andEXCEPTION = 'NULL' group by REALIZATION
User: admin
Success: true
Duration: 0.089
Project: KYLIN_SYSTEM
Realization Names: [CUBE[name=KYLIN_HIVE_METRICS_QUERY_QA]]
Cuboid Ids: [7740]
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==========================[QUERY]===============================
2020-04-13 06:48:41,950 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
enumerator.OLAPEnumerator:98 : query storage...
2020-04-13 06:48:41,951 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
gtrecord.GTCubeStorageQueryBase:323 : Need storage aggregation
2020-04-13 06:48:41,951 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
gtrecord.GTCubeStorageQueryBase:561 : exactAggregation is false because need
sorage aggregation
2020-04-13 06:48:41,952 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
gtrecord.GTCubeStorageQueryBase:301 : Filter column set for query:
[KYLIN.HIVE_METRICS_JOB_QA.PROJECT, KYLIN.HIVE_METRICS_JOB_QA.KDAY_DATE]
2020-04-13 06:48:41,952 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
gtrecord.GTCubeStorageQueryBase:310 : Filter mask is: 1032
2020-04-13 06:48:41,952 WARN [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
storage.StorageContext:153 : Not enabling limit push down because current limi
is invalid: 2147483647
2020-04-13 06:48:41,953 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
gtrecord.GTCubeStorageQueryBase:524 : Can not push down having filter, must hae
only one segment
2020-04-13 06:48:41,953 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
gtrecord.GTCubeStorageQueryBase:183 : Cuboid identified:
cube=KYLIN_HIVE_METRIC_JOB_QA, cuboidId=1928, groupsD=[],
filterD=[KYLIN.HIVE_METRICS_JOB_QA.PROJECT,
KYLIN.HIVE_METRICS_JOB_QA.KDAY_DATE], limitPushdown=2147483647,
limitLevel=NO_LMIT, storageAggr=true
2020-04-13 06:48:41,954 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
common.SegmentPruner:61 : Prune segment
KYLIN_HIVE_METRICS_JOB_QA[1970010100000_20200413033000] due to 0 input record
2020-04-13 06:48:41,954 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
common.SegmentPruner:61 : Prune segment
KYLIN_HIVE_METRICS_JOB_QA[2020041303300_20200413034500] due to 0 input record
2020-04-13 06:48:41,954 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
common.SegmentPruner:61 : Prune segment
KYLIN_HIVE_METRICS_JOB_QA[2020041303450_20200413040000] due to 0 input record
2020-04-13 06:48:41,955 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
common.SegmentPruner:61 : Prune segment
KYLIN_HIVE_METRICS_JOB_QA[2020041304000_20200413041500] due to 0 input record
2020-04-13 06:48:41,955 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
common.SegmentPruner:61 : Prune segment
KYLIN_HIVE_METRICS_JOB_QA[2020041304150_20200413043000] due to 0 input record
2020-04-13 06:48:41,956 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
enumerator.OLAPEnumerator:110 : return TupleIterator...
2020-04-13 06:48:41,960 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
service.QueryService:1144 : Processed rows for each storageContext: 0
2020-04-13 06:48:41,961 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
service.QueryService:483 : Stats of SQL response: isException: false, duration
98, total scan count 0
2020-04-13 06:48:41,961 DEBUG [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
util.CheckUtil:32 : query is too lightweight with duration: 98 (threshold 2000,
scan count: 0 (threshold 10240), scan bytes: 0 (threshold 1048576)
2020-04-13 06:48:41,962 INFO [Query c77a77a1-1a84-5b19-0ba2-b4b2d1246a84-437]
service.QueryService:355 :
> Kylin System Cube Hive tables not able to update
> -------------------------------------------------
>
> Key: KYLIN-4442
> URL: https://issues.apache.org/jira/browse/KYLIN-4442
> Project: Kylin
> Issue Type: Bug
> Affects Versions: v3.0.0
> Reporter: Sonu Singh
> Priority: Blocker
>
> Kylin System Cube Hive table is not updating. I am using Kylin hadoop3 code
> and running on vanilla hadoop3.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
