{"id":559,"date":"2021-07-13T21:13:10","date_gmt":"2021-07-13T21:13:10","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=559"},"modified":"2021-09-13T05:54:45","modified_gmt":"2021-09-13T05:54:45","slug":"what-is-hive-metastore","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/","title":{"rendered":"What is hive metastore ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"hive-metastore\" class=\"color-green\" style=\"text-align: justify;\">Hive metastore<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li>It stores the metadata for Hive tables,it separates in relational database,the client use to access the information from API(Application Programming Interface).<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"ImageContent\" style=\"text-align: justify;\">\n<div class=\"hddn\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png\" alt=\"what is hive metastore\" width=\"621\" height=\"352\" \/><\/div>\n<\/div>\n<div class=\"TextHeading\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<h2 id=\"how-does-hive-metastore-works\" class=\"color-green\">How does hive metastore works ?<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\">\n<div class=\"hddn\">\n<ul>\n<li style=\"text-align: justify;\">Hive implementations need a metastore, where it stores metadata. It is implemented using tables in a relational database. By default, Hive uses a built-in Derby SQL server.<\/li>\n<li style=\"text-align: justify;\">When we use hive in a cluster, then MySQL or other similar relational database is required.<\/li>\n<li style=\"text-align: justify;\">Now when you run your Hive query and the default Derby database, you will find that your current directory now contains a new sub-directory,\u00a0<b>metastore_db.<\/b>\u00a0Also, the metastore will be created it doesn\u2019t already exist.<\/li>\n<li style=\"text-align: justify;\">By default, the location of the warehouse is\u00a0<b>file:\/\/\/user\/hive\/warehouse<\/b>\u00a0and we can also use the\u00a0<b>hive-site.xml<\/b>\u00a0file for the local or remote metastore.<\/li>\n<li style=\"text-align: justify;\">For changing the configuration we use hive-site.xml to specify Hive where the database is stored.We used a JDBC-compliant database for the metastore because the default database is not suitable for production.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Answer : It stores the metadata for Hive tables,it separates in relational database<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3782],"tags":[195,971,3799,203,199,214,209,205,222,484,3820,3823,621,620,3828,196,3827,3716,712,3821,970,366,208,288,483,976,975,200,974,3824,197,280,364,3822,3825,968,216,2119,969,3826],"class_list":["post-559","post","type-post","status-publish","format-standard","hentry","category-hive","tag-accenture-interview-questions-and-answers","tag-altimetrik-india-pvt-ltd-interview-questions-and-answers","tag-ani-technologies-pvt-ltd-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-genpact-interview-questions-and-answers","tag-hive-metastore","tag-hive-metastore-architecture","tag-hive-query-based-interview-questions","tag-hive-scenario-based-interview-questions","tag-how-to-start-hive-metastore-service","tag-ibm-interview-questions-and-answers","tag-if-you-do-not-configure-the-hive-metastore-what-will-happen","tag-impetus-technologies-interview-questions-and-answers","tag-indiabulls-technology-solutions-ltd-interview-questions-and-answers","tag-metastore","tag-mindtree-interview-questions-and-answers","tag-netapp-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-r-systems-interview-questions-and-answers","tag-reliance-industries-ltd-interview-questions-and-answers","tag-synechron-te-interview-questions-and-answers","tag-tata-consultancy-service-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-trigent-software-interview-questions-and-answers","tag-types-of-metastore-in-hive","tag-unitedhealth-group-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-hive-metastore","tag-what-is-hive-used-as","tag-wipro-infotech-interview-questions-and-answers","tag-wipro-interview-questions-and-answers","tag-yash-technologies-interview-questions-and-answers","tag-yodlee-infotech-pvt-ltd-interview-questions-and-answers","tag-you-should-configure-the-hive-metastore"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is hive metastore ? - Apache Hive Interview Questions<\/title>\n<meta name=\"description\" content=\"What is hive metastore ? - apache hive interview questions - The Hive metastore service stores the metadata for Hive tables\" \/>\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.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is hive metastore ? - Apache Hive Interview Questions\" \/>\n<meta property=\"og:description\" content=\"What is hive metastore ? - apache hive interview questions - The Hive metastore service stores the metadata for Hive tables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-13T21:13:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-13T05:54:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png\" \/>\n<meta name=\"author\" content=\"Editor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Editor\" \/>\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.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is hive metastore ?\",\"datePublished\":\"2021-07-13T21:13:10+00:00\",\"dateModified\":\"2021-09-13T05:54:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/\"},\"wordCount\":175,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore.png\",\"keywords\":[\"Accenture interview questions and answers\",\"Altimetrik India Pvt Ltd interview questions and answers\",\"ANI Technologies Pvt Ltd interview questions and answers\",\"Capgemini interview questions and answers\",\"CASTING NETWORKS INDIA PVT LIMITED interview questions and answers\",\"CGI Group Inc interview questions and answers\",\"Collabera Technologies interview questions and answers\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"Flipkart interview questions and answers\",\"Genpact interview questions and answers\",\"hive metastore\",\"hive metastore architecture\",\"hive query based interview questions\",\"hive scenario based interview questions\",\"how to start hive metastore service\",\"IBM interview questions and answers\",\"if you do not configure the hive metastore what will happen\",\"Impetus Technologies interview questions and answers\",\"Indiabulls Technology Solutions Ltd interview questions and answers\",\"metastore\",\"Mindtree interview questions and answers\",\"NetApp interview questions and answers\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"R Systems interview questions and answers\",\"Reliance Industries Ltd interview questions and answers\",\"Synechron Te interview questions and answers\",\"Tata Consultancy Service interview questions and answers\",\"Tech Mahindra interview questions and answers\",\"Trigent Software interview questions and answers\",\"types of metastore in hive\",\"UnitedHealth Group interview questions and answers\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"what is hive metastore\",\"what is hive used as\",\"Wipro Infotech interview questions and answers\",\"Wipro interview questions and answers\",\"Yash Technologies interview questions and answers\",\"Yodlee Infotech Pvt Ltd interview questions and answers\",\"you should configure the hive metastore\"],\"articleSection\":[\"Hive\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/\",\"name\":\"What is hive metastore ? - Apache Hive Interview Questions\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore.png\",\"datePublished\":\"2021-07-13T21:13:10+00:00\",\"dateModified\":\"2021-09-13T05:54:45+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is hive metastore ? - apache hive interview questions - The Hive metastore service stores the metadata for Hive tables\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore.png\",\"contentUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-hive-metastore.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\",\"name\":\"Editor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"caption\":\"Editor\"},\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/editor\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is hive metastore ? - Apache Hive Interview Questions","description":"What is hive metastore ? - apache hive interview questions - The Hive metastore service stores the metadata for Hive tables","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.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/","og_locale":"en_US","og_type":"article","og_title":"What is hive metastore ? - Apache Hive Interview Questions","og_description":"What is hive metastore ? - apache hive interview questions - The Hive metastore service stores the metadata for Hive tables","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/","og_site_name":"Wikitechy","article_published_time":"2021-07-13T21:13:10+00:00","article_modified_time":"2021-09-13T05:54:45+00:00","og_image":[{"url":"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png","type":"","width":"","height":""}],"author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is hive metastore ?","datePublished":"2021-07-13T21:13:10+00:00","dateModified":"2021-09-13T05:54:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/"},"wordCount":175,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png","keywords":["Accenture interview questions and answers","Altimetrik India Pvt Ltd interview questions and answers","ANI Technologies Pvt Ltd interview questions and answers","Capgemini interview questions and answers","CASTING NETWORKS INDIA PVT LIMITED interview questions and answers","CGI Group Inc interview questions and answers","Collabera Technologies interview questions and answers","Dell International Services India Pvt Ltd interview questions and answers","Flipkart interview questions and answers","Genpact interview questions and answers","hive metastore","hive metastore architecture","hive query based interview questions","hive scenario based interview questions","how to start hive metastore service","IBM interview questions and answers","if you do not configure the hive metastore what will happen","Impetus Technologies interview questions and answers","Indiabulls Technology Solutions Ltd interview questions and answers","metastore","Mindtree interview questions and answers","NetApp interview questions and answers","Prokarma Softech Pvt Ltd interview questions and answers","R Systems interview questions and answers","Reliance Industries Ltd interview questions and answers","Synechron Te interview questions and answers","Tata Consultancy Service interview questions and answers","Tech Mahindra interview questions and answers","Trigent Software interview questions and answers","types of metastore in hive","UnitedHealth Group interview questions and answers","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","what is hive metastore","what is hive used as","Wipro Infotech interview questions and answers","Wipro interview questions and answers","Yash Technologies interview questions and answers","Yodlee Infotech Pvt Ltd interview questions and answers","you should configure the hive metastore"],"articleSection":["Hive"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/","name":"What is hive metastore ? - Apache Hive Interview Questions","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png","datePublished":"2021-07-13T21:13:10+00:00","dateModified":"2021-09-13T05:54:45+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is hive metastore ? - apache hive interview questions - The Hive metastore service stores the metadata for Hive tables","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore\/#primaryimage","url":"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png","contentUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/hive\/what-is-hive-metastore.png"},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757","name":"Editor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","caption":"Editor"},"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=559"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/559\/revisions"}],"predecessor-version":[{"id":3477,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/559\/revisions\/3477"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}