[jira] [Updated] (HIVE-12893) Sorted dynamic partition does not work if subset of partition columns are constant folded

["Prasanth Jayachandran (JIRA)" <ji...@apache.org>]

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

Prasanth Jayachandran updated HIVE-12893:
-----------------------------------------
    Attachment: HIVE-12893.1.patch

This patch moves the SortedDynamicPartition optimizer above PartitionConditionRemover optimization. Removal of partition condition after constant folding makes it complicated to determine the partition columns as the folded columns will be removed from row schema. Also this patch disables BucketingSortingReduceSinkOptimizer if SortedDynamicPartition optimizer inserts a new ReduceSink. 

> Sorted dynamic partition does not work if subset of partition columns are constant folded
> -----------------------------------------------------------------------------------------
>
>                 Key: HIVE-12893
>                 URL: https://issues.apache.org/jira/browse/HIVE-12893
>             Project: Hive
>          Issue Type: Bug
>          Components: Logical Optimizer
>    Affects Versions: 1.3.0, 2.0.0
>            Reporter: Prasanth Jayachandran
>            Assignee: Prasanth Jayachandran
>         Attachments: HIVE-12893.1.patch
>
>
> If all partition columns are constant folded then sorted dynamic partitioning should not be used as it is similar to static partitioning. But if only subset of partition columns are constant folded sorted dynamic partition optimization will be helpful. Currently, this optimization is disabled if atleast one partition column constant folded.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)