CINXE.COM

<!DOCTYPE html> <html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-toc-available" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Apache Hive - Wikipedia</title> <script>(function(){var className="client-js vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )enwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy", "wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"f361cd2e-6e23-450b-9ffc-d2b17ade431d","wgCanonicalNamespace":"","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":0,"wgPageName":"Apache_Hive","wgTitle":"Apache Hive","wgCurRevisionId":1232204991,"wgRevisionId":1232204991,"wgArticleId":30248516,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["CS1 maint: multiple names: authors list","Articles with short description","Short description matches Wikidata","Articles with a promotional tone from October 2019","All articles with a promotional tone","Articles needing additional references from May 2023","All articles needing additional references","Articles with multiple maintenance issues","Articles needing cleanup from October 2016","All pages needing cleanup", "Articles with sections that need to be turned into prose from October 2016","2015 software","Apache Software Foundation projects","Cloud computing","Facebook software","Free software programmed in Java (programming language)","Free system software","Hadoop","Software using the Apache license"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Apache_Hive","wgRelevantArticleId":30248516,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"wikipedia","wgCiteReferencePreviewsActive":false,"wgFlaggedRevsParams":{"tags":{"status":{"levels":1}}},"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgPopupsFlags":0,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample": false,"wgWMEPageLength":20000,"wgRelatedArticlesCompat":[],"wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"interlanguage","wgULSisCompactLinksEnabled":false,"wgVector2022LanguageInHeader":true,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q4778914","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"],"GEHomepageSuggestedEditsEnableTopics":true,"wgGETopicsMatchModeEnabled":false,"wgGEStructuredTaskRejectionReasonTextInputEnabled":false,"wgGELevelingUpEnabledForUser":false};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.cite.styles":"ready","ext.pygments":"ready","skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","jquery.makeCollapsible.styles":"ready","ext.wikimediamessages.styles": "ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.interlanguage":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["ext.cite.ux-enhancements","ext.pygments.view","site","mediawiki.page.ready","jquery.makeCollapsible","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.gadget.ReferenceTooltips","ext.gadget.switcher","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.popups","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.interface","ext.cx.eventlogging.campaigns","ext.cx.uls.quick.actions","wikibase.client.vector-2022","ext.checkUser.clientHints","ext.growthExperiments.SuggestedEditSession","wikibase.sidebar.tracking"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.cite.styles%7Cext.pygments%2CwikimediaBadges%7Cext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediamessages.styles%7Cjquery.makeCollapsible.styles%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.4"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta property="og:image" content="https://upload.wikimedia.org/wikipedia/commons/thumb/b/bb/Apache_Hive_logo.svg/1200px-Apache_Hive_logo.svg.png"> <meta property="og:image:width" content="1200"> <meta property="og:image:height" content="1080"> <meta property="og:image" content="https://upload.wikimedia.org/wikipedia/commons/thumb/b/bb/Apache_Hive_logo.svg/800px-Apache_Hive_logo.svg.png"> <meta property="og:image:width" content="800"> <meta property="og:image:height" content="720"> <meta property="og:image" content="https://upload.wikimedia.org/wikipedia/commons/thumb/b/bb/Apache_Hive_logo.svg/640px-Apache_Hive_logo.svg.png"> <meta property="og:image:width" content="640"> <meta property="og:image:height" content="576"> <meta name="viewport" content="width=1120"> <meta property="og:title" content="Apache Hive - Wikipedia"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//en.m.wikipedia.org/wiki/Apache_Hive"> <link rel="alternate" type="application/x-wiki" title="Edit this page" href="/w/index.php?title=Apache_Hive&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/wikipedia.png"> <link rel="icon" href="/static/favicon/wikipedia.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikipedia (en)"> <link rel="EditURI" type="application/rsd+xml" href="//en.wikipedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://en.wikipedia.org/wiki/Apache_Hive"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en"> <link rel="alternate" type="application/atom+xml" title="Wikipedia Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="//login.wikimedia.org"> </head> <body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject mw-editable page-Apache_Hive rootpage-Apache_Hive skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Jump to content</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right" > <input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Main menu" > <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Main menu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container" > <div class="vector-pinnable-header-label">Main menu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">hide</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Navigation </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Main_Page" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-contents" class="mw-list-item"><a href="/wiki/Wikipedia:Contents" title="Guides to browsing Wikipedia"><span>Contents</span></a></li><li id="n-currentevents" class="mw-list-item"><a href="/wiki/Portal:Current_events" title="Articles related to current events"><span>Current events</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Special:Random" title="Visit a randomly selected article [x]" accesskey="x"><span>Random article</span></a></li><li id="n-aboutsite" class="mw-list-item"><a href="/wiki/Wikipedia:About" title="Learn about Wikipedia and how it works"><span>About Wikipedia</span></a></li><li id="n-contactpage" class="mw-list-item"><a href="//en.wikipedia.org/wiki/Wikipedia:Contact_us" title="How to contact Wikipedia"><span>Contact us</span></a></li> </ul> </div> </div> <div id="p-interaction" class="vector-menu mw-portlet mw-portlet-interaction" > <div class="vector-menu-heading"> Contribute </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-help" class="mw-list-item"><a href="/wiki/Help:Contents" title="Guidance on how to use and edit Wikipedia"><span>Help</span></a></li><li id="n-introduction" class="mw-list-item"><a href="/wiki/Help:Introduction" title="Learn how to edit Wikipedia"><span>Learn to edit</span></a></li><li id="n-portal" class="mw-list-item"><a href="/wiki/Wikipedia:Community_portal" title="The hub for editors"><span>Community portal</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes to Wikipedia [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-upload" class="mw-list-item"><a href="/wiki/Wikipedia:File_upload_wizard" title="Add images or other media for use on Wikipedia"><span>Upload file</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/Main_Page" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/wikipedia.png" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="Wikipedia" src="/static/images/mobile/copyright/wikipedia-wordmark-en.svg" style="width: 7.5em; height: 1.125em;"> <img class="mw-logo-tagline" alt="The Free Encyclopedia" src="/static/images/mobile/copyright/wikipedia-tagline-en.svg" width="117" height="13" style="width: 7.3125em; height: 0.8125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/wiki/Special:Search" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Search Wikipedia [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Search</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Search Wikipedia" aria-label="Search Wikipedia" autocapitalize="sentences" title="Search Wikipedia [f]" accesskey="f" id="searchInput" > <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Special:Search"> </div> <button class="cdx-button cdx-search-input__end-button">Search</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Personal tools"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="Change the appearance of the page's font size, width, and color" > <input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Appearance" > <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Appearance</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_en.wikipedia.org&uselang=en" class=""><span>Donate</span></a> </li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:CreateAccount&returnto=Apache+Hive" title="You are encouraged to create an account and log in; however, it is not mandatory" class=""><span>Create account</span></a> </li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:UserLogin&returnto=Apache+Hive" title="You're encouraged to log in; however, it's not mandatory. [o]" accesskey="o" class=""><span>Log in</span></a> </li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="Log in and more options" > <input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Personal tools" > <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Personal tools</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="User menu" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_en.wikipedia.org&uselang=en"><span>Donate</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Apache+Hive" title="You are encouraged to create an account and log in; however, it is not mandatory"><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Create account</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Apache+Hive" title="You're encouraged to log in; however, it's not mandatory. [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Log in</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor" > <div class="vector-menu-heading"> Pages for logged out editors <a href="/wiki/Help:Introduction" aria-label="Learn more about editing"><span>learn more</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice"></div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Contents" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc" > <h2 class="vector-pinnable-header-label">Contents</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">hide</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"> <a href="#" class="vector-toc-link"> <div class="vector-toc-text">(Top)</div> </a> </li> <li id="toc-Features" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Features"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Features</span> </div> </a> <ul id="toc-Features-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Architecture" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Architecture"> <div class="vector-toc-text"> <span class="vector-toc-numb">2</span> <span>Architecture</span> </div> </a> <ul id="toc-Architecture-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-HiveQL" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#HiveQL"> <div class="vector-toc-text"> <span class="vector-toc-numb">3</span> <span>HiveQL</span> </div> </a> <button aria-controls="toc-HiveQL-sublist" class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-toc-toggle"> <span class="vector-icon mw-ui-icon-wikimedia-expand"></span> <span>Toggle HiveQL subsection</span> </button> <ul id="toc-HiveQL-sublist" class="vector-toc-list"> <li id="toc-Example" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#Example"> <div class="vector-toc-text"> <span class="vector-toc-numb">3.1</span> <span>Example</span> </div> </a> <ul id="toc-Example-sublist" class="vector-toc-list"> </ul> </li> </ul> </li> <li id="toc-Comparison_with_traditional_databases" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Comparison_with_traditional_databases"> <div class="vector-toc-text"> <span class="vector-toc-numb">4</span> <span>Comparison with traditional databases</span> </div> </a> <ul id="toc-Comparison_with_traditional_databases-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Security" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Security"> <div class="vector-toc-text"> <span class="vector-toc-numb">5</span> <span>Security</span> </div> </a> <ul id="toc-Security-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-See_also" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#See_also"> <div class="vector-toc-text"> <span class="vector-toc-numb">6</span> <span>See also</span> </div> </a> <ul id="toc-See_also-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-References" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#References"> <div class="vector-toc-text"> <span class="vector-toc-numb">7</span> <span>References</span> </div> </a> <ul id="toc-References-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-External_links" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#External_links"> <div class="vector-toc-text"> <span class="vector-toc-numb">8</span> <span>External links</span> </div> </a> <ul id="toc-External_links-sublist" class="vector-toc-list"> </ul> </li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Contents" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left" > <input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Toggle the table of contents" > <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Toggle the table of contents</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-main">Apache Hive</span></h1> <div id="p-lang-btn" class="vector-dropdown mw-portlet mw-portlet-lang" > <input type="checkbox" id="p-lang-btn-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-lang-btn" class="vector-dropdown-checkbox mw-interlanguage-selector" aria-label="Go to an article in another language. Available in 11 languages" > <label id="p-lang-btn-label" for="p-lang-btn-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--action-progressive mw-portlet-lang-heading-11" aria-hidden="true" ><span class="vector-icon mw-ui-icon-language-progressive mw-ui-icon-wikimedia-language-progressive"></span> <span class="vector-dropdown-label-text">11 languages</span> </label> <div class="vector-dropdown-content"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-az mw-list-item"><a href="https://az.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Azerbaijani" lang="az" hreflang="az" data-title="Apache Hive" data-language-autonym="Azərbaycanca" data-language-local-name="Azerbaijani" class="interlanguage-link-target"><span>Azərbaycanca</span></a></li><li class="interlanguage-link interwiki-ca mw-list-item"><a href="https://ca.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Catalan" lang="ca" hreflang="ca" data-title="Apache Hive" data-language-autonym="Català" data-language-local-name="Catalan" class="interlanguage-link-target"><span>Català</span></a></li><li class="interlanguage-link interwiki-es mw-list-item"><a href="https://es.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Spanish" lang="es" hreflang="es" data-title="Apache Hive" data-language-autonym="Español" data-language-local-name="Spanish" class="interlanguage-link-target"><span>Español</span></a></li><li class="interlanguage-link interwiki-fr mw-list-item"><a href="https://fr.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – French" lang="fr" hreflang="fr" data-title="Apache Hive" data-language-autonym="Français" data-language-local-name="French" class="interlanguage-link-target"><span>Français</span></a></li><li class="interlanguage-link interwiki-ko mw-list-item"><a href="https://ko.wikipedia.org/wiki/%EC%95%84%ED%8C%8C%EC%B9%98_%ED%95%98%EC%9D%B4%EB%B8%8C" title="아파치 하이브 – Korean" lang="ko" hreflang="ko" data-title="아파치 하이브" data-language-autonym="한국어" data-language-local-name="Korean" class="interlanguage-link-target"><span>한국어</span></a></li><li class="interlanguage-link interwiki-it mw-list-item"><a href="https://it.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Italian" lang="it" hreflang="it" data-title="Apache Hive" data-language-autonym="Italiano" data-language-local-name="Italian" class="interlanguage-link-target"><span>Italiano</span></a></li><li class="interlanguage-link interwiki-he mw-list-item"><a href="https://he.wikipedia.org/wiki/%D7%90%D7%A4%D7%90%D7%A6%27%D7%99_%D7%94%D7%99%D7%99%D7%91" title="אפאצ'י הייב – Hebrew" lang="he" hreflang="he" data-title="אפאצ'י הייב" data-language-autonym="עברית" data-language-local-name="Hebrew" class="interlanguage-link-target"><span>עברית</span></a></li><li class="interlanguage-link interwiki-ja mw-list-item"><a href="https://ja.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Japanese" lang="ja" hreflang="ja" data-title="Apache Hive" data-language-autonym="日本語" data-language-local-name="Japanese" class="interlanguage-link-target"><span>日本語</span></a></li><li class="interlanguage-link interwiki-pt mw-list-item"><a href="https://pt.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Portuguese" lang="pt" hreflang="pt" data-title="Apache Hive" data-language-autonym="Português" data-language-local-name="Portuguese" class="interlanguage-link-target"><span>Português</span></a></li><li class="interlanguage-link interwiki-ru mw-list-item"><a href="https://ru.wikipedia.org/wiki/Hive" title="Hive – Russian" lang="ru" hreflang="ru" data-title="Hive" data-language-autonym="Русский" data-language-local-name="Russian" class="interlanguage-link-target"><span>Русский</span></a></li><li class="interlanguage-link interwiki-zh mw-list-item"><a href="https://zh.wikipedia.org/wiki/Apache_Hive" title="Apache Hive – Chinese" lang="zh" hreflang="zh" data-title="Apache Hive" data-language-autonym="中文" data-language-local-name="Chinese" class="interlanguage-link-target"><span>中文</span></a></li> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-edit wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q4778914#sitelinks-wikipedia" title="Edit interlanguage links" class="wbc-editpage">Edit links</a></span></div> </div> </div> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Namespaces"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-main" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Apache_Hive" title="View the content page [c]" accesskey="c"><span>Article</span></a></li><li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="/wiki/Talk:Apache_Hive" rel="discussion" title="Discuss improvements to the content page [t]" accesskey="t"><span>Talk</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet" > <input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Change language variant" > <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">English</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Views"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Apache_Hive"><span>Read</span></a></li><li id="ca-edit" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Apache_Hive&action=edit" title="Edit this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Apache_Hive&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown" > <input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Tools" > <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Tools</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container" > <div class="vector-pinnable-header-label">Tools</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">hide</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="More options" > <div class="vector-menu-heading"> Actions </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/wiki/Apache_Hive"><span>Read</span></a></li><li id="ca-more-edit" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Apache_Hive&action=edit" title="Edit this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Apache_Hive&action=history"><span>View history</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> General </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/Apache_Hive" title="List of all English Wikipedia pages containing links to this page [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Apache_Hive" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-upload" class="mw-list-item"><a href="/wiki/Wikipedia:File_Upload_Wizard" title="Upload files [u]" accesskey="u"><span>Upload file</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Apache_Hive&oldid=1232204991" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Apache_Hive&action=info" title="More information about this page"><span>Page information</span></a></li><li id="t-cite" class="mw-list-item"><a href="/w/index.php?title=Special:CiteThisPage&page=Apache_Hive&id=1232204991&wpFormIdentifier=titleform" title="Information on how to cite this page"><span>Cite this page</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FApache_Hive"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrCode&url=https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FApache_Hive"><span>Download QR code</span></a></li> </ul> </div> </div> <div id="p-coll-print_export" class="vector-menu mw-portlet mw-portlet-coll-print_export" > <div class="vector-menu-heading"> Print/export </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Apache_Hive&action=show-download-screen" title="Download this page as a PDF file"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Apache_Hive&printable=yes" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects" > <div class="vector-menu-heading"> In other projects </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="wb-otherproject-link wb-otherproject-commons mw-list-item"><a href="https://commons.wikimedia.org/wiki/Category:Apache_Hive" hreflang="en"><span>Wikimedia Commons</span></a></li><li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q4778914" title="Structured data on this page hosted by Wikidata [g]" accesskey="g"><span>Wikidata item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container" > <div class="vector-pinnable-header-label">Appearance</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">hide</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div class="mw-indicators"> </div> <div id="siteSub" class="noprint">From Wikipedia, the free encyclopedia</div> </div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="mw-content-text" class="mw-body-content"><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><div class="shortdescription nomobile noexcerpt noprint searchaux" style="display:none">Database engine</div> <style data-mw-deduplicate="TemplateStyles:r1251242444">.mw-parser-output .ambox{border:1px solid #a2a9b1;border-left:10px solid #36c;background-color:#fbfbfb;box-sizing:border-box}.mw-parser-output .ambox+link+.ambox,.mw-parser-output .ambox+link+style+.ambox,.mw-parser-output .ambox+link+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+style+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+link+.ambox{margin-top:-1px}html body.mediawiki .mw-parser-output .ambox.mbox-small-left{margin:4px 1em 4px 0;overflow:hidden;width:238px;border-collapse:collapse;font-size:88%;line-height:1.25em}.mw-parser-output .ambox-speedy{border-left:10px solid #b32424;background-color:#fee7e6}.mw-parser-output .ambox-delete{border-left:10px solid #b32424}.mw-parser-output .ambox-content{border-left:10px solid #f28500}.mw-parser-output .ambox-style{border-left:10px solid #fc3}.mw-parser-output .ambox-move{border-left:10px solid #9932cc}.mw-parser-output .ambox-protection{border-left:10px solid #a2a9b1}.mw-parser-output .ambox .mbox-text{border:none;padding:0.25em 0.5em;width:100%}.mw-parser-output .ambox .mbox-image{border:none;padding:2px 0 2px 0.5em;text-align:center}.mw-parser-output .ambox .mbox-imageright{border:none;padding:2px 0.5em 2px 0;text-align:center}.mw-parser-output .ambox .mbox-empty-cell{border:none;padding:0;width:1px}.mw-parser-output .ambox .mbox-image-div{width:52px}@media(min-width:720px){.mw-parser-output .ambox{margin:0 10%}}@media print{body.ns-0 .mw-parser-output .ambox{display:none!important}}</style><style data-mw-deduplicate="TemplateStyles:r1248332772">.mw-parser-output .multiple-issues-text{width:95%;margin:0.2em 0}.mw-parser-output .multiple-issues-text>.mw-collapsible-content{margin-top:0.3em}.mw-parser-output .compact-ambox .ambox{border:none;border-collapse:collapse;background-color:transparent;margin:0 0 0 1.6em!important;padding:0!important;width:auto;display:block}body.mediawiki .mw-parser-output .compact-ambox .ambox.mbox-small-left{font-size:100%;width:auto;margin:0}.mw-parser-output .compact-ambox .ambox .mbox-text{padding:0!important;margin:0!important}.mw-parser-output .compact-ambox .ambox .mbox-text-span{display:list-item;line-height:1.5em;list-style-type:disc}body.skin-minerva .mw-parser-output .multiple-issues-text>.mw-collapsible-toggle,.mw-parser-output .compact-ambox .ambox .mbox-image,.mw-parser-output .compact-ambox .ambox .mbox-imageright,.mw-parser-output .compact-ambox .ambox .mbox-empty-cell,.mw-parser-output .compact-ambox .hide-when-compact{display:none}</style><table class="box-Multiple_issues plainlinks metadata ambox ambox-content ambox-multiple_issues compact-ambox" role="presentation"><tbody><tr><td class="mbox-image"><div class="mbox-image-div"><span typeof="mw:File"><span><img alt="" src="//upload.wikimedia.org/wikipedia/en/thumb/b/b4/Ambox_important.svg/40px-Ambox_important.svg.png" decoding="async" width="40" height="40" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/b/b4/Ambox_important.svg/60px-Ambox_important.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/b/b4/Ambox_important.svg/80px-Ambox_important.svg.png 2x" data-file-width="40" data-file-height="40" /></span></span></div></td><td class="mbox-text"><div class="mbox-text-span"><div class="multiple-issues-text mw-collapsible"><b>This article has multiple issues.</b> Please help <b><a href="/wiki/Special:EditPage/Apache_Hive" title="Special:EditPage/Apache Hive">improve it</a></b> or discuss these issues on the <b><a href="/wiki/Talk:Apache_Hive" title="Talk:Apache Hive">talk page</a></b>. <small><i>(<a href="/wiki/Help:Maintenance_template_removal" title="Help:Maintenance template removal">Learn how and when to remove these messages</a>)</i></small> <div class="mw-collapsible-content"> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1251242444"><table class="box-Promotional plainlinks metadata ambox ambox-content ambox-Advert" role="presentation"><tbody><tr><td class="mbox-image"><div class="mbox-image-div"><span typeof="mw:File"><span><img alt="" src="//upload.wikimedia.org/wikipedia/en/thumb/b/b4/Ambox_important.svg/40px-Ambox_important.svg.png" decoding="async" width="40" height="40" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/b/b4/Ambox_important.svg/60px-Ambox_important.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/b/b4/Ambox_important.svg/80px-Ambox_important.svg.png 2x" data-file-width="40" data-file-height="40" /></span></span></div></td><td class="mbox-text"><div class="mbox-text-span">This article <b>contains <a href="/wiki/Wikipedia:What_Wikipedia_is_not#Wikipedia_is_not_a_soapbox_or_means_of_promotion" title="Wikipedia:What Wikipedia is not">promotional content</a></b>.<span class="hide-when-compact"> Please help <a class="external text" href="https://en.wikipedia.org/w/index.php?title=Apache_Hive&action=edit">improve it</a> by removing <a href="/wiki/Wikipedia:Spam" title="Wikipedia:Spam">promotional language</a> and inappropriate <a href="/wiki/Wikipedia:External_links#Advertising_and_conflicts_of_interest" title="Wikipedia:External links">external links</a>, and by adding encyclopedic text written from a <a href="/wiki/Wikipedia:Neutral_point_of_view" title="Wikipedia:Neutral point of view">neutral point of view</a>.</span> <span class="date-container"><i>(<span class="date">October 2019</span>)</i></span><span class="hide-when-compact"><i> (<small><a href="/wiki/Help:Maintenance_template_removal" title="Help:Maintenance template removal">Learn how and when to remove this message</a></small>)</i></span></div></td></tr></tbody></table> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1251242444"><table class="box-More_citations_needed plainlinks metadata ambox ambox-content ambox-Refimprove" role="presentation"><tbody><tr><td class="mbox-image"><div class="mbox-image-div"><span typeof="mw:File"><a href="/wiki/File:Question_book-new.svg" class="mw-file-description"><img alt="" src="//upload.wikimedia.org/wikipedia/en/thumb/9/99/Question_book-new.svg/50px-Question_book-new.svg.png" decoding="async" width="50" height="39" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/9/99/Question_book-new.svg/75px-Question_book-new.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/9/99/Question_book-new.svg/100px-Question_book-new.svg.png 2x" data-file-width="512" data-file-height="399" /></a></span></div></td><td class="mbox-text"><div class="mbox-text-span">This article <b>needs additional citations for <a href="/wiki/Wikipedia:Verifiability" title="Wikipedia:Verifiability">verification</a></b>.<span class="hide-when-compact"> Please help <a href="/wiki/Special:EditPage/Apache_Hive" title="Special:EditPage/Apache Hive">improve this article</a> by <a href="/wiki/Help:Referencing_for_beginners" title="Help:Referencing for beginners">adding citations to reliable sources</a>. Unsourced material may be challenged and removed.<br /><small><span class="plainlinks"><i>Find sources:</i> <a rel="nofollow" class="external text" href="https://www.google.com/search?as_eq=wikipedia&q=%22Apache+Hive%22">"Apache Hive"</a> – <a rel="nofollow" class="external text" href="https://www.google.com/search?tbm=nws&q=%22Apache+Hive%22+-wikipedia&tbs=ar:1">news</a> <b>·</b> <a rel="nofollow" class="external text" href="https://www.google.com/search?&q=%22Apache+Hive%22&tbs=bkt:s&tbm=bks">newspapers</a> <b>·</b> <a rel="nofollow" class="external text" href="https://www.google.com/search?tbs=bks:1&q=%22Apache+Hive%22+-wikipedia">books</a> <b>·</b> <a rel="nofollow" class="external text" href="https://scholar.google.com/scholar?q=%22Apache+Hive%22">scholar</a> <b>·</b> <a rel="nofollow" class="external text" href="https://www.jstor.org/action/doBasicSearch?Query=%22Apache+Hive%22&acc=on&wc=on">JSTOR</a></span></small></span> <span class="date-container"><i>(<span class="date">May 2023</span>)</i></span><span class="hide-when-compact"><i> (<small><a href="/wiki/Help:Maintenance_template_removal" title="Help:Maintenance template removal">Learn how and when to remove this message</a></small>)</i></span></div></td></tr></tbody></table> </div> </div><span class="hide-when-compact"><i> (<small><a href="/wiki/Help:Maintenance_template_removal" title="Help:Maintenance template removal">Learn how and when to remove this message</a></small>)</i></span></div></td></tr></tbody></table> <style data-mw-deduplicate="TemplateStyles:r1257001546">.mw-parser-output .infobox-subbox{padding:0;border:none;margin:-3px;width:auto;min-width:100%;font-size:100%;clear:none;float:none;background-color:transparent}.mw-parser-output .infobox-3cols-child{margin:auto}.mw-parser-output .infobox .navbar{font-size:100%}@media screen{html.skin-theme-clientpref-night .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .infobox-full-data:not(.notheme) div:not(.notheme){background:#1f1f23!important;color:#f8f9fa}}@media(min-width:640px){body.skin--responsive .mw-parser-output .infobox-table{display:table!important}body.skin--responsive .mw-parser-output .infobox-table>caption{display:table-caption!important}body.skin--responsive .mw-parser-output .infobox-table>tbody{display:table-row-group}body.skin--responsive .mw-parser-output .infobox-table tr{display:table-row!important}body.skin--responsive .mw-parser-output .infobox-table th,body.skin--responsive .mw-parser-output .infobox-table td{padding-left:inherit;padding-right:inherit}}</style><table class="infobox vevent"><caption class="infobox-title summary">Apache Hive</caption><tbody><tr><td colspan="2" class="infobox-image logo"><span typeof="mw:File"><a href="/wiki/File:Apache_Hive_logo.svg" class="mw-file-description" title="Apache Hive"><img alt="Apache Hive" src="//upload.wikimedia.org/wikipedia/commons/thumb/b/bb/Apache_Hive_logo.svg/150px-Apache_Hive_logo.svg.png" decoding="async" width="150" height="135" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/b/bb/Apache_Hive_logo.svg/225px-Apache_Hive_logo.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/b/bb/Apache_Hive_logo.svg/300px-Apache_Hive_logo.svg.png 2x" data-file-width="1000" data-file-height="900" /></a></span></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Programmer" title="Programmer">Original author(s)</a></th><td class="infobox-data"><a href="/wiki/Facebook,_Inc." class="mw-redirect" title="Facebook, Inc.">Facebook, Inc.</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Programmer" title="Programmer">Developer(s)</a></th><td class="infobox-data"><a rel="nofollow" class="external text" href="https://hive.apache.org/people.html">Contributors</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Initial release</th><td class="infobox-data">October 1, 2010<span class="noprint">; 14 years ago</span><span style="display:none"> (<span class="bday dtstart published updated">2010-10-01</span>)</span><sup id="cite_ref-1" class="reference"><a href="#cite_note-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup></td></tr><tr style="display: none;"><td colspan="2" class="infobox-full-data"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1257001546"></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Software_release_life_cycle" title="Software release life cycle">Stable release</a></th><td class="infobox-data"><div style="margin:0px;">3.1.3 / April 8, 2022<span class="noprint">; 2 years ago</span><span style="display:none"> (<span class="bday dtstart published updated">2022-04-08</span>)</span><sup id="cite_ref-releases_2-0" class="reference"><a href="#cite_note-releases-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup></div></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Software_release_life_cycle#Beta" title="Software release life cycle">Preview release</a></th><td class="infobox-data"><div style="margin:0px;">4.0.0-beta-1 / August 14, 2023<span class="noprint">; 15 months ago</span><span style="display:none"> (<span class="bday dtstart published updated">2023-08-14</span>)</span><sup id="cite_ref-releases_2-1" class="reference"><a href="#cite_note-releases-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup></div></td></tr><tr style="display:none"><td colspan="2"> </td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Repository_(version_control)" title="Repository (version control)">Repository</a></th><td class="infobox-data"><span class="url"><a rel="nofollow" class="external text" href="https://github.com/apache/hive">github<wbr />.com<wbr />/apache<wbr />/hive</a></span></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Written in</th><td class="infobox-data"><a href="/wiki/Java_(programming_language)" title="Java (programming language)">Java</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Operating_system" title="Operating system">Operating system</a></th><td class="infobox-data"><a href="/wiki/Cross-platform" class="mw-redirect" title="Cross-platform">Cross-platform</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Available in</th><td class="infobox-data">SQL</td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Software_categories#Categorization_approaches" title="Software categories">Type</a></th><td class="infobox-data"><a href="/wiki/Data_warehouse" title="Data warehouse">Data warehouse</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="/wiki/Software_license" title="Software license">License</a></th><td class="infobox-data"><a href="/wiki/Apache_License_2.0" class="mw-redirect" title="Apache License 2.0">Apache License 2.0</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Website</th><td class="infobox-data"><span class="url"><a rel="nofollow" class="external text" href="https://hive.apache.org">hive<wbr />.apache<wbr />.org</a></span></td></tr></tbody></table> <p><b>Apache Hive</b> is a <a href="/wiki/Data_warehouse" title="Data warehouse">data warehouse</a> software project. It is built on top of <a href="/wiki/Apache_Hadoop" title="Apache Hadoop">Apache Hadoop</a> for providing data query and analysis.<sup id="cite_ref-3" class="reference"><a href="#cite_note-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-4" class="reference"><a href="#cite_note-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> Hive gives an SQL-like <a href="/wiki/Interface_(computing)" title="Interface (computing)">interface</a> to query data stored in various databases and file systems that integrate with Hadoop. Traditional SQL queries must be implemented in the <a href="/wiki/MapReduce" title="MapReduce">MapReduce</a> Java API to execute SQL applications and queries over distributed data. </p><p>Hive provides the necessary SQL abstraction to integrate SQL-like queries (<a href="#HiveQL">HiveQL</a>) into the underlying Java without the need to implement queries in the low-level Java API. Hive facilitates the integration of SQL-based querying languages with Hadoop, which is commonly used in data warehousing applications.<sup id="cite_ref-:3_5-0" class="reference"><a href="#cite_note-:3-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> While initially developed by <a href="/wiki/Facebook,_Inc." class="mw-redirect" title="Facebook, Inc.">Facebook</a>, Apache Hive is used and developed by other companies such as <a href="/wiki/Netflix" title="Netflix">Netflix</a> and the <a href="/wiki/Financial_Industry_Regulatory_Authority" title="Financial Industry Regulatory Authority">Financial Industry Regulatory Authority</a> (FINRA).<sup id="cite_ref-6" class="reference"><a href="#cite_note-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-7" class="reference"><a href="#cite_note-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup> Amazon maintains a software fork of Apache Hive included in <a href="/wiki/Apache_Hadoop#On_Amazon_Elastic_MapReduce" title="Apache Hadoop">Amazon Elastic MapReduce</a> on <a href="/wiki/Amazon_Web_Services" title="Amazon Web Services">Amazon Web Services</a>.<sup id="cite_ref-8" class="reference"><a href="#cite_note-8"><span class="cite-bracket">[</span>8<span class="cite-bracket">]</span></a></sup> </p> <meta property="mw:PageProp/toc" /> <div class="mw-heading mw-heading2"><h2 id="Features">Features</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=1" title="Edit section: Features"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Apache Hive supports the analysis of large datasets stored in Hadoop's <a href="/wiki/HDFS" class="mw-redirect" title="HDFS">HDFS</a> and compatible file systems such as <a href="/wiki/Amazon_S3" title="Amazon S3">Amazon S3</a> filesystem and <a href="/wiki/Alluxio" title="Alluxio">Alluxio</a>. It provides a SQL-like query language called HiveQL<sup id="cite_ref-9" class="reference"><a href="#cite_note-9"><span class="cite-bracket">[</span>9<span class="cite-bracket">]</span></a></sup> with schema on read and transparently converts queries to <a href="/wiki/MapReduce" title="MapReduce">MapReduce</a>, Apache Tez<sup id="cite_ref-10" class="reference"><a href="#cite_note-10"><span class="cite-bracket">[</span>10<span class="cite-bracket">]</span></a></sup> and <a href="/wiki/Apache_Spark" title="Apache Spark">Spark</a> jobs. All three execution engines can run in <a href="/wiki/Hadoop" class="mw-redirect" title="Hadoop">Hadoop</a>'s resource negotiator, YARN (Yet Another Resource Negotiator). To accelerate queries, it provided indexes, but this feature was removed in version 3.0<sup id="cite_ref-11" class="reference"><a href="#cite_note-11"><span class="cite-bracket">[</span>11<span class="cite-bracket">]</span></a></sup> Other features of Hive include: </p> <ul><li>Different storage types such as plain text, <a href="/wiki/RCFile" title="RCFile">RCFile</a>, <a href="/wiki/HBase" class="mw-redirect" title="HBase">HBase</a>, ORC, and others.</li> <li>Metadata storage in a <a href="/wiki/Relational_database_management_system" class="mw-redirect" title="Relational database management system">relational database management system</a>, significantly reduces the time to perform semantic checks during query execution.</li> <li>Operating on compressed data stored in the Hadoop ecosystem using algorithms including <a href="/wiki/DEFLATE" class="mw-redirect" title="DEFLATE">DEFLATE</a>, <a href="/wiki/Burrows%E2%80%93Wheeler_transform" title="Burrows–Wheeler transform">BWT</a>, <a href="/wiki/Snappy_(compression)" title="Snappy (compression)">Snappy</a>, etc.</li> <li>Built-in <a href="/wiki/User-defined_function" title="User-defined function">user-defined functions</a> (UDFs) to manipulate dates, strings, and other data-mining tools. Hive supports extending the UDF set to handle use cases not supported by built-in functions.</li> <li>SQL-like queries (HiveQL), which are implicitly converted into MapReduce or Tez, or Spark jobs.</li></ul> <p>By default, Hive stores metadata in an embedded <a href="/wiki/Apache_Derby" title="Apache Derby">Apache Derby</a> database, and other client/server databases like <a href="/wiki/MySQL" title="MySQL">MySQL</a> can optionally be used.<sup id="cite_ref-12" class="reference"><a href="#cite_note-12"><span class="cite-bracket">[</span>12<span class="cite-bracket">]</span></a></sup> </p><p>The first four file formats supported in Hive were plain text,<sup id="cite_ref-13" class="reference"><a href="#cite_note-13"><span class="cite-bracket">[</span>13<span class="cite-bracket">]</span></a></sup> sequence file, optimized row columnar (ORC) format<sup id="cite_ref-14" class="reference"><a href="#cite_note-14"><span class="cite-bracket">[</span>14<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-15" class="reference"><a href="#cite_note-15"><span class="cite-bracket">[</span>15<span class="cite-bracket">]</span></a></sup> and <a href="/wiki/RCFile" title="RCFile">RCFile</a>.<sup id="cite_ref-:0_16-0" class="reference"><a href="#cite_note-:0-16"><span class="cite-bracket">[</span>16<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-17" class="reference"><a href="#cite_note-17"><span class="cite-bracket">[</span>17<span class="cite-bracket">]</span></a></sup> <a href="/wiki/Apache_Parquet" title="Apache Parquet">Apache Parquet</a> can be read via plugin in versions later than 0.10 and natively starting at 0.13.<sup id="cite_ref-18" class="reference"><a href="#cite_note-18"><span class="cite-bracket">[</span>18<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-19" class="reference"><a href="#cite_note-19"><span class="cite-bracket">[</span>19<span class="cite-bracket">]</span></a></sup> </p> <div class="mw-heading mw-heading2"><h2 id="Architecture">Architecture</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=2" title="Edit section: Architecture"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1251242444"><table class="box-Prose plainlinks metadata ambox ambox-style ambox-Prose" role="presentation"><tbody><tr><td class="mbox-image"><div class="mbox-image-div"><span typeof="mw:File"><span><img alt="" src="//upload.wikimedia.org/wikipedia/en/thumb/f/f2/Edit-clear.svg/40px-Edit-clear.svg.png" decoding="async" width="40" height="40" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/f2/Edit-clear.svg/60px-Edit-clear.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/f2/Edit-clear.svg/80px-Edit-clear.svg.png 2x" data-file-width="48" data-file-height="48" /></span></span></div></td><td class="mbox-text"><div class="mbox-text-span">This section <b>is in <a href="/wiki/MOS:LIST" class="mw-redirect" title="MOS:LIST">list</a> format but may read better as <a href="/wiki/MOS:PROSE" class="mw-redirect" title="MOS:PROSE">prose</a></b>.<span class="hide-when-compact"> You can help by <a class="external text" href="https://en.wikipedia.org/w/index.php?title=Apache_Hive&action=edit">converting this section</a>, if appropriate. <a href="/wiki/Help:Editing" title="Help:Editing">Editing help</a> is available.</span> <span class="date-container"><i>(<span class="date">October 2016</span>)</i></span></div></td></tr></tbody></table> <p>Major components of the Hive architecture are: </p> <ul><li><b>Metastore:</b> Stores metadata for each of the tables such as their schema and location. It also includes the partition metadata which helps the driver to track the progress of various data sets distributed over the cluster.<sup id="cite_ref-:1_20-0" class="reference"><a href="#cite_note-:1-20"><span class="cite-bracket">[</span>20<span class="cite-bracket">]</span></a></sup> The data is stored in a traditional <a href="/wiki/RDBMS" class="mw-redirect" title="RDBMS">RDBMS</a> format. The metadata helps the driver to keep track of the data and it is crucial. Hence, a backup server regularly replicates the data which can be retrieved in case of data loss.</li> <li><b>Driver:</b> Acts like a controller which receives the HiveQL statements. It starts the execution of the statement by creating sessions and monitors the life cycle and progress of the execution. It stores the necessary metadata generated during the execution of a HiveQL statement. The driver also acts as a collection point of data or query results obtained after the Reduce operation.<sup id="cite_ref-:0_16-1" class="reference"><a href="#cite_note-:0-16"><span class="cite-bracket">[</span>16<span class="cite-bracket">]</span></a></sup></li> <li><b>Compiler:</b> Performs compilation of the HiveQL query, which converts the query to an execution plan. This plan contains the tasks and steps needed to be performed by the <a href="/wiki/Apache_Hadoop" title="Apache Hadoop">Hadoop</a> <a href="/wiki/MapReduce" title="MapReduce">MapReduce</a> to get the output as translated by the query. The compiler converts the query to an <a href="/wiki/Abstract_syntax_tree" title="Abstract syntax tree">abstract syntax tree</a> (AST). After checking for compatibility and compile time errors, it converts the AST to a <a href="/wiki/Directed_acyclic_graph" title="Directed acyclic graph">directed acyclic graph</a> (DAG).<sup id="cite_ref-21" class="reference"><a href="#cite_note-21"><span class="cite-bracket">[</span>21<span class="cite-bracket">]</span></a></sup> The DAG divides operators to MapReduce stages and tasks based on the input query and data.<sup id="cite_ref-:1_20-1" class="reference"><a href="#cite_note-:1-20"><span class="cite-bracket">[</span>20<span class="cite-bracket">]</span></a></sup></li> <li><b>Optimizer:</b> Performs various transformations on the execution plan to get an optimized DAG. Transformations can be aggregated together, such as converting a pipeline of joins to a single join, for better performance.<sup id="cite_ref-:2_22-0" class="reference"><a href="#cite_note-:2-22"><span class="cite-bracket">[</span>22<span class="cite-bracket">]</span></a></sup> It can also split the tasks, such as applying a transformation on data before a reduced operation, to provide better performance and scalability. However, the logic of transformation used for optimization can be modified or pipelined using another optimizer.<sup id="cite_ref-:0_16-2" class="reference"><a href="#cite_note-:0-16"><span class="cite-bracket">[</span>16<span class="cite-bracket">]</span></a></sup> An optimizer called YSmart<sup id="cite_ref-23" class="reference"><a href="#cite_note-23"><span class="cite-bracket">[</span>23<span class="cite-bracket">]</span></a></sup> is a part of Apache Hive. This correlated optimizer merges correlated MapReduce jobs into a single MapReduce job, significantly reducing the execution time.</li> <li><b>Executor:</b> After compilation and optimization, the executor executes the tasks. It interacts with the job tracker of Hadoop to schedule tasks to be run. It takes care of pipelining the tasks by making sure that a task with dependency gets executed only if all other prerequisites are run.<sup id="cite_ref-:2_22-1" class="reference"><a href="#cite_note-:2-22"><span class="cite-bracket">[</span>22<span class="cite-bracket">]</span></a></sup></li> <li><b>CLI, UI, and <a href="/wiki/Apache_Thrift" title="Apache Thrift">Thrift Server</a></b>: A <a href="/wiki/Command-line_interface" title="Command-line interface">command-line interface</a> (CLI) provides a <a href="/wiki/User_interface" title="User interface">user interface</a> for an external user to interact with Hive by submitting queries, and instructions and monitoring the process status. Thrift server allows external clients to interact with Hive over a network, similar to the <a href="/wiki/Jdbc" class="mw-redirect" title="Jdbc">JDBC</a> or <a href="/wiki/Odbc" class="mw-redirect" title="Odbc">ODBC</a> protocols.<sup id="cite_ref-24" class="reference"><a href="#cite_note-24"><span class="cite-bracket">[</span>24<span class="cite-bracket">]</span></a></sup></li></ul> <div class="mw-heading mw-heading2"><h2 id="HiveQL">HiveQL</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=3" title="Edit section: HiveQL"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>While based on SQL, HiveQL does not strictly follow the full <a href="/wiki/SQL-92" title="SQL-92">SQL-92</a> standard. HiveQL offers extensions not in SQL, including <i>multi-table inserts,</i> and <i>creates tables as select</i>. HiveQL lacked support for <a href="/wiki/Database_transaction" title="Database transaction">transactions</a> and <a href="/wiki/Materialized_view" title="Materialized view">materialized views</a>, and only limited subquery support.<sup id="cite_ref-:4_25-0" class="reference"><a href="#cite_note-:4-25"><span class="cite-bracket">[</span>25<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-26" class="reference"><a href="#cite_note-26"><span class="cite-bracket">[</span>26<span class="cite-bracket">]</span></a></sup> Support for insert, update, and delete with full <a href="/wiki/ACID" title="ACID">ACID</a> functionality was made available with release 0.14.<sup id="cite_ref-27" class="reference"><a href="#cite_note-27"><span class="cite-bracket">[</span>27<span class="cite-bracket">]</span></a></sup> </p><p>Internally, a <a href="/wiki/Compiler" title="Compiler">compiler</a> translates HiveQL statements into a <a href="/wiki/Directed_acyclic_graph" title="Directed acyclic graph">directed acyclic graph</a> of <a href="/wiki/MapReduce" title="MapReduce">MapReduce</a>, Tez, or <a href="/wiki/Apache_Spark" title="Apache Spark">Spark</a> jobs, which are submitted to Hadoop for execution.<sup id="cite_ref-28" class="reference"><a href="#cite_note-28"><span class="cite-bracket">[</span>28<span class="cite-bracket">]</span></a></sup> </p> <div class="mw-heading mw-heading3"><h3 id="Example">Example</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=4" title="Edit section: Example"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The word count program counts the number of times each word occurs in the input. The word count can be written in HiveQL as:<sup id="cite_ref-:3_5-1" class="reference"><a href="#cite_note-:3-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr mw-highlight-lines" dir="ltr"><pre><span></span><span class="linenos" data-line="1"></span><span class="k">DROP</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="k">EXISTS</span><span class="w"> </span><span class="n">docs</span><span class="p">;</span> <span class="linenos" data-line="2"></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">docs</span><span class="w"> </span><span class="p">(</span><span class="n">line</span><span class="w"> </span><span class="n">STRING</span><span class="p">);</span> <span class="linenos" data-line="3"></span><span class="k">LOAD</span><span class="w"> </span><span class="k">DATA</span><span class="w"> </span><span class="n">INPATH</span><span class="w"> </span><span class="s1">'input_file'</span><span class="w"> </span><span class="n">OVERWRITE</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">docs</span><span class="p">;</span> <span class="linenos" data-line="4"></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">word_counts</span><span class="w"> </span><span class="k">AS</span> <span class="linenos" data-line="5"></span><span class="k">SELECT</span><span class="w"> </span><span class="n">word</span><span class="p">,</span><span class="w"> </span><span class="k">count</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="k">count</span><span class="w"> </span><span class="k">FROM</span> <span class="linenos" data-line="6"></span><span class="w"> </span><span class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span class="n">explode</span><span class="p">(</span><span class="n">split</span><span class="p">(</span><span class="n">line</span><span class="p">,</span><span class="w"> </span><span class="s1">'\s'</span><span class="p">))</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">word</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">docs</span><span class="p">)</span><span class="w"> </span><span class="n">temp</span> <span class="linenos" data-line="7"></span><span class="k">GROUP</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">word</span> <span class="linenos" data-line="8"></span><span class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">word</span><span class="p">;</span> </pre></div> <p>A brief explanation of each of the statements is as follows: </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr mw-highlight-lines" dir="ltr"><pre><span></span><span class="linenos" data-line="1"></span><span class="k">DROP</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="k">EXISTS</span><span class="w"> </span><span class="n">docs</span><span class="p">;</span> <span class="linenos" data-line="2"></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">docs</span><span class="w"> </span><span class="p">(</span><span class="n">line</span><span class="w"> </span><span class="n">STRING</span><span class="p">);</span> </pre></div> <p>Checks if table <code>docs</code> exists and drops it if it does. Creates a new table called <code>docs</code> with a single column of type <code>STRING</code> called <code>line</code>. </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr mw-highlight-lines" dir="ltr"><pre><span></span><span class="linenos" data-line="3"></span><span class="k">LOAD</span><span class="w"> </span><span class="k">DATA</span><span class="w"> </span><span class="n">INPATH</span><span class="w"> </span><span class="s1">'input_file'</span><span class="w"> </span><span class="n">OVERWRITE</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">docs</span><span class="p">;</span> </pre></div> <p>Loads the specified file or directory (In this case “input_file”) into the table. <code>OVERWRITE</code> specifies that the target table to which the data is being loaded into is to be re-written; Otherwise, the data would be appended. </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr mw-highlight-lines" dir="ltr"><pre><span></span><span class="linenos" data-line="4"></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">word_counts</span><span class="w"> </span><span class="k">AS</span> <span class="linenos" data-line="5"></span><span class="k">SELECT</span><span class="w"> </span><span class="n">word</span><span class="p">,</span><span class="w"> </span><span class="k">count</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="k">count</span><span class="w"> </span><span class="k">FROM</span> <span class="linenos" data-line="6"></span><span class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span class="n">explode</span><span class="p">(</span><span class="n">split</span><span class="p">(</span><span class="n">line</span><span class="p">,</span><span class="w"> </span><span class="s1">'\s'</span><span class="p">))</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">word</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">docs</span><span class="p">)</span><span class="w"> </span><span class="n">temp</span> <span class="linenos" data-line="7"></span><span class="k">GROUP</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">word</span> <span class="linenos" data-line="8"></span><span class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">word</span><span class="p">;</span> </pre></div> <p>The query <code class="mw-highlight mw-highlight-lang-text mw-content-ltr" style="" dir="ltr">CREATE TABLE word_counts AS SELECT word, count(1) AS count</code> creates a table called <code>word_counts</code> with two columns: <code>word</code> and <code>count</code>. This query draws its input from the inner query <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span class="n">explode</span><span class="p">(</span><span class="n">split</span><span class="p">(</span><span class="n">line</span><span class="p">,</span><span class="w"> </span><span class="s1">'\s'</span><span class="p">))</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">word</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">docs</span><span class="p">)</span><span class="w"> </span><span class="n">temp</span><span class="err">"</span></code>. This query serves to split the input words into different rows of a temporary table aliased as <code>temp</code>. The <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">GROUP</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">WORD</span></code> groups the results based on their keys. This results in the <code>count</code> column holding the number of occurrences for each word of the <code>word</code> column. The <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">WORDS</span></code> sorts the words alphabetically. </p> <div class="mw-heading mw-heading2"><h2 id="Comparison_with_traditional_databases">Comparison with traditional databases</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=5" title="Edit section: Comparison with traditional databases"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The storage and querying operations of Hive closely resemble those of traditional databases. While Hive is a SQL dialect, there are a lot of differences in structure and working of Hive in comparison to relational databases. The differences are mainly because Hive is built on top of the <a href="/wiki/Apache_Hadoop" title="Apache Hadoop">Hadoop</a> ecosystem, and has to comply with the restrictions of Hadoop and <a href="/wiki/MapReduce" title="MapReduce">MapReduce</a>. </p><p>A schema is applied to a table in traditional databases. In such traditional databases, the table typically enforces the schema when the data is loaded into the table. This enables the database to make sure that the data entered follows the representation of the table as specified by the table definition. This design is called <i>schema on write</i>. In comparison, Hive does not verify the data against the table schema on write. Instead, it subsequently does run time checks when the data is read. This model is called <i>schema on read</i>.<sup id="cite_ref-:4_25-1" class="reference"><a href="#cite_note-:4-25"><span class="cite-bracket">[</span>25<span class="cite-bracket">]</span></a></sup> The two approaches have their own advantages and drawbacks. </p><p>Checking data against table schema during the load time adds extra overhead, which is why traditional databases take a longer time to load data. Quality checks are performed against the data at the load time to ensure that the data is not corrupt. Early detection of corrupt data ensures early exception handling. Since the tables are forced to match the schema after/during the data load, it has better query time performance. Hive, on the other hand, can load data dynamically without any schema check, ensuring a fast initial load, but with the drawback of comparatively slower performance at query time. Hive does have an advantage when the schema is not available at the load time, but is instead generated later dynamically.<sup id="cite_ref-:4_25-2" class="reference"><a href="#cite_note-:4-25"><span class="cite-bracket">[</span>25<span class="cite-bracket">]</span></a></sup> </p><p>Transactions are key operations in traditional databases. As any typical <a href="/wiki/Relational_database_management_system" class="mw-redirect" title="Relational database management system">RDBMS</a>, Hive supports all four properties of transactions (<a href="/wiki/ACID" title="ACID">ACID</a>): <a href="/wiki/Atomicity_(database_systems)" title="Atomicity (database systems)">Atomicity</a>, <a href="/wiki/Consistency_(database_systems)" title="Consistency (database systems)">Consistency</a>, <a href="/wiki/Isolation_(database_systems)" title="Isolation (database systems)">Isolation</a>, and <a href="/wiki/Durability_(database_systems)" title="Durability (database systems)">Durability</a>. Transactions in Hive were introduced in Hive 0.13 but were only limited to the partition level.<sup id="cite_ref-29" class="reference"><a href="#cite_note-29"><span class="cite-bracket">[</span>29<span class="cite-bracket">]</span></a></sup> The recent version of Hive 0.14 had these functions fully added to support complete <a href="/wiki/ACID" title="ACID">ACID</a> properties. Hive 0.14 and later provides different row level transactions such as <i>INSERT, DELETE and UPDATE</i>.<sup id="cite_ref-30" class="reference"><a href="#cite_note-30"><span class="cite-bracket">[</span>30<span class="cite-bracket">]</span></a></sup> Enabling <i>INSERT, UPDATE, and DELETE</i> transactions require setting appropriate values for configuration properties such as <code>hive.support.concurrency</code>, <code>hive.enforce.bucketing</code>, and <code>hive.exec.dynamic.partition.mode</code>.<sup id="cite_ref-31" class="reference"><a href="#cite_note-31"><span class="cite-bracket">[</span>31<span class="cite-bracket">]</span></a></sup> </p> <div class="mw-heading mw-heading2"><h2 id="Security">Security</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=6" title="Edit section: Security"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Hive v0.7.0 added integration with Hadoop security. Hadoop began using <a href="/wiki/Kerberos_(protocol)" title="Kerberos (protocol)">Kerberos</a> authorization support to provide security. Kerberos allows for mutual authentication between client and server. In this system, the client's request for a ticket is passed along with the request. The previous versions of Hadoop had several issues such as users being able to spoof their username by setting the <code>hadoop.job.ugi</code> property and also MapReduce operations being run under the same user: Hadoop or mapred. With Hive v0.7.0's integration with Hadoop security, these issues have largely been fixed. TaskTracker jobs are run by the user who launched it and the username can no longer be spoofed by setting the <code>hadoop.job.ugi</code> property. Permissions for newly created files in Hive are dictated by the <a href="/wiki/Apache_Hadoop" title="Apache Hadoop">HDFS</a>. The Hadoop distributed file system authorization model uses three entities: user, group and others with three permissions: read, write and execute. The default permissions for newly created files can be set by changing the unmask value for the Hive configuration variable <code>hive.files.umask.value</code>.<sup id="cite_ref-:3_5-2" class="reference"><a href="#cite_note-:3-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> </p> <div class="mw-heading mw-heading2"><h2 id="See_also">See also</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=7" title="Edit section: See also"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><a href="/wiki/Apache_Pig" title="Apache Pig">Apache Pig</a></li> <li><a href="/wiki/Sqoop" title="Sqoop">Sqoop</a></li> <li><a href="/wiki/Apache_Impala" title="Apache Impala">Apache Impala</a></li> <li><a href="/wiki/Apache_Drill" title="Apache Drill">Apache Drill</a></li> <li><a href="/wiki/Apache_Flume" class="mw-redirect" title="Apache Flume">Apache Flume</a></li> <li><a href="/wiki/HBase" class="mw-redirect" title="HBase">Apache HBase</a></li> <li><a href="/wiki/Trino_(SQL_query_engine)" title="Trino (SQL query engine)">Trino (SQL query engine)</a></li></ul> <div class="mw-heading mw-heading2"><h2 id="References">References</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=8" title="Edit section: References"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <style data-mw-deduplicate="TemplateStyles:r1239543626">.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}</style><div class="reflist reflist-columns references-column-width" style="column-width: 30em;"> <ol class="references"> <li id="cite_note-1"><span class="mw-cite-backlink"><b><a href="#cite_ref-1">^</a></b></span> <span class="reference-text"><style data-mw-deduplicate="TemplateStyles:r1238218222">.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("//upload.wikimedia.org/wikipedia/commons/6/65/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("//upload.wikimedia.org/wikipedia/commons/d/d6/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("//upload.wikimedia.org/wikipedia/commons/a/aa/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("//upload.wikimedia.org/wikipedia/commons/4/4c/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}</style><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://github.com/apache/hive/releases/tag/release-1.0.0">"Release release-1.0.0 · apache/Hive"</a>. <i><a href="/wiki/GitHub" title="GitHub">GitHub</a></i>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=GitHub&rft.atitle=Release+release-1.0.0+%C2%B7+apache%2FHive&rft_id=https%3A%2F%2Fgithub.com%2Fapache%2Fhive%2Freleases%2Ftag%2Frelease-1.0.0&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-releases-2"><span class="mw-cite-backlink">^ <a href="#cite_ref-releases_2-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-releases_2-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://hive.apache.org/downloads.html">"Apache Hive - Downloads"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">21 November</span> 2022</span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=unknown&rft.btitle=Apache+Hive+-+Downloads&rft_id=https%3A%2F%2Fhive.apache.org%2Fdownloads.html&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-3"><span class="mw-cite-backlink"><b><a href="#cite_ref-3">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFVenner2009" class="citation book cs1">Venner, Jason (2009). <span class="id-lock-registration" title="Free registration required"><a rel="nofollow" class="external text" href="https://archive.org/details/prohadoop0000venn"><i>Pro Hadoop</i></a></span>. <a href="/wiki/Apress" class="mw-redirect" title="Apress">Apress</a>. <a href="/wiki/ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a> <a href="/wiki/Special:BookSources/978-1-4302-1942-2" title="Special:BookSources/978-1-4302-1942-2"><bdi>978-1-4302-1942-2</bdi></a>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Pro+Hadoop&rft.pub=Apress&rft.date=2009&rft.isbn=978-1-4302-1942-2&rft.aulast=Venner&rft.aufirst=Jason&rft_id=https%3A%2F%2Farchive.org%2Fdetails%2Fprohadoop0000venn&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-4"><span class="mw-cite-backlink"><b><a href="#cite_ref-4">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFYin_Huai,_Ashutosh_Chauhan,_Alan_Gates,_Gunther_Hagleitner,_Eric_N.Hanson,_Owen_O'Malley,_Jitendra_Pandey,_Yuan_Yuan,_Rubao_Lee,_and_Xiaodong_Zhang2014" class="citation conference cs1">Yin Huai, Ashutosh Chauhan, Alan Gates, Gunther Hagleitner, Eric N.Hanson, Owen O'Malley, Jitendra Pandey, Yuan Yuan, Rubao Lee, and Xiaodong Zhang (2014). <i>"Major Technical Advancements in Apache Hive"</i>. SIGMOD' 14. pp. 1235–1246. <a href="/wiki/Doi_(identifier)" class="mw-redirect" title="Doi (identifier)">doi</a>:<a rel="nofollow" class="external text" href="https://doi.org/10.1145%2F2588555.2595630">10.1145/2588555.2595630</a>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=conference&rft.btitle=%22Major+Technical+Advancements+in+Apache+Hive%22&rft.pages=1235-1246&rft.date=2014&rft_id=info%3Adoi%2F10.1145%2F2588555.2595630&rft.au=Yin+Huai%2C+Ashutosh+Chauhan%2C+Alan+Gates%2C+Gunther+Hagleitner%2C+Eric+N.Hanson%2C+Owen+O%27Malley%2C+Jitendra+Pandey%2C+Yuan+Yuan%2C+Rubao+Lee%2C+and+Xiaodong+Zhang&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span><span class="cs1-maint citation-comment"><code class="cs1-code">{{<a href="/wiki/Template:Cite_conference" title="Template:Cite conference">cite conference</a>}}</code>: CS1 maint: multiple names: authors list (<a href="/wiki/Category:CS1_maint:_multiple_names:_authors_list" title="Category:CS1 maint: multiple names: authors list">link</a>)</span></span> </li> <li id="cite_note-:3-5"><span class="mw-cite-backlink">^ <a href="#cite_ref-:3_5-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-:3_5-1"><sup><i><b>b</b></i></sup></a> <a href="#cite_ref-:3_5-2"><sup><i><b>c</b></i></sup></a></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation book cs1"><a rel="nofollow" class="external text" href="https://www.safaribooksonline.com/library/view/programming-hive/9781449326944/"><i>Programming Hive [Book]</i></a>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Programming+Hive+%5BBook%5D&rft_id=https%3A%2F%2Fwww.safaribooksonline.com%2Flibrary%2Fview%2Fprogramming-hive%2F9781449326944%2F&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-6"><span class="mw-cite-backlink"><b><a href="#cite_ref-6">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://www.slideshare.net/evamtse/hive-user-group-presentation-from-netflix-3182010-3483386">Use Case Study of Hive/Hadoop </a></span> </li> <li id="cite_note-7"><span class="mw-cite-backlink"><b><a href="#cite_ref-7">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://www.youtube.com/watch?v=Idu9OKnAOis"><span class="plainlinks">OSCON Data 2011, Adrian Cockcroft, "Data Flow at Netflix"</span></a> on <a href="/wiki/YouTube_video_(identifier)" class="mw-redirect" title="YouTube video (identifier)">YouTube</a></span> </li> <li id="cite_note-8"><span class="mw-cite-backlink"><b><a href="#cite_ref-8">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="http://s3.amazonaws.com/awsdocs/ElasticMapReduce/latest/emr-dg.pdf">Amazon Elastic MapReduce Developer Guide</a></span> </li> <li id="cite_note-9"><span class="mw-cite-backlink"><b><a href="#cite_ref-9">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual">HiveQL Language Manual</a></span> </li> <li id="cite_note-10"><span class="mw-cite-backlink"><b><a href="#cite_ref-10">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://tez.apache.org/">Apache Tez</a></span> </li> <li id="cite_note-11"><span class="mw-cite-backlink"><b><a href="#cite_ref-11">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Indexing#LanguageManualIndexing-IndexingIsRemovedsince3.0">Hive Language Manual</a></span> </li> <li id="cite_note-12"><span class="mw-cite-backlink"><b><a href="#cite_ref-12">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFLam2010" class="citation book cs1">Lam, Chuck (2010). <i>Hadoop in Action</i>. <a href="/wiki/Manning_Publications" title="Manning Publications">Manning Publications</a>. <a href="/wiki/ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a> <a href="/wiki/Special:BookSources/978-1-935182-19-1" title="Special:BookSources/978-1-935182-19-1"><bdi>978-1-935182-19-1</bdi></a>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Hadoop+in+Action&rft.pub=Manning+Publications&rft.date=2010&rft.isbn=978-1-935182-19-1&rft.aulast=Lam&rft.aufirst=Chuck&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-13"><span class="mw-cite-backlink"><b><a href="#cite_ref-13">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20141115010328/http://www.semantikoz.com/blog/optimising-hadoop-big-data-text-hive">"Optimising Hadoop and Big Data with Text and HiveOptimising Hadoop and Big Data with Text and Hive"</a>. Archived from <a rel="nofollow" class="external text" href="http://www.semantikoz.com/blog/optimising-hadoop-big-data-text-hive/">the original</a> on 2014-11-15<span class="reference-accessdate">. Retrieved <span class="nowrap">2014-11-16</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=unknown&rft.btitle=Optimising+Hadoop+and+Big+Data+with+Text+and+HiveOptimising+Hadoop+and+Big+Data+with+Text+and+Hive&rft_id=http%3A%2F%2Fwww.semantikoz.com%2Fblog%2Foptimising-hadoop-big-data-text-hive%2F&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-14"><span class="mw-cite-backlink"><b><a href="#cite_ref-14">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC">"ORC Language Manual"</a>. <i>Hive project wiki</i><span class="reference-accessdate">. Retrieved <span class="nowrap">April 24,</span> 2017</span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=Hive+project+wiki&rft.atitle=ORC+Language+Manual&rft_id=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FLanguageManual%2BORC&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-15"><span class="mw-cite-backlink"><b><a href="#cite_ref-15">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFYin_Huai,_Siyuan_Ma,_Rubao_Lee,_Owen_O'Malley,_and_Xiaodong_Zhang2013" class="citation conference cs1">Yin Huai, Siyuan Ma, Rubao Lee, Owen O'Malley, and Xiaodong Zhang (2013). <i>"Understanding Insights into the Basic Structure and Essential Issues of Table Placement Methods in Clusters "</i>. VLDB' 39. pp. 1750–1761. <a href="/wiki/CiteSeerX_(identifier)" class="mw-redirect" title="CiteSeerX (identifier)">CiteSeerX</a> <span class="id-lock-free" title="Freely accessible"><a rel="nofollow" class="external text" href="https://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.406.4342">10.1.1.406.4342</a></span>. <a href="/wiki/Doi_(identifier)" class="mw-redirect" title="Doi (identifier)">doi</a>:<a rel="nofollow" class="external text" href="https://doi.org/10.14778%2F2556549.2556559">10.14778/2556549.2556559</a>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=conference&rft.btitle=%22Understanding+Insights+into+the+Basic+Structure+and+Essential+Issues+of+Table+Placement+Methods+in+Clusters+%22&rft.pages=1750-1761&rft.date=2013&rft_id=https%3A%2F%2Fciteseerx.ist.psu.edu%2Fviewdoc%2Fsummary%3Fdoi%3D10.1.1.406.4342%23id-name%3DCiteSeerX&rft_id=info%3Adoi%2F10.14778%2F2556549.2556559&rft.au=Yin+Huai%2C+Siyuan+Ma%2C+Rubao+Lee%2C+Owen+O%27Malley%2C+and+Xiaodong+Zhang&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span><span class="cs1-maint citation-comment"><code class="cs1-code">{{<a href="/wiki/Template:Cite_conference" title="Template:Cite conference">cite conference</a>}}</code>: CS1 maint: multiple names: authors list (<a href="/wiki/Category:CS1_maint:_multiple_names:_authors_list" title="Category:CS1 maint: multiple names: authors list">link</a>)</span></span> </li> <li id="cite_note-:0-16"><span class="mw-cite-backlink">^ <a href="#cite_ref-:0_16-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-:0_16-1"><sup><i><b>b</b></i></sup></a> <a href="#cite_ref-:0_16-2"><sup><i><b>c</b></i></sup></a></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20110728063630/http://www.sfbayacm.org/wp/wp-content/uploads/2010/01/sig_2010_v21.pdf">"Facebook's Petabyte Scale Data Warehouse using Hive and Hadoop"</a> <span class="cs1-format">(PDF)</span>. Archived from <a rel="nofollow" class="external text" href="http://www.sfbayacm.org/wp/wp-content/uploads/2010/01/sig_2010_v21.pdf">the original</a> <span class="cs1-format">(PDF)</span> on 2011-07-28<span class="reference-accessdate">. Retrieved <span class="nowrap">2011-09-09</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=unknown&rft.btitle=Facebook%27s+Petabyte+Scale+Data+Warehouse+using+Hive+and+Hadoop&rft_id=http%3A%2F%2Fwww.sfbayacm.org%2Fwp%2Fwp-content%2Fuploads%2F2010%2F01%2Fsig_2010_v21.pdf&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-17"><span class="mw-cite-backlink"><b><a href="#cite_ref-17">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFYongqiang_He,_Rubao_Lee,_Yin_Huai,_Zheng_Shao,_Namit_Jain,_Xiaodong_Zhang,_and_Zhiwei_Xu2011" class="citation conference cs1">Yongqiang He, Rubao Lee, Yin Huai, Zheng Shao, Namit Jain, Xiaodong Zhang, and Zhiwei Xu (2011). <a rel="nofollow" class="external text" href="https://ieeexplore.ieee.org/document/5767933"><i>"RCFile: A Fast and Space-efficient Data Placement Structure in MapReduce-based Warehouse Systems"</i></a>. IEEE 27th International Conference on Data Engineering.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=conference&rft.btitle=%22RCFile%3A+A+Fast+and+Space-efficient+Data+Placement+Structure+in+MapReduce-based+Warehouse+Systems%22&rft.date=2011&rft.au=Yongqiang+He%2C+Rubao+Lee%2C+Yin+Huai%2C+Zheng+Shao%2C+Namit+Jain%2C+Xiaodong+Zhang%2C+and+Zhiwei+Xu&rft_id=https%3A%2F%2Fieeexplore.ieee.org%2Fdocument%2F5767933&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span><span class="cs1-maint citation-comment"><code class="cs1-code">{{<a href="/wiki/Template:Cite_conference" title="Template:Cite conference">cite conference</a>}}</code>: CS1 maint: multiple names: authors list (<a href="/wiki/Category:CS1_maint:_multiple_names:_authors_list" title="Category:CS1 maint: multiple names: authors list">link</a>)</span></span> </li> <li id="cite_note-18"><span class="mw-cite-backlink"><b><a href="#cite_ref-18">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20150202145641/https://cwiki.apache.org/confluence/display/Hive/Parquet">"Parquet"</a>. 18 Dec 2014. Archived from <a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/Parquet">the original</a> on 2 February 2015<span class="reference-accessdate">. Retrieved <span class="nowrap">2 February</span> 2015</span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=unknown&rft.btitle=Parquet&rft.date=2014-12-18&rft_id=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FParquet&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-19"><span class="mw-cite-backlink"><b><a href="#cite_ref-19">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFMassie2013" class="citation web cs1">Massie, Matt (21 August 2013). <a rel="nofollow" class="external text" href="https://web.archive.org/web/20150202145026/http://zenfractal.com/2013/08/21/a-powerful-big-data-trio/">"A Powerful Big Data Trio: Spark, Parquet and Avro"</a>. <i>zenfractal.com</i>. Archived from <a rel="nofollow" class="external text" href="http://zenfractal.com/2013/08/21/a-powerful-big-data-trio/">the original</a> on 2 February 2015<span class="reference-accessdate">. Retrieved <span class="nowrap">2 February</span> 2015</span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=zenfractal.com&rft.atitle=A+Powerful+Big+Data+Trio%3A+Spark%2C+Parquet+and+Avro&rft.date=2013-08-21&rft.aulast=Massie&rft.aufirst=Matt&rft_id=http%3A%2F%2Fzenfractal.com%2F2013%2F08%2F21%2Fa-powerful-big-data-trio%2F&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-:1-20"><span class="mw-cite-backlink">^ <a href="#cite_ref-:1_20-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-:1_20-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/Design">"Design - Apache Hive - Apache Software Foundation"</a>. <i>cwiki.apache.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-09-12</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=cwiki.apache.org&rft.atitle=Design+-+Apache+Hive+-+Apache+Software+Foundation&rft_id=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FDesign&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-21"><span class="mw-cite-backlink"><b><a href="#cite_ref-21">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://c2.com/cgi/wiki?AbstractSyntaxTree">"Abstract Syntax Tree"</a>. <i>c2.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-09-12</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=c2.com&rft.atitle=Abstract+Syntax+Tree&rft_id=http%3A%2F%2Fc2.com%2Fcgi%2Fwiki%3FAbstractSyntaxTree&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-:2-22"><span class="mw-cite-backlink">^ <a href="#cite_ref-:2_22-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-:2_22-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFDokerogluOzalBayirCinar2014" class="citation journal cs1">Dokeroglu, Tansel; Ozal, Serkan; Bayir, Murat Ali; Cinar, Muhammet Serkan; Cosar, Ahmet (2014-07-29). <a rel="nofollow" class="external text" href="https://doi.org/10.1186%2Fs13677-014-0012-6">"Improving the performance of Hadoop Hive by sharing scan and computation tasks"</a>. <i>Journal of Cloud Computing</i>. <b>3</b> (1): 1–11. <a href="/wiki/Doi_(identifier)" class="mw-redirect" title="Doi (identifier)">doi</a>:<span class="id-lock-free" title="Freely accessible"><a rel="nofollow" class="external text" href="https://doi.org/10.1186%2Fs13677-014-0012-6">10.1186/s13677-014-0012-6</a></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.jtitle=Journal+of+Cloud+Computing&rft.atitle=Improving+the+performance+of+Hadoop+Hive+by+sharing+scan+and+computation+tasks&rft.volume=3&rft.issue=1&rft.pages=1-11&rft.date=2014-07-29&rft_id=info%3Adoi%2F10.1186%2Fs13677-014-0012-6&rft.aulast=Dokeroglu&rft.aufirst=Tansel&rft.au=Ozal%2C+Serkan&rft.au=Bayir%2C+Murat+Ali&rft.au=Cinar%2C+Muhammet+Serkan&rft.au=Cosar%2C+Ahmet&rft_id=https%3A%2F%2Fdoi.org%2F10.1186%252Fs13677-014-0012-6&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-23"><span class="mw-cite-backlink"><b><a href="#cite_ref-23">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFRubao_Lee,_Tian_Luo,_Yin_Huai,_Fusheng_Wang,_Yongqiang_He,_and_Xiaodong_Zhang2011" class="citation conference cs1">Rubao Lee, Tian Luo, Yin Huai, Fusheng Wang, Yongqiang He, and Xiaodong Zhang (2011). <a rel="nofollow" class="external text" href="https://ieeexplore.ieee.org/document/5961685"><i>"YSmart: Yet Another SQL-to-MapReduce Translator"</i></a>. 31st International Conference on Distributed Computing Systems. pp. 25–36.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=conference&rft.btitle=%22YSmart%3A+Yet+Another+SQL-to-MapReduce+Translator%22&rft.pages=25-36&rft.date=2011&rft.au=Rubao+Lee%2C+Tian+Luo%2C+Yin+Huai%2C+Fusheng+Wang%2C+Yongqiang+He%2C+and+Xiaodong+Zhang&rft_id=https%3A%2F%2Fieeexplore.ieee.org%2Fdocument%2F5961685&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span><span class="cs1-maint citation-comment"><code class="cs1-code">{{<a href="/wiki/Template:Cite_conference" title="Template:Cite conference">cite conference</a>}}</code>: CS1 maint: multiple names: authors list (<a href="/wiki/Category:CS1_maint:_multiple_names:_authors_list" title="Category:CS1 maint: multiple names: authors list">link</a>)</span></span> </li> <li id="cite_note-24"><span class="mw-cite-backlink"><b><a href="#cite_ref-24">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/HiveServer">"HiveServer - Apache Hive - Apache Software Foundation"</a>. <i>cwiki.apache.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-09-12</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=cwiki.apache.org&rft.atitle=HiveServer+-+Apache+Hive+-+Apache+Software+Foundation&rft_id=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FHiveServer&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-:4-25"><span class="mw-cite-backlink">^ <a href="#cite_ref-:4_25-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-:4_25-1"><sup><i><b>b</b></i></sup></a> <a href="#cite_ref-:4_25-2"><sup><i><b>c</b></i></sup></a></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite id="CITEREFWhite2010" class="citation book cs1">White, Tom (2010). <span class="id-lock-registration" title="Free registration required"><a rel="nofollow" class="external text" href="https://archive.org/details/hadoopdefinitive0000whit"><i>Hadoop: The Definitive Guide</i></a></span>. <a href="/wiki/O%27Reilly_Media" title="O'Reilly Media">O'Reilly Media</a>. <a href="/wiki/ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a> <a href="/wiki/Special:BookSources/978-1-4493-8973-4" title="Special:BookSources/978-1-4493-8973-4"><bdi>978-1-4493-8973-4</bdi></a>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Hadoop%3A+The+Definitive+Guide&rft.pub=O%27Reilly+Media&rft.date=2010&rft.isbn=978-1-4493-8973-4&rft.aulast=White&rft.aufirst=Tom&rft_id=https%3A%2F%2Farchive.org%2Fdetails%2Fhadoopdefinitive0000whit&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-26"><span class="mw-cite-backlink"><b><a href="#cite_ref-26">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual">Hive Language Manual</a></span> </li> <li id="cite_note-27"><span class="mw-cite-backlink"><b><a href="#cite_ref-27">^</a></b></span> <span class="reference-text"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions">ACID and Transactions in Hive</a></span> </li> <li id="cite_note-28"><span class="mw-cite-backlink"><b><a href="#cite_ref-28">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20131008161608/http://www.vldb.org/pvldb/2/vldb09-938.pdf">"Hive A Warehousing Solution Over a MapReduce Framework"</a> <span class="cs1-format">(PDF)</span>. Archived from <a rel="nofollow" class="external text" href="http://www.vldb.org/pvldb/2/vldb09-938.pdf">the original</a> <span class="cs1-format">(PDF)</span> on 2013-10-08<span class="reference-accessdate">. Retrieved <span class="nowrap">2011-09-03</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=unknown&rft.btitle=Hive+A+Warehousing+Solution+Over+a+MapReduce+Framework&rft_id=http%3A%2F%2Fwww.vldb.org%2Fpvldb%2F2%2Fvldb09-938.pdf&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-29"><span class="mw-cite-backlink"><b><a href="#cite_ref-29">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20160903210039/http://datametica.com/introduction-to-hive-transactions">"Introduction to Hive transactions"</a>. <i>datametica.com</i>. Archived from <a rel="nofollow" class="external text" href="http://datametica.com/introduction-to-hive-transactions/">the original</a> on 2016-09-03<span class="reference-accessdate">. Retrieved <span class="nowrap">2016-09-12</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=datametica.com&rft.atitle=Introduction+to+Hive+transactions&rft_id=http%3A%2F%2Fdatametica.com%2Fintroduction-to-hive-transactions%2F&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-30"><span class="mw-cite-backlink"><b><a href="#cite_ref-30">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-NewConfigurationParametersforTransactions">"Hive Transactions - Apache Hive - Apache Software Foundation"</a>. <i>cwiki.apache.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-09-12</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=cwiki.apache.org&rft.atitle=Hive+Transactions+-+Apache+Hive+-+Apache+Software+Foundation&rft_id=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FHive%2BTransactions%23HiveTransactions-NewConfigurationParametersforTransactions&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> <li id="cite_note-31"><span class="mw-cite-backlink"><b><a href="#cite_ref-31">^</a></b></span> <span class="reference-text"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1238218222"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.txn.manager">"Configuration Properties - Apache Hive - Apache Software Foundation"</a>. <i>cwiki.apache.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-09-12</span></span>.</cite><span title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=cwiki.apache.org&rft.atitle=Configuration+Properties+-+Apache+Hive+-+Apache+Software+Foundation&rft_id=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FHive%2FConfiguration%2BProperties%23ConfigurationProperties-hive.txn.manager&rfr_id=info%3Asid%2Fen.wikipedia.org%3AApache+Hive" class="Z3988"></span></span> </li> </ol></div> <div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Apache_Hive&action=edit&section=9" title="Edit section: External links"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><span class="official-website"><span class="url"><a rel="nofollow" class="external text" href="https://hive.apache.org">Official website</a></span></span> <span class="mw-valign-text-top" typeof="mw:File/Frameless"><a href="https://www.wikidata.org/wiki/Q4778914#P856" title="Edit this at Wikidata"><img alt="Edit this at Wikidata" src="//upload.wikimedia.org/wikipedia/en/thumb/8/8a/OOjs_UI_icon_edit-ltr-progressive.svg/10px-OOjs_UI_icon_edit-ltr-progressive.svg.png" decoding="async" width="10" height="10" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/8/8a/OOjs_UI_icon_edit-ltr-progressive.svg/15px-OOjs_UI_icon_edit-ltr-progressive.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/8/8a/OOjs_UI_icon_edit-ltr-progressive.svg/20px-OOjs_UI_icon_edit-ltr-progressive.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span></li></ul> <div class="navbox-styles"><style data-mw-deduplicate="TemplateStyles:r1129693374">.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist.inline,.mw-parser-output .hlist.inline dl,.mw-parser-output .hlist.inline ol,.mw-parser-output .hlist.inline ul,.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li{display:none}.mw-parser-output .hlist dt::after{content:": "}.mw-parser-output .hlist dd::after,.mw-parser-output .hlist li::after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child::after,.mw-parser-output .hlist dt:last-child::after,.mw-parser-output .hlist li:last-child::after{content:none}.mw-parser-output .hlist dd dd:first-child::before,.mw-parser-output .hlist dd dt:first-child::before,.mw-parser-output .hlist dd li:first-child::before,.mw-parser-output .hlist dt dd:first-child::before,.mw-parser-output .hlist dt dt:first-child::before,.mw-parser-output .hlist dt li:first-child::before,.mw-parser-output .hlist li dd:first-child::before,.mw-parser-output .hlist li dt:first-child::before,.mw-parser-output .hlist li li:first-child::before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child::after,.mw-parser-output .hlist dd dt:last-child::after,.mw-parser-output .hlist dd li:last-child::after,.mw-parser-output .hlist dt dd:last-child::after,.mw-parser-output .hlist dt dt:last-child::after,.mw-parser-output .hlist dt li:last-child::after,.mw-parser-output .hlist li dd:last-child::after,.mw-parser-output .hlist li dt:last-child::after,.mw-parser-output .hlist li li:last-child::after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li::before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child::before,.mw-parser-output .hlist dt ol>li:first-child::before,.mw-parser-output .hlist li ol>li:first-child::before{content:" ("counter(listitem)"\a0 "}</style><style data-mw-deduplicate="TemplateStyles:r1236075235">.mw-parser-output .navbox{box-sizing:border-box;border:1px solid #a2a9b1;width:100%;clear:both;font-size:88%;text-align:center;padding:1px;margin:1em auto 0}.mw-parser-output .navbox .navbox{margin-top:0}.mw-parser-output .navbox+.navbox,.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox-group,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{padding:0.25em 1em;line-height:1.5em;text-align:center}.mw-parser-output .navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background-color:#fdfdfd}.mw-parser-output .navbox-list{line-height:1.5em;border-color:#fdfdfd}.mw-parser-output .navbox-list-with-group{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output tr+tr>.navbox-abovebelow,.mw-parser-output tr+tr>.navbox-group,.mw-parser-output tr+tr>.navbox-image,.mw-parser-output tr+tr>.navbox-list{border-top:2px solid #fdfdfd}.mw-parser-output .navbox-title{background-color:#ccf}.mw-parser-output .navbox-abovebelow,.mw-parser-output .navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background-color:#ddf}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background-color:#e6e6ff}.mw-parser-output .navbox-even{background-color:#f7f7f7}.mw-parser-output .navbox-odd{background-color:transparent}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em}body.skin--responsive .mw-parser-output .navbox-image img{max-width:none!important}@media print{body.ns-0 .mw-parser-output .navbox{display:none!important}}</style></div><div role="navigation" class="navbox" aria-labelledby="The_Apache_Software_Foundation" style="padding:3px"><table class="nowraplinks hlist mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1129693374"><style data-mw-deduplicate="TemplateStyles:r1239400231">.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw-parser-output .navbar-boxtext{word-spacing:0}.mw-parser-output .navbar ul{display:inline-block;white-space:nowrap;line-height:inherit}.mw-parser-output .navbar-brackets::before{margin-right:-0.125em;content:"[ "}.mw-parser-output .navbar-brackets::after{margin-left:-0.125em;content:" ]"}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbar a>span,.mw-parser-output .navbar a>abbr{text-decoration:inherit}.mw-parser-output .navbar-mini abbr{font-variant:small-caps;border-bottom:none;text-decoration:none;cursor:inherit}.mw-parser-output .navbar-ct-full{font-size:114%;margin:0 7em}.mw-parser-output .navbar-ct-mini{font-size:114%;margin:0 4em}html.skin-theme-clientpref-night .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}@media(prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}}@media print{.mw-parser-output .navbar{display:none!important}}</style><div class="navbar plainlinks hlist navbar-mini"><ul><li class="nv-view"><a href="/wiki/Template:Apache_Software_Foundation" title="Template:Apache Software Foundation"><abbr title="View this template">v</abbr></a></li><li class="nv-talk"><a href="/wiki/Template_talk:Apache_Software_Foundation" title="Template talk:Apache Software Foundation"><abbr title="Discuss this template">t</abbr></a></li><li class="nv-edit"><a href="/wiki/Special:EditPage/Template:Apache_Software_Foundation" title="Special:EditPage/Template:Apache Software Foundation"><abbr title="Edit this template">e</abbr></a></li></ul></div><div id="The_Apache_Software_Foundation" style="font-size:114%;margin:0 4em"><a href="/wiki/The_Apache_Software_Foundation" title="The Apache Software Foundation">The Apache Software Foundation</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Top-level<br />projects</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Apache_Accumulo" title="Apache Accumulo">Accumulo</a></li> <li><a href="/wiki/Apache_ActiveMQ" title="Apache ActiveMQ">ActiveMQ</a></li> <li><a href="/wiki/Apache_Airavata" title="Apache Airavata">Airavata</a></li> <li><a href="/wiki/Apache_Airflow" title="Apache Airflow">Airflow</a></li> <li><a href="/wiki/Apache_Allura" title="Apache Allura">Allura</a></li> <li><a href="/wiki/Apache_Ambari" class="mw-redirect" title="Apache Ambari">Ambari</a></li> <li><a href="/wiki/Apache_Ant" title="Apache Ant">Ant</a></li> <li><a href="/wiki/Apache_Aries" title="Apache Aries">Aries</a></li> <li><a href="/wiki/Apache_Arrow" title="Apache Arrow">Arrow</a></li> <li><a href="/wiki/Apache_HTTP_Server" title="Apache HTTP Server">Apache HTTP Server</a></li> <li><a href="/wiki/Apache_Portable_Runtime" title="Apache Portable Runtime">APR</a></li> <li><a href="/wiki/Apache_Avro" title="Apache Avro">Avro</a></li> <li><a href="/wiki/Apache_Axis" title="Apache Axis">Axis</a></li> <li><a href="/wiki/Apache_Axis2" title="Apache Axis2">Axis2</a></li> <li><a href="/wiki/Apache_Beam" title="Apache Beam">Beam</a></li> <li><a href="/wiki/Apache_Bloodhound" class="mw-redirect" title="Apache Bloodhound">Bloodhound</a></li> <li><a href="/wiki/Apache_Brooklyn" title="Apache Brooklyn">Brooklyn</a></li> <li><a href="/wiki/Apache_Calcite" title="Apache Calcite">Calcite</a></li> <li><a href="/wiki/Apache_Camel" title="Apache Camel">Camel</a></li> <li><a href="/wiki/Apache_CarbonData" title="Apache CarbonData">CarbonData</a></li> <li><a href="/wiki/Apache_Cassandra" title="Apache Cassandra">Cassandra</a></li> <li><a href="/wiki/Apache_Cayenne" title="Apache Cayenne">Cayenne</a></li> <li><a href="/wiki/Apache_CloudStack" title="Apache CloudStack">CloudStack</a></li> <li><a href="/wiki/Apache_Cocoon" title="Apache Cocoon">Cocoon</a></li> <li><a href="/wiki/Apache_Cordova" title="Apache Cordova">Cordova</a></li> <li><a href="/wiki/Apache_CouchDB" title="Apache CouchDB">CouchDB</a></li> <li><a href="/wiki/Apache_cTAKES" title="Apache cTAKES">cTAKES</a></li> <li><a href="/wiki/Apache_CXF" title="Apache CXF">CXF</a></li> <li><a href="/wiki/Apache_Derby" title="Apache Derby">Derby</a></li> <li><a href="/wiki/Apache_Directory" title="Apache Directory">Directory</a></li> <li><a href="/wiki/Apache_Drill" title="Apache Drill">Drill</a></li> <li><a href="/wiki/Apache_Druid" title="Apache Druid">Druid</a></li> <li><a href="/wiki/Apache_Empire-db" title="Apache Empire-db">Empire-db</a></li> <li><a href="/wiki/Apache_Felix" title="Apache Felix">Felix</a></li> <li><a href="/wiki/Apache_Flex" title="Apache Flex">Flex</a></li> <li><a href="/wiki/Apache_Flink" title="Apache Flink">Flink</a></li> <li><a href="/wiki/Apache_Flume" class="mw-redirect" title="Apache Flume">Flume</a></li> <li><a href="/wiki/FreeMarker" title="FreeMarker">FreeMarker</a></li> <li><a href="/wiki/Apache_Geronimo" title="Apache Geronimo">Geronimo</a></li> <li><a href="/wiki/Apache_Groovy" title="Apache Groovy">Groovy</a></li> <li><a href="/wiki/Apache_Guacamole" title="Apache Guacamole">Guacamole</a></li> <li><a href="/wiki/Apache_Gump" title="Apache Gump">Gump</a></li> <li><a href="/wiki/Apache_Hadoop" title="Apache Hadoop">Hadoop</a></li> <li><a href="/wiki/Apache_HBase" title="Apache HBase">HBase</a></li> <li><a href="/wiki/Apache_Helix" title="Apache Helix">Helix</a></li> <li><a class="mw-selflink selflink">Hive</a></li> <li><a href="/wiki/Apache_Iceberg" title="Apache Iceberg">Iceberg</a></li> <li><a href="/wiki/Apache_Ignite" title="Apache Ignite">Ignite</a></li> <li><a href="/wiki/Apache_Impala" title="Apache Impala">Impala</a></li> <li><a href="/wiki/Apache_Jackrabbit" title="Apache Jackrabbit">Jackrabbit</a></li> <li><a href="/wiki/Apache_James" title="Apache James">James</a></li> <li><a href="/wiki/Apache_Jena" title="Apache Jena">Jena</a></li> <li><a href="/wiki/Apache_JMeter" title="Apache JMeter">JMeter</a></li> <li><a href="/wiki/Apache_Kafka" title="Apache Kafka">Kafka</a></li> <li><a href="/wiki/Apache_Kudu" title="Apache Kudu">Kudu</a></li> <li><a href="/wiki/Apache_Kylin" title="Apache Kylin">Kylin</a></li> <li><a href="/wiki/Apache_Lucene" title="Apache Lucene">Lucene</a></li> <li><a href="/wiki/Apache_Mahout" title="Apache Mahout">Mahout</a></li> <li><a href="/wiki/Apache_Maven" title="Apache Maven">Maven</a></li> <li><a href="/wiki/Apache_MINA" title="Apache MINA">MINA</a></li> <li><a href="/wiki/Mod_perl" title="Mod perl">mod_perl</a></li> <li><a href="/wiki/Apache_MyFaces" title="Apache MyFaces">MyFaces</a></li> <li><a href="/wiki/Apache_Mynewt" title="Apache Mynewt">Mynewt</a></li> <li><a href="/wiki/Apache_NiFi" title="Apache NiFi">NiFi</a></li> <li><a href="/wiki/NetBeans" title="NetBeans">NetBeans</a></li> <li><a href="/wiki/Apache_Nutch" title="Apache Nutch">Nutch</a></li> <li><a href="/wiki/NuttX" title="NuttX">NuttX</a></li> <li><a href="/wiki/Apache_OFBiz" title="Apache OFBiz">OFBiz</a></li> <li><a href="/wiki/Apache_Oozie" title="Apache Oozie">Oozie</a></li> <li><a href="/wiki/Apache_OpenEJB" title="Apache OpenEJB">OpenEJB</a></li> <li><a href="/wiki/Apache_OpenJPA" title="Apache OpenJPA">OpenJPA</a></li> <li><a href="/wiki/Apache_OpenNLP" title="Apache OpenNLP">OpenNLP</a></li> <li><a href="/wiki/Apache_OpenOffice" title="Apache OpenOffice">OрenOffice</a></li> <li><a href="/wiki/Apache_ORC" title="Apache ORC">ORC</a></li> <li><a href="/wiki/Apache_PDFBox" title="Apache PDFBox">PDFBox</a></li> <li><a href="/wiki/Apache_Parquet" title="Apache Parquet">Parquet</a></li> <li><a href="/wiki/Apache_Phoenix" title="Apache Phoenix">Phoenix</a></li> <li><a href="/wiki/Apache_POI" title="Apache POI">POI</a></li> <li><a href="/wiki/Apache_Pig" title="Apache Pig">Pig</a></li> <li><a href="/wiki/Apache_Pinot" title="Apache Pinot">Pinot</a></li> <li><a href="/wiki/Apache_Pivot" title="Apache Pivot">Pivot</a></li> <li><a href="/wiki/Apache_Qpid" title="Apache Qpid">Qpid</a></li> <li><a href="/wiki/Apache_Roller" title="Apache Roller">Roller</a></li> <li><a href="/wiki/Apache_RocketMQ" title="Apache RocketMQ">RocketMQ</a></li> <li><a href="/wiki/Apache_Samza" title="Apache Samza">Samza</a></li> <li><a href="/wiki/Apache_Shiro" title="Apache Shiro">Shiro</a></li> <li><a href="/wiki/Apache_SINGA" title="Apache SINGA">SINGA</a></li> <li><a href="/wiki/Apache_Sling" title="Apache Sling">Sling</a></li> <li><a href="/wiki/Apache_Solr" title="Apache Solr">Solr</a></li> <li><a href="/wiki/Apache_Spark" title="Apache Spark">Spark</a></li> <li><a href="/wiki/Apache_Storm" title="Apache Storm">Storm</a></li> <li><a href="/wiki/Apache_SpamAssassin" title="Apache SpamAssassin">SpamAssassin</a></li> <li><a href="/wiki/Apache_Struts" title="Apache Struts">Struts</a> <ul><li><a href="/wiki/Apache_Struts_1" title="Apache Struts 1">1</a></li></ul></li> <li><a href="/wiki/Apache_Subversion" title="Apache Subversion">Subversion</a></li> <li><a href="/wiki/Apache_Superset" title="Apache Superset">Superset</a></li> <li><a href="/wiki/Apache_SystemDS" title="Apache SystemDS">SystemDS</a></li> <li><a href="/wiki/Apache_Tapestry" title="Apache Tapestry">Tapestry</a></li> <li><a href="/wiki/Apache_Thrift" title="Apache Thrift">Thrift</a></li> <li><a href="/wiki/Apache_Tika" title="Apache Tika">Tika</a></li> <li><a href="/wiki/Apache_TinkerPop" class="mw-redirect" title="Apache TinkerPop">TinkerPop</a></li> <li><a href="/wiki/Apache_Tomcat" title="Apache Tomcat">Tomcat</a></li> <li><a href="/wiki/Apache_Trafodion" class="mw-redirect" title="Apache Trafodion">Trafodion</a></li> <li><a href="/wiki/Apache_Traffic_Server" title="Apache Traffic Server">Traffic Server</a></li> <li><a href="/wiki/UIMA" title="UIMA">UIMA</a></li> <li><a href="/wiki/Apache_Velocity" title="Apache Velocity">Velocity</a></li> <li><a href="/wiki/Apache_Wicket" title="Apache Wicket">Wicket</a></li> <li><a href="/wiki/Apache_Xalan" title="Apache Xalan">Xalan</a></li> <li><a href="/wiki/Apache_Xerces" title="Apache Xerces">Xerces</a></li> <li><a href="/wiki/Apache_XMLBeans" title="Apache XMLBeans">XMLBeans</a></li> <li>Yetus</li> <li><a href="/wiki/Apache_ZooKeeper" title="Apache ZooKeeper">ZooKeeper</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="/wiki/Apache_Commons" title="Apache Commons">Commons</a></th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Byte_Code_Engineering_Library" title="Byte Code Engineering Library">BCEL</a></li> <li><a href="/wiki/Bean_Scripting_Framework" title="Bean Scripting Framework">BSF</a></li> <li><a href="/wiki/Commons_Daemon" title="Commons Daemon">Daemon</a></li> <li><a href="/wiki/Apache_Jelly" title="Apache Jelly">Jelly</a></li> <li><a href="/wiki/Apache_Commons_Logging" title="Apache Commons Logging">Logging</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Incubator</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Apache_Taverna" title="Apache Taverna">Taverna</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Other projects</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Apache_Batik" title="Apache Batik">Batik</a></li> <li><a href="/wiki/Apache_FOP_(Formatting_Objects_Processor)" class="mw-redirect" title="Apache FOP (Formatting Objects Processor)">FOP</a></li> <li><a href="/wiki/Apache_Ivy" title="Apache Ivy">Ivy</a></li> <li><a href="/wiki/Log4j" title="Log4j">Log4j</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Attic</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Apache_Apex" title="Apache Apex">Apex</a></li> <li><a href="/wiki/AxKit" title="AxKit">AxKit</a></li> <li><a href="/wiki/Apache_Beehive" title="Apache Beehive">Beehive</a></li> <li><a href="/wiki/Apache_iBATIS" title="Apache iBATIS">iBATIS</a></li> <li><a href="/wiki/Apache_Click" title="Apache Click">Click</a></li> <li><a href="/wiki/Apache_Continuum" title="Apache Continuum">Continuum</a></li> <li><a href="/wiki/Deltacloud" title="Deltacloud">Deltacloud</a></li> <li><a href="/wiki/Etch_(protocol)" title="Etch (protocol)">Etch</a></li> <li><a href="/wiki/Apache_Giraph" title="Apache Giraph">Giraph</a></li> <li><a href="/wiki/Apache_Hama" title="Apache Hama">Hama</a></li> <li><a href="/wiki/Apache_Harmony" title="Apache Harmony">Harmony</a></li> <li><a href="/wiki/Jakarta_Project" title="Jakarta Project">Jakarta</a></li> <li><a href="/wiki/Apache_Marmotta" title="Apache Marmotta">Marmotta</a></li> <li><a href="/wiki/Apache_MXNet" title="Apache MXNet">MXNet</a></li> <li><a href="/wiki/Apache_ODE" title="Apache ODE">ODE</a></li> <li><a href="/wiki/Jini" title="Jini">River</a></li> <li><a href="/wiki/Apache_Shale" title="Apache Shale">Shale</a></li> <li><a href="/wiki/Jakarta_Slide" class="mw-redirect" title="Jakarta Slide">Slide</a></li> <li><a href="/wiki/Sqoop" title="Sqoop">Sqoop</a></li> <li><a href="/wiki/Apache_Stanbol" title="Apache Stanbol">Stanbol</a></li> <li><a href="/wiki/Apache_Tuscany" class="mw-redirect" title="Apache Tuscany">Tuscany</a></li> <li><a href="/wiki/Apache_Wave" class="mw-redirect" title="Apache Wave">Wave</a></li> <li><a href="/wiki/Apache_XML" title="Apache XML">XML</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Licenses</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Apache_License" title="Apache License">Apache License</a></li></ul> </div></td></tr><tr><td class="navbox-abovebelow" colspan="2"><div> <ul><li><span class="noviewer" typeof="mw:File"><span title="Category"><img alt="" src="//upload.wikimedia.org/wikipedia/en/thumb/9/96/Symbol_category_class.svg/16px-Symbol_category_class.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/9/96/Symbol_category_class.svg/23px-Symbol_category_class.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/9/96/Symbol_category_class.svg/31px-Symbol_category_class.svg.png 2x" data-file-width="180" data-file-height="185" /></span></span> <b><a href="/wiki/Category:Apache_Software_Foundation" title="Category:Apache Software Foundation">Category</a></b></li></ul> </div></td></tr></tbody></table></div> <div class="navbox-styles"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1129693374"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1236075235"></div><div role="navigation" class="navbox" aria-labelledby="Meta_Platforms" style="padding:3px"><table class="nowraplinks hlist mw-collapsible mw-collapsed navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1129693374"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1239400231"><div class="navbar plainlinks hlist navbar-mini"><ul><li class="nv-view"><a href="/wiki/Template:Meta_Platforms" title="Template:Meta Platforms"><abbr title="View this template">v</abbr></a></li><li class="nv-talk"><a href="/wiki/Template_talk:Meta_Platforms" title="Template talk:Meta Platforms"><abbr title="Discuss this template">t</abbr></a></li><li class="nv-edit"><a href="/wiki/Special:EditPage/Template:Meta_Platforms" title="Special:EditPage/Template:Meta Platforms"><abbr title="Edit this template">e</abbr></a></li></ul></div><div id="Meta_Platforms" style="font-size:114%;margin:0 4em"><a href="/wiki/Meta_Platforms" title="Meta Platforms">Meta Platforms</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Products<br />and services</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%"><a href="/wiki/Facebook" title="Facebook">Facebook</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Facebook" title="Facebook">Service</a></li> <li><a href="/wiki/List_of_Facebook_features" title="List of Facebook features">Features</a></li> <li><a href="/wiki/Facebook_Beacon" title="Facebook Beacon">Beacon</a></li> <li><a href="/wiki/Facebook_Bluetooth_Beacon" title="Facebook Bluetooth Beacon">Bluetooth Beacon</a></li> <li><a href="/wiki/Facebook_Credits" title="Facebook Credits">Credits</a></li> <li><a href="/wiki/Facebook_Dating" title="Facebook Dating">Dating</a></li> <li><a href="/wiki/EdgeRank" title="EdgeRank">EdgeRank</a></li> <li><a href="/wiki/Feed_(Facebook)" title="Feed (Facebook)">Feed</a></li> <li><a href="/wiki/List_of_Facebook_features#Facebook_Gaming" title="List of Facebook features">Gaming</a></li> <li><a href="/wiki/Facebook_Graph_Search" title="Facebook Graph Search">Graph Search</a></li> <li><a href="/wiki/Facebook_Instant_Articles" title="Facebook Instant Articles">Instant Articles</a></li> <li><a href="/wiki/Facebook_like_button" title="Facebook like button">Like button</a></li> <li><a href="/wiki/List_of_Facebook_features#Live_streaming" title="List of Facebook features">Live</a></li> <li><a href="/wiki/Lookalike_audience" title="Lookalike audience">Lookalike audience</a></li> <li><a href="/wiki/Facebook_onion_address" title="Facebook onion address">Onion address</a></li> <li><a href="/wiki/Facebook_Platform" title="Facebook Platform">Platform</a> <ul><li><a href="/wiki/Facebook_Platform#Facebook_Connect" title="Facebook Platform">Connect</a></li></ul></li> <li><a href="/wiki/Facebook_Safety_Check" title="Facebook Safety Check">Safety Check</a></li> <li><a href="/wiki/Facebook_Stories" title="Facebook Stories">Stories</a></li> <li><a href="/wiki/Facebook_Watch" title="Facebook Watch">Watch</a> <ul><li><a href="/wiki/List_of_Facebook_Watch_original_programming" title="List of Facebook Watch original programming">list of original programs</a></li></ul></li> <li><a href="/wiki/Facebook_Zero" title="Facebook Zero">Zero</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="/wiki/Instagram" title="Instagram">Instagram</a></th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Hyperlapse_(application)" title="Hyperlapse (application)">Hyperlapse</a></li> <li><a href="/wiki/IGTV" title="IGTV">IGTV</a></li> <li><a href="/wiki/List_of_most-followed_Instagram_accounts" title="List of most-followed Instagram accounts">List of most-followed accounts</a></li> <li><a href="/wiki/List_of_most-liked_Instagram_posts" title="List of most-liked Instagram posts">List of most-liked pictures</a></li> <li><a href="/wiki/Threads_(social_network)" title="Threads (social network)">Threads</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Hardware</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Meta_Portal" title="Meta Portal">Portal</a></li> <li><a href="/wiki/Meta_Quest" title="Meta Quest">Meta Quest</a> <ul><li><a href="/wiki/Oculus_Quest" title="Oculus Quest">Quest 1</a></li> <li><a href="/wiki/Quest_2" title="Quest 2">Quest 2</a></li> <li><a href="/wiki/Meta_Quest_3" title="Meta Quest 3">Quest 3</a></li> <li><a href="/wiki/Meta_Quest_Pro" title="Meta Quest Pro">Pro</a></li> <li><a href="/wiki/Oculus_Touch" title="Oculus Touch">Touch</a></li></ul></li> <li><a href="/wiki/Ray-Ban_Stories" class="mw-redirect" title="Ray-Ban Stories">Ray-Ban Stories</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Other</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Express_Wi-Fi" title="Express Wi-Fi">Express Wi-Fi</a></li> <li><a href="/wiki/Internet.org" title="Internet.org">Free Basics</a></li> <li><a href="/wiki/Messenger_(software)" title="Messenger (software)">Messenger</a> <ul><li><a href="/wiki/Messenger_Kids" title="Messenger Kids">Kids</a></li> <li><a href="/wiki/Messenger_(software)#Messenger_Rooms" title="Messenger (software)">Rooms</a></li></ul></li> <li><a href="/wiki/Mapillary" title="Mapillary">Mapillary</a></li> <li><a href="/wiki/Meta_AI" title="Meta AI">Meta AI</a></li> <li><a href="/wiki/Meta_Horizon_OS" title="Meta Horizon OS">Meta Horizon OS</a></li> <li><a href="/wiki/Within_(company)" title="Within (company)">Supernatural</a></li> <li><a href="/wiki/WhatsApp" title="WhatsApp">WhatsApp</a></li> <li><a href="/wiki/Workplace_(software)" title="Workplace (software)">Workplace</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Atlas_Solutions" title="Atlas Solutions">Atlas Solutions</a></li> <li><a href="/wiki/FriendFeed" title="FriendFeed">FriendFeed</a></li> <li><a href="/wiki/Giphy" title="Giphy">Giphy</a></li> <li><a href="/wiki/Facebook_Home" title="Facebook Home">Home</a> <ul><li><a href="/wiki/HTC_First" title="HTC First">HTC First</a></li></ul></li> <li><a href="/wiki/M_(virtual_assistant)" title="M (virtual assistant)">M</a></li> <li><a href="/wiki/Oculus_Go" title="Oculus Go">Oculus Go</a></li> <li><a href="/wiki/Oculus_Rift" title="Oculus Rift">Oculus Rift</a> <ul><li><a href="/wiki/Oculus_Rift_CV1" title="Oculus Rift CV1">CV1</a></li> <li><a href="/wiki/Oculus_Rift_S" title="Oculus Rift S">S</a></li></ul></li> <li><a href="/wiki/Onavo" title="Onavo">Onavo</a></li> <li><a href="/wiki/Facebook_Paper" title="Facebook Paper">Paper</a></li> <li><a href="/wiki/Facebook_Slingshot" title="Facebook Slingshot">Slingshot</a></li> <li><a href="/wiki/Tbh_(app)" class="mw-redirect" title="Tbh (app)">tbh</a></li> <li><a href="/wiki/Wirehog" title="Wirehog">Wirehog</a></li></ul> </div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">People</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Founders</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Mark_Zuckerberg" title="Mark Zuckerberg">Mark Zuckerberg</a> (28% equity)</li> <li><a href="/wiki/Dustin_Moskovitz" title="Dustin Moskovitz">Dustin Moskovitz</a> (7%)</li> <li><a href="/wiki/Eduardo_Saverin" title="Eduardo Saverin">Eduardo Saverin</a> (<i>5%, formerly</i>)</li> <li><a href="/wiki/Chris_Hughes" title="Chris Hughes">Chris Hughes</a> (<i>1%, formerly</i>)</li> <li><a href="/wiki/Andrew_McCollum" title="Andrew McCollum">Andrew McCollum</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Board</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Mark_Zuckerberg" title="Mark Zuckerberg">Mark Zuckerberg</a></li> <li><a href="/wiki/Marc_Andreessen" title="Marc Andreessen">Marc Andreessen</a></li> <li><a href="/wiki/John_D._Arnold" title="John D. Arnold">John D. Arnold</a></li> <li><a href="/wiki/Drew_Houston" title="Drew Houston">Drew Houston</a></li> <li><a href="/wiki/Nancy_Killefer" title="Nancy Killefer">Nancy Killefer</a></li> <li><a href="/wiki/Robert_M._Kimmitt" title="Robert M. Kimmitt">Robert M. Kimmitt</a></li> <li><a href="/wiki/Hock_Tan" title="Hock Tan">Hock Tan</a></li> <li><a href="/wiki/Tony_Xu" title="Tony Xu">Tony Xu</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Sheryl_Sandberg" title="Sheryl Sandberg">Sheryl Sandberg</a></li> <li><a href="/wiki/Peter_Thiel" title="Peter Thiel">Peter Thiel</a></li></ul> </div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Executive<br />officers</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Mark_Zuckerberg" title="Mark Zuckerberg">Mark Zuckerberg</a> (Chairman and CEO)</li> <li><a href="/wiki/Javier_Olivan" title="Javier Olivan">Javier Olivan</a> (COO)</li> <li><a href="/wiki/Andrew_Bosworth" title="Andrew Bosworth">Andrew Bosworth</a> (CTO)</li> <li><a href="/wiki/Chris_Cox_(manager)" title="Chris Cox (manager)">Chris Cox</a> (CPO)</li> <li><a href="/wiki/Nick_Clegg" title="Nick Clegg">Nick Clegg</a> (President of Global Affairs)</li> <li><a href="/wiki/Jennifer_Gillian_Newstead" title="Jennifer Gillian Newstead">Jennifer Newstead</a> (Chief Legal Officer)</li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Sean_Parker" title="Sean Parker">Sean Parker</a> (<i>4%, formerly</i>)</li> <li><a href="/wiki/Owen_Van_Natta" title="Owen Van Natta">Owen Van Natta</a></li> <li><a href="/wiki/Gideon_Yu" title="Gideon Yu">Gideon Yu</a></li> <li><a href="/wiki/Adam_D%27Angelo" title="Adam D'Angelo">Adam D'Angelo</a></li> <li><a href="/wiki/Chris_Kelly_(entrepreneur)" title="Chris Kelly (entrepreneur)">Chris Kelly</a></li> <li><a href="/wiki/Bret_Taylor" title="Bret Taylor">Bret Taylor</a></li> <li><a href="/wiki/Sheryl_Sandberg" title="Sheryl Sandberg">Sheryl Sandberg</a></li> <li><a href="/wiki/Mike_Schroepfer" title="Mike Schroepfer">Mike Schroepfer</a></li> <li><a href="/wiki/David_Wehner" title="David Wehner">David Wehner</a></li> <li><a href="/wiki/David_Ebersman" title="David Ebersman">David Ebersman</a></li> <li><a href="/wiki/Marne_Levine" title="Marne Levine">Marne Levine</a></li> <li><a href="/wiki/Alex_Stamos" title="Alex Stamos">Alex Stamos</a></li></ul> </div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="/wiki/Oversight_Board_(Meta)" title="Oversight Board (Meta)">Oversight<br />Board</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Members</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Catalina_Botero_Marino" title="Catalina Botero Marino">Catalina Botero Marino</a>, Co-Chair (2020–)</li> <li><a href="/wiki/Jamal_Greene" title="Jamal Greene">Jamal Greene</a>, Co-Chair (2020–)</li> <li><a href="/wiki/Michael_W._McConnell" title="Michael W. McConnell">Michael W. McConnell</a>, Co-Chair (2020–)</li> <li><a href="/wiki/Helle_Thorning-Schmidt" title="Helle Thorning-Schmidt">Helle Thorning-Schmidt</a>, Co-Chair (2020–)</li> <li><a href="/wiki/Afia_Asantewaa_Asare-Kyei" title="Afia Asantewaa Asare-Kyei">Afia Asantewaa Asare-Kyei</a> (2020–)</li> <li><a href="/wiki/Evelyn_Aswad" title="Evelyn Aswad">Evelyn Aswad</a> (2020–)</li> <li><a href="/wiki/Endy_Bayuni" title="Endy Bayuni">Endy Bayuni</a> (2020–)</li> <li><a href="/wiki/Katherine_Chen" title="Katherine Chen">Katherine Chen</a> (2020–)</li> <li><a href="/wiki/Nighat_Dad" title="Nighat Dad">Nighat Dad</a> (2020–)</li> <li><a href="/wiki/Tawakkol_Karman" title="Tawakkol Karman">Tawakkol Karman</a> (2020–)</li> <li><a href="/wiki/Maina_Kiai" title="Maina Kiai">Maina Kiai</a> (2020–)</li> <li><a href="/wiki/Sudhir_Krishnaswamy" title="Sudhir Krishnaswamy">Sudhir Krishnaswamy</a> (2020–)</li> <li><a href="/wiki/Ronaldo_Lemos" title="Ronaldo Lemos">Ronaldo Lemos</a> (2020–)</li> <li><a href="/wiki/Julie_Owono" title="Julie Owono">Julie Owono</a> (2020–)</li> <li><a href="/wiki/Emi_Palmor" title="Emi Palmor">Emi Palmor</a> (2020–)</li> <li><a href="/wiki/Alan_Rusbridger" title="Alan Rusbridger">Alan Rusbridger</a> (2020–)</li> <li><a href="/wiki/Andr%C3%A1s_Saj%C3%B3" title="András Sajó">András Sajó</a> (2020–)</li> <li><a href="/wiki/John_Samples" title="John Samples">John Samples</a> (2020–)</li> <li>Nicolas Suzor (2020–)</li> <li><a href="/wiki/Suzanne_Nossel" title="Suzanne Nossel">Suzanne Nossel</a> (2021–)</li> <li>Khaled Mansour (2022–)</li> <li>Pamela San Martin (2022–)</li> <li>Paolo Carozza (2022–)</li> <li><a href="/wiki/Kenji_Yoshino" title="Kenji Yoshino">Kenji Yoshino</a> (2023–)</li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Board of<br />Trustees</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Stephen_Neal_(lawyer)" title="Stephen Neal (lawyer)">Stephen Neal</a>, Chair (2021–)</li> <li>Kristina Arriaga (2020–)</li> <li>Cherine Chalaby (2020–)</li> <li>Wanda Felton (2020–)</li> <li><a href="/wiki/Kate_O%27Regan" title="Kate O'Regan">Kate O'Regan</a> (2020–)</li> <li><a href="/wiki/Robert_Post_(law_professor)" title="Robert Post (law professor)">Robert Post</a> (2020–)</li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former<br />members</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Pamela_S._Karlan" title="Pamela S. Karlan">Pamela S. Karlan</a> (Board Member, 2020–2021)</li> <li><a href="/wiki/Paul_G._Haaga_Jr." title="Paul G. Haaga Jr.">Paul G. Haaga Jr.</a> (Board of Trustees Chair, 2020–2021)</li></ul> </div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Notable<br />employees</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Lars_Rasmussen_(software_developer)" title="Lars Rasmussen (software developer)">Lars Rasmussen</a> (Graph Search director)</li> <li><a href="/wiki/Naomi_Gleit" title="Naomi Gleit">Naomi Gleit</a> (VP of social good)</li> <li><a href="/wiki/Nicola_Mendelsohn" title="Nicola Mendelsohn">Nicola Mendelsohn</a> (head of Global Business Group)</li> <li><a href="/wiki/Adam_Mosseri" title="Adam Mosseri">Adam Mosseri</a> (head of Instagram)</li> <li><a href="/wiki/Thomas_Reardon" title="Thomas Reardon">Thomas Reardon</a> (<a href="/wiki/Reality_Labs" title="Reality Labs">Reality Labs</a> director)</li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Blake_Ross" title="Blake Ross">Blake Ross</a> (Director of Product)</li> <li><a href="/wiki/Ted_Ullyot" title="Ted Ullyot">Ted Ullyot</a> (VP, General Counsel, and Secretary)</li> <li><a href="/wiki/Hugo_Barra" title="Hugo Barra">Hugo Barra</a> (VP of <a href="/wiki/Reality_Labs" title="Reality Labs">Reality Labs</a>)</li> <li><a href="/wiki/John_Carmack" title="John Carmack">John Carmack</a> (CTO of <a href="/wiki/Reality_Labs" title="Reality Labs">Reality Labs</a>)</li> <li><a href="/wiki/Matt_Cohler" title="Matt Cohler">Matt Cohler</a></li> <li><a href="/wiki/Charlie_Cheever" title="Charlie Cheever">Charlie Cheever</a></li> <li><a href="/wiki/Randi_Zuckerberg" title="Randi Zuckerberg">Randi Zuckerberg</a></li> <li><a href="/wiki/Yishan_Wong" title="Yishan Wong">Yishan Wong</a></li> <li><a href="/wiki/George_Hotz" title="George Hotz">George Hotz</a></li> <li><a href="/wiki/Joe_Lockhart" title="Joe Lockhart">Joe Lockhart</a></li> <li><a href="/wiki/Andrei_Alexandrescu" title="Andrei Alexandrescu">Andrei Alexandrescu</a> (research scientist)</li> <li><a href="/wiki/Chamath_Palihapitiya" title="Chamath Palihapitiya">Chamath Palihapitiya</a> (VP of User Growth)</li> <li><a href="/wiki/Elliot_Schrage" title="Elliot Schrage">Elliot Schrage</a> (VP of Global Communications, Marketing and Public Policy)</li> <li><a href="/wiki/Frances_Haugen" title="Frances Haugen">Frances Haugen</a> (Product Manager of Civic Integrity Team)</li></ul> </div></td></tr></tbody></table><div></div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Open source</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Apache_Cassandra" title="Apache Cassandra">Apache Cassandra</a></li> <li><a class="mw-selflink selflink">Apache Hive</a></li> <li><a href="/wiki/Apache_Thrift" title="Apache Thrift">Apache Thrift</a></li> <li><a href="/wiki/Buck_(software)" title="Buck (software)">Buck</a></li> <li><a href="/wiki/Facebook_Query_Language" title="Facebook Query Language">FQL</a></li> <li><a href="/wiki/Hack_(programming_language)" title="Hack (programming language)">Hack</a></li> <li><a href="/wiki/HHVM" title="HHVM">HHVM</a></li> <li><a href="/wiki/HipHop_for_PHP" title="HipHop for PHP">HipHop for PHP</a></li> <li><a href="/wiki/Infer_Static_Analyzer" title="Infer Static Analyzer">Infer</a></li> <li><a href="/wiki/MyRocks" title="MyRocks">MyRocks</a></li> <li><a href="/wiki/Open_Compute_Project" title="Open Compute Project">Open Compute Project</a></li> <li><a href="/wiki/Phabricator" title="Phabricator">Phabricator</a></li> <li><a href="/wiki/React_(software)" title="React (software)">React</a></li> <li><a href="/wiki/React_Native" title="React Native">React Native</a></li> <li><a href="/wiki/RocksDB" title="RocksDB">RocksDB</a></li> <li><a href="/wiki/Scribe_(log_server)" title="Scribe (log server)">Scribe</a></li> <li><a href="/wiki/Telecom_Infra_Project" title="Telecom Infra Project">Telecom Infra Project</a></li> <li><a href="/wiki/Tornado_(web_server)" title="Tornado (web server)">Tornado</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Mass media</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><i><a href="/wiki/The_Facebook_Effect" title="The Facebook Effect">The Facebook Effect</a></i></li> <li><i><a href="/wiki/The_Accidental_Billionaires" title="The Accidental Billionaires">The Accidental Billionaires</a></i></li> <li><i><a href="/wiki/The_Social_Network" title="The Social Network">The Social Network</a></i></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Concepts</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Activity_stream" title="Activity stream">Activity stream</a></li> <li><a href="/wiki/Social_graph" title="Social graph">Social graph</a></li> <li><a href="/wiki/Friending_and_following" title="Friending and following">Friending and following</a></li> <li><a href="/wiki/Reblogging" title="Reblogging">Reblogging</a></li> <li><a href="/wiki/Fan-gating" title="Fan-gating">Fan-gating</a></li> <li><a href="/wiki/Digital_diplomacy#Facebook_diplomacy" title="Digital diplomacy">Facebook diplomacy</a></li> <li><a href="/wiki/Facebook_like_button" title="Facebook like button">Facebook like button</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Business</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/History_of_Facebook" title="History of Facebook">History of Facebook</a></li> <li><a href="/wiki/Timeline_of_Instagram" title="Timeline of Instagram">Timeline of Instagram</a></li> <li><a href="/wiki/Timeline_of_WhatsApp" title="Timeline of WhatsApp">Timeline of WhatsApp</a></li> <li><a href="/wiki/List_of_mergers_and_acquisitions_by_Meta_Platforms" title="List of mergers and acquisitions by Meta Platforms">Acquisitions</a></li> <li><a href="/wiki/Facebook_F8" title="Facebook F8">f8 conference</a></li> <li><a href="/wiki/Initial_public_offering_of_Facebook" title="Initial public offering of Facebook">IPO</a></li> <li><a href="/wiki/Censorship_of_Facebook" title="Censorship of Facebook">Censorship</a></li> <li><a href="/wiki/Criticism_of_Facebook" title="Criticism of Facebook">Criticism</a> <ul><li><a href="/wiki/Facebook%E2%80%93Cambridge_Analytica_data_scandal" title="Facebook–Cambridge Analytica data scandal">Cambridge Analytica data scandal</a></li> <li><a href="/wiki/2020_Facebook_ad_boycotts" title="2020 Facebook ad boycotts">2020 ad boycotts</a></li> <li><a href="/wiki/2021_Facebook_leak" title="2021 Facebook leak">2021 company files leak</a></li> <li><a href="/wiki/Privacy_concerns_with_Facebook" title="Privacy concerns with Facebook">Privacy</a></li> <li><a href="/wiki/Facebook_content_management_controversies" title="Facebook content management controversies">Content management</a></li></ul></li> <li><a href="/wiki/Lawsuits_involving_Meta_Platforms" title="Lawsuits involving Meta Platforms">Litigation</a></li> <li><i><a href="/wiki/Young_v._Facebook,_Inc." title="Young v. Facebook, Inc.">Young v. Facebook, Inc.</a></i> (2011)</li> <li><i><a href="/wiki/Fraley_v._Facebook,_Inc." title="Fraley v. Facebook, Inc.">Fraley v. Facebook, Inc.</a></i> (2016)</li> <li><i><a href="/wiki/Force_v._Facebook,_Inc." title="Force v. Facebook, Inc.">Force v. Facebook, Inc.</a></i> (2019)</li> <li><i><a href="/wiki/Facebook,_Inc._v._Duguid" title="Facebook, Inc. v. Duguid">Facebook, Inc. v. Duguid</a></i> (2021)</li> <li><i><a href="/wiki/Federal_Trade_Commission_v._Meta_Platforms,_Inc." title="Federal Trade Commission v. Meta Platforms, Inc.">Federal Trade Commission v. Meta Platforms, Inc.</a></i> (ongoing)</li> <li><a href="/wiki/Meta_and_unions" title="Meta and unions">unionization</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Lists</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/List_of_most-followed_Facebook_pages" title="List of most-followed Facebook pages">Most-followed Facebook pages</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Related</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"> <ul><li><a href="/wiki/Priscilla_Chan" title="Priscilla Chan">Priscilla Chan</a> (wife of Mark Zuckerberg)</li> <li><a href="/wiki/Chan_Zuckerberg_Initiative" title="Chan Zuckerberg Initiative">Chan Zuckerberg Initiative</a></li> <li><a href="/wiki/Facebook_Aquila" title="Facebook Aquila">Aquila Internet relay drone</a></li> <li><a href="/wiki/Willow_Village" title="Willow Village">Willow Village</a></li> <li><a href="/wiki/WaveGroup_Sound" title="WaveGroup Sound">WaveGroup Sound</a></li> <li><a href="/wiki/2021_Facebook_outage" title="2021 Facebook outage">2021 Facebook outage</a></li></ul> </div></td></tr></tbody></table></div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://en.wikipedia.org/w/index.php?title=Apache_Hive&oldid=1232204991">https://en.wikipedia.org/w/index.php?title=Apache_Hive&oldid=1232204991</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Help:Category" title="Help:Category">Categories</a>: <ul><li><a href="/wiki/Category:2015_software" title="Category:2015 software">2015 software</a></li><li><a href="/wiki/Category:Apache_Software_Foundation_projects" title="Category:Apache Software Foundation projects">Apache Software Foundation projects</a></li><li><a href="/wiki/Category:Cloud_computing" title="Category:Cloud computing">Cloud computing</a></li><li><a href="/wiki/Category:Facebook_software" title="Category:Facebook software">Facebook software</a></li><li><a href="/wiki/Category:Free_software_programmed_in_Java_(programming_language)" title="Category:Free software programmed in Java (programming language)">Free software programmed in Java (programming language)</a></li><li><a href="/wiki/Category:Free_system_software" title="Category:Free system software">Free system software</a></li><li><a href="/wiki/Category:Hadoop" title="Category:Hadoop">Hadoop</a></li><li><a href="/wiki/Category:Software_using_the_Apache_license" title="Category:Software using the Apache license">Software using the Apache license</a></li></ul></div><div id="mw-hidden-catlinks" class="mw-hidden-catlinks mw-hidden-cats-hidden">Hidden categories: <ul><li><a href="/wiki/Category:CS1_maint:_multiple_names:_authors_list" title="Category:CS1 maint: multiple names: authors list">CS1 maint: multiple names: authors list</a></li><li><a href="/wiki/Category:Articles_with_short_description" title="Category:Articles with short description">Articles with short description</a></li><li><a href="/wiki/Category:Short_description_matches_Wikidata" title="Category:Short description matches Wikidata">Short description matches Wikidata</a></li><li><a href="/wiki/Category:Articles_with_a_promotional_tone_from_October_2019" title="Category:Articles with a promotional tone from October 2019">Articles with a promotional tone from October 2019</a></li><li><a href="/wiki/Category:All_articles_with_a_promotional_tone" title="Category:All articles with a promotional tone">All articles with a promotional tone</a></li><li><a href="/wiki/Category:Articles_needing_additional_references_from_May_2023" title="Category:Articles needing additional references from May 2023">Articles needing additional references from May 2023</a></li><li><a href="/wiki/Category:All_articles_needing_additional_references" title="Category:All articles needing additional references">All articles needing additional references</a></li><li><a href="/wiki/Category:Articles_with_multiple_maintenance_issues" title="Category:Articles with multiple maintenance issues">Articles with multiple maintenance issues</a></li><li><a href="/wiki/Category:Articles_needing_cleanup_from_October_2016" title="Category:Articles needing cleanup from October 2016">Articles needing cleanup from October 2016</a></li><li><a href="/wiki/Category:All_pages_needing_cleanup" title="Category:All pages needing cleanup">All pages needing cleanup</a></li><li><a href="/wiki/Category:Articles_with_sections_that_need_to_be_turned_into_prose_from_October_2016" title="Category:Articles with sections that need to be turned into prose from October 2016">Articles with sections that need to be turned into prose from October 2016</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 2 July 2024, at 14:27<span class="anonymous-show"> (UTC)</span>.</li> <li id="footer-info-copyright">Text is available under the <a href="/wiki/Wikipedia:Text_of_the_Creative_Commons_Attribution-ShareAlike_4.0_International_License" title="Wikipedia:Text of the Creative Commons Attribution-ShareAlike 4.0 International License">Creative Commons Attribution-ShareAlike 4.0 License</a>; additional terms may apply. By using this site, you agree to the <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use" class="extiw" title="foundation:Special:MyLanguage/Policy:Terms of Use">Terms of Use</a> and <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy" class="extiw" title="foundation:Special:MyLanguage/Policy:Privacy policy">Privacy Policy</a>. Wikipedia® is a registered trademark of the <a rel="nofollow" class="external text" href="https://wikimediafoundation.org/">Wikimedia Foundation, Inc.</a>, a non-profit organization.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Wikipedia:About">About Wikipedia</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Wikipedia:General_disclaimer">Disclaimers</a></li> <li id="footer-places-contact"><a href="//en.wikipedia.org/wiki/Wikipedia:Contact_us">Contact Wikipedia</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/en.wikipedia.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//en.m.wikipedia.org/w/index.php?title=Apache_Hive&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-f69cdc8f6-rqr4k","wgBackendResponseTime":146,"wgPageParseReport":{"limitreport":{"cputime":"0.580","walltime":"0.766","ppvisitednodes":{"value":3523,"limit":1000000},"postexpandincludesize":{"value":184615,"limit":2097152},"templateargumentsize":{"value":12670,"limit":2097152},"expansiondepth":{"value":27,"limit":100},"expensivefunctioncount":{"value":15,"limit":500},"unstrip-depth":{"value":1,"limit":20},"unstrip-size":{"value":119202,"limit":5000000},"entityaccesscount":{"value":1,"limit":400},"timingprofile":["100.00% 614.057 1 -total"," 32.40% 198.955 1 Template:Reflist"," 19.88% 122.102 2 Template:Infobox"," 19.56% 120.096 8 Template:Navbox"," 18.83% 115.609 14 Template:Cite_web"," 15.56% 95.572 1 Template:Infobox_software"," 15.53% 95.380 1 Template:Multiple_issues"," 14.98% 91.966 1 Template:Apache_Software_Foundation"," 11.53% 70.794 1 Template:Short_description"," 11.52% 70.711 3 Template:Ambox"]},"scribunto":{"limitreport-timeusage":{"value":"0.318","limit":"10.000"},"limitreport-memusage":{"value":6901783,"limit":52428800}},"cachereport":{"origin":"mw-api-int.codfw.main-849f99967d-nrgnf","timestamp":"20241124121308","ttl":2592000,"transientcontent":false}}});});</script> <script type="application/ld+json">{"@context":"https:\/\/schema.org","@type":"Article","name":"Apache Hive","url":"https:\/\/en.wikipedia.org\/wiki\/Apache_Hive","sameAs":"http:\/\/www.wikidata.org\/entity\/Q4778914","mainEntity":"http:\/\/www.wikidata.org\/entity\/Q4778914","author":{"@type":"Organization","name":"Contributors to Wikimedia projects"},"publisher":{"@type":"Organization","name":"Wikimedia Foundation, Inc.","logo":{"@type":"ImageObject","url":"https:\/\/www.wikimedia.org\/static\/images\/wmf-hor-googpub.png"}},"datePublished":"2010-12-30T18:01:13Z","dateModified":"2024-07-02T14:27:47Z","image":"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/b\/bb\/Apache_Hive_logo.svg","headline":"database engine"}</script> </body> </html>