hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-19259) Create view on tables having union all fail with "Table not found"
Date Tue, 22 May 2018 17:43:00 GMT

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

Jesus Camacho Rodriguez updated HIVE-19259:
-------------------------------------------
    Attachment: HIVE-19259.02.patch

> Create view on tables having union all fail with "Table not found"
> ------------------------------------------------------------------
>
>                 Key: HIVE-19259
>                 URL: https://issues.apache.org/jira/browse/HIVE-19259
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>    Affects Versions: 1.2.1
>         Environment: hive-1.2.1
>  
>            Reporter: Rajkumar Singh
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>         Attachments: HIVE-19259.01.patch, HIVE-19259.02.patch, HIVE-19259.patch
>
>
> create view on table with union work well while "union all" failed with table not found,
here are the reproduce steps.
> {code}
> _hive> create table foo(id int);_
> _OK_
> _Time taken: 0.401 seconds_
> _hive> create table bar(id int);_
> _OK_
>  
> _// view on table union_
> _hive> create view unionview as with tmp_1 as ( select * from foo ), tmp_2 as (select
* from bar ) select * from tmp_1 union  select * from tmp_2;_ 
> _OK_
> _Time taken: 0.517 seconds_
> _hive> select * from unionview;_
> _OK_
> _Time taken: 5.805 seconds_
>  
>  
> _// view on union all_ 
> _hive> create view unionallview as with tmp_1 as ( select * from foo ), tmp_2 as (select
* from bar ) select * from tmp_1 union all  select * from tmp_2;_ 
> _OK_
> _Time taken: 1.535 seconds_
> _hive> select * from unionallview;_
> _FAILED: SemanticException Line 1:134 Table not found 'tmp_1' in definition of VIEW unionallview
[_
> _with tmp_1 as ( select `foo`.`id` from `default`.`foo` ), tmp_2 as (select `bar`.`id`
from `default`.`bar` ) select `tmp_1`.`id` from tmp_1 union all  select `tmp_2`.`id` from
tmp_2_
> _] used as unionallview at Line 1:14_
> _{code}_



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message