You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Gopal V (JIRA)" <ji...@apache.org> on 2018/02/09 07:23:01 UTC

[jira] [Created] (HIVE-18666) Materialized view: "create materialized enable rewrite" should fail if rewriting is not possible

Gopal V created HIVE-18666:
------------------------------

             Summary: Materialized view: "create materialized enable rewrite" should fail if rewriting is not possible
                 Key: HIVE-18666
                 URL: https://issues.apache.org/jira/browse/HIVE-18666
             Project: Hive
          Issue Type: Bug
            Reporter: Gopal V


{code}
CREATE MATERIALIZED VIEW TEST_AGG ENABLE REWRITE AS 
select ... from ext_Table;
{code}

works, but then 

{code}
alter materialized view TEST_AGG enable rewrite;
{code}

fails with {{SemanticException Automatic rewriting for materialized view cannot be enabled if the materialized view uses non-transactional tables}}



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