[jira] [Created] (IMPALA-10317) Add query option that limits join #rows at runtime

["Fucun Chu (Jira)" <ji...@apache.org>]

Fucun Chu created IMPALA-10317:
----------------------------------

             Summary: Add query option that limits join #rows at runtime
                 Key: IMPALA-10317
                 URL: https://issues.apache.org/jira/browse/IMPALA-10317
             Project: IMPALA
          Issue Type: New Feature
          Components: Backend
            Reporter: Fucun Chu
            Assignee: Fucun Chu
         Attachments: query82_summary.png

Reject queries that rows produced too bigger by join operator when executing the query.
This is a mechanism to protect the cluster from potentially harmful queries.

When the cardinality of the table is very large and the join conditions are very bad, the number of rows produced by the join will be very large, sometimes tens of billions, which affects the cluster status and other running queries.

In our environment, the NUM_JOIN_ROWS_PRODUCED_LIMIT query option is added to limit the number of rows produced by a single join operator.
Implementation refers to [IMPALA-6034|https://issues.apache.org/jira/browse/IMPALA-6034] and summary (see the figure below), check the join operator #rows size



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org