[
https://issues.apache.org/jira/browse/HIVE-24243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Henrique dos Santos Goulart updated HIVE-24243:
-----------------------------------------------
Description:
Missing table alias in LEFT JOIN causing inconsistent results, see attachments.
{code:java}
with
cte_left as (
select null as col11, 'col2_1' as col2 union all
select 1 as col11, 'col2_2' as col2
),
cte_right as (
select 1 as col1, 'col3' as col3
)
select *
from cte_left l
left join cte_right r on r.col1 = l.col11;
{code}
Returns 2 rows correctly.
vs
{code:java}
with
cte_left as (
select null as col11, 'col2_1' as col2 union all
select 1 as col11, 'col2_2' as col2
),
cte_right as (
select 1 as col1, 'col3' as col3
)
select *
from cte_left
left join cte_right r on r.col1 = col11;
{code}
Returns 1 row.
was:
Missing table alias in LEFT JOIN causing inconsistent results, see attachments.
{code:java}
with
cte_left as (
select null as col11, 'col2_1' as col2 union all
select 1 as col11, 'col2_2' as col2
),
cte_right as (
select 1 as col1, 'col3' as col3
)
select *
from cte_left l
left join cte_right r on r.col1 = l.col11;
{code}
vs
{code:java}
with
cte_left as (
select null as col11, 'col2_1' as col2 union all
select 1 as col11, 'col2_2' as col2
),
cte_right as (
select 1 as col1, 'col3' as col3
)
select *
from cte_left
left join cte_right r on r.col1 = col11;
{code}
> Missing table alias in LEFT JOIN causing inconsistent results
> -------------------------------------------------------------
>
> Key: HIVE-24243
> URL: https://issues.apache.org/jira/browse/HIVE-24243
> Project: Hive
> Issue Type: Bug
> Affects Versions: 2.1.1
> Reporter: Henrique dos Santos Goulart
> Priority: Major
> Attachments: alias.png, no_alias.png
>
>
> Missing table alias in LEFT JOIN causing inconsistent results, see
> attachments.
> {code:java}
> with
> cte_left as (
> select null as col11, 'col2_1' as col2 union all
> select 1 as col11, 'col2_2' as col2
> ),
> cte_right as (
> select 1 as col1, 'col3' as col3
> )
> select *
> from cte_left l
> left join cte_right r on r.col1 = l.col11;
> {code}
> Returns 2 rows correctly.
> vs
> {code:java}
> with
> cte_left as (
> select null as col11, 'col2_1' as col2 union all
> select 1 as col11, 'col2_2' as col2
> ),
> cte_right as (
> select 1 as col1, 'col3' as col3
> )
> select *
> from cte_left
> left join cte_right r on r.col1 = col11;
> {code}
> Returns 1 row.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
