{"id":584,"date":"2021-07-13T21:51:40","date_gmt":"2021-07-13T21:51:40","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=584"},"modified":"2021-09-13T04:38:19","modified_gmt":"2021-09-13T04:38:19","slug":"what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/","title":{"rendered":"What is the difference between a normal hive table and hive table stored as ORC ?"},"content":{"rendered":"

Difference between a normal hive table and hive table stored as ORC<\/h2>\n\n\n\n\n\n\n\n\n\n
Normal hive table<\/th>\nHive table stored as orc<\/th>\n<\/tr>\n
Hive data is organized into Databases:
\nNamespaces function to avoid naming conflicts for tables,
\nviews, partitions, columns, and so on.<\/td>\n		It produce efficient way to store Hive data.It designed to overcome the drawback of others Hive file formats Using Optimized Row Columnar files improves speed when Hive is reading, writing, and processing data.<\/td>\n<\/tr>\n
Databases can also be used to enforce security for a
\nuser or group of users.<\/td>\n		Advantages- Single file as the output of each task, that reduces the NameNode\u2019s load.<\/td>\n<\/tr>\n
There are two types of tables in Hive,
\none is Managed table and second is external table.
\nThe difference is, when you drop a table,
\nif it is managed table hive deletes both data and meta data,
\nif it is external table Hive
\nonly deletes metadata.<\/td>\n		An Optimized Row Columnar file contains types of data define as stripes,along with information in a file footer. At the end of the file a postscript holds compression parameters and the size of the compressed footer.<\/td>\n<\/tr>\n
It damage how data is loaded,
\ncontrolled, and managed in Hive ;By use external
\ntables when the data is also used outside of Hive.<\/td>\n		Default stripe size is 250 MB. large stripe sizes enable large, efficient reads from HDFS.<\/td>\n<\/tr>\n
The data files are read and processed by an existing
\nprogram that doesn\u2019t lock the files. Data needs to
\nremain in the underlying location even after a DROP<\/td>\n		File footer having a list of stripes and number of rows,each columns contains count, min, max, and sum.<\/td>\n<\/tr>\n
Storing data in Hive is nothing but
\nstoring data in HDFS (Hadoop).<\/td>\n		The stripe file footer contains a directory of stream locations.Row data is used in table scans<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Answer : Hive data is organized into Databases….<\/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,3954,222,484,3959,3952,3953,3794,621,620,196,3716,712,3956,970,366,208,288,3955,483,976,975,200,3958,974,197,280,364,968,216,2119,969],"class_list":["post-584","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-different-file-formats-in-hive","tag-flipkart-interview-questions-and-answers","tag-genpact-interview-questions-and-answers","tag-hive-advanced-interview-questions","tag-hive-columnar-storage","tag-hive-file-format-comparison","tag-hive-interview-questions-and-answers-for-experienced","tag-hive-query-based-interview-questions","tag-hive-scenario-based-interview-questions","tag-ibm-interview-questions-and-answers","tag-impetus-technologies-interview-questions-and-answers","tag-indiabulls-technology-solutions-ltd-interview-questions-and-answers","tag-managed-table-vs-external-table-in-hive","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-rc-file-format-in-hive","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-text-file-format-in-hive","tag-trigent-software-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-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"],"yoast_head":"\nDifference between a normal hive table and hive table stored as ORC<\/title>\n<meta name=\"description\" content=\"What is the difference between a normal hive table and hive table stored as ORC ? - hive interview questions and answers - Hive data is organized into: Databases.\" \/>\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-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference between a normal hive table and hive table stored as ORC\" \/>\n<meta property=\"og:description\" content=\"What is the difference between a normal hive table and hive table stored as ORC ? - hive interview questions and answers - Hive data is organized into: Databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-13T21:51:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-13T04:38:19+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=\"2 minutes\" \/>\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-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is the difference between a normal hive table and hive table stored as ORC ?\",\"datePublished\":\"2021-07-13T21:51:40+00:00\",\"dateModified\":\"2021-09-13T04:38:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/\"},\"wordCount\":317,\"commentCount\":0,\"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\",\"different file formats in hive\",\"Flipkart interview questions and answers\",\"Genpact interview questions and answers\",\"hive advanced interview questions\",\"hive columnar storage\",\"hive file format comparison\",\"hive interview questions and answers for experienced\",\"hive query based interview questions\",\"hive scenario based interview questions\",\"IBM interview questions and answers\",\"Impetus Technologies interview questions and answers\",\"Indiabulls Technology Solutions Ltd interview questions and answers\",\"managed table vs external table in hive\",\"Mindtree interview questions and answers\",\"NetApp interview questions and answers\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"R Systems interview questions and answers\",\"rc file format in hive\",\"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\",\"text file format in hive\",\"Trigent Software 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\",\"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\"],\"articleSection\":[\"Hive\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/\",\"name\":\"Difference between a normal hive table and hive table stored as ORC\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"datePublished\":\"2021-07-13T21:51:40+00:00\",\"dateModified\":\"2021-09-13T04:38:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is the difference between a normal hive table and hive table stored as ORC ? - hive interview questions and answers - Hive data is organized into: Databases.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/hive\\\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\\\/\"]}]},{\"@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":"Difference between a normal hive table and hive table stored as ORC","description":"What is the difference between a normal hive table and hive table stored as ORC ? - hive interview questions and answers - Hive data is organized into: Databases.","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-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/","og_locale":"en_US","og_type":"article","og_title":"Difference between a normal hive table and hive table stored as ORC","og_description":"What is the difference between a normal hive table and hive table stored as ORC ? - hive interview questions and answers - Hive data is organized into: Databases.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/","og_site_name":"Wikitechy","article_published_time":"2021-07-13T21:51:40+00:00","article_modified_time":"2021-09-13T04:38:19+00:00","author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is the difference between a normal hive table and hive table stored as ORC ?","datePublished":"2021-07-13T21:51:40+00:00","dateModified":"2021-09-13T04:38:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/"},"wordCount":317,"commentCount":0,"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","different file formats in hive","Flipkart interview questions and answers","Genpact interview questions and answers","hive advanced interview questions","hive columnar storage","hive file format comparison","hive interview questions and answers for experienced","hive query based interview questions","hive scenario based interview questions","IBM interview questions and answers","Impetus Technologies interview questions and answers","Indiabulls Technology Solutions Ltd interview questions and answers","managed table vs external table in hive","Mindtree interview questions and answers","NetApp interview questions and answers","Prokarma Softech Pvt Ltd interview questions and answers","R Systems interview questions and answers","rc file format in hive","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","text file format in hive","Trigent Software 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","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"],"articleSection":["Hive"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/","name":"Difference between a normal hive table and hive table stored as ORC","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"datePublished":"2021-07-13T21:51:40+00:00","dateModified":"2021-09-13T04:38:19+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is the difference between a normal hive table and hive table stored as ORC ? - hive interview questions and answers - Hive data is organized into: Databases.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/hive\/what-is-the-difference-between-a-normal-hive-table-and-hive-table-stored-as-orc\/"]}]},{"@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\/584","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=584"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/584\/revisions"}],"predecessor-version":[{"id":595,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/584\/revisions\/595"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}