You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by my is mine <79...@qq.com> on 2020/12/28 06:33:21 UTC
kylin查询不一致问题
cube建立后，在insight中和hive shell中查询事实表，数量不一致，原始hive中2.61亿，cube中查询2.49亿，相差很大，大致原因在哪，另外，cube构建过程中没有报错
回复：kylin查询不一致问题
Posted by 刘波 <10...@qq.com>.
Hi,
Have you ever check "Why I got an error when running a “select * “ query?" in Kylin FAQ? Check this link : http://kylin.apache.org/docs/gettingstarted/faq.html.
--
Why I got an error when running a “select * “ query?
The cube only has aggregated data, so all your queries should be aggregated queries (“GROUP BY”). You can use a SQL with all dimensions be grouped to get them as close as the detailed result, but that is not the raw data.
In order to be connected from some BI tools, Kylin tries to answer “select *” query but please aware the result might not be expected. Please make sure each query to Kylin is aggregated.
------------------ 原始邮件 ------------------
发件人: "user" <7946816@qq.com>;
发送时间: 2020年12月28日(星期一) 下午2:33
收件人: "user"<user@kylin.apache.org>;
主题: kylin查询不一致问题
cube建立后，在insight中和hive shell中查询事实表，数量不一致，原始hive中2.61亿，cube中查询2.49亿，相差很大，大致原因在哪，另外，cube构建过程中没有报错