{"id":1734,"date":"2022-01-05T06:00:00","date_gmt":"2022-01-05T12:00:00","guid":{"rendered":"https:\/\/www.bigdatainrealworld.com\/?p=1734"},"modified":"2023-02-19T07:30:51","modified_gmt":"2023-02-19T13:30:51","slug":"how-to-move-a-hive-table-from-one-database-to-another","status":"publish","type":"post","link":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/","title":{"rendered":"How to move a Hive table from one database to another?"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Let\u2019s see how to move a Hive table from one database to another in action.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We are currently inside a database named hirw. Let\u2019s list the table under hirw.<\/span><\/p>\n<pre class=\"lang:default decode:true \">0: jdbc:hive2:\/\/ms2.hirw.com:2181,wk1.hirw.co&gt; show tables;\n\n+-----------+--+\n| tab_name\u00a0 |\n+-----------+--+\n| employee\u00a0 |\n+-----------+--+<\/pre>\n<p><span style=\"font-weight: 400;\">We got one table named employee under database hirw.\u00a0<\/span><span style=\"font-weight: 400;\">Let\u2019s create a new database named hirw_2<\/span><\/p>\n<pre class=\"lang:default decode:true \">0: jdbc:hive2:\/\/ms2.hirw.com:2181,wk1.hirw.co&gt; create database hirw_2;\n\nNo rows affected (0.275 seconds)<\/pre>\n<h2><span style=\"font-weight: 400;\">Move table from hirw database to hirw_2 database<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Hive offers a convenient alter table..rename command to move a Hive table from one database to another.<\/span><\/p>\n<pre class=\"lang:default decode:true \">0: jdbc:hive2:\/\/ms2.hirw.com:2181,wk1.hirw.co&gt; alter table employee rename to hirw_2.employee;\n\nNo rows affected (0.649 seconds)<\/pre>\n<p><span style=\"font-weight: 400;\">We don\u2019t see the employee table anymore when we now list the tables under hirw.<\/span><\/p>\n<pre class=\"lang:default decode:true \">0: jdbc:hive2:\/\/ms2.hirw.com:2181,wk1.hirw.co&gt; show tables;\n\n+-----------+--+\n| tab_name\u00a0 |\n+-----------+--+\n\n+-----------+--+\n\nNo rows selected (0.287 seconds)<\/pre>\n<p><span style=\"font-weight: 400;\">Let\u2019s switch to hirw_2 database and list the tables again. There you go, employee table is under hirw_2 which is exactly what we wanted.<\/span><\/p>\n<pre class=\"lang:default decode:true\">0: jdbc:hive2:\/\/ms2.hirw.com:2181,wk1.hirw.co&gt; use hirw_2\n\n0: jdbc:hive2:\/\/ms2.hirw.com:2181,wk1.hirw.co&gt; show tables;\n\n+-----------+--+\n| tab_name\u00a0 |\n+-----------+--+\n| employee\u00a0 |\n+-----------+--+\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Let\u2019s see how to move a Hive table from one database to another in action. We are currently inside a database named hirw. Let\u2019s list the<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-1734","post","type-post","status-publish","format-standard","hentry","category-apache-hive"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to move a Hive table from one database to another? - Big Data In Real World<\/title>\n<meta name=\"description\" content=\"Quick solution to move a Hive table from one database to another.\" \/>\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.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to move a Hive table from one database to another? - Big Data In Real World\" \/>\n<meta property=\"og:description\" content=\"Quick solution to move a Hive table from one database to another.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\" \/>\n<meta property=\"og:site_name\" content=\"Big Data In Real World\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bigdatainrealworld\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-05T12:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-19T13:30:51+00:00\" \/>\n<meta name=\"author\" content=\"Big Data In Real World\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Big Data In Real World\" \/>\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.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\"},\"author\":{\"name\":\"Big Data In Real World\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67\"},\"headline\":\"How to move a Hive table from one database to another?\",\"datePublished\":\"2022-01-05T12:00:00+00:00\",\"dateModified\":\"2023-02-19T13:30:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\"},\"wordCount\":126,\"publisher\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#organization\"},\"articleSection\":[\"Apache Hive\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\",\"name\":\"How to move a Hive table from one database to another? - Big Data In Real World\",\"isPartOf\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#website\"},\"datePublished\":\"2022-01-05T12:00:00+00:00\",\"dateModified\":\"2023-02-19T13:30:51+00:00\",\"description\":\"Quick solution to move a Hive table from one database to another.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bigdatainrealworld.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to move a Hive table from one database to another?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#website\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/\",\"name\":\"Big Data In Real World\",\"description\":\"Learn Big Data from experts!\",\"publisher\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bigdatainrealworld.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#organization\",\"name\":\"Big Data In Real World\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png\",\"contentUrl\":\"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png\",\"width\":500,\"height\":500,\"caption\":\"Big Data In Real World\"},\"image\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/bigdatainrealworld\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67\",\"name\":\"Big Data In Real World\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g\",\"caption\":\"Big Data In Real World\"},\"description\":\"We are a group of Big Data engineers who are passionate about Big Data and related Big Data technologies. We have designed, developed, deployed and maintained Big Data applications ranging from batch to real time streaming big data platforms. We have seen a wide range of real world big data problems, implemented some innovative and complex (or simple, depending on how you look at it) solutions.\",\"sameAs\":[\"https:\/\/www.bigdatainrealworld.com\/\"],\"url\":\"https:\/\/www.bigdatainrealworld.com\/author\/bigdatainrealworld\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to move a Hive table from one database to another? - Big Data In Real World","description":"Quick solution to move a Hive table from one database to another.","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.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/","og_locale":"en_US","og_type":"article","og_title":"How to move a Hive table from one database to another? - Big Data In Real World","og_description":"Quick solution to move a Hive table from one database to another.","og_url":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/","og_site_name":"Big Data In Real World","article_publisher":"https:\/\/www.facebook.com\/bigdatainrealworld","article_published_time":"2022-01-05T12:00:00+00:00","article_modified_time":"2023-02-19T13:30:51+00:00","author":"Big Data In Real World","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Big Data In Real World","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/#article","isPartOf":{"@id":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/"},"author":{"name":"Big Data In Real World","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67"},"headline":"How to move a Hive table from one database to another?","datePublished":"2022-01-05T12:00:00+00:00","dateModified":"2023-02-19T13:30:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/"},"wordCount":126,"publisher":{"@id":"https:\/\/www.bigdatainrealworld.com\/#organization"},"articleSection":["Apache Hive"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/","url":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/","name":"How to move a Hive table from one database to another? - Big Data In Real World","isPartOf":{"@id":"https:\/\/www.bigdatainrealworld.com\/#website"},"datePublished":"2022-01-05T12:00:00+00:00","dateModified":"2023-02-19T13:30:51+00:00","description":"Quick solution to move a Hive table from one database to another.","breadcrumb":{"@id":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bigdatainrealworld.com\/how-to-move-a-hive-table-from-one-database-to-another\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bigdatainrealworld.com\/"},{"@type":"ListItem","position":2,"name":"How to move a Hive table from one database to another?"}]},{"@type":"WebSite","@id":"https:\/\/www.bigdatainrealworld.com\/#website","url":"https:\/\/www.bigdatainrealworld.com\/","name":"Big Data In Real World","description":"Learn Big Data from experts!","publisher":{"@id":"https:\/\/www.bigdatainrealworld.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bigdatainrealworld.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bigdatainrealworld.com\/#organization","name":"Big Data In Real World","url":"https:\/\/www.bigdatainrealworld.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png","contentUrl":"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png","width":500,"height":500,"caption":"Big Data In Real World"},"image":{"@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/bigdatainrealworld"]},{"@type":"Person","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67","name":"Big Data In Real World","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g","caption":"Big Data In Real World"},"description":"We are a group of Big Data engineers who are passionate about Big Data and related Big Data technologies. We have designed, developed, deployed and maintained Big Data applications ranging from batch to real time streaming big data platforms. We have seen a wide range of real world big data problems, implemented some innovative and complex (or simple, depending on how you look at it) solutions.","sameAs":["https:\/\/www.bigdatainrealworld.com\/"],"url":"https:\/\/www.bigdatainrealworld.com\/author\/bigdatainrealworld\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts\/1734"}],"collection":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/comments?post=1734"}],"version-history":[{"count":2,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts\/1734\/revisions"}],"predecessor-version":[{"id":2109,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts\/1734\/revisions\/2109"}],"wp:attachment":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/media?parent=1734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/categories?post=1734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/tags?post=1734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}