You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2019/06/04 00:11:00 UTC

[jira] [Updated] (IMPALA-8611) Runtime filters cannot be pushed through subquery with analytic

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

Tim Armstrong updated IMPALA-8611:
----------------------------------
       Target Version: Product Backlog
    Affects Version/s: Impala 3.2.0
               Labels: perf  (was: )
          Description: 
When an analytical function is present in a query I don't see runtime filters being generated. Please, consider an example from the attached file.

It is valid to push the filter through the analytic when it is filtering columns that are in the "PARTITION BY" expression, since the filters would eliminate whole partitions of the analytic and therefore not affect results.

  was:When an analytical function is present in a query I don't see runtime filters being generated. Please, consider an example from the attached file.

          Component/s: Frontend
              Summary: Runtime filters cannot be pushed through subquery with analytic  (was: Dynamic partition pruning won't work when an analytical function is present in the query)

> Runtime filters cannot be pushed through subquery with analytic
> ---------------------------------------------------------------
>
>                 Key: IMPALA-8611
>                 URL: https://issues.apache.org/jira/browse/IMPALA-8611
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 3.2.0
>            Reporter: Dima Fadeyev
>            Priority: Critical
>              Labels: perf
>         Attachments: rank_and_partition_pruning.txt
>
>
> When an analytical function is present in a query I don't see runtime filters being generated. Please, consider an example from the attached file.
> It is valid to push the filter through the analytic when it is filtering columns that are in the "PARTITION BY" expression, since the filters would eliminate whole partitions of the analytic and therefore not affect results.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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