Re: Doris resource queue

2023-03-01 Thread Joice Jacob
Hi, I'm trying to understand how the resource queue feature in Apache Doris works. From what I understand, this feature helps manage resources by queuing queries when there aren't enough resources available to execute them. Can you please explain the overall working of this feature? Thanks Joice

Re: Doris resource queue

2023-03-01 Thread Joice Jacob
Hi Mingyu Chen, Doris version is 1.2.1 The error details attached below Exception in thread "main" java.sql.SQLException: errCode = 2, detailMessage = Process has no memory available, cancel top memory usage query: query memory tracker consumption 309.01 MB, backend 10.0.12.192 process memory us

Re: order by 后速度特别慢

2023-03-01 Thread GuoLei Yi
Could you please share the query profile so that I could help you find the problem. liuwangfa 于2023年2月28日周二 11:42写道: > > 您好: > 这个字段已经建立索引 但是还是很慢 INDEX idx_TRADE_DATE_STR (`TRADE_DATE_STR`) USING > INVERTED COMMENT '';doris集群 1个fe 3个be 都为16核64G服务器 > > > > > mysql> select * from mkt_cyq_chip

Re: Doris resource queue

2023-03-01 Thread GuoLei Yi
Hi Joice, I am developing this feature. Currently, this feature is under designed. I will finish design on May or June. This feature will be released with Doris 2.2. Joice Jacob 于2023年3月2日周四 01:03写道: > > Hi everyone, > I'm facing a java.sql.SQLException error with the following message:

Re:Doris resource queue

2023-03-01 Thread Mingyu Chen
The resource queue will be available in version 2.1, Q2 this year. > Process has no memory available This is there any more infornation about this error? and what is your Doris version? -- 此致!Best Regards 陈明雨 Mingyu Chen Email: morning...@apache.org At 2023-03-02 01:02:32, "Joice Ja

Doris resource queue

2023-03-01 Thread Joice Jacob
Hi everyone, I'm facing a java.sql.SQLException error with the following message: errCode = 2, detailMessage = Process has no memory available, cancel top memory usage query. I understand that this means my query is using too much memory, but I'm not sure how to fix it. Can anyone help me understan