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

["Aman Sinha (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-10317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha resolved IMPALA-10317.
---------------------------------
    Fix Version/s: Impala 4.0
       Resolution: Fixed

> 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
>            Priority: Major
>             Fix For: Impala 4.0
>
>         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)