The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.
The driver for Hive / SparkSQL is deprecated and will be removed in a future
release. It is community-supported and is not maintained by Cube or the database
vendor.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Cube Documentation","colors":{"primary":"#5339CF","light":"#A5A3FF","dark":"#716EEE"},"logo":{"light":"https://mintcdn.com/cubed3/wCTntgEXVYYYnx4l/logo/light.svg?fit=max\u0026auto=format\u0026n=wCTntgEXVYYYnx4l\u0026q=85\u0026s=8bbf45ba64eac6116629064fac55aad7","dark":"https://mintcdn.com/cubed3/wCTntgEXVYYYnx4l/logo/dark.svg?fit=max\u0026auto=format\u0026n=wCTntgEXVYYYnx4l\u0026q=85\u0026s=d8fa230950c8c63b3c2f88d2768694d0"},"favicon":"https://mintcdn.com/cubed3/wCTntgEXVYYYnx4l/favicon.svg?fit=max\u0026auto=format\u0026n=wCTntgEXVYYYnx4l\u0026q=85\u0026s=3b0cb7aa770d2abd546ef19463fbba8c","navbar":{"links":[{"href":"https://cube.dev/demos","label":"Demos"},{"href":"https://cube.dev/changelog","label":"Changelog"},{"href":"https://slack.cube.dev","label":"Community"}],"primary":{"type":"button","label":"Get Started","href":"https://cubecloud.dev/auth/signup"}},"footer":{"socials":{"x":"https://x.com/the_cube_dev","github":"https://github.com/cube-js/cube","linkedin":"https://www.linkedin.com/company/cube-dev"},"links":[{"header":"Legal","items":[{"label":"Privacy Policy","href":"https://cube.dev/legal/privacy-policy"},{"label":"Cookie Preferences","href":"#cookie-preferences"}]}]},"seo":{"metatags":{"og:type":"website","og:site_name":"Cube Documentation"},"indexing":"navigable"},"icons":{"library":"tabler"},"styling":{"codeblocks":"dark","latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"cubed3","hasAudioNarration":false,"actualSubdomain":"cubed3","customDomains":["docs.cube.dev"],"gitSource":{"type":"github","owner":"cube-js","repo":"cube","deployBranch":"master","contentDirectory":"docs-mintlify","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6aff77fbb5f9972b85a20c09","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"default","tag":"API","count":238},{"language":"default","tag":"Platform Endpoints","count":231},{"language":"default","tag":"Documentation","count":101},{"language":"default","tag":"Admin","count":95},{"language":"default","tag":"Data Modeling","count":65},{"language":"default","tag":"Recipes","count":47},{"language":"default","tag":"Topics","count":47},{"language":"default","tag":"Reference","count":44},{"language":"default","tag":"Connect to data","count":31},{"language":"default","tag":"Explore \u0026 Analyze","count":30}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"#content-area table,.mdx-content table{width:100%!important}.cube-consent{position:fixed;right:16px;bottom:16px;z-index:2147483000;box-sizing:border-box;display:flex;flex-direction:column;gap:8px;width:min(440px, calc(100vw - 32px));padding:16px;background:#fff;color:#111827;border:1px solid #e5e7eb;border-radius:8px;box-shadow:0 8px 24px rgb(0 0 0 / 12%);font-size:14px;line-height:1.5}html.dark .cube-consent{background:#111318;color:#f3f4f6;border-color:#2b2f38}.cube-consent__title{margin:0;padding-right:24px;font-size:16px;font-weight:600}.cube-consent__text,.cube-consent__status{margin:0;color:#4b5563}html.dark .cube-consent__text,html.dark .cube-consent__status{color:#b6bcc8}.cube-consent__link{color:inherit;text-decoration:underline}.cube-consent__actions{display:flex;gap:8px}.cube-consent__button{flex:1;padding:8px 16px;border:1px solid #111827;border-radius:6px;background:#111827;color:#fff;font:inherit;font-weight:500;cursor:pointer}html.dark .cube-consent__button{border-color:#f3f4f6;background:#f3f4f6;color:#111318}.cube-consent__button:hover{opacity:0.88}.cube-consent__button:focus-visible,.cube-consent__close:focus-visible,.cube-consent__link:focus-visible{outline:2px solid #111827;outline-offset:2px}html.dark .cube-consent :focus-visible{outline-color:#f3f4f6}.cube-consent__close{position:absolute;top:8px;right:8px;width:24px;height:24px;padding:0;border:0;background:transparent;color:inherit;font-size:20px;line-height:1;cursor:pointer}"}]}
{"page":{"pagePath":"admin/connect-to-data/data-sources/hive","slug":"/admin/connect-to-data/data-sources/hive","pageMetadata":{"title":"Hive / SparkSQL","description":"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.","href":"/admin/connect-to-data/data-sources/hive"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,p:`p`,pre:`pre`,span:`span`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Warning,{children:_jsx(_components.p,{children:`The driver for Hive / SparkSQL is deprecated and will be removed in a future\nrelease. It is community-supported and is not maintained by Cube or the database\nvendor.`})}),`\n`,_jsx(Heading,{level:`2`,id:`prerequisites`,children:`Prerequisites`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`The hostname for the `,_jsx(_components.a,{href:`https://hive.apache.org/`,children:`Hive`}),` database server`]}),`\n`,_jsxs(_components.li,{children:[`The username/password for the `,_jsx(_components.a,{href:`https://hive.apache.org/`,children:`Hive`}),` database server`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`setup`,children:`Setup`}),`\n`,_jsx(Heading,{level:`3`,id:`manual`,children:`Manual`}),`\n`,_jsxs(_components.p,{children:[`Add the following to a `,_jsx(_components.code,{children:`.env`}),` file in your Cube project:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`5`,language:`dotenv`,children:_jsx(_components.pre,{className:`shiki shiki-themes dark-plus dark-plus`,style:{backgroundColor:`#0B0C0E`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#D4D4D4`,\"--shiki-dark\":`#D4D4D4`},language:`dotenv`,children:_jsxs(_components.code,{language:`dotenv`,numberOfLines:`5`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#9CDCFE`,\"--shiki-dark\":`#9CDCFE`},children:`CUBEJS_DB_TYPE`}),_jsx(_components.span,{style:{color:`#D4D4D4`,\"--shiki-dark\":`#D4D4D4`},children:`=hive`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#9CDCFE`,\"--shiki-dark\":`#9CDCFE`},children:`CUBEJS_DB_HOST`}),_jsx(_components.span,{style:{color:`#D4D4D4`,\"--shiki-dark\":`#D4D4D4`},children:`=my.hive.host`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#9CDCFE`,\"--shiki-dark\":`#9CDCFE`},children:`CUBEJS_DB_NAME`}),_jsx(_components.span,{style:{color:`#D4D4D4`,\"--shiki-dark\":`#D4D4D4`},children:`=my_hive_database`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#9CDCFE`,\"--shiki-dark\":`#9CDCFE`},children:`CUBEJS_DB_USER`}),_jsx(_components.span,{style:{color:`#D4D4D4`,\"--shiki-dark\":`#D4D4D4`},children:`=hive_user`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#9CDCFE`,\"--shiki-dark\":`#9CDCFE`},children:`CUBEJS_DB_PASS`}),_jsx(_components.span,{style:{color:`#D4D4D4`,\"--shiki-dark\":`#D4D4D4`},children:`=**********`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`environment-variables`,children:`Environment Variables`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Environment Variable`}),_jsx(_components.th,{children:`Description`}),_jsx(_components.th,{children:`Possible Values`}),_jsx(_components.th,{style:{textAlign:`center`},children:`Required`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_host`,children:_jsx(_components.code,{children:`CUBEJS_DB_HOST`})})}),_jsx(_components.td,{children:`The host URL for a database`}),_jsx(_components.td,{children:`A valid database host URL`}),_jsx(_components.td,{style:{textAlign:`center`},children:`✅`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_port`,children:_jsx(_components.code,{children:`CUBEJS_DB_PORT`})})}),_jsx(_components.td,{children:`The port for the database connection`}),_jsx(_components.td,{children:`A valid port number`}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_name`,children:_jsx(_components.code,{children:`CUBEJS_DB_NAME`})})}),_jsx(_components.td,{children:`The name of the database to connect to`}),_jsx(_components.td,{children:`A valid database name`}),_jsx(_components.td,{style:{textAlign:`center`},children:`✅`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_user`,children:_jsx(_components.code,{children:`CUBEJS_DB_USER`})})}),_jsx(_components.td,{children:`The username used to connect to the database`}),_jsx(_components.td,{children:`A valid database username`}),_jsx(_components.td,{style:{textAlign:`center`},children:`✅`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_pass`,children:_jsx(_components.code,{children:`CUBEJS_DB_PASS`})})}),_jsx(_components.td,{children:`The password used to connect to the database`}),_jsx(_components.td,{children:`A valid database password`}),_jsx(_components.td,{style:{textAlign:`center`},children:`✅`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_hive_type`,children:_jsx(_components.code,{children:`CUBEJS_DB_HIVE_TYPE`})})}),_jsx(_components.td,{}),_jsx(_components.td,{}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_hive_ver`,children:_jsx(_components.code,{children:`CUBEJS_DB_HIVE_VER`})})}),_jsx(_components.td,{}),_jsx(_components.td,{}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_hive_thrift_ver`,children:_jsx(_components.code,{children:`CUBEJS_DB_HIVE_THRIFT_VER`})})}),_jsx(_components.td,{}),_jsx(_components.td,{}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_hive_cdh_ver`,children:_jsx(_components.code,{children:`CUBEJS_DB_HIVE_CDH_VER`})})}),_jsx(_components.td,{}),_jsx(_components.td,{}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_db_max_pool`,children:_jsx(_components.code,{children:`CUBEJS_DB_MAX_POOL`})})}),_jsxs(_components.td,{children:[`The maximum number of concurrent database connections to pool. Default is `,_jsx(_components.code,{children:`8`})]}),_jsx(_components.td,{children:`A valid number`}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/reference/configuration/environment-variables#cubejs_concurrency`,children:_jsx(_components.code,{children:`CUBEJS_CONCURRENCY`})})}),_jsxs(_components.td,{children:[`The number of `,_jsx(_components.a,{href:`/admin/connect-to-data/concurrency#data-source-concurrency`,children:`concurrent queries`}),` to the data source`]}),_jsx(_components.td,{children:`A valid number`}),_jsx(_components.td,{style:{textAlign:`center`},children:`❌`})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"codeStyling":"dark","config":{},"pageMetadata":{"title":"Hive / SparkSQL","description":"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.","href":"/admin/connect-to-data/data-sources/hive"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Prerequisites","slug":"prerequisites","depth":2,"children":[]},{"title":"Setup","slug":"setup","depth":2,"children":[{"title":"Manual","slug":"manual","depth":3,"children":[]}]},{"title":"Environment Variables","slug":"environment-variables","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/cubed3/73c42f6b43b9b3b0/scripts/extract-chat.js","/_mintlify/custom/cubed3/08d502537a7bd0d7/scripts/extract-core-data.js","/_mintlify/custom/cubed3/476a9fa93e98d93b/consent.js"],"subdomain":"cubed3","siteName":"Cube Documentation","title":"Hive / SparkSQL - Cube Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-12T14:11:50.857Z","originalFileLocation":"admin/connect-to-data/data-sources/hive.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Cube Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Hive / SparkSQL - Cube Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Cube Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://cubed3.mintlify.site/_mintlify/api/og/v2?division=Data+Sources\u0026amp;title=Hive+%2F+SparkSQL\u0026amp;description=The+driver+for+Hive+%2F+SparkSQL+is+deprecated+and+community-supported%2C+and+is+not+maintained+by+Cube+or+the+database+vendor.\u0026amp;theme=6d1e003873cec4de62649d7c\u0026amp;signature=07b36c79832b393126794c23758ad45c74b7cceaa697fb5c965e02517e32e943\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Hive / SparkSQL - Cube Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://cubed3.mintlify.site/_mintlify/api/og/v2?division=Data+Sources\u0026amp;title=Hive+%2F+SparkSQL\u0026amp;description=The+driver+for+Hive+%2F+SparkSQL+is+deprecated+and+community-supported%2C+and+is+not+maintained+by+Cube+or+the+database+vendor.\u0026amp;theme=6d1e003873cec4de62649d7c\u0026amp;signature=07b36c79832b393126794c23758ad45c74b7cceaa697fb5c965e02517e32e943\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Cube Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#5339CF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/admin/connect-to-data/data-sources/hive.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.cube.dev/#organization\",\"name\":\"Cube Documentation\",\"url\":\"https://docs.cube.dev\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/cubed3/wCTntgEXVYYYnx4l/logo/light.svg?fit=max\u0026auto=format\u0026n=wCTntgEXVYYYnx4l\u0026q=85\u0026s=8bbf45ba64eac6116629064fac55aad7\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.cube.dev#website\",\"name\":\"Cube Documentation\",\"url\":\"https://docs.cube.dev\",\"publisher\":{\"@id\":\"https://docs.cube.dev/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive#webpage\",\"url\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive\",\"name\":\"Hive / SparkSQL\",\"description\":\"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.\",\"dateModified\":\"2026-11-12T14:11:50.857Z\",\"isPartOf\":{\"@id\":\"https://docs.cube.dev#website\"},\"breadcrumb\":{\"@id\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Connect to data\",\"item\":\"https://docs.cube.dev/admin/connect-to-data\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Sources\",\"item\":\"https://docs.cube.dev/admin/connect-to-data/data-sources\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Hive / SparkSQL\",\"item\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive#article\",\"headline\":\"Hive / SparkSQL\",\"name\":\"Hive / SparkSQL\",\"description\":\"The driver for Hive / SparkSQL is deprecated and community-supported, and is not maintained by Cube or the database vendor.\",\"url\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive\",\"mainEntityOfPage\":{\"@id\":\"https://docs.cube.dev/admin/connect-to-data/data-sources/hive#webpage\"},\"dateModified\":\"2026-11-12T14:11:50.857Z\",\"publisher\":{\"@id\":\"https://docs.cube.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.cube.dev#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Cube Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Cube Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/admin/connect-to-data/data-sources/hive.md","siteName":"Cube Documentation","nav":{"global":null,"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/docs/introduction"}]},{"tab":"Admin","groups":[{"group":"Connect to data","pages":[{"title":"Connect to data","sidebarTitle":"Overview","mode":"wide","href":"/admin/connect-to-data"},{"group":"Data Sources","root":{"title":"Data Sources","sidebarTitle":"Overview","mode":"wide","href":"/admin/connect-to-data/data-sources/index"},"pages":[{"title":"Amazon Athena","href":"/admin/connect-to-data/data-sources/aws-athena"},{"title":"AWS Redshift","href":"/admin/connect-to-data/data-sources/aws-redshift"},{"title":"ClickHouse","href":"/admin/connect-to-data/data-sources/clickhouse"},{"title":"Databricks","href":"/admin/connect-to-data/data-sources/databricks-jdbc"},{"title":"Druid","href":"/admin/connect-to-data/data-sources/druid"},{"title":"DuckDB","href":"/admin/connect-to-data/data-sources/duckdb"},{"title":"Firebolt","href":"/admin/connect-to-data/data-sources/firebolt"},{"title":"Google BigQuery","description":"Grant a Google Cloud service account the right BigQuery IAM roles, then point Cube at your project, region, and key material.","href":"/admin/connect-to-data/data-sources/google-bigquery"},{"title":"Hive / SparkSQL","href":"/admin/connect-to-data/data-sources/hive"},{"title":"ksqlDB","description":"ksqlDB is a purpose-built database for stream processing applications, ingesting data from Apache Kafka.","href":"/admin/connect-to-data/data-sources/ksqldb"},{"title":"Materialize","href":"/admin/connect-to-data/data-sources/materialize"},{"title":"MongoDB","href":"/admin/connect-to-data/data-sources/mongodb"},{"title":"Microsoft Fabric","href":"/admin/connect-to-data/data-sources/ms-fabric"},{"title":"Microsoft SQL Server","href":"/admin/connect-to-data/data-sources/ms-sql"},{"title":"MySQL","href":"/admin/connect-to-data/data-sources/mysql"},{"title":"Oracle","href":"/admin/connect-to-data/data-sources/oracle"},{"title":"Apache Pinot","href":"/admin/connect-to-data/data-sources/pinot"},{"title":"Postgres","href":"/admin/connect-to-data/data-sources/postgres"},{"title":"Presto","href":"/admin/connect-to-data/data-sources/presto"},{"title":"QuestDB","href":"/admin/connect-to-data/data-sources/questdb"},{"title":"RisingWave","href":"/admin/connect-to-data/data-sources/risingwave"},{"title":"SingleStore","href":"/admin/connect-to-data/data-sources/singlestore"},{"title":"Snowflake","href":"/admin/connect-to-data/data-sources/snowflake"},{"title":"SQLite","href":"/admin/connect-to-data/data-sources/sqlite"},{"title":"Trino","href":"/admin/connect-to-data/data-sources/trino"},{"title":"Vertica","href":"/admin/connect-to-data/data-sources/vertica"}]},{"title":"Connecting to multiple data sources","href":"/admin/connect-to-data/multiple-data-sources"},{"title":"Querying concurrency","href":"/admin/connect-to-data/concurrency"},{"title":"Query tracing","href":"/admin/connect-to-data/query-tracing"},{"title":"Set up per-user OAuth","href":"/admin/connect-to-data/oauth-authentication"}]},{"group":"Users \u0026 Permissions","pages":[{"title":"Manage users","href":"/admin/users-and-permissions/manage-users"},{"title":"Roles \u0026 Permissions","href":"/admin/users-and-permissions/roles-and-permissions"},{"title":"User Attributes","href":"/admin/users-and-permissions/user-attributes"},{"title":"User groups","href":"/admin/users-and-permissions/user-groups"},{"title":"Custom roles","href":"/admin/users-and-permissions/custom-roles"}]},{"group":"SSO \u0026 Identity Providers","pages":[{"title":"Overview","sidebarTitle":"Overview","href":"/admin/sso/index"},{"title":"Google Workspace","href":"/admin/sso/google-workspace"},{"group":"Microsoft Entra ID","pages":[{"title":"SAML authentication with Microsoft Entra ID","sidebarTitle":"SAML","href":"/admin/sso/microsoft-entra-id/saml"},{"title":"SCIM provisioning with Microsoft Entra ID","sidebarTitle":"SCIM","href":"/admin/sso/microsoft-entra-id/scim"}]},{"group":"Okta","pages":[{"title":"SAML authentication with Okta","sidebarTitle":"SAML","href":"/admin/sso/okta/saml"},{"title":"SCIM provisioning with Okta","sidebarTitle":"SCIM","href":"/admin/sso/okta/scim"}]}]},{"group":"Deployment","pages":[{"title":"Overview","sidebarTitle":"Overview","href":"/admin/deployment/index"},{"title":"Deployment types","sidebarTitle":"Deployment types","href":"/admin/deployment/deployment-types"},{"title":"Deployment environments","sidebarTitle":"Deployment environments","href":"/admin/deployment/environments"},{"title":"Continuous deployment","href":"/admin/deployment/continuous-deployment"},{"title":"Custom domains","href":"/admin/deployment/custom-domains"},{"title":"Deployment warm-up","href":"/admin/deployment/warm-up"},{"title":"Auto-suspension","hidden":true,"href":"/admin/deployment/auto-suspension"},{"title":"Scalability","href":"/admin/deployment/scalability"},{"title":"Encryption keys","href":"/admin/deployment/encryption-keys"},{"title":"Limits and quotas","href":"/admin/deployment/limits"},{"title":"Infrastructure Options","href":"/admin/deployment/infrastructure"},{"group":"Dedicated Infrastructure","root":{"title":"Dedicated Infrastructure","href":"/admin/deployment/dedicated/index"},"pages":[{"group":"AWS","root":{"title":"Dedicated Infrastructure on AWS","sidebarTitle":"AWS","href":"/admin/deployment/dedicated/aws/index"},"pages":[{"title":"Setting up AWS PrivateLink","sidebarTitle":"PrivateLink","href":"/admin/deployment/dedicated/aws/private-link"},{"title":"Private API Connectivity on AWS","sidebarTitle":"Private API Connectivity","href":"/admin/deployment/dedicated/aws/private-api-connectivity"},{"title":"Bring Your Own Cloud on AWS","sidebarTitle":"BYOC","href":"/admin/deployment/dedicated/aws/byoc"}]},{"group":"Azure","root":{"title":"Dedicated Infrastructure on Azure","sidebarTitle":"Azure","href":"/admin/deployment/dedicated/azure/index"},"pages":[{"title":"Setting up Azure Private Link","sidebarTitle":"Private Link","href":"/admin/deployment/dedicated/azure/private-link"},{"title":"Bring Your Own Cloud on Azure","sidebarTitle":"BYOC","href":"/admin/deployment/dedicated/azure/byoc"}]},{"group":"GCP","root":{"title":"Dedicated Infrastructure on GCP","sidebarTitle":"GCP","href":"/admin/deployment/dedicated/gcp/index"},"pages":[{"title":"Setting up Google Private Service Connect","sidebarTitle":"Private Service Connect","href":"/admin/deployment/dedicated/gcp/private-service-connect"},{"title":"Bring Your Own Cloud on GCP","sidebarTitle":"BYOC","href":"/admin/deployment/dedicated/gcp/byoc"}]},{"title":"Bring-Your-Own Pre-aggregation Storage","sidebarTitle":"Pre-aggregation Storage","href":"/admin/deployment/dedicated/pre-aggregation-storage"}]},{"group":"Cube OIDC","root":{"title":"OIDC workload identity","sidebarTitle":"Overview","href":"/admin/deployment/oidc/index"},"pages":[{"title":"AWS","sidebarTitle":"AWS","href":"/admin/deployment/oidc/aws"},{"title":"GCP","sidebarTitle":"GCP","href":"/admin/deployment/oidc/gcp"},{"title":"Azure","sidebarTitle":"Azure","href":"/admin/deployment/oidc/azure"}]}]},{"group":"Monitoring","pages":[{"title":"Usage Analytics","href":"/admin/monitoring/usage-analytics"},{"title":"Query History","href":"/admin/monitoring/query-history"},{"title":"Pre-Aggregations","href":"/admin/monitoring/pre-aggregations"},{"title":"Performance Insights","href":"/admin/monitoring/performance"},{"title":"Audit Log","href":"/admin/monitoring/audit-log"},{"title":"Chats History","href":"/admin/monitoring/chats-history"},{"title":"Analyzing data from Query History export","sidebarTitle":"Query History export","href":"/admin/monitoring/query-history-export"},{"group":"Monitoring Integrations","root":{"title":"Overview","href":"/admin/monitoring/monitoring-integrations/index"},"pages":[{"title":"Integration with Amazon CloudWatch","sidebarTitle":"AWS CloudWatch","href":"/admin/monitoring/monitoring-integrations/cloudwatch"},{"title":"Integration with Amazon S3","sidebarTitle":"Amazon S3","href":"/admin/monitoring/monitoring-integrations/s3"},{"title":"Integration with Datadog","sidebarTitle":"Datadog","href":"/admin/monitoring/monitoring-integrations/datadog"},{"title":"Integration with Google Cloud Storage","sidebarTitle":"Google Cloud Storage","href":"/admin/monitoring/monitoring-integrations/gcs"},{"title":"Integration with Grafana Cloud","sidebarTitle":"Grafana Cloud","href":"/admin/monitoring/monitoring-integrations/grafana-cloud"},{"title":"Integration with New Relic","sidebarTitle":"New Relic","href":"/admin/monitoring/monitoring-integrations/new-relic"}]},{"title":"Alerts","href":"/admin/monitoring/alerts"}]},{"group":"AI","pages":[{"title":"Overview","href":"/admin/ai/index"},{"title":"Rules","href":"/admin/ai/rules"},{"title":"Certified queries","href":"/admin/ai/certified-queries"},{"title":"Skills","href":"/admin/ai/skills"},{"title":"Memories","href":"/admin/ai/memory-isolation"},{"title":"Multi-agent","href":"/admin/ai/multi-agent"},{"title":"Bring Your Own Model","sidebarTitle":"Bring Your Own Model","href":"/admin/ai/bring-your-own-model"},{"title":"MCP Connectors","href":"/admin/ai/mcp-connectors"},{"title":"Evals","href":"/admin/ai/evals"}]},{"group":"Account","pages":[{"group":"Customization","pages":[{"title":"App theme","href":"/admin/customization/app-theme"},{"title":"Chart palettes","href":"/admin/customization/chart-palettes"},{"title":"Dashboard themes","href":"/admin/customization/dashboard-themes"}]},{"title":"Time zones","href":"/admin/time-zones"},{"title":"Pricing in Cube Cloud","sidebarTitle":"Pricing","href":"/admin/account-billing/pricing"},{"title":"AI Tokens","sidebarTitle":"AI Tokens","href":"/admin/account-billing/ai-tokens"},{"title":"API keys","href":"/admin/account-billing/api-keys"},{"title":"Billing FAQ","sidebarTitle":"Billing FAQ","href":"/admin/account-billing/billing-faq"},{"title":"Support in Cube Cloud","sidebarTitle":"Support","href":"/admin/account-billing/support"}]}]},{"tab":"Embedding","pages":[{"title":"Embedding","href":"/embedding"}]},{"tab":"Reference","pages":[{"title":"Reference","href":"/reference/data-modeling/cube"}]},{"tab":"Cube Core","pages":[{"title":"Cube Core","href":"/cube-core"}]},{"tab":"Recipes","pages":[{"title":"Recipes","href":"/recipes"}]},{"tab":"API","pages":[{"title":"API","href":"/api-reference/introduction"}]}]},"basePath":"","title":"Hive / SparkSQL - Cube Documentation","deploymentId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","buildId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","dynamics":[],"chunks":[]}