[
https://issues.apache.org/jira/browse/HIVE-19259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16488233#comment-16488233
]
Hive QA commented on HIVE-19259:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12924591/HIVE-19259.02.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 14395 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_sort_1_23]
(batchId=81)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_sort_skew_1_23]
(batchId=9)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_gby2]
(batchId=37)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_sort_1_23]
(batchId=144)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_sort_skew_1_23]
(batchId=112)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/11168/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11168/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11168/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 5 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12924591 - PreCommit-HIVE-Build
> 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)
