[jira] [Reopened] (HIVE-8651) CBO: sort column changed in infer_bucket_sort test

["Jesús Camacho Rodríguez (JIRA)" <ji...@apache.org>]

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

Jesús Camacho Rodríguez reopened HIVE-8651:
-------------------------------------------

[~ashutoshc], you are right, your point is that there is a dependency between the insert and the select in the following query

{noformat}
INSERT OVERWRITE TABLE test_table PARTITION (part = '1') 
SELECT a.key, c.value FROM src a JOIN src b ON (a.key = b.key) JOIN src c ON (b.value = c.value);
{noformat}

and that we are not respecting anymore, right?

I re-open the issue, I'll look at it.

> CBO: sort column changed in infer_bucket_sort test
> --------------------------------------------------
>
>                 Key: HIVE-8651
>                 URL: https://issues.apache.org/jira/browse/HIVE-8651
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>            Reporter: Sergey Shelukhin
>            Assignee: Jesús Camacho Rodríguez
>             Fix For: 0.15.0
>
>
> {noformat}
> -Bucket Columns:        [value]                  
> -Sort Columns:          [Order(col:value, order:1)]      
> +Bucket Columns:        [key]                    
> +Sort Columns:          [Order(col:key, order:1)]        
> {noformat}
> That is in the case for "Test join on three tables on different keys, should be bucketed and sorted by latter key"; the sort changed to the first key instead



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