*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.