{"id":242,"date":"2016-11-28T17:10:15","date_gmt":"2016-11-28T19:10:15","guid":{"rendered":"http:\/\/portal.venidera.com\/kb\/?p=242"},"modified":"2018-07-26T13:39:50","modified_gmt":"2018-07-26T16:39:50","slug":"english-hbase-tables-backup","status":"publish","type":"post","link":"https:\/\/portal.venidera.com\/kb\/2016\/11\/28\/english-hbase-tables-backup\/","title":{"rendered":"(English) Hbase tables backup"},"content":{"rendered":"<p class=\"qtranxs-available-languages-message qtranxs-available-languages-message-pb\">Desculpe-nos, mas este texto est\u00e1 apenas dispon\u00edvel em <a href=\"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/242?lang=en\" class=\"qtranxs-available-language-link qtranxs-available-language-link-en\" title=\"English\">English<\/a>. For the sake of viewer convenience, the content is shown below in the alternative language. You may click the link to switch the active language.<\/p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 hundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-overflow:visible;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\">Here is an sample for backup hbase tables. In this example we are exporting OpenTSDB tables.<br \/>\nFirst it&#8217;s necessary to export tables do the HDFS and then execute -get to save the files in the local system.<\/p>\n[code]\n#!\/bin\/bash<\/p>\n<p>DATAREF=`date +&quot;%Y-%m-%d&quot;`<br \/>\nBKPDIR=\/backup\/$DATAREF<\/p>\n<p>mkdir $BKPDIR<\/p>\n<p>sudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb<br \/>\nsudo -u hdfs hbase org.apache.hadoop.hbase.mapreduce.Export tsdb \/dump-tsdb<br \/>\nsudo -u hdfs hadoop dfs -get \/dump-tsdb $BKPDIR<br \/>\nsudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb<\/p>\n<p>sudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb-tree<br \/>\nsudo -u hdfs hbase org.apache.hadoop.hbase.mapreduce.Export tsdb-tree \/dump-tsdb-tree<br \/>\nsudo -u hdfs hadoop dfs -get \/dump-tsdb-tree $BKPDIR<br \/>\nsudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb-tree<\/p>\n<p>sudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb-uid<br \/>\nsudo -u hdfs hbase org.apache.hadoop.hbase.mapreduce.Export tsdb-uid \/dump-tsdb-uid<br \/>\nsudo -u hdfs hadoop dfs -get \/dump-tsdb-uid $BKPDIR<br \/>\nsudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb-uid<\/p>\n<p>sudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb-meta<br \/>\nsudo -u hdfs hbase org.apache.hadoop.hbase.mapreduce.Export tsdb-meta \/dump-tsdb-meta<br \/>\nsudo -u hdfs hadoop dfs -get \/dump-tsdb-meta $BKPDIR<br \/>\nsudo -u hdfs hadoop dfs -rm -f -r \/dump-tsdb-meta<\/p>\n<p>cd $BKPDIR<br \/>\ntar -cjf hbase_bkp_$DATAREF.tar.bz2 dump-*<br \/>\nrm -fr $BKPDIR\/dump-*[\/code]\n<p>To restore:[code]\n$ bin\/hbase org.apache.hadoop.hbase.mapreduce.Import &lt;tablename&gt; &lt;inputdir&gt;[\/code]\n<p>Reference:<br \/>\n<a href=\"http:\/\/hbase.apache.org\/0.94\/book\/ops_mgt.html\" target=\"_blank\">Chapter 14. Apache HBase (TM) Operational Management<\/a><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-242","post","type-post","status-publish","format-standard","hentry","category-hbase"],"_links":{"self":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/comments?post=242"}],"version-history":[{"count":5,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/242\/revisions"}],"predecessor-version":[{"id":281,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/242\/revisions\/281"}],"wp:attachment":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/media?parent=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/categories?post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/tags?post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}