hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Singhi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HBASE-8642) [Snapshot] List and delete snapshot by table
Date Wed, 01 Jul 2015 07:16:05 GMT

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

Ashish Singhi commented on HBASE-8642:
--------------------------------------

Thanks Anoop for the review. Added one example with namespace in v3 patch.

bq. Hope u have tested shell commands with all possible combinations.
Following are the combinations I have tested with their output.
{noformat}
hbase(main):015:0> list
TABLE
ns:t
t
t1
u
4 row(s) in 0.0330 seconds

=> ["ns:t", "t", "t1", "u"]

hbase(main):016:0> list_snapshots

SNAPSHOT                                             TABLE + CREATION TIME
 as2                                                 t1 (Wed Jul 01 18:16:07 +0530 2015)
 as3                                                 ns:t (Wed Jul 01 18:16:26 +0530 2015)
 p                                                   t (Wed Jul 01 18:15:54 +0530 2015)
 q                                                   u (Wed Jul 01 18:16:42 +0530 2015)
 s                                                   t (Wed Jul 01 18:15:45 +0530 2015)
 s1                                                  t (Wed Jul 01 18:15:48 +0530 2015)
 s2                                                  t1 (Wed Jul 01 18:16:01 +0530 2015)
 s3                                                  ns:t (Wed Jul 01 18:16:22 +0530 2015)
 s4                                                  u (Wed Jul 01 18:16:47 +0530 2015)
9 row(s) in 0.0780 seconds

=> ["as2", "as3", "p", "q", "s", "s1", "s2", "s3", "s4"]

hbase(main):017:0> delete_table_snapshots '.*'
SNAPSHOT                                             TABLE + CREATION TIME
 as2                                                 t1 (Wed Jul 01 18:16:07 +0530 2015)
 as3                                                 ns:t (Wed Jul 01 18:16:26 +0530 2015)
 p                                                   t (Wed Jul 01 18:15:54 +0530 2015)
 q                                                   u (Wed Jul 01 18:16:42 +0530 2015)
 s                                                   t (Wed Jul 01 18:15:45 +0530 2015)
 s1                                                  t (Wed Jul 01 18:15:48 +0530 2015)
 s2                                                  t1 (Wed Jul 01 18:16:01 +0530 2015)
 s3                                                  ns:t (Wed Jul 01 18:16:22 +0530 2015)
 s4                                                  u (Wed Jul 01 18:16:47 +0530 2015)

Delete the above 9 snapshots (y/n)?
n

hbase(main):018:0> delete_table_snapshots '.*', '.*'
SNAPSHOT                                             TABLE + CREATION TIME
 as2                                                 t1 (Wed Jul 01 18:16:07 +0530 2015)
 as3                                                 ns:t (Wed Jul 01 18:16:26 +0530 2015)
 p                                                   t (Wed Jul 01 18:15:54 +0530 2015)
 q                                                   u (Wed Jul 01 18:16:42 +0530 2015)
 s                                                   t (Wed Jul 01 18:15:45 +0530 2015)
 s1                                                  t (Wed Jul 01 18:15:48 +0530 2015)
 s2                                                  t1 (Wed Jul 01 18:16:01 +0530 2015)
 s3                                                  ns:t (Wed Jul 01 18:16:22 +0530 2015)
 s4                                                  u (Wed Jul 01 18:16:47 +0530 2015)

Delete the above 9 snapshots (y/n)?
n

hbase(main):022:0> delete_table_snapshots 't.*'
SNAPSHOT                                             TABLE + CREATION TIME
 as2                                                 t1 (Wed Jul 01 18:16:07 +0530 2015)
 p                                                   t (Wed Jul 01 18:15:54 +0530 2015)
 s                                                   t (Wed Jul 01 18:15:45 +0530 2015)
 s1                                                  t (Wed Jul 01 18:15:48 +0530 2015)
 s2                                                  t1 (Wed Jul 01 18:16:01 +0530 2015)

Delete the above 5 snapshots (y/n)?
n

hbase(main):023:0> delete_table_snapshots 't.*', 's.*'
SNAPSHOT                                             TABLE + CREATION TIME
 s                                                   t (Wed Jul 01 18:15:45 +0530 2015)
 s1                                                  t (Wed Jul 01 18:15:48 +0530 2015)
 s2                                                  t1 (Wed Jul 01 18:16:01 +0530 2015)

Delete the above 3 snapshots (y/n)?
n

hbase(main):024:0> delete_table_snapshots 'ns:t.*', 's.*'
SNAPSHOT                                             TABLE + CREATION TIME
 s3                                                  ns:t (Wed Jul 01 18:16:22 +0530 2015)

Delete the above 1 snapshots (y/n)?
n

hbase(main):025:0> delete_table_snapshots 'ns:t.*'
SNAPSHOT                                             TABLE + CREATION TIME
 as3                                                 ns:t (Wed Jul 01 18:16:26 +0530 2015)
 s3                                                  ns:t (Wed Jul 01 18:16:22 +0530 2015)

Delete the above 2 snapshots (y/n)?
n

hbase(main):026:0> delete_table_snapshots 'ns:t.*'
SNAPSHOT                                             TABLE + CREATION TIME
 as3                                                 ns:t (Wed Jul 01 18:16:26 +0530 2015)
 s3                                                  ns:t (Wed Jul 01 18:16:22 +0530 2015)

Delete the above 2 snapshots (y/n)?
y
0 row(s) in 0.1060 seconds
2 snapshots successfully deleted.

hbase(main):027:0> delete_table_snapshots '.*', 's.*'
SNAPSHOT                                             TABLE + CREATION TIME
 s                                                   t (Wed Jul 01 18:15:45 +0530 2015)
 s1                                                  t (Wed Jul 01 18:15:48 +0530 2015)
 s2                                                  t1 (Wed Jul 01 18:16:01 +0530 2015)
 s4                                                  u (Wed Jul 01 18:16:47 +0530 2015)

Delete the above 4 snapshots (y/n)?
y
0 row(s) in 0.0910 seconds
4 snapshots successfully deleted.

hbase(main):028:0> delete_table_snapshots '.*', '.*'
SNAPSHOT                                             TABLE + CREATION TIME
 as2                                                 t1 (Wed Jul 01 18:16:07 +0530 2015)
 p                                                   t (Wed Jul 01 18:15:54 +0530 2015)
 q                                                   u (Wed Jul 01 18:16:42 +0530 2015)

Delete the above 3 snapshots (y/n)?
y
0 row(s) in 0.0720 seconds
3 snapshots successfully deleted.

hbase(main):030:0> delete_table_snapshots '.*'
SNAPSHOT                                             TABLE + CREATION TIME
No snapshots matched the table name regular expression .* and the snapshot name regular expression
.*

hbase(main):032:0> delete_table_snapshots 't'
SNAPSHOT                                             TABLE + CREATION TIME
No snapshots matched the table name regular expression t and the snapshot name regular expression
.*

hbase(main):033:0> delete_table_snapshots

ERROR: wrong number of arguments (0 for 1)

Here is some help for this command:
Delete all of the snapshots matching the given table name regular expression
and snapshot name regular expression.
By default snapshot name regular expression will delete all the snapshots of the
matching table name regular expression.

Examples:
  hbase> delete_table_snapshots 'tableName'
  hbase> delete_table_snapshots 'tableName.*'
  hbase> delete_table_snapshots 'tableName' 'snapshotName'
  hbase> delete_table_snapshots 'tableName' 'snapshotName.*'
  hbase> delete_table_snapshots 'tableName.*' 'snapshotName.*'
  hbase> delete_table_snapshots 'ns:tableName.*' 'snapshotName.*'
{noformat}

> [Snapshot] List and delete snapshot by table
> --------------------------------------------
>
>                 Key: HBASE-8642
>                 URL: https://issues.apache.org/jira/browse/HBASE-8642
>             Project: HBase
>          Issue Type: Improvement
>          Components: snapshots
>    Affects Versions: 0.98.0, 0.95.0, 0.95.1, 0.95.2
>            Reporter: Julian Zhou
>            Assignee: Ashish Singhi
>             Fix For: 2.0.0
>
>         Attachments: 8642-trunk-0.95-v0.patch, 8642-trunk-0.95-v1.patch, 8642-trunk-0.95-v2.patch,
HBASE-8642-v1.patch, HBASE-8642-v2.patch, HBASE-8642-v3.patch, HBASE-8642.patch
>
>
> Support list and delete snapshots by table names.
> User scenario:
> A user wants to delete all the snapshots which were taken in January month for a table
't' where snapshot names starts with 'Jan'.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message