{"id":13145,"date":"2024-03-15T01:58:22","date_gmt":"2024-03-15T01:58:22","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/"},"modified":"2025-08-05T12:08:37","modified_gmt":"2025-08-05T12:08:37","slug":"how-to-create-an-external-table-in-hbase-using-hive","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/","title":{"rendered":"Create HBase External Tables Using Hive"},"content":{"rendered":"<p>The following steps are required to create an external table in HBase.<\/p>\n<ol>\n<li>Create a Hive table to define the structure of an external table. You can use the CREATE EXTERNAL TABLE statement to create the external table, specifying the table name and column families for storing HBase data.<\/li>\n<\/ol>\n<p>For example, create an external table named my_external_table that stores data from an HBase table named hbase_table, with the column family cf1.<\/p>\n<pre class=\"post-pre\"><code>CREATE EXTERNAL TABLE my_external_table (\r\n    id INT,\r\n    name STRING,\r\n    age INT\r\n)\r\nSTORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'\r\nWITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,cf1:name,cf1:age')\r\nTBLPROPERTIES ('hbase.table.name' = 'hbase_table');\r\n<\/code><\/pre>\n<ol>\n<li>Add the HBase storage handler to the classpath of Hive. You can add the following configuration in the Hive configuration file hive-site.xml.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>&lt;property&gt;\r\n    &lt;name&gt;hive.aux.jars.path&lt;\/name&gt;\r\n    &lt;value&gt;\/path\/to\/hbase-handler.jar&lt;\/value&gt;\r\n&lt;\/property&gt;\r\n<\/code><\/pre>\n<p>Be sure to replace \/path\/to\/hbase-handler.jar with the actual path to the HBase handler jar file.<\/p>\n<ol>\n<li>Querying an external table in Hive. Once the external table is created, it can be used like any other Hive table for querying. For example, you can use a SELECT statement to query the data in the external table.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>SELECT * FROM my_external_table;\r\n<\/code><\/pre>\n<p>\u6ce8\u610f\u5728\u521b\u5efaHBase\u5916\u90e8\u8868\u65f6\uff0c\u8981\u786e\u4fddHBase\u548cHive\u4e4b\u95f4\u7684\u8fde\u63a5\u548c\u914d\u7f6e\u662f\u6b63\u786e\u7684\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The following steps are required to create an external table in HBase. Create a Hive table to define the structure of an external table. You can use the CREATE EXTERNAL TABLE statement to create the external table, specifying the table name and column families for storing HBase data. For example, create an external table named [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[302,8803,301,304,303],"class_list":["post-13145","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-big-data","tag-external-tables","tag-hadoop","tag-hbase","tag-hive"],"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>Create HBase External Tables Using Hive - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Step-by-step guide to create external tables in HBase using Hive for efficient big data management.\" \/>\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-create-an-external-table-in-hbase-using-hive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create HBase External Tables Using Hive\" \/>\n<meta property=\"og:description\" content=\"Step-by-step guide to create external tables in HBase using Hive for efficient big data management.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/\" \/>\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-15T01:58:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T12:08:37+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\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=\"Ava Mitchell\" \/>\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-create-an-external-table-in-hbase-using-hive\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Create HBase External Tables Using Hive\",\"datePublished\":\"2024-03-15T01:58:22+00:00\",\"dateModified\":\"2025-08-05T12:08:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/\"},\"wordCount\":162,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Big Data\",\"External tables\",\"Hadoop\",\"HBase\",\"Hive\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/\",\"name\":\"Create HBase External Tables Using Hive - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T01:58:22+00:00\",\"dateModified\":\"2025-08-05T12:08:37+00:00\",\"description\":\"Step-by-step guide to create external tables in HBase using Hive for efficient big data management.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create HBase External Tables Using Hive\"}]},{\"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Create HBase External Tables Using Hive - Blog - Silicon Cloud","description":"Step-by-step guide to create external tables in HBase using Hive for efficient big data management.","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-create-an-external-table-in-hbase-using-hive\/","og_locale":"en_US","og_type":"article","og_title":"Create HBase External Tables Using Hive","og_description":"Step-by-step guide to create external tables in HBase using Hive for efficient big data management.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T01:58:22+00:00","article_modified_time":"2025-08-05T12:08:37+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Create HBase External Tables Using Hive","datePublished":"2024-03-15T01:58:22+00:00","dateModified":"2025-08-05T12:08:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/"},"wordCount":162,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Big Data","External tables","Hadoop","HBase","Hive"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/","name":"Create HBase External Tables Using Hive - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T01:58:22+00:00","dateModified":"2025-08-05T12:08:37+00:00","description":"Step-by-step guide to create external tables in HBase using Hive for efficient big data management.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-an-external-table-in-hbase-using-hive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Create HBase External Tables Using Hive"}]},{"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13145","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13145"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13145\/revisions"}],"predecessor-version":[{"id":157013,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13145\/revisions\/157013"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}