[
https://issues.apache.org/jira/browse/HIVE-19259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16474433#comment-16474433
]
Ashutosh Chauhan commented on HIVE-19259:
-----------------------------------------
+1
> 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.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)
