[
https://issues.apache.org/jira/browse/HIVE-11034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Srini Pindi updated HIVE-11034:
-------------------------------
Description:
Join between one main table with other tables with different join columns
returns wrong results in hive. Changing the order of the joins between main
table and other tables is producing different results.
Here are the steps to reproduce the issue:
1. Create tables as follows:
create table p(ck string, email string);
create table a1(ck string, flag string);
create table a2(email string, flag string);
create table a3(ck string, flag string);
2. Load data into the tables as follows:
was:
Join between one main table with other tables with different join columns
returns wrong results in hive. Changing the order of the joins between main
table and other tables is producing different results.
> Joining multiple tables producing different results with different order of
> join
> --------------------------------------------------------------------------------
>
> Key: HIVE-11034
> URL: https://issues.apache.org/jira/browse/HIVE-11034
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.13.0
> Environment: Linux 2.6.32-279.19.1.el6.x86_64
> Reporter: Srini Pindi
> Priority: Critical
> Attachments: hive_issue.zip, steps_to_reproduce_.docx
>
>
> Join between one main table with other tables with different join columns
> returns wrong results in hive. Changing the order of the joins between main
> table and other tables is producing different results.
> Here are the steps to reproduce the issue:
> 1. Create tables as follows:
> create table p(ck string, email string);
> create table a1(ck string, flag string);
> create table a2(email string, flag string);
> create table a3(ck string, flag string);
> 2. Load data into the tables as follows:
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
