{"id":24749,"date":"2024-03-16T03:47:21","date_gmt":"2024-03-16T03:47:21","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/"},"modified":"2024-03-22T04:29:57","modified_gmt":"2024-03-22T04:29:57","slug":"how-can-data-be-deleted-in-hbase-based-on-a-timestamp","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/","title":{"rendered":"How can data be deleted in HBase based on a timestamp?"},"content":{"rendered":"<p>In HBase, you can use the Delete class to delete data based on timestamp. Here is an example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.conf.Configuration;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.HBaseConfiguration;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.client.Connection;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.client.ConnectionFactory;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.client.Delete;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.client.Table;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.util.Bytes;\r\n\r\n<span class=\"hljs-keyword\">import<\/span> java.io.IOException;\r\n\r\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title class_\">HBaseDeleteByTimestampExample<\/span> {\r\n\r\n    <span class=\"hljs-keyword\">private<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">final<\/span> <span class=\"hljs-type\">String<\/span> <span class=\"hljs-variable\">TABLE_NAME<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">\"your_table_name\"<\/span>;\r\n    <span class=\"hljs-keyword\">private<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">final<\/span> <span class=\"hljs-type\">String<\/span> <span class=\"hljs-variable\">COLUMN_FAMILY<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">\"your_column_family\"<\/span>;\r\n    <span class=\"hljs-keyword\">private<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">final<\/span> <span class=\"hljs-type\">String<\/span> <span class=\"hljs-variable\">COLUMN_QUALIFIER<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">\"your_column_qualifier\"<\/span>;\r\n    <span class=\"hljs-keyword\">private<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">final<\/span> <span class=\"hljs-type\">long<\/span> <span class=\"hljs-variable\">TIMESTAMP<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-number\">1612896000000L<\/span>; <span class=\"hljs-comment\">\/\/ \u65f6\u95f4\u6233\uff0c\u5355\u4f4d\u4e3a\u6beb\u79d2<\/span>\r\n\r\n    <span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title function_\">main<\/span><span class=\"hljs-params\">(String[] args)<\/span> <span class=\"hljs-keyword\">throws<\/span> IOException {\r\n        <span class=\"hljs-type\">Configuration<\/span> <span class=\"hljs-variable\">conf<\/span> <span class=\"hljs-operator\">=<\/span> HBaseConfiguration.create();\r\n        <span class=\"hljs-keyword\">try<\/span> (<span class=\"hljs-type\">Connection<\/span> <span class=\"hljs-variable\">connection<\/span> <span class=\"hljs-operator\">=<\/span> ConnectionFactory.createConnection(conf);\r\n             <span class=\"hljs-type\">Table<\/span> <span class=\"hljs-variable\">table<\/span> <span class=\"hljs-operator\">=<\/span> connection.getTable(Bytes.toBytes(TABLE_NAME))) {\r\n            <span class=\"hljs-type\">Delete<\/span> <span class=\"hljs-variable\">delete<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">Delete<\/span>(Bytes.toBytes(<span class=\"hljs-string\">\"row_key\"<\/span>)); <span class=\"hljs-comment\">\/\/ \u6839\u636e\u884c\u952e\u5220\u9664\u6570\u636e<\/span>\r\n            delete.addColumn(Bytes.toBytes(COLUMN_FAMILY), Bytes.toBytes(COLUMN_QUALIFIER), TIMESTAMP);\r\n\r\n            table.delete(delete);\r\n            System.out.println(<span class=\"hljs-string\">\"Data deleted successfully.\"<\/span>);\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>In the sample code above, a Delete object is first created. Then the addColumn method is used to specify the column family, column qualifier, and timestamp to be deleted. Finally, the table.delete method is called to execute the deletion operation.<\/p>\n<p>It is important to note that the timestamp is a long integer value measured in milliseconds, and you can obtain the current timestamp using the System.currentTimeMillis() method.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In HBase, you can use the Delete class to delete data based on timestamp. Here is an example code: import org.apache.hadoop.conf.Configuration; import org.apache.hadoop.hbase.HBaseConfiguration; import org.apache.hadoop.hbase.client.Connection; import org.apache.hadoop.hbase.client.ConnectionFactory; import org.apache.hadoop.hbase.client.Delete; import org.apache.hadoop.hbase.client.Table; import org.apache.hadoop.hbase.util.Bytes; import java.io.IOException; public class HBaseDeleteByTimestampExample { private static final String TABLE_NAME = &#8220;your_table_name&#8221;; private static final String COLUMN_FAMILY = &#8220;your_column_family&#8221;; private static [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-24749","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can data be deleted in HBase based on a timestamp? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can data be deleted in HBase based on a timestamp?\" \/>\n<meta property=\"og:description\" content=\"In HBase, you can use the Delete class to delete data based on timestamp. Here is an example code: import org.apache.hadoop.conf.Configuration; import org.apache.hadoop.hbase.HBaseConfiguration; import org.apache.hadoop.hbase.client.Connection; import org.apache.hadoop.hbase.client.ConnectionFactory; import org.apache.hadoop.hbase.client.Delete; import org.apache.hadoop.hbase.client.Table; import org.apache.hadoop.hbase.util.Bytes; import java.io.IOException; public class HBaseDeleteByTimestampExample { private static final String TABLE_NAME = &quot;your_table_name&quot;; private static final String COLUMN_FAMILY = &quot;your_column_family&quot;; private static [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T03:47:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T04:29:57+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"How can data be deleted in HBase based on a timestamp?\",\"datePublished\":\"2024-03-16T03:47:21+00:00\",\"dateModified\":\"2024-03-22T04:29:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\"},\"wordCount\":99,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\",\"name\":\"How can data be deleted in HBase based on a timestamp? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T03:47:21+00:00\",\"dateModified\":\"2024-03-22T04:29:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can data be deleted in HBase based on a timestamp?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can data be deleted in HBase based on a timestamp? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/","og_locale":"en_US","og_type":"article","og_title":"How can data be deleted in HBase based on a timestamp?","og_description":"In HBase, you can use the Delete class to delete data based on timestamp. Here is an example code: import org.apache.hadoop.conf.Configuration; import org.apache.hadoop.hbase.HBaseConfiguration; import org.apache.hadoop.hbase.client.Connection; import org.apache.hadoop.hbase.client.ConnectionFactory; import org.apache.hadoop.hbase.client.Delete; import org.apache.hadoop.hbase.client.Table; import org.apache.hadoop.hbase.util.Bytes; import java.io.IOException; public class HBaseDeleteByTimestampExample { private static final String TABLE_NAME = \"your_table_name\"; private static final String COLUMN_FAMILY = \"your_column_family\"; private static [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T03:47:21+00:00","article_modified_time":"2024-03-22T04:29:57+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"How can data be deleted in HBase based on a timestamp?","datePublished":"2024-03-16T03:47:21+00:00","dateModified":"2024-03-22T04:29:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/"},"wordCount":99,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/","name":"How can data be deleted in HBase based on a timestamp? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T03:47:21+00:00","dateModified":"2024-03-22T04:29:57+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-in-hbase-based-on-a-timestamp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can data be deleted in HBase based on a timestamp?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=24749"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24749\/revisions"}],"predecessor-version":[{"id":58803,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24749\/revisions\/58803"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=24749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=24749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=24749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}