You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/03/19 19:51:00 UTC

[jira] [Assigned] (HIVE-18991) Drop database cascade doesn't work with materialized views

     [ https://issues.apache.org/jira/browse/HIVE-18991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez reassigned HIVE-18991:
----------------------------------------------

    Assignee: Jesus Camacho Rodriguez

> Drop database cascade doesn't work with materialized views
> ----------------------------------------------------------
>
>                 Key: HIVE-18991
>                 URL: https://issues.apache.org/jira/browse/HIVE-18991
>             Project: Hive
>          Issue Type: Bug
>          Components: Materialized views, Metastore
>    Affects Versions: 3.0.0
>            Reporter: Alan Gates
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>
> Create a database, add a table and then a materialized view that depends on the table.  Then drop the database with cascade set.  Sometimes this will fail because when HiveMetaStore.drop_database_core goes to drop all of the tables it may drop the base table before the materialized view, which will cause an integrity constraint violation in the RDBMS.  To resolve this that method should change to fetch and drop materialized views before tables.
> cc [~jcamachorodriguez]



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