You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2017/10/11 20:32:00 UTC

[jira] [Created] (HIVE-17775) PTF should take advantage of partitioning, bucketing and sorting

Sergey Shelukhin created HIVE-17775:
---------------------------------------

             Summary: PTF should take advantage of partitioning, bucketing and sorting
                 Key: HIVE-17775
                 URL: https://issues.apache.org/jira/browse/HIVE-17775
             Project: Hive
          Issue Type: Bug
            Reporter: Sergey Shelukhin


When the user is running a PTF that partitions by a partition column of the table (or a bucketing column, although that could be more difficult), or orders by a partition column, or a column on which the table is already sorted being bucketed+sorted, the PTF should take advantage of these.
That can turn some PTF operators (that I'm presently observing on a real query from a user) into a single scan, or at least a much simpler DAG; as it is, the query is very slow.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)