Hello Xiaoxiang I have created plenty of index but why it is very slow query and it still showed "No model index built....": [image: image.png] [image: image.png]
On Thu, Oct 19, 2023 at 5:10 PM Nam Đỗ Duy <na...@vnpay.vn> wrote: > Thank you for sharing. > > I have one very important question: Is the concept of Segment or Index now > in version 5.x similar to columnar OLAP database like clickhouse or druid? > > Best regards > > On Thu, Oct 19, 2023 at 3:49 PM Xiaoxiang Yu <x...@apache.org> wrote: > >> In Kylin 5, the functions of cube are merged into DataModel, so power of >> multidimensional cube is kept in Model of Kylin 5. >> >> >> Here is demo for creating and query model in Kylin 5: >> https://people.apache.org/~xxyu/resources/How_to_create_and_query_Model_in_Kylin_5.pptx >> . >> >> >> -- >> *Best wishes to you ! * >> *From :**Xiaoxiang Yu* >> >> >> >> At 2023-10-18 22:38:51, "Nam Đỗ Duy" <na...@vnpay.vn.INVALID> wrote: >> >Hello ShaoFeng >> > >> >Thank you for your email. >> > >> >I am a bit confused when the cube is no more. >> > >> >Then how can I utilize the power of multidimensional cube when querying >> >data? >> > >> >On Tue, Oct 17, 2023 at 3:08 PM ShaoFeng Shi <shaofeng...@apache.org> wrote: >> > >> >> Copy to dev@kylin which is the right address: >> >> >> >> For question 1, yes Kylin 5 embedded the cube concept into the "data >> >> model". In the previous versions, a cube contains a fixed number of >> >> cuboids. In Kylin 5, a "data model" can have a flexibile number of >> >> "index". >> >> The concept of "index" is equal "cuboid". >> >> >> >> For question 2, due to license issue, there is no open source ODBC driver >> >> for Apache Kylin any more. But you can seek third-party, for example: >> >> https://kyligence.io/resources/kyligence-odbc-driver-for-apache-kylin-2/ >> >> >> >> >> >> Best regards, >> >> >> >> Shaofeng Shi 史少锋 >> >> Apache Kylin PMC, >> >> Apache Incubator PMC, >> >> Email: shaofeng...@apache.org >> >> >> >> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html >> >> Join Kylin user mail group: user-subscr...@kylin.apache.org >> >> Join Kylin dev mail group: dev-subscr...@kylin.apache.org >> >> >> >> >> >> >> >> >> >> Nam Đỗ Duy <na...@vnpay.vn> 于2023年10月11日周三 19:38写道: >> >> >> >>> Hello ShaoFeng >> >>> >> >>> I download apache 5.0 docker and build the model already, >> >>> >> >>> 1. Is that true that you embed the Cube concept into model in version >> >>> 5.0? >> >>> 2. How can I find ODBC driver to connect PoweBI with kylin model version >> >>> 5.0? >> >>> >> >>> Thank you very much >> >>> >> >>> On Wed, Sep 20, 2023 at 10:20 PM ShaoFeng Shi <shaofeng...@apache.org> >> >>> wrote: >> >>> >> >>>> Hi Nam, you can check it here: >> >>>> >> >>>> >> >>>> https://github.com/apache/kylin/blob/99574f90e735a7679d8ceed576cccfd8d750beee/build/release/all-in-one-docker/all_in_one/entrypoint.sh#L83C48-L83C50 >> >>>> >> >>>> >> >>>> Best regards, >> >>>> >> >>>> Shaofeng Shi 史少锋 >> >>>> Apache Kylin PMC, >> >>>> Apache Incubator PMC, >> >>>> Email: shaofeng...@apache.org >> >>>> >> >>>> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html >> >>>> Join Kylin user mail group: user-subscr...@kylin.apache.org >> >>>> Join Kylin dev mail group: dev-subscr...@kylin.apache.org >> >>>> >> >>>> >> >>>> >> >>>> >> >>>> Nam Đỗ Duy <na...@vnpay.vn> 于2023年9月19日周二 17:21写道: >> >>>> >> >>>>> Dear sir/Madam >> >>>>> >> >>>>> I run docker pull and docker run from the following page and then how >> >>>>> can I login to mysql ? please instruct me the mysql credentials >> >>>>> >> >>>>> apachekylin/apache-kylin-standalone - Docker Image | Docker Hub >> >>>>> <https://hub.docker.com/r/apachekylin/apache-kylin-standalone> >> >>>>> >> >>>>> Thank you very much >> >>>>> >> >>>> >> >>