date:20190708

[jira] [Updated] (HIVE-21761) Support table level replication in Hive

2019-07-08 Thread mahesh kumar behera (JIRA)

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

mahesh kumar behera updated HIVE-21761:
---
Description:
*Requirements:*
{code:java}
- User needs to define replication policy to replicate any specific table. This
enables user to replicate only the business critical tables instead of
replicating all tables which may throttle the network bandwidth, storage and
also slow-down Hive replication.
- User needs to define replication policy using regular expressions (such as
db.sales_*) and needs to include additional tables which are non-matching given
pattern and exclude some tables which are matching given pattern.
- User needs to dynamically add/remove tables to the list either by manually
changing the replication policy during run time.
{code}
*Design:*
{code:java}
1. Hive continue to support DB level replication policy of format but
logically, we support the policy as .'t1|t3| …'.'t*'.

2. Regular expression can also be supported as replication policy. For example,
a. .''
b. .'<*suffix>'
c. .''
d. .''

3. User can provide include and exclude list to specify the tables to be
included in the replication policy.
a. Include list specifies the tables to be included.
b. Exclude list specifies the tables to be excluded even if it satisfies the
expression in include list.
c. So the tables included in the policy is a-b.
d. For backward compatibility, if no include or exclude list is given, then
all the tables will be included in
the policy.

4. New format for the Replication policy have 3 parts all separated with Dot
(.).
a. First part is DB name.
b. Second part is included list. Valid java regex within single quote.
c. Third part is excluded list. Valid java regex within single quote.
- -- Full DB replication which is currently supported
- .'.*?' -- Full DB replication
- .'t1|t3' -- DB replication with static list of tables t1 and t3
included.
- .'(t1*)|t2'.'t100' -- DB replication with all tables having
prefix t1 and also include table t2 which doesn’t have prefix t1 and exclude
t100 which has the prefix t1.

5. If the DB property “repl.source.for” is set, then by default all the tables
in the DB will be enabled for replication and will continue to archive deleted
data to CM path.

6. REPL DUMP takes 2 inputs along with existing FROM and WITH clause.
a. REPL DUMP [REPLACE FROM
WITH ;
current_repl_policy and previous_repl_policy can be any format mentioned in
Point-4.
b. REPLACE clause to be supported to take previous repl policy as input.
c. Rest of the format remains same.

7. Now, REPL DUMP on this DB will replicate the tables based on
current_repl_policy.

8. Single table replication of format .t1 is not supported. User can
provide the same with .'t1' format.

9. If any table is added dynamically either due to change in regular expression
or added to include list should be bootstrapped.
a. Hive will automatically figure out the list of tables newly included in
the list by comparing the current_repl_policy & previous_repl_policy inputs and
combine bootstrap dump for added tables as part of incremental dump. As we can
combine first incremental with bootstrap dump, it removes the current
limitation of target DB being inconsistent after bootstrap unless we run first
incremental replication.
b. If any table is renamed, then it may gets dynamically added/removed for
replication based on defined replication policy + include/exclude list. So,
Hive will perform bootstrap for the table which is just included after rename.
c. Also, if renamed table is excluded from replication policy, then need to
drop the old table at target as well.

10. Only the initial bootstrap load expects the target DB to be empty but the
intermediate bootstrap on tables due to regex or inclusion/exclusion list
change or renames doesn’t expect the target DB or table to be empty. If any
table with same name exist during such bootstrap, the table will be overwritten
including data.
{code}

was:
*Requirements:*
{code}
- User needs to define replication policy to replicate any specific table. This
enables user to replicate only the business critical tables instead of
replicating all tables which may throttle the network bandwidth, storage and
also slow-down Hive replication.
- User needs to define replication policy using regular expressions (such as
db.sales_*) and needs to include additional tables which are non-matching given
pattern and exclude some tables which are matching given pattern.
- User needs to dynamically add/remove tables to the list either by manually
changing the replication policy during run time.
{code}

*Design:*
{code}
1. Hive continue to support DB level replication policy of format .*
but logically, we support the policy as .(t1, t3, …).

2. Regular expression can also be supported as replication

[jira] [Commented] (HIVE-21970) Avoid using RegistryUtils.currentUser()

2019-07-08 Thread Gopal V (JIRA)



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

Gopal V commented on HIVE-21970:


LGTM - +1 tests pending

> Avoid using RegistryUtils.currentUser()
> ---
>
> Key: HIVE-21970
> URL: https://issues.apache.org/jira/browse/HIVE-21970
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 4.0.0, 3.2.0
>Reporter: Prasanth Jayachandran
>Assignee: Prasanth Jayachandran
>Priority: Major
> Attachments: HIVE-21970.1.patch
>
>
> RegistryUtils.currentUser() does replacement of '_' with '-' for DNS reasons. 
> This is used inconsistently in some places causing issues wrt. ZK (deletion 
> token secret manager, llap cluster membership for external clients).
>  
> Replace RegistryUtils.currentUser() with 
> UserGroupInformation.getCurrentUser().getShortUserName() for consistency. 



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

[jira] [Commented] (HIVE-21973) "show locks" print the header twice.

2019-07-08 Thread Gopal V (JIRA)



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

Gopal V commented on HIVE-21973:


+1 tests pending

> "show locks" print the header twice.
> 
>
> Key: HIVE-21973
> URL: https://issues.apache.org/jira/browse/HIVE-21973
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Minor
> Attachments: HIVE-21973.patch
>
>
> show locks; 
> -- output
> {code:java}
> +--+---+++-+-++-+-+--+---+---+-+
> |  lockid  | database  | table  | partition  | lock_state  | blocked_by  | 
> lock_type  | transaction_id  | last_heartbeat  | acquired_at  | user  | 
> hostname  | agent_info  |
> +--+---+++-+-++-+-+--+---+---+-+
> | Lock ID  | Database  | Table  | Partition  | State   | Blocked By  | 
> Type   | Transaction ID  | Last Heartbeat  | Acquired At  | User  | 
> Hostname  | Agent Info  |
> +--+---+++-+-++-+-+--+---+---+-+
> {code}



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

[jira] [Commented] (HIVE-21972) "show transactions" display the header twice

2019-07-08 Thread Gopal V (JIRA)



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

Gopal V commented on HIVE-21972:


+1 tests pending

> "show transactions" display the header twice
> 
>
> Key: HIVE-21972
> URL: https://issues.apache.org/jira/browse/HIVE-21972
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Major
> Attachments: HIVE-21972.patch
>
>
> show transactions;
> {code:java}
> +-+++--+---+---+
> |  txnid  |   state|  startedtime   |  lastheartbeattime  
>  | user  |   host|
> +-+++--+---+---+
> | Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time 
>  | User  | Hostname  |
> | 896 | ABORTED| 1560209607000  | 1560209607000   
>  | hive  | hostname  |
> +-+++--+---+---+
> {code}



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

[jira] [Updated] (HIVE-21973) "show locks" print the header twice.

2019-07-08 Thread Rajkumar Singh (JIRA)



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

Rajkumar Singh updated HIVE-21973:
--
Attachment: HIVE-21973.patch
Status: Patch Available  (was: Open)

> "show locks" print the header twice.
> 
>
> Key: HIVE-21973
> URL: https://issues.apache.org/jira/browse/HIVE-21973
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Minor
> Attachments: HIVE-21973.patch
>
>
> show locks; 
> -- output
> {code:java}
> +--+---+++-+-++-+-+--+---+---+-+
> |  lockid  | database  | table  | partition  | lock_state  | blocked_by  | 
> lock_type  | transaction_id  | last_heartbeat  | acquired_at  | user  | 
> hostname  | agent_info  |
> +--+---+++-+-++-+-+--+---+---+-+
> | Lock ID  | Database  | Table  | Partition  | State   | Blocked By  | 
> Type   | Transaction ID  | Last Heartbeat  | Acquired At  | User  | 
> Hostname  | Agent Info  |
> +--+---+++-+-++-+-+--+---+---+-+
> {code}



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

[jira] [Assigned] (HIVE-21973) "show locks" print the header twice.

2019-07-08 Thread Rajkumar Singh (JIRA)



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

Rajkumar Singh reassigned HIVE-21973:
-


> "show locks" print the header twice.
> 
>
> Key: HIVE-21973
> URL: https://issues.apache.org/jira/browse/HIVE-21973
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Minor
>
> show locks; 
> -- output
> {code:java}
> +--+---+++-+-++-+-+--+---+---+-+
> |  lockid  | database  | table  | partition  | lock_state  | blocked_by  | 
> lock_type  | transaction_id  | last_heartbeat  | acquired_at  | user  | 
> hostname  | agent_info  |
> +--+---+++-+-++-+-+--+---+---+-+
> | Lock ID  | Database  | Table  | Partition  | State   | Blocked By  | 
> Type   | Transaction ID  | Last Heartbeat  | Acquired At  | User  | 
> Hostname  | Agent Info  |
> +--+---+++-+-++-+-+--+---+---+-+
> {code}



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

[jira] [Updated] (HIVE-21972) "show transactions" display the header twice

2019-07-08 Thread Rajkumar Singh (JIRA)



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

Rajkumar Singh updated HIVE-21972:
--
Attachment: HIVE-21972.patch
Status: Patch Available  (was: Open)

> "show transactions" display the header twice
> 
>
> Key: HIVE-21972
> URL: https://issues.apache.org/jira/browse/HIVE-21972
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Major
> Attachments: HIVE-21972.patch
>
>
> show transactions;
> {code:java}
> +-+++--+---+---+
> |  txnid  |   state|  startedtime   |  lastheartbeattime  
>  | user  |   host|
> +-+++--+---+---+
> | Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time 
>  | User  | Hostname  |
> | 896 | ABORTED| 1560209607000  | 1560209607000   
>  | hive  | hostname  |
> +-+++--+---+---+
> {code}



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

[jira] [Updated] (HIVE-21972) "show transactions" display the header twice

2019-07-08 Thread Rajkumar Singh (JIRA)



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

Rajkumar Singh updated HIVE-21972:
--
Description: 
show transactions;

{code:java}
+-+++--+---+---+
|  txnid  |   state|  startedtime   |  lastheartbeattime   
| user  |   host|
+-+++--+---+---+
| Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time  
| User  | Hostname  |
| 896 | ABORTED| 1560209607000  | 1560209607000
| hive  | hdp32b.hdp.local  |
+-+++--+---+---+
{code}


  was:
show transactions;
+-+++--+---+---+
|  txnid  |   state|  startedtime   |  lastheartbeattime   
| user  |   host|
+-+++--+---+---+
| Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time  
| User  | Hostname  |
| 896 | ABORTED| 1560209607000  | 1560209607000
| hive  | hdp32b.hdp.local  |
+-+++--+---+---+


> "show transactions" display the header twice
> 
>
> Key: HIVE-21972
> URL: https://issues.apache.org/jira/browse/HIVE-21972
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Major
>
> show transactions;
> {code:java}
> +-+++--+---+---+
> |  txnid  |   state|  startedtime   |  lastheartbeattime  
>  | user  |   host|
> +-+++--+---+---+
> | Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time 
>  | User  | Hostname  |
> | 896 | ABORTED| 1560209607000  | 1560209607000   
>  | hive  | hdp32b.hdp.local  |
> +-+++--+---+---+
> {code}



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

[jira] [Updated] (HIVE-21972) "show transactions" display the header twice

2019-07-08 Thread Rajkumar Singh (JIRA)



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

Rajkumar Singh updated HIVE-21972:
--
Description: 
show transactions;

{code:java}
+-+++--+---+---+
|  txnid  |   state|  startedtime   |  lastheartbeattime   
| user  |   host|
+-+++--+---+---+
| Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time  
| User  | Hostname  |
| 896 | ABORTED| 1560209607000  | 1560209607000
| hive  | hostname  |
+-+++--+---+---+
{code}


  was:
show transactions;

{code:java}
+-+++--+---+---+
|  txnid  |   state|  startedtime   |  lastheartbeattime   
| user  |   host|
+-+++--+---+---+
| Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time  
| User  | Hostname  |
| 896 | ABORTED| 1560209607000  | 1560209607000
| hive  | hdp32b.hdp.local  |
+-+++--+---+---+
{code}



> "show transactions" display the header twice
> 
>
> Key: HIVE-21972
> URL: https://issues.apache.org/jira/browse/HIVE-21972
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Major
>
> show transactions;
> {code:java}
> +-+++--+---+---+
> |  txnid  |   state|  startedtime   |  lastheartbeattime  
>  | user  |   host|
> +-+++--+---+---+
> | Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time 
>  | User  | Hostname  |
> | 896 | ABORTED| 1560209607000  | 1560209607000   
>  | hive  | hostname  |
> +-+++--+---+---+
> {code}



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

[jira] [Assigned] (HIVE-21972) "show transactions" display the header twice

2019-07-08 Thread Rajkumar Singh (JIRA)



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

Rajkumar Singh reassigned HIVE-21972:
-


> "show transactions" display the header twice
> 
>
> Key: HIVE-21972
> URL: https://issues.apache.org/jira/browse/HIVE-21972
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Affects Versions: 3.1.1
>Reporter: Rajkumar Singh
>Assignee: Rajkumar Singh
>Priority: Major
>
> show transactions;
> +-+++--+---+---+
> |  txnid  |   state|  startedtime   |  lastheartbeattime  
>  | user  |   host|
> +-+++--+---+---+
> | Transaction ID  | Transaction State  | Started Time   | Last Heartbeat Time 
>  | User  | Hostname  |
> | 896 | ABORTED| 1560209607000  | 1560209607000   
>  | hive  | hdp32b.hdp.local  |
> +-+++--+---+---+



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

1 2 >

1 - 100 of 171 matches

Mail list logo