[
https://issues.apache.org/jira/browse/KYLIN-4486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17107864#comment-17107864
]
shenqiong commented on KYLIN-4486:
----------------------------------
select
t1.DATEYMD as datet,t1.DEPARTMENT_ID,
sum(t1.SIGN_COUNT) as attenNum,
sum(t1.SIGN_REPLACE) as replaceAttenNum,
sum(t1.SIGN_EXCEPTION) as freeSigninNum
from V_GXY_ATTENDANCE t1
WHERE t1.SCHOOL_ID = '735bc978a20d93b48c963f288c7b9b47' and
t1.BATCH_ID = 'c14270dd13e47f1d9aa7ed020915921e'
AND t1.DATEYMD >='2020-04-30'
AND t1.DATEYMD <'2020-05-01'
group by t1.DATEYMD,t1.DEPARTMENT_ID
order by t1.DATEYMD
[~hit_lacus]
> dismatch between kylin and hive
> -------------------------------
>
> Key: KYLIN-4486
> URL: https://issues.apache.org/jira/browse/KYLIN-4486
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.6.5
> Reporter: shenqiong
> Priority: Major
>
> I run same sql in kylin and hive, but kylin return 0 while hive return non
> empty.
> I found some data of some days is missing after kylin build, even though I
> refresh the cube.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
