You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2017/10/11 20:32:00 UTC

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

    [ https://issues.apache.org/jira/browse/HIVE-17775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16200915#comment-16200915 ] 

Sergey Shelukhin commented on HIVE-17775:
-----------------------------------------

cc [~jcamachorodriguez] [~ashutoshc]

> 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)