[
https://issues.apache.org/jira/browse/HIVE-25590?focusedWorklogId=660437&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-660437
]
ASF GitHub Bot logged work on HIVE-25590:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 05/Oct/21 16:39
Start Date: 05/Oct/21 16:39
Worklog Time Spent: 10m
Work Description: kasakrisz commented on pull request #2697:
URL: https://github.com/apache/hive/pull/2697#issuecomment-934575532
I usually use `-Dtest.output.overwrite` and then `git status` to see if
there were any change because if any of the q.out files changed I can do a
better diff.
Anyway I removed `-Dtest.output.overwrite` from the description.
--
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: 660437)
Time Spent: 40m (was: 0.5h)
> 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: 40m
> 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)
