Can you provide the messages in logs/kylin.log when executing the SQL? and you can also check the Spark UI from yarn resource manager (there should be one running application called Spardar, which is Kylin's backend spark application). If the application is not there, it may indicates the yarn doesn't have resource to startup it.
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月31日周二 10:35写道： > Dear Sir/Madam, > > I have a fact with 500million rows then I build model, index according to > the website help. > > I chose full incremental because this is the first times I load data > > I create both index types Aggregate group index, table index as photo > attached. > > But the query always failed after timeout of 300 seconds (I run in > docker), I dont want to increase the value of 300 seconds because I wish > the OLAP can run within 1 minutes (is that possible?) > > It seems that the OLAP function in indexing not working to speedup the > query by precomputed cube. > > Can you advise to check whether the index did really work? > > It is quite urgent task for me so prompt response is highly appreciated. > > Thank you very much >
