(window.webpackJsonp=window.webpackJsonp||[]).push([[41],{EgHj:function(e,t,n){"use strict";n.r(t),n.d(t,"_frontmatter",(function(){return c})),n.d(t,"default",(function(){return i}));var a=n("k1TG"),o=n("8o2o"),r=(n("q1tI"),n("7ljp")),s=n("hhGP"),c=(n("qKvR"),{});void 0!==c&&c&&c===Object(c)&&Object.isExtensible(c)&&!c.hasOwnProperty("__filemeta")&&Object.defineProperty(c,"__filemeta",{configurable:!0,value:{name:"_frontmatter",filename:"src/pages/docs/Connecting to Databases/presto.mdx"}});var p={_frontmatter:c},b=s.a;function i(e){var t=e.components,n=Object(o.a)(e,["components"]);return Object(r.b)(b,Object(a.a)({},p,n,{components:t,mdxType:"MDXLayout"}),Object(r.b)("h2",{id:"presto"},"Presto"),Object(r.b)("p",null,"The ",Object(r.b)("a",Object(a.a)({parentName:"p"},{href:"https://pypi.org/project/PyHive/"}),"pyhive")," library is the recommended way to connect to Presto through SQLAlchemy."),Object(r.b)("p",null,"The expected connection string is formatted as follows:"),Object(r.b)("pre",null,Object(r.b)("code",Object(a.a)({parentName:"pre"},{}),"presto://{hostname}:{port}/{database}\n")),Object(r.b)("p",null,"You can pass in a username and password as well:"),Object(r.b)("pre",null,Object(r.b)("code",Object(a.a)({parentName:"pre"},{}),"presto://{username}:{password}@{hostname}:{port}/{database}\n")),Object(r.b)("p",null,"Here is an example connection string with values:"),Object(r.b)("pre",null,Object(r.b)("code",Object(a.a)({parentName:"pre"},{}),"presto://datascientist:securepassword@presto.example.com:8080/hive\n")),Object(r.b)("p",null,"By default Superset assumes the most recent version of Presto is being used when querying the\ndatasource. If you’re using an older version of Presto, you can configure it in the extra parameter:"),Object(r.b)("pre",null,Object(r.b)("code",Object(a.a)({parentName:"pre"},{}),'{\n    "version": "0.123"\n}\n')))}void 0!==i&&i&&i===Object(i)&&Object.isExtensible(i)&&!i.hasOwnProperty("__filemeta")&&Object.defineProperty(i,"__filemeta",{configurable:!0,value:{name:"MDXContent",filename:"src/pages/docs/Connecting to Databases/presto.mdx"}}),i.isMDXComponent=!0}}]);
//# sourceMappingURL=component---src-pages-docs-connecting-to-databases-presto-mdx-c70f708fc3b38961a564.js.map