{"id":203,"date":"2021-07-12T08:18:28","date_gmt":"2021-07-12T08:18:28","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=203"},"modified":"2021-09-14T11:25:08","modified_gmt":"2021-09-14T11:25:08","slug":"what-is-the-difference-between-pig-hive-and-hadoop","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/","title":{"rendered":"What is the difference between Pig,Hive and Hadoop ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"difference-between-pighive-and-hadoop\" class=\"color-green\">Difference between Pig,Hive and Hadoop<\/h2>\n<\/div>\n<\/div>\n<table class=\"table-bordered table-striped table table-responsive\">\n<tbody>\n<tr>\n<th>Pig<\/th>\n<th>Hive<\/th>\n<th>Hadoop<\/th>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">Apache Pig is a high-level<br \/>\nplatform for creating programs<br \/>\nit runs on Apache Hadoop.<\/td>\n<td class=\"text-leftalign\">Apache Hive is a data warehouse<br \/>\nsoftware project built on top of<br \/>\nApache Hadoop for providing<br \/>\ndata query, and<br \/>\nanalysis.<\/td>\n<td class=\"text-leftalign\">Open-source software framework for distributed storage and processing dataset of big data using the MapReduce programming model.<\/td>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">Pig Latin extracts the programming<br \/>\nfrom the Java MapReduce phrase<br \/>\ninto a code which creates<br \/>\nMapReduce programming high level.<\/td>\n<td class=\"text-leftalign\">Hive provides the SQL<br \/>\nabstraction to integrate<br \/>\nSQL-like queries (HiveQL).<br \/>\nThe underlying Java without<br \/>\nwe need to implement queries in the<br \/>\nlow-level Java API.<\/td>\n<td class=\"text-leftalign\">The Hadoop Common package for Java ARchive (JAR) files and scripts needed to start Hadoop.<\/td>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">Pig basically has 2 parts:<br \/>\nthe Pig Interpreter and the<br \/>\nlanguage, PigLatin<\/td>\n<td class=\"text-leftalign\">It provides us data warehousing<br \/>\nfacilities on top of an<br \/>\nexisting Hadoop cluster.<\/td>\n<td class=\"text-leftalign\">Hadoop is basically two things:Hadoop Distributed File System (HDFS) +a Computation or Processing framework (MapReduce).<\/td>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">Pig makes our life a lot easier,<br \/>\notherwise writing MapReduce is<br \/>\nalways not easy.<\/td>\n<td class=\"text-leftalign\">User can create tables in Hive and<br \/>\nstore data there. Along with<br \/>\nthat user can even map their<br \/>\nexisting HBase tables to Hive<br \/>\nand operate on them.<\/td>\n<td class=\"text-leftalign\">Hadoop is a distributed, scalable,big data store, modelled after Google\u2019s BigTable.It stores data as key\/value pairs.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Answer:Apache Pig is a high-level,Apache Hive is a data warehouse<br \/>\nsoftware project,Open-source software framework<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[456],"tags":[195,365,509,491,564,203,199,214,209,488,205,485,486,222,484,490,653,654,636,504,196,286,207,487,217,501,477,508,517,518,519,468,503,502,651,638,652,489,493,367,483,492,200,197,280,364,285],"class_list":["post-203","post","type-post","status-publish","format-standard","hentry","category-apache-pig","tag-accenture-interview-questions-and-answers","tag-amazon-development-centre-india-pvt-ltd-interview-questions-and-answers","tag-apache-pig-interview-questions","tag-applied-materials-interview-questions-and-answers","tag-best-apache-pig-interview-questions","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-crisil-limited-interview-questions-and-answers","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-ernst-young-interview-questions-and-answers","tag-exide-industries-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-genpact-interview-questions-and-answers","tag-hexaware-technologies-interview-questions-and-answers","tag-hive-can-be-used-for-real-time-queries","tag-hive-vs-mapreduce-performance","tag-hive-vs-pig-vs-hbase","tag-hive-vs-pig-vs-spark","tag-ibm-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-myntra-designs-pvt-ltd-interview-questions-and-answers","tag-peoplestrong-interview-questions-and-answers","tag-pig-and-hive-tutorial","tag-pig-interview-questions","tag-pig-interview-questions-and-answers","tag-pig-interview-questions-and-answers-for-experienced","tag-pig-interview-questions-for-experienced","tag-pig-interview-questions-for-experienced-and-freshers","tag-pig-practice-questions","tag-pig-vs-hive-comparison","tag-pig-vs-hive-performance","tag-pig-vs-mapreduce","tag-pig-vs-sql","tag-pig-vs-sqlhive-vs-pig-vs-hbase","tag-prokarma-softech-nterview-questions-and-answers","tag-quintiles-interview-questions-and-answers","tag-rbs-india-development-centre-pvt-ltd-interview-questions-and-answers","tag-reliance-industries-ltd-interview-questions-and-answers","tag-syngene-international-limited-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","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-xoriant-solutions-pvt-ltd-interview-questions-and-answers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is the difference between Pig,Hive and Hadoop ? - Apache Pig<\/title>\n<meta name=\"description\" content=\"What is the difference between Pig , Hive and Hadoop ? - apache pig interview questions and answers - Pig hadoop and Hive hadoop have a similar goal\" \/>\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\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the difference between Pig,Hive and Hadoop ? - Apache Pig\" \/>\n<meta property=\"og:description\" content=\"What is the difference between Pig , Hive and Hadoop ? - apache pig interview questions and answers - Pig hadoop and Hive hadoop have a similar goal\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-12T08:18:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-14T11:25:08+00:00\" \/>\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\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is the difference between Pig,Hive and Hadoop ?\",\"datePublished\":\"2021-07-12T08:18:28+00:00\",\"dateModified\":\"2021-09-14T11:25:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/\"},\"wordCount\":228,\"commentCount\":0,\"keywords\":[\"Accenture interview questions and answers\",\"Amazon Development Centre India Pvt Ltd interview questions and answers\",\"apache pig interview questions\",\"Applied Materials interview questions and answers\",\"Best Apache Pig Interview Questions\",\"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\",\"CRISIL LIMITED interview questions and answers\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"Ernst &amp; Young interview questions and answers\",\"Exide Industries interview questions and answers\",\"Flipkart interview questions and answers\",\"Genpact interview questions and answers\",\"Hexaware Technologies interview questions and answers\",\"hive can be used for real time queries\",\"hive vs mapreduce performance\",\"hive vs pig vs hbase\",\"hive vs pig vs spark\",\"IBM interview questions and answers\",\"L&amp;T Infotech interview questions and answers\",\"Mphasis interview questions and answers\",\"Myntra Designs Pvt. Ltd interview questions and answers\",\"PeopleStrong interview questions and answers\",\"pig and hive tutorial\",\"pig interview questions\",\"pig interview questions and answers\",\"pig interview questions and answers for experienced\",\"pig interview questions for experienced\",\"Pig Interview Questions for experienced and freshers\",\"pig practice questions\",\"pig vs hive comparison\",\"pig vs hive performance\",\"pig vs mapreduce\",\"pig vs sql\",\"pig vs sqlhive vs pig vs hbase\",\"Prokarma Softech nterview questions and answers\",\"Quintiles interview questions and answers\",\"RBS India Development Centre Pvt Ltd interview questions and answers\",\"Reliance Industries Ltd interview questions and answers\",\"Syngene International Limited interview questions and answers\",\"Tech Mahindra interview questions and answers\",\"UnitedHealth Group interview questions and answers\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"Xoriant Solutions Pvt Ltd interview questions and answers\"],\"articleSection\":[\"Apache Pig\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/\",\"name\":\"What is the difference between Pig,Hive and Hadoop ? - Apache Pig\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"datePublished\":\"2021-07-12T08:18:28+00:00\",\"dateModified\":\"2021-09-14T11:25:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is the difference between Pig , Hive and Hadoop ? - apache pig interview questions and answers - Pig hadoop and Hive hadoop have a similar goal\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/apache-pig\\\/what-is-the-difference-between-pig-hive-and-hadoop\\\/\"]}]},{\"@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 the difference between Pig,Hive and Hadoop ? - Apache Pig","description":"What is the difference between Pig , Hive and Hadoop ? - apache pig interview questions and answers - Pig hadoop and Hive hadoop have a similar goal","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\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/","og_locale":"en_US","og_type":"article","og_title":"What is the difference between Pig,Hive and Hadoop ? - Apache Pig","og_description":"What is the difference between Pig , Hive and Hadoop ? - apache pig interview questions and answers - Pig hadoop and Hive hadoop have a similar goal","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/","og_site_name":"Wikitechy","article_published_time":"2021-07-12T08:18:28+00:00","article_modified_time":"2021-09-14T11:25:08+00:00","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\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is the difference between Pig,Hive and Hadoop ?","datePublished":"2021-07-12T08:18:28+00:00","dateModified":"2021-09-14T11:25:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/"},"wordCount":228,"commentCount":0,"keywords":["Accenture interview questions and answers","Amazon Development Centre India Pvt Ltd interview questions and answers","apache pig interview questions","Applied Materials interview questions and answers","Best Apache Pig Interview Questions","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","CRISIL LIMITED interview questions and answers","Dell International Services India Pvt Ltd interview questions and answers","Ernst &amp; Young interview questions and answers","Exide Industries interview questions and answers","Flipkart interview questions and answers","Genpact interview questions and answers","Hexaware Technologies interview questions and answers","hive can be used for real time queries","hive vs mapreduce performance","hive vs pig vs hbase","hive vs pig vs spark","IBM interview questions and answers","L&amp;T Infotech interview questions and answers","Mphasis interview questions and answers","Myntra Designs Pvt. Ltd interview questions and answers","PeopleStrong interview questions and answers","pig and hive tutorial","pig interview questions","pig interview questions and answers","pig interview questions and answers for experienced","pig interview questions for experienced","Pig Interview Questions for experienced and freshers","pig practice questions","pig vs hive comparison","pig vs hive performance","pig vs mapreduce","pig vs sql","pig vs sqlhive vs pig vs hbase","Prokarma Softech nterview questions and answers","Quintiles interview questions and answers","RBS India Development Centre Pvt Ltd interview questions and answers","Reliance Industries Ltd interview questions and answers","Syngene International Limited interview questions and answers","Tech Mahindra interview questions and answers","UnitedHealth Group interview questions and answers","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","Xoriant Solutions Pvt Ltd interview questions and answers"],"articleSection":["Apache Pig"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/","name":"What is the difference between Pig,Hive and Hadoop ? - Apache Pig","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"datePublished":"2021-07-12T08:18:28+00:00","dateModified":"2021-09-14T11:25:08+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is the difference between Pig , Hive and Hadoop ? - apache pig interview questions and answers - Pig hadoop and Hive hadoop have a similar goal","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/apache-pig\/what-is-the-difference-between-pig-hive-and-hadoop\/"]}]},{"@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\/203","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=203"}],"version-history":[{"count":2,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"predecessor-version":[{"id":3747,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/203\/revisions\/3747"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}