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