Hi here are results:
kylin: select count(*) from ICSTOCKBILL_1W result:10366 hive: select count(*) from ICSTOCKBILL_1W result:10411 ------------------ ???????? ------------------ ??????: "JiaTao Tao"<[email protected]>; ????????: 2019??1??22??(??????) ????3:04 ??????: "dev"<[email protected]>; ????: Re: ??????cube???????????? Hi Can you try "select count(*)" and compare the result with hive? FYI: http://kylin.apache.org/docs/gettingstarted/faq.html (Why I got an error when running a ??select * ?? query?) ???????? <[email protected]> ??2019??1??22?????? ????5:21?????? > ????group by ?????????????????? > ?????? goodsid ????1137?? > select * from ICSTOCKBILL_1W where goodsid = '1137' > ?????? > > > ????????????cube???????????????????????????????? > ???????????????? > > > hive???????????????????? > ??????cube???????????????? > > > ------------------ ???????? ------------------ > *??????:* "Chao Long"<[email protected]>; > *????????:* 2019??1??22??(??????) ????12:11 > *??????:* "dev"<[email protected]>; > *????:* ????????????cube???????????? > > Hi, > The cube only has aggregated data, so your queries should include "group > by" clause. > You can check the faq: > http://kylin.apache.org/docs/gettingstarted/faq.html(# Why I got an error > when running a ??select * ?? query) > > > ------------------ > Best Regards, > Chao Long > > > ------------------ ???????? ------------------ > ??????: "????????"<[email protected]>; > ????????: 2019??1??22??(??????) ????11:06 > ??????: "dev"<[email protected]>; > > ????: ??????cube???????????? > > > > Hi, > > > ??????????hive????????????????????????????????????????????hive????????????????????cube > ???????????? > ?????????? select * from ICSTOCKBILL_1W where goodsid = '643'?? > ICSTOCKBILL_1W ?????????? > ???????????? > hive???????? > ????cube???????? > > > ??????????????????goodsid ???????????????????????????? > > > env: > ubuntu 16.04 hadoop???? 3?? > apache-kylin-2.5.2-bin-hadoop3 or apache-kylin-2.6.0-bin-hadoop3 ??kylin > ?????? > hive:2.3.4 > hbase:1.3.3 > zookeeper:3.4.13 > > > > ?????????????????????????? > > > Best regards > -- Regards! Aron Tao
