{"id":22562,"date":"2024-03-15T23:48:08","date_gmt":"2024-03-15T23:48:08","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/"},"modified":"2024-03-21T23:10:53","modified_gmt":"2024-03-21T23:10:53","slug":"how-to-add-data-to-a-table-in-hbase","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/","title":{"rendered":"How to add data to a table in HBase?"},"content":{"rendered":"<p>There are several ways to add data to an HBase table.<\/p>\n<ol>\n<li>place<\/li>\n<li>the table owned by me<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>put 'myTable', 'rowKey1', 'columnFamily:columnQualifier1', 'value1'\r\nput 'myTable', 'rowKey2', 'columnFamily:columnQualifier2', 'value2'\r\n<\/code><\/pre>\n<ol>\n<li>By utilizing the Java API, you can write code to insert data using HBase. Here is a simple example:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.client.Put;\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.TableName;\r\n<span class=\"hljs-keyword\">import<\/span> org.apache.hadoop.hbase.util.Bytes;\r\n\r\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title class_\">HBaseExample<\/span> {\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> Exception {\r\n        <span class=\"hljs-comment\">\/\/ \u521b\u5efaHBase\u8fde\u63a5<\/span>\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-type\">Connection<\/span> <span class=\"hljs-variable\">connection<\/span> <span class=\"hljs-operator\">=<\/span> ConnectionFactory.createConnection(conf);\r\n\r\n        <span class=\"hljs-comment\">\/\/ \u83b7\u53d6\u8868\u5bf9\u8c61<\/span>\r\n        <span class=\"hljs-type\">TableName<\/span> <span class=\"hljs-variable\">tableName<\/span> <span class=\"hljs-operator\">=<\/span> TableName.valueOf(<span class=\"hljs-string\">\"myTable\"<\/span>);\r\n        <span class=\"hljs-type\">Table<\/span> <span class=\"hljs-variable\">table<\/span> <span class=\"hljs-operator\">=<\/span> connection.getTable(tableName);\r\n\r\n        <span class=\"hljs-comment\">\/\/ \u521b\u5efaPut\u5bf9\u8c61\uff0c\u5e76\u8bbe\u7f6e\u884c\u952e\u548c\u5217\u503c<\/span>\r\n        <span class=\"hljs-type\">Put<\/span> <span class=\"hljs-variable\">put<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">Put<\/span>(Bytes.toBytes(<span class=\"hljs-string\">\"rowKey1\"<\/span>));\r\n        put.addColumn(Bytes.toBytes(<span class=\"hljs-string\">\"columnFamily\"<\/span>), Bytes.toBytes(<span class=\"hljs-string\">\"columnQualifier1\"<\/span>), Bytes.toBytes(<span class=\"hljs-string\">\"value1\"<\/span>));\r\n\r\n        <span class=\"hljs-comment\">\/\/ \u63d2\u5165\u6570\u636e<\/span>\r\n        table.put(put);\r\n\r\n        <span class=\"hljs-comment\">\/\/ \u5173\u95ed\u8fde\u63a5<\/span>\r\n        table.close();\r\n        connection.close();\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>In this context, myTable is the name of the table, rowKey1 is the row key, columnFamily is the column family, columnQualifier1 is the column qualifier, and value1 is the value to be inserted.<\/p>\n<ol>\n<li>The HBase REST API allows for inserting data by sending a POST request with the data as a JSON object to HBase. Here is an example.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>curl -vi -X POST \\\r\n  -H \"Accept: application\/json\" \\\r\n  -H \"Content-Type: application\/json\" \\\r\n  --data '{\r\n    \"Row\": [\r\n        {\r\n            \"key\": \"cm93S2V5MQ==\",\r\n            \"Cell\": [\r\n                {\r\n                    \"column\": \"Y29sdW1uRmFtaWx5OmNvbHVtblF1YWxpZmllcjE=\",\r\n                    \"$\": \"dmFsdWUx\"\r\n                }\r\n            ]\r\n        }\r\n    ]\r\n}' \\\r\n  \"http:\/\/localhost:8080\/myTable\/rowKey1\"\r\n<\/code><\/pre>\n<p>In this case, myTable is the name of the table, rowKey1 is the row key, columnFamily:columnQualifier1 is the column, and value1 is the value to be inserted.<\/p>\n<p>No matter which method you choose, it is necessary to ensure that HBase is properly installed and configured, and that the table already exists.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are several ways to add data to an HBase table. place the table owned by me put &#8216;myTable&#8217;, &#8216;rowKey1&#8217;, &#8216;columnFamily:columnQualifier1&#8217;, &#8216;value1&#8217; put &#8216;myTable&#8217;, &#8216;rowKey2&#8217;, &#8216;columnFamily:columnQualifier2&#8217;, &#8216;value2&#8217; By utilizing the Java API, you can write code to insert data using HBase. Here is a simple example: import org.apache.hadoop.hbase.client.Put; import org.apache.hadoop.hbase.client.Connection; import org.apache.hadoop.hbase.client.ConnectionFactory; import org.apache.hadoop.hbase.TableName; import [&hellip;]<\/p>\n","protected":false},"author":6,"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-22562","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 to add data to a table in HBase? - 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-to-add-data-to-a-table-in-hbase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to add data to a table in HBase?\" \/>\n<meta property=\"og:description\" content=\"There are several ways to add data to an HBase table. place the table owned by me put &#039;myTable&#039;, &#039;rowKey1&#039;, &#039;columnFamily:columnQualifier1&#039;, &#039;value1&#039; put &#039;myTable&#039;, &#039;rowKey2&#039;, &#039;columnFamily:columnQualifier2&#039;, &#039;value2&#039; By utilizing the Java API, you can write code to insert data using HBase. Here is a simple example: import org.apache.hadoop.hbase.client.Put; import org.apache.hadoop.hbase.client.Connection; import org.apache.hadoop.hbase.client.ConnectionFactory; import org.apache.hadoop.hbase.TableName; import [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/\" \/>\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-15T23:48:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T23:10:53+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\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=\"Benjamin Taylor\" \/>\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-to-add-data-to-a-table-in-hbase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"How to add data to a table in HBase?\",\"datePublished\":\"2024-03-15T23:48:08+00:00\",\"dateModified\":\"2024-03-21T23:10:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/\"},\"wordCount\":156,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/\",\"name\":\"How to add data to a table in HBase? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T23:48:08+00:00\",\"dateModified\":\"2024-03-21T23:10:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to add data to a table in HBase?\"}]},{\"@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\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to add data to a table in HBase? - 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-to-add-data-to-a-table-in-hbase\/","og_locale":"en_US","og_type":"article","og_title":"How to add data to a table in HBase?","og_description":"There are several ways to add data to an HBase table. place the table owned by me put 'myTable', 'rowKey1', 'columnFamily:columnQualifier1', 'value1' put 'myTable', 'rowKey2', 'columnFamily:columnQualifier2', 'value2' By utilizing the Java API, you can write code to insert data using HBase. Here is a simple example: import org.apache.hadoop.hbase.client.Put; import org.apache.hadoop.hbase.client.Connection; import org.apache.hadoop.hbase.client.ConnectionFactory; import org.apache.hadoop.hbase.TableName; import [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T23:48:08+00:00","article_modified_time":"2024-03-21T23:10:53+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"How to add data to a table in HBase?","datePublished":"2024-03-15T23:48:08+00:00","dateModified":"2024-03-21T23:10:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/"},"wordCount":156,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/","name":"How to add data to a table in HBase? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T23:48:08+00:00","dateModified":"2024-03-21T23:10:53+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-add-data-to-a-table-in-hbase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to add data to a table in HBase?"}]},{"@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\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22562","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=22562"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22562\/revisions"}],"predecessor-version":[{"id":56491,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22562\/revisions\/56491"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=22562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=22562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=22562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}