hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18991) Drop database cascade doesn't work with materialized views
Date Mon, 26 Mar 2018 22:21:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-18991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414659#comment-16414659
] 

Jesus Camacho Rodriguez commented on HIVE-18991:
------------------------------------------------

[~alangates], sorry, I was not paying enough attention. I have uploaded a new patch that moves
the code that drops the materialized views out of that loop, and also retrieves the materialized
views in batches.

> 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
>         Attachments: HIVE-18991.01.patch, HIVE-18991.03.patch, HIVE-18991.06.patch, HIVE-18991.patch
>
>
> 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)

Mime
View raw message