????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
