hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jesús Camacho Rodríguez (JIRA) <>
Subject [jira] [Reopened] (HIVE-8651) CBO: sort column changed in infer_bucket_sort test
Date Thu, 30 Oct 2014 04:02:33 GMT


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

SELECT a.key, c.value FROM src a JOIN src b ON (a.key = b.key) JOIN src c ON (b.value = c.value);

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

View raw message