You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "anishek (JIRA)" <ji...@apache.org> on 2018/01/17 09:06:00 UTC

[jira] [Updated] (HIVE-18467) support whole warehouse dump / load + create/drop database events

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

anishek updated HIVE-18467:
---------------------------
    Description: 
A complete hive warehouse might be required to replicate to a DR site for certain use cases and rather than allowing only a database name in the REPL DUMP commands, we should allow dumping of all databases using the "*" option as in 

_REPL DUMP *_ 

On the repl  load side there will not be an option to specify the database name when loading from a location used to dump multiple databases, hence only 

_REPL LOAD FROM [location]_ would be supported when dumping via _REPL DUMP *_


Additionally, incremental dumps will go through all events across databases in a warehouse and hence CREATE / DROP Database events have to be serialized correctly to allow repl load to create them correctly. 

  was:
A complete hive warehouse might be required to replicate to a DR site for certain use cases and rather than allowing only a database name in the REPL DUMP commands, we should allow dumping of all databases using the "*" option as in 

REPL DUMP * 

On the repl  load side there will not be an option to specify the database name when loading from a location used to dump multiple databases, hence only 

_REPL LOAD FROM [location]_ would be supported when dumping via _REPL DUMP *_


Additionally, incremental dumps will go through all events across databases in a warehouse and hence CREATE / DROP Database events have to be serialized correctly to allow repl load to create them correctly. 


> support whole warehouse dump / load + create/drop database events
> -----------------------------------------------------------------
>
>                 Key: HIVE-18467
>                 URL: https://issues.apache.org/jira/browse/HIVE-18467
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: anishek
>            Assignee: anishek
>            Priority: Major
>             Fix For: 3.0.0
>
>
> A complete hive warehouse might be required to replicate to a DR site for certain use cases and rather than allowing only a database name in the REPL DUMP commands, we should allow dumping of all databases using the "*" option as in 
> _REPL DUMP *_ 
> On the repl  load side there will not be an option to specify the database name when loading from a location used to dump multiple databases, hence only 
> _REPL LOAD FROM [location]_ would be supported when dumping via _REPL DUMP *_
> Additionally, incremental dumps will go through all events across databases in a warehouse and hence CREATE / DROP Database events have to be serialized correctly to allow repl load to create them correctly. 



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