[jira] [Commented] (KYLIN-1958) Get wrong result from query

["Billy(Yiming) Liu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15420820#comment-15420820 ] 

Billy(Yiming) Liu commented on KYLIN-1958:
------------------------------------------

There are many threads about this kinds of questions before. 

I quote here:
"By default Kylin only remembers aggregates of your data set. Thus all queries must has a "group by" clause in order to get correct result. That is why your second query didn't return correct result.

However there is one way to let Kylin support raw record query. Check out http://kylin.apache.org/blog/2016/05/29/raw-measure-in-kylin/"

Once again, JIRA is for tracking verified bug and features, not for questions. If you have question, please ask in the user mailer first.

> Get wrong result from query
> ---------------------------
>
>                 Key: KYLIN-1958
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1958
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v1.5.2
>            Reporter: Le Van Ha
>
> Hi all,
> When I run query:
>    select count( * ) from streaming_sales_table 
> result：
> ---------------------------------------------------------------
> 748
> But,  query is :
>     select * from streaming_sales_table 
> I see the result has 598 records. 
> Why is that?
> Looking forward to hear from you. Thanks. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)