bw-chuxin commented on issue #6722: URL: https://github.com/apache/gravitino/issues/6722#issuecomment-2742502893
Currently I can think of the following two solutions, 1."show backends" is a syntax supported by all versions of doris, but the disadvantage is that it cannot be filtered according to conditions, only all backend information can be obtained and then filtered and counted in the code, not sure whether it will cause performance problems. 2.doris2.x and later versions can be queried and filtered through the table-valued function "backends()". The specific syntax is as follows: ```sql select count(*) from backends() where alive = 'true'; ``` When obtaining the number of surviving backend nodes, we can first query through the original syntax, and then query through the table-valued function when the query throws exception. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
