I noticed that we have a sql AdminFnStmt <https://github.com/apache/impala/blob/master/fe/src/main/cup/sql-parser.cup#L3115> ,and it seems this is just for admin commands through functions, even though only shutdown function is supported ,So what about extend this syntax ?WDYT? e.g. set_event_status (event_id, status).
Of course, webUi must also be modified. But all users that can view the WebUI can perform the operations. We > currently have the same issue for canceling queries or adjusting the log > level in WebUI. This is a problem, but I feel that it may not have much to do with the function itself. It may be necessary to make an authentication design for weiUi. guo Maxwell <cclive1...@gmail.com> 于2023年10月19日周四 11:01写道： > Thanks quanlong, > yeah, It seems I missed.😄 > > Quanlong Huang <huangquanl...@gmail.com> 于2023年10月19日周四 10:16写道： > >> Hi, I had a reply but maybe you missed it: >> https://lists.apache.org/thread/5mw8jd5hgz7yycz9h2pxvqj101k0j47m >> Feel free to file JIRAs and welcome to work on these! >> >> Thanks, >> Quanlong >> >> On Wed, Oct 18, 2023 at 1:59 PM guo Maxwell <cclive1...@gmail.com> wrote: >> >>> Hello everyone, >>> It’s been a while since my last email. And any feedback? >>> >>> guo Maxwell <cclive1...@gmail.com> 于2023年9月28日周四 10:33写道： >>> >>> > *background : * >>> > Sometimes when the EventProcessorStatus of our impala changes to >>> > NEED_INVALIDATE, and we manually perform invalidate metadata >>> operations on >>> > certain tables(as we know the changed schema).But the >>> EventProcessorStatus >>> > may not be changed, as we can see the description in IMPALA-12468 >>> > <https://issues.apache.org/jira/browse/IMPALA-12468> . >>> > >>> > So what about support some impala operation and maintenance behavior >>> > through SQL. As I know some database has already exposed some >>> operation and >>> > maintenance operations through sql. >>> > >>> > *Action :* >>> > To fix this problem , I recommend providing Impala with a new SQL >>> named : >>> > SET EVENT ACTIVE. >>> > Initially we can only support set ACTIVE status when we found the >>> status >>> > is all right . Other states can be supported on demand. >>> > >>> > So what do you think? Thanks. >>> > >>> > >>> >>> -- >>> you are the apple of my eye ! >>> >>
