You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Quanlong Huang (JIRA)" <ji...@apache.org> on 2019/07/25 05:20:00 UTC

[jira] [Created] (IMPALA-8792) User Defined Admission Rules

Quanlong Huang created IMPALA-8792:
--------------------------------------

             Summary: User Defined Admission Rules
                 Key: IMPALA-8792
                 URL: https://issues.apache.org/jira/browse/IMPALA-8792
             Project: IMPALA
          Issue Type: New Feature
            Reporter: Quanlong Huang


Impala cluster may be shared by many products. Admin may want to ban some queries as a work around for some bugs or known limitations, to avoid problematic queries impact the whole cluster.

The rules can base on user names, query text, AST after parsing, or the plan after analysis. It'd be better if admin can add/delete/modify rules without restarting the coordinators.

Example rules:
 * Ban all queries submitted from user idiot_product_name
 * Ban all queries containing text "application-name=xxx" (usually added as hint, used to recognize a product)
 * Ban all queries with text length larger than a threshold
 * Ban all queries that joins more than 20 tables (require AST)
 * Ban all queries that joins two specify fact tables (require AST)
 * Ban all queries using specify wrong join path (require AST)
 * Ban all queries that contain too complex expressions, e.g. #nodes in the expression tree exceeding a threshold (require AST)

 



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)