[
https://issues.apache.org/jira/browse/HIVE-25590?focusedWorklogId=660306&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-660306
]
ASF GitHub Bot logged work on HIVE-25590:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 05/Oct/21 13:07
Start Date: 05/Oct/21 13:07
Worklog Time Spent: 10m
Work Description: asolimando commented on pull request #2697:
URL: https://github.com/apache/hive/pull/2697#issuecomment-934396405
I did run it with `-Dtest.output.overwrite` like in the PR title, and I did
not notice the discrepancies in the `.q.out` files.
Maybe it's better to remove the option from the "How it was tested" example
to avoid somebody else getting fooled by this?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 660306)
Time Spent: 20m (was: 10m)
> Able to create views referencing temporary tables and materialized views
> ------------------------------------------------------------------------
>
> Key: HIVE-25590
> URL: https://issues.apache.org/jira/browse/HIVE-25590
> Project: Hive
> Issue Type: Bug
> Components: Query Planning
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Creating views/materialized views referencing temporary tables and
> materialized views are disabled in Hive. However the verification algorithm
> fails to recognize temporary tables and materialized views in subqueries.
> The verification also fails when the view definition contains joins because
> CBO transforms join branches to subqueries.
> Example1:
> {code}
> create temporary table tmp1 (c1 string, c2 string);
> create view tmp1_view as
> select subq.c1 from (select c1, c2 from tmp1) subq;
> {code}
> Example2:
> {code}
> create table t1 (a int) stored as orc tblproperties ('transactional'='true');
> create table t2 (a int) stored as orc tblproperties ('transactional'='true');
> create materialized view mv1 as
> select a from t1 where a = 10;
> create materialized view mv2 as
> select t2.a from mv1
> join t2 on (mv1.a = t2.a);
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
