| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[4050],{15680:(e,a,n)=>{n.d(a,{xA:()=>d,yg:()=>u});var t=n(296540);function l(e,a,n){return a in e?Object.defineProperty(e,a,{value:n,enumerable:!0,configurable:!0,writable:!0}):e[a]=n,e}function r(e,a){var n=Object.keys(e);if(Object.getOwnPropertySymbols){var t=Object.getOwnPropertySymbols(e);a&&(t=t.filter((function(a){return Object.getOwnPropertyDescriptor(e,a).enumerable}))),n.push.apply(n,t)}return n}function i(e){for(var a=1;a<arguments.length;a++){var n=null!=arguments[a]?arguments[a]:{};a%2?r(Object(n),!0).forEach((function(a){l(e,a,n[a])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(n)):r(Object(n)).forEach((function(a){Object.defineProperty(e,a,Object.getOwnPropertyDescriptor(n,a))}))}return e}function g(e,a){if(null==e)return{};var n,t,l=function(e,a){if(null==e)return{};var n,t,l={},r=Object.keys(e);for(t=0;t<r.length;t++)n=r[t],a.indexOf(n)>=0||(l[n]=e[n]);return l}(e,a);if(Object.getOwnPropertySymbols){var r=Object.getOwnPropertySymbols(e);for(t=0;t<r.length;t++)n=r[t],a.indexOf(n)>=0||Object.prototype.propertyIsEnumerable.call(e,n)&&(l[n]=e[n])}return l}var p=t.createContext({}),o=function(e){var a=t.useContext(p),n=a;return e&&(n="function"==typeof e?e(a):i(i({},a),e)),n},d=function(e){var a=o(e.components);return t.createElement(p.Provider,{value:a},e.children)},y="mdxType",m={inlineCode:"code",wrapper:function(e){var a=e.children;return t.createElement(t.Fragment,{},a)}},s=t.forwardRef((function(e,a){var n=e.components,l=e.mdxType,r=e.originalType,p=e.parentName,d=g(e,["components","mdxType","originalType","parentName"]),y=o(n),s=l,u=y["".concat(p,".").concat(s)]||y[s]||m[s]||r;return n?t.createElement(u,i(i({ref:a},d),{},{components:n})):t.createElement(u,i({ref:a},d))}));function u(e,a){var n=arguments,l=a&&a.mdxType;if("string"==typeof e||l){var r=n.length,i=new Array(r);i[0]=s;var g={};for(var p in a)hasOwnProperty.call(a,p)&&(g[p]=a[p]);g.originalType=e,g[y]="string"==typeof e?e:l,i[1]=g;for(var o=2;o<r;o++)i[o]=n[o];return t.createElement.apply(null,i)}return t.createElement.apply(null,n)}s.displayName="MDXCreateElement"},350034:(e,a,n)=>{n.r(a),n.d(a,{assets:()=>p,contentTitle:()=>i,default:()=>m,frontMatter:()=>r,metadata:()=>g,toc:()=>o});var t=n(58168),l=(n(296540),n(15680));const r={title:"JDBC Catalog",language:"zh-CN"},i=void 0,g={unversionedId:"lakehouse/database/jdbc",id:"lakehouse/database/jdbc",title:"JDBC Catalog",description:"\x3c!--",source:"@site/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/jdbc.md",sourceDirName:"lakehouse/database",slug:"/lakehouse/database/jdbc",permalink:"/zh-CN/docs/dev/lakehouse/database/jdbc",draft:!1,tags:[],version:"current",frontMatter:{title:"JDBC Catalog",language:"zh-CN"},sidebar:"docs",previous:{title:"Hive",permalink:"/zh-CN/docs/dev/lakehouse/datalake-building/hive-build"},next:{title:"MySQL",permalink:"/zh-CN/docs/dev/lakehouse/database/mysql"}},p={},o=[{value:"\u652f\u6301\u7684\u6570\u636e\u5e93",id:"\u652f\u6301\u7684\u6570\u636e\u5e93",level:2},{value:"\u914d\u7f6e",id:"\u914d\u7f6e",level:2},{value:"\u57fa\u672c\u5c5e\u6027",id:"\u57fa\u672c\u5c5e\u6027",level:3},{value:"\u53ef\u9009\u5c5e\u6027",id:"\u53ef\u9009\u5c5e\u6027",level:3},{value:"\u8fde\u63a5\u6c60\u5c5e\u6027",id:"\u8fde\u63a5\u6c60\u5c5e\u6027",level:3},{value:"\u5c5e\u6027\u987b\u77e5",id:"\u5c5e\u6027\u987b\u77e5",level:2},{value:"\u9a71\u52a8\u5305\u8def\u5f84\u4e0e\u5b89\u5168\u6027",id:"\u9a71\u52a8\u5305\u8def\u5f84\u4e0e\u5b89\u5168\u6027",level:3},{value:"\u5c0f\u5199\u540d\u79f0\u540c\u6b65",id:"\u5c0f\u5199\u540d\u79f0\u540c\u6b65",level:3},{value:"\u6307\u5b9a\u540c\u6b65\u6570\u636e\u5e93",id:"\u6307\u5b9a\u540c\u6b65\u6570\u636e\u5e93",level:3},{value:"\u8fde\u63a5\u6c60\u914d\u7f6e",id:"\u8fde\u63a5\u6c60\u914d\u7f6e",level:3},{value:"Insert \u4e8b\u52a1",id:"insert-\u4e8b\u52a1",level:3},{value:"\u793a\u4f8b",id:"\u793a\u4f8b",level:2},{value:"\u8bed\u53e5\u900f\u4f20",id:"\u8bed\u53e5\u900f\u4f20",level:2},{value:"\u900f\u4f20 DDL \u548c DML",id:"\u900f\u4f20-ddl-\u548c-dml",level:3},{value:"\u900f\u4f20\u67e5\u8be2",id:"\u900f\u4f20\u67e5\u8be2",level:3},{value:"\u539f\u7406\u548c\u9650\u5236",id:"\u539f\u7406\u548c\u9650\u5236",level:3}],d={toc:o},y="wrapper";function m(e){let{components:a,...n}=e;return(0,l.yg)(y,(0,t.A)({},d,n,{components:a,mdxType:"MDXLayout"}),(0,l.yg)("p",null,"Doris JDBC Catalog \u652f\u6301\u901a\u8fc7\u6807\u51c6 JDBC \u63a5\u53e3\u8fde\u63a5\u4e0d\u540c\u652f\u6301 JDBC \u534f\u8bae\u7684\u6570\u636e\u5e93\u3002\u672c\u6587\u6863\u4ecb\u7ecd JDBC Catalog \u7684\u901a\u7528\u914d\u7f6e\u548c\u4f7f\u7528\u65b9\u6cd5\u3002"),(0,l.yg)("h2",{id:"\u652f\u6301\u7684\u6570\u636e\u5e93"},"\u652f\u6301\u7684\u6570\u636e\u5e93"),(0,l.yg)("p",null,"Doris JDBC Catalog \u652f\u6301\u8fde\u63a5\u4ee5\u4e0b\u6570\u636e\u5e93\uff1a"),(0,l.yg)("table",null,(0,l.yg)("thead",{parentName:"table"},(0,l.yg)("tr",{parentName:"thead"},(0,l.yg)("th",{parentName:"tr",align:null},"\u6570\u636e\u5e93"),(0,l.yg)("th",{parentName:"tr",align:null},"\u8bf4\u660e"))),(0,l.yg)("tbody",{parentName:"table"},(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/mysql"},"MySQL")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/postgresql"},"PostgreSQL")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/oracle"},"Oracle")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/sqlserver"},"SQL Server")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/ibm-db2"},"IBM Db2")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/clickhouse"},"ClickHouse")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/sap-hana"},"SAP HANA")),(0,l.yg)("td",{parentName:"tr",align:null})),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("a",{parentName:"td",href:"/zh-CN/docs/dev/lakehouse/database/oceanbase"},"OceanBase")),(0,l.yg)("td",{parentName:"tr",align:null})))),(0,l.yg)("h2",{id:"\u914d\u7f6e"},"\u914d\u7f6e"),(0,l.yg)("h3",{id:"\u57fa\u672c\u5c5e\u6027"},"\u57fa\u672c\u5c5e\u6027"),(0,l.yg)("table",null,(0,l.yg)("thead",{parentName:"table"},(0,l.yg)("tr",{parentName:"thead"},(0,l.yg)("th",{parentName:"tr",align:null},"\u53c2\u6570"),(0,l.yg)("th",{parentName:"tr",align:null},"\u8bf4\u660e"))),(0,l.yg)("tbody",{parentName:"table"},(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"type")),(0,l.yg)("td",{parentName:"tr",align:null},"\u56fa\u5b9a\u4e3a ",(0,l.yg)("inlineCode",{parentName:"td"},"jdbc"))),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"user")),(0,l.yg)("td",{parentName:"tr",align:null},"\u6570\u636e\u6e90\u7528\u6237\u540d")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"password")),(0,l.yg)("td",{parentName:"tr",align:null},"\u6570\u636e\u6e90\u5bc6\u7801")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"jdbc_url")),(0,l.yg)("td",{parentName:"tr",align:null},"\u6570\u636e\u6e90\u8fde\u63a5 URL")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"driver_url")),(0,l.yg)("td",{parentName:"tr",align:null},"\u6570\u636e\u6e90 JDBC \u9a71\u52a8\u7a0b\u5e8f\u7684\u8def\u5f84")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"driver_class")),(0,l.yg)("td",{parentName:"tr",align:null},"\u6570\u636e\u6e90 JDBC \u9a71\u52a8\u7a0b\u5e8f\u7684\u7c7b\u540d")))),(0,l.yg)("h3",{id:"\u53ef\u9009\u5c5e\u6027"},"\u53ef\u9009\u5c5e\u6027"),(0,l.yg)("table",null,(0,l.yg)("thead",{parentName:"table"},(0,l.yg)("tr",{parentName:"thead"},(0,l.yg)("th",{parentName:"tr",align:null},"\u53c2\u6570"),(0,l.yg)("th",{parentName:"tr",align:null},"\u9ed8\u8ba4\u503c"),(0,l.yg)("th",{parentName:"tr",align:null},"\u8bf4\u660e"))),(0,l.yg)("tbody",{parentName:"table"},(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"lower_case_meta_names")),(0,l.yg)("td",{parentName:"tr",align:null},'"false"'),(0,l.yg)("td",{parentName:"tr",align:null},"\u662f\u5426\u4ee5\u5c0f\u5199\u7684\u5f62\u5f0f\u540c\u6b65\u5916\u90e8\u6570\u636e\u6e90\u7684\u5e93\u540d\u548c\u8868\u540d\u4ee5\u53ca\u5217\u540d")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"meta_names_mapping")),(0,l.yg)("td",{parentName:"tr",align:null},'""'),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f53\u5916\u90e8\u6570\u636e\u6e90\u5b58\u5728\u540d\u79f0\u76f8\u540c\u53ea\u6709\u5927\u5c0f\u5199\u4e0d\u540c\u7684\u60c5\u51b5\uff0c\u4f8b\u5982 DORIS \u548c doris\uff0cDoris \u7531\u4e8e\u6b67\u4e49\u800c\u5728\u67e5\u8be2 Catalog \u65f6\u62a5\u9519\uff0c\u6b64\u65f6\u9700\u8981\u914d\u7f6e ",(0,l.yg)("inlineCode",{parentName:"td"},"meta_names_mapping")," \u53c2\u6570\u6765\u89e3\u51b3\u51b2\u7a81\u3002")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"only_specified_database")),(0,l.yg)("td",{parentName:"tr",align:null},'"false"'),(0,l.yg)("td",{parentName:"tr",align:null},"\u662f\u5426\u53ea\u540c\u6b65 JDBC URL \u4e2d\u6307\u5b9a\u7684\u6570\u636e\u6e90\u7684 Database\uff08\u6b64\u5904\u7684 Database \u4e3a\u6620\u5c04\u5230 Doris \u7684 Database \u5c42\u7ea7\uff09")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"include_database_list")),(0,l.yg)("td",{parentName:"tr",align:null},'""'),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f53 ",(0,l.yg)("inlineCode",{parentName:"td"},"only_specified_database=true")," \u65f6\uff0c\u6307\u5b9a\u540c\u6b65\u591a\u4e2a Database\uff0c\u4ee5','\u5206\u9694\u3002Database \u540d\u79f0\u662f\u5927\u5c0f\u5199\u654f\u611f\u7684\u3002")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"exclude_database_list")),(0,l.yg)("td",{parentName:"tr",align:null},'""'),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f53 ",(0,l.yg)("inlineCode",{parentName:"td"},"only_specified_database=true")," \u65f6\uff0c\u6307\u5b9a\u4e0d\u9700\u8981\u540c\u6b65\u7684\u591a\u4e2a Database\uff0c\u4ee5','\u5206\u5272\u3002Database \u540d\u79f0\u662f\u5927\u5c0f\u5199\u654f\u611f\u7684\u3002")))),(0,l.yg)("h3",{id:"\u8fde\u63a5\u6c60\u5c5e\u6027"},"\u8fde\u63a5\u6c60\u5c5e\u6027"),(0,l.yg)("table",null,(0,l.yg)("thead",{parentName:"table"},(0,l.yg)("tr",{parentName:"thead"},(0,l.yg)("th",{parentName:"tr",align:null},"\u53c2\u6570"),(0,l.yg)("th",{parentName:"tr",align:null},"\u9ed8\u8ba4\u503c"),(0,l.yg)("th",{parentName:"tr",align:null},"\u8bf4\u660e"))),(0,l.yg)("tbody",{parentName:"table"},(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"connection_pool_min_size")),(0,l.yg)("td",{parentName:"tr",align:null},"1"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5b9a\u4e49\u8fde\u63a5\u6c60\u7684\u6700\u5c0f\u8fde\u63a5\u6570\uff0c\u7528\u4e8e\u521d\u59cb\u5316\u8fde\u63a5\u6c60\u5e76\u4fdd\u8bc1\u5728\u542f\u7528\u4fdd\u6d3b\u673a\u5236\u65f6\u81f3\u5c11\u6709\u8be5\u6570\u91cf\u7684\u8fde\u63a5\u5904\u4e8e\u6d3b\u8dc3\u72b6\u6001\u3002")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"connection_pool_max_size")),(0,l.yg)("td",{parentName:"tr",align:null},"10"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5b9a\u4e49\u8fde\u63a5\u6c60\u7684\u6700\u5927\u8fde\u63a5\u6570\uff0c\u6bcf\u4e2a Catalog \u5bf9\u5e94\u7684\u6bcf\u4e2a FE \u6216 BE \u8282\u70b9\u6700\u591a\u53ef\u6301\u6709\u6b64\u6570\u91cf\u7684\u8fde\u63a5\u3002")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"connection_pool_max_wait_time")),(0,l.yg)("td",{parentName:"tr",align:null},"5000"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5982\u679c\u8fde\u63a5\u6c60\u4e2d\u6ca1\u6709\u53ef\u7528\u8fde\u63a5\uff0c\u5b9a\u4e49\u5ba2\u6237\u7aef\u7b49\u5f85\u8fde\u63a5\u7684\u6700\u5927\u6beb\u79d2\u6570\u3002")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"connection_pool_max_life_time")),(0,l.yg)("td",{parentName:"tr",align:null},"1800000"),(0,l.yg)("td",{parentName:"tr",align:null},"\u8bbe\u7f6e\u8fde\u63a5\u5728\u8fde\u63a5\u6c60\u4e2d\u4fdd\u6301\u6d3b\u8dc3\u7684\u6700\u5927\u65f6\u957f\uff08\u6beb\u79d2\uff09\u3002\u8d85\u65f6\u7684\u8fde\u63a5\u5c06\u88ab\u56de\u6536\u3002\u540c\u65f6\uff0c\u6b64\u503c\u7684\u4e00\u534a\u5c06\u4f5c\u4e3a\u8fde\u63a5\u6c60\u7684\u6700\u5c0f\u9010\u51fa\u7a7a\u95f2\u65f6\u95f4\uff0c\u8fbe\u5230\u8be5\u65f6\u95f4\u7684\u8fde\u63a5\u5c06\u6210\u4e3a\u9010\u51fa\u5019\u9009\u5bf9\u8c61\u3002")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},(0,l.yg)("inlineCode",{parentName:"td"},"connection_pool_keep_alive")),(0,l.yg)("td",{parentName:"tr",align:null},"false"),(0,l.yg)("td",{parentName:"tr",align:null},"\u4ec5\u5728 BE \u8282\u70b9\u4e0a\u6709\u6548\uff0c\u7528\u4e8e\u51b3\u5b9a\u662f\u5426\u4fdd\u6301\u8fbe\u5230\u6700\u5c0f\u9010\u51fa\u7a7a\u95f2\u65f6\u95f4\u4f46\u672a\u5230\u6700\u5927\u751f\u547d\u5468\u671f\u7684\u8fde\u63a5\u6d3b\u8dc3\u3002\u9ed8\u8ba4\u5173\u95ed\uff0c\u4ee5\u51cf\u5c11\u4e0d\u5fc5\u8981\u7684\u8d44\u6e90\u4f7f\u7528\u3002")))),(0,l.yg)("h2",{id:"\u5c5e\u6027\u987b\u77e5"},"\u5c5e\u6027\u987b\u77e5"),(0,l.yg)("h3",{id:"\u9a71\u52a8\u5305\u8def\u5f84\u4e0e\u5b89\u5168\u6027"},"\u9a71\u52a8\u5305\u8def\u5f84\u4e0e\u5b89\u5168\u6027"),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"driver_url")," \u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u4e09\u79cd\u65b9\u5f0f\u6307\u5b9a\uff1a"),(0,l.yg)("ol",null,(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u6587\u4ef6\u540d\u3002\u5982 ",(0,l.yg)("inlineCode",{parentName:"p"},"mysql-connector-j-8.3.0.jar"),"\u3002\u9700\u5c06 Jar \u5305\u9884\u5148\u5b58\u653e\u5728 FE \u548c BE \u90e8\u7f72\u76ee\u5f55\u4e0b\u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"jdbc_drivers/"),"\n\u76ee\u5f55\u4e0b\u3002\u7cfb\u7edf\u4f1a\u81ea\u52a8\u5728\u8fd9\u4e2a\u76ee\u5f55\u4e0b\u5bfb\u627e\u3002\u8be5\u76ee\u5f55\u7684\u4f4d\u7f6e\uff0c\u4e5f\u53ef\u4ee5\u7531 fe.conf \u548c be.conf \u4e2d\u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"jdbc_drivers_dir")," \u914d\u7f6e\u4fee\u6539\u3002")),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u672c\u5730\u7edd\u5bf9\u8def\u5f84\u3002\u5982 ",(0,l.yg)("inlineCode",{parentName:"p"},"file:///path/to/mysql-connector-j-8.3.0.jar"),"\u3002\u9700\u5c06 Jar \u5305\u9884\u5148\u5b58\u653e\u5728\u6240\u6709 FE/BE \u8282\u70b9\u6307\u5b9a\u7684\u8def\u5f84\u4e0b\u3002")),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"Http \u5730\u5740\u3002\u5982\uff1a",(0,l.yg)("a",{parentName:"p",href:"http://repo1.maven.org/maven2/com/mysql/mysql-connector-j/8.3.0/mysql-connector-j-8.3.0.jar"},"http://repo1.maven.org/maven2/com/mysql/mysql-connector-j/8.3.0/mysql-connector-j-8.3.0.jar")," \u7cfb\u7edf\u4f1a\u4ece\u8fd9\u4e2a Http \u5730\u5740\u4e0b\u8f7d Driver \u6587\u4ef6\u3002\u4ec5\u652f\u6301\u65e0\u8ba4\u8bc1\u7684 Http \u670d\u52a1\u3002"))),(0,l.yg)("p",null,(0,l.yg)("strong",{parentName:"p"},"\u9a71\u52a8\u5305\u5b89\u5168\u6027")),(0,l.yg)("p",null,"\u4e3a\u4e86\u9632\u6b62\u5728\u521b\u5efa Catalog \u65f6\u4f7f\u7528\u4e86\u672a\u5141\u8bb8\u8def\u5f84\u7684 Driver Jar \u5305\uff0cDoris \u4f1a\u5bf9 Jar \u5305\u8fdb\u884c\u8def\u5f84\u7ba1\u7406\u548c\u6821\u9a8c\u548c\u68c0\u67e5\u3002"),(0,l.yg)("ol",null,(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u9488\u5bf9\u4e0a\u8ff0\u65b9\u5f0f 1\uff0cDoris \u9ed8\u8ba4\u7528\u6237\u914d\u7f6e\u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"jdbc_drivers_dir")," \u548c\u5176\u76ee\u5f55\u4e0b\u7684\u6240\u6709 Jar \u5305\u90fd\u662f\u5b89\u5168\u7684\uff0c\u4e0d\u4f1a\u5bf9\u5176\u8fdb\u884c\u8def\u5f84\u68c0\u67e5\u3002")),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u9488\u5bf9\u4e0a\u8ff0\u65b9\u5f0f 2\u30013 \uff0cDoris \u4f1a\u5bf9 Jar \u5305\u7684\u6765\u6e90\u8fdb\u884c\u68c0\u67e5\uff0c\u68c0\u67e5\u89c4\u5219\u5982\u4e0b\uff1a"),(0,l.yg)("ul",{parentName:"li"},(0,l.yg)("li",{parentName:"ul"},"\u901a\u8fc7 FE \u914d\u7f6e\u9879 ",(0,l.yg)("inlineCode",{parentName:"li"},"jdbc_driver_secure_path")," \u6765\u63a7\u5236\u5141\u8bb8\u7684\u9a71\u52a8\u5305\u8def\u5f84\uff0c\u8be5\u914d\u7f6e\u9879\u53ef\u914d\u7f6e\u591a\u4e2a\u8def\u5f84\uff0c\u4ee5\u5206\u53f7\u5206\u9694\u3002\u5f53\u914d\u7f6e\u4e86\u8be5\u9879\u65f6\uff0cDoris\n\u4f1a\u68c0\u67e5 Catalog properties \u4e2d driver_url \u7684\u8def\u5f84\u662f\u7684\u90e8\u5206\u524d\u7f00\u662f\u5426\u5728 ",(0,l.yg)("inlineCode",{parentName:"li"},"jdbc_driver_secure_path")," \u4e2d\uff0c\u5982\u679c\u4e0d\u5728\u5176\u4e2d\uff0c\u5219\u4f1a\u62d2\u7edd\u521b\u5efa\nCatalog\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u6b64\u53c2\u6570\u9ed8\u8ba4\u4e3a ",(0,l.yg)("inlineCode",{parentName:"li"},"*")," \uff0c\u8868\u793a\u5141\u8bb8\u6240\u6709\u8def\u5f84\u7684 Jar \u5305\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u5982\u679c\u914d\u7f6e ",(0,l.yg)("inlineCode",{parentName:"li"},"jdbc_driver_secure_path")," \u4e3a\u7a7a\uff0c\u4e5f\u8868\u793a\u5141\u8bb8\u6240\u6709\u8def\u5f84\u7684 Jar \u5305\u3002")),(0,l.yg)("admonition",{parentName:"li",title:"\u5907\u6ce8",type:"info"},(0,l.yg)("p",{parentName:"admonition"},"\u5982\u914d\u7f6e ",(0,l.yg)("inlineCode",{parentName:"p"},'jdbc_driver_secure_path = "file:///path/to/jdbc_drivers;http://path/to/jdbc_drivers"')," \uff1a"),(0,l.yg)("p",{parentName:"admonition"},"\u5219\u53ea\u5141\u8bb8\u4ee5 ",(0,l.yg)("inlineCode",{parentName:"p"},"file:///path/to/jdbc_drivers")," \u6216 ",(0,l.yg)("inlineCode",{parentName:"p"},"http://path/to/jdbc_drivers")," \u5f00\u5934\u7684\u9a71\u52a8\u5305\u8def\u5f84\u3002"))),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u5728\u521b\u5efa Catalog \u65f6\uff0c\u53ef\u4ee5\u901a\u8fc7 ",(0,l.yg)("inlineCode",{parentName:"p"},"checksum")," \u53c2\u6570\u6765\u6307\u5b9a\u9a71\u52a8\u5305\u7684\u6821\u9a8c\u548c\uff0cDoris \u4f1a\u5728\u52a0\u8f7d\u9a71\u52a8\u5305\u540e\uff0c\u5bf9\u9a71\u52a8\u5305\u8fdb\u884c\u6821\u9a8c\uff0c\u5982\u679c\u6821\u9a8c\u5931\u8d25\uff0c\u5219\u4f1a\u62d2\u7edd\u521b\u5efa\nCatalog\u3002"))),(0,l.yg)("admonition",{title:"\u5907\u6ce8",type:"info"},(0,l.yg)("p",{parentName:"admonition"},"\u4e0a\u8ff0\u7684\u6821\u9a8c\u53ea\u4f1a\u5728\u521b\u5efa Catalog \u65f6\u8fdb\u884c\uff0c\u5bf9\u4e8e\u5df2\u7ecf\u521b\u5efa\u7684 Catalog\uff0c\u4e0d\u4f1a\u518d\u6b21\u8fdb\u884c\u6821\u9a8c\u3002")),(0,l.yg)("h3",{id:"\u5c0f\u5199\u540d\u79f0\u540c\u6b65"},"\u5c0f\u5199\u540d\u79f0\u540c\u6b65"),(0,l.yg)("p",null,"\u5f53 ",(0,l.yg)("inlineCode",{parentName:"p"},"lower_case_meta_names")," \u8bbe\u7f6e\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"true")," \u65f6\uff0cDoris \u901a\u8fc7\u7ef4\u62a4\u5c0f\u5199\u540d\u79f0\u5230\u8fdc\u7a0b\u7cfb\u7edf\u4e2d\u5b9e\u9645\u540d\u79f0\u7684\u6620\u5c04\uff0c\u4f7f\u67e5\u8be2\u65f6\u80fd\u591f\u4f7f\u7528\u5c0f\u5199\u53bb\u67e5\u8be2\u5916\u90e8\u6570\u636e\u6e90\u975e\u5c0f\u5199\u7684\u6570\u636e\u5e93\u548c\u8868\u4ee5\u53ca\u5217\u3002"),(0,l.yg)("p",null,"\u7531\u4e8e FE \u5b58\u5728 ",(0,l.yg)("inlineCode",{parentName:"p"},"lower_case_table_names")," \u7684\u53c2\u6570\uff0c\u4f1a\u5f71\u54cd\u67e5\u8be2\u65f6\u7684\u8868\u540d\u5927\u5c0f\u5199\u89c4\u5219\uff0c\u6240\u4ee5\u89c4\u5219\u5982\u4e0b"),(0,l.yg)("ul",null,(0,l.yg)("li",{parentName:"ul"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("strong",{parentName:"p"},"lower_case_meta_names = true")),(0,l.yg)("p",{parentName:"li"},"\u5e93\u8868\u5217\u540d\u90fd\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5c0f\u5199\u3002")),(0,l.yg)("li",{parentName:"ul"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("strong",{parentName:"p"},"lower_case_meta_names = false")),(0,l.yg)("p",{parentName:"li"},"\u5f53 FE \u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"lower_case_table_names")," \u53c2\u6570\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"0")," \u6216 ",(0,l.yg)("inlineCode",{parentName:"p"},"2")," \u65f6\uff0c\u5e93\u540d\u8868\u540d\u5217\u540d\u90fd\u4e0d\u4f1a\u88ab\u8f6c\u6362\u3002"),(0,l.yg)("p",{parentName:"li"},"\u5f53 FE \u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"lower_case_table_names")," \u53c2\u6570\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"1")," \u65f6\uff0c\u8868\u540d\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u5e93\u540d\u548c\u5217\u540d\u4e0d\u4f1a\u88ab\u8f6c\u6362\u3002"))),(0,l.yg)("p",null,"\u5982\u679c\u521b\u5efa Catalog \u65f6\u7684\u53c2\u6570\u914d\u7f6e\u5339\u914d\u5230\u4e86\u4e0a\u8ff0\u89c4\u5219\u4e2d\u7684\u8f6c\u53d8\u5c0f\u5199\u89c4\u5219\uff0c\u5219 Doris \u4f1a\u5c06\u5bf9\u5e94\u7684\u540d\u79f0\u8f6c\u53d8\u4e3a\u5c0f\u5199\u5b58\u50a8\u5728 Doris \u4e2d\uff0c\u67e5\u8be2\u65f6\u9700\u4f7f\u7528\nDoris \u663e\u793a\u7684\u5c0f\u5199\u540d\u79f0\u53bb\u67e5\u8be2\u3002"),(0,l.yg)("p",null,"\u5982\u679c\u5916\u90e8\u6570\u636e\u6e90\u5b58\u5728\u540d\u79f0\u76f8\u540c\u53ea\u6709\u5927\u5c0f\u5199\u4e0d\u540c\u7684\u60c5\u51b5\uff0c\u4f8b\u5982 DORIS \u548c doris\uff0cDoris \u7531\u4e8e\u6b67\u4e49\u800c\u5728\u67e5\u8be2 Catalog\n\u65f6\u62a5\u9519\uff0c\u6b64\u65f6\u9700\u8981\u914d\u7f6e ",(0,l.yg)("inlineCode",{parentName:"p"},"meta_names_mapping")," \u53c2\u6570\u6765\u89e3\u51b3\u51b2\u7a81\u3002"),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"meta_names_mapping")," \u53c2\u6570\u63a5\u53d7\u4e00\u4e2a Json \u683c\u5f0f\u7684\u5b57\u7b26\u4e32\uff0c\u683c\u5f0f\u5982\u4e0b\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-json"},'{\n "databases": [\n {\n "remoteDatabase": "DORIS",\n "mapping": "doris_1"\n },\n {\n "remoteDatabase": "doris",\n "mapping": "doris_2"\n }\n ],\n "tables": [\n {\n "remoteDatabase": "DORIS",\n "remoteTable": "DORIS",\n "mapping": "doris_1"\n },\n {\n "remoteDatabase": "DORIS",\n "remoteTable": "doris",\n "mapping": "doris_2"\n }\n ],\n "columns": [\n {\n "remoteDatabase": "DORIS",\n "remoteTable": "DORIS",\n "remoteColumn": "DORIS",\n "mapping": "doris_1"\n },\n {\n "remoteDatabase": "DORIS",\n "remoteTable": "DORIS",\n "remoteColumn": "doris",\n "mapping": "doris_2"\n }\n ]\n}\n')),(0,l.yg)("p",null,"\u5728\u5c06\u6b64\u914d\u7f6e\u586b\u5199\u5230\u521b\u5efa Catalog \u7684\u8bed\u53e5\u4e2d\u65f6\uff0cJson \u4e2d\u5b58\u5728\u53cc\u5f15\u53f7\uff0c\u56e0\u6b64\u5728\u586b\u5199\u65f6\u9700\u8981\u5c06\u53cc\u5f15\u53f7\u8f6c\u4e49\u6216\u8005\u76f4\u63a5\u4f7f\u7528\u5355\u5f15\u53f7\u5305\u88f9 Json \u5b57\u7b26\u4e32\u3002"),(0,l.yg)("h3",{id:"\u6307\u5b9a\u540c\u6b65\u6570\u636e\u5e93"},"\u6307\u5b9a\u540c\u6b65\u6570\u636e\u5e93"),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"only_specified_database"),":\n\u662f\u5426\u53ea\u540c\u6b65 JDBC URL \u4e2d\u6307\u5b9a\u7684\u6570\u636e\u6e90\u7684 Database\u3002\u9ed8\u8ba4\u503c\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"false"),"\uff0c\u8868\u793a\u540c\u6b65 JDBC URL \u4e2d\u6240\u6709\u7684 Database\u3002"),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"include_database_list"),":\n\u4ec5\u5728",(0,l.yg)("inlineCode",{parentName:"p"},"only_specified_database=true"),"\u65f6\u751f\u6548\uff0c\u6307\u5b9a\u9700\u8981\u540c\u6b65\u7684 PostgreSQL \u7684 Schema\uff0c\u4ee5','\u5206\u9694\u3002Schema \u540d\u79f0\u662f\u5927\u5c0f\u5199\u654f\u611f\u7684\u3002"),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"exclude_database_list"),":\n\u4ec5\u5728",(0,l.yg)("inlineCode",{parentName:"p"},"only_specified_database=true"),"\u65f6\u751f\u6548\uff0c\u6307\u5b9a\u4e0d\u9700\u8981\u540c\u6b65\u7684 PostgreSQL \u7684 Schema\uff0c\u4ee5','\u5206\u9694\u3002Schema \u540d\u79f0\u662f\u5927\u5c0f\u5199\u654f\u611f\u7684\u3002"),(0,l.yg)("admonition",{title:"\u5907\u6ce8",type:"info"},(0,l.yg)("ul",{parentName:"admonition"},(0,l.yg)("li",{parentName:"ul"},"\u4e0a\u8ff0\u4e09\u4e2a\u53c2\u6570\u4e2d\u63d0\u5230\u7684 Database \u662f\u6307 Doris \u4e2d\u7684 Database \u5c42\u7ea7\uff0c\u800c\u4e0d\u662f\u5916\u90e8\u6570\u636e\u6e90\u7684 Database \u5c42\u7ea7\uff0c\u5177\u4f53\u7684\u6620\u5c04\u5173\u7cfb\u53ef\u4ee5\u53c2\u8003\u5404\u4e2a\u6570\u636e\u6e90\u6587\u6863\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u5f53 ",(0,l.yg)("inlineCode",{parentName:"li"},"include_database_list")," \u548c ",(0,l.yg)("inlineCode",{parentName:"li"},"exclude_database_list")," \u6709\u91cd\u5408\u7684database\u914d\u7f6e\u65f6\uff0c",(0,l.yg)("inlineCode",{parentName:"li"},"exclude_database_list"),"\u4f1a\u4f18\u5148\u751f\u6548\u3002"))),(0,l.yg)("h3",{id:"\u8fde\u63a5\u6c60\u914d\u7f6e"},"\u8fde\u63a5\u6c60\u914d\u7f6e"),(0,l.yg)("p",null,"\u5728 Doris \u4e2d\uff0c\u6bcf\u4e2a FE \u548c BE \u8282\u70b9\u90fd\u4f1a\u7ef4\u62a4\u4e00\u4e2a\u8fde\u63a5\u6c60\uff0c\u8fd9\u6837\u53ef\u4ee5\u907f\u514d\u9891\u7e41\u5730\u6253\u5f00\u548c\u5173\u95ed\u5355\u72ec\u7684\u6570\u636e\u6e90\u8fde\u63a5\u3002\u8fde\u63a5\u6c60\u4e2d\u7684\u6bcf\u4e2a\u8fde\u63a5\u90fd\u53ef\u4ee5\u7528\u6765\u4e0e\u6570\u636e\u6e90\u5efa\u7acb\u8fde\u63a5\u5e76\u6267\u884c\u67e5\u8be2\u3002\u4efb\u52a1\u5b8c\u6210\u540e\uff0c\u8fd9\u4e9b\u8fde\u63a5\u4f1a\u88ab\u5f52\u8fd8\u5230\u6c60\u4e2d\u4ee5\u4fbf\u91cd\u590d\u4f7f\u7528\uff0c\u8fd9\u4e0d\u4ec5\u63d0\u9ad8\u4e86\u6027\u80fd\uff0c\u8fd8\u51cf\u5c11\u4e86\u5efa\u7acb\u8fde\u63a5\u65f6\u7684\u7cfb\u7edf\u5f00\u9500\uff0c\u5e76\u5e2e\u52a9\u9632\u6b62\u8fbe\u5230\u6570\u636e\u6e90\u7684\u8fde\u63a5\u6570\u4e0a\u9650\u3002"),(0,l.yg)("p",null,"\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8c03\u6574\u8fde\u63a5\u6c60\u7684\u5927\u5c0f\uff0c\u4ee5\u4fbf\u66f4\u597d\u5730\u9002\u5e94\u60a8\u7684\u5de5\u4f5c\u8d1f\u8f7d\u3002\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u8fde\u63a5\u6c60\u7684\u6700\u5c0f\u8fde\u63a5\u6570\u5e94\u8be5\u8bbe\u7f6e\u4e3a 1\uff0c\u4ee5\u786e\u4fdd\u5728\u542f\u7528\u4fdd\u6d3b\u673a\u5236\u65f6\u81f3\u5c11\u6709\u4e00\u4e2a\u8fde\u63a5\u5904\u4e8e\u6d3b\u8dc3\u72b6\u6001\u3002\u8fde\u63a5\u6c60\u7684\u6700\u5927\u8fde\u63a5\u6570\u5e94\u8be5\u8bbe\u7f6e\u4e3a\u4e00\u4e2a\u5408\u7406\u7684\u503c\uff0c\u4ee5\u907f\u514d\u8fc7\u591a\u7684\u8fde\u63a5\u5360\u7528\u8d44\u6e90\u3002"),(0,l.yg)("p",null,"\u540c\u65f6\u4e3a\u4e86\u907f\u514d\u5728 BE \u4e0a\u7d2f\u79ef\u8fc7\u591a\u7684\u672a\u4f7f\u7528\u7684\u8fde\u63a5\u6c60\u7f13\u5b58\uff0c\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e BE \u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"jdbc_connection_pool_cache_clear_time_sec")," \u53c2\u6570\u6765\u6307\u5b9a\u6e05\u7406\u7f13\u5b58\u7684\u65f6\u95f4\u95f4\u9694\u3002\u9ed8\u8ba4\u503c\u4e3a 28800 \u79d2\uff088\u5c0f\u65f6\uff09\uff0c\u6b64\u95f4\u9694\u8fc7\u540e\uff0cBE \u5c06\u5f3a\u5236\u6e05\u7406\u6240\u6709\u8d85\u8fc7\u8be5\u65f6\u95f4\u672a\u4f7f\u7528\u7684\u8fde\u63a5\u6c60\u7f13\u5b58\u3002"),(0,l.yg)("h3",{id:"insert-\u4e8b\u52a1"},"Insert \u4e8b\u52a1"),(0,l.yg)("p",null,"Doris \u7684\u6570\u636e\u662f\u7531\u4e00\u7ec4 batch \u7684\u65b9\u5f0f\u5199\u5165 JDBC Catalog \u7684\uff0c\u5982\u679c\u4e2d\u9014\u5bfc\u5165\u4e2d\u65ad\uff0c\u4e4b\u524d\u5199\u5165\u6570\u636e\u53ef\u80fd\u9700\u8981\u56de\u6eda\u3002\u6240\u4ee5 JDBC Catalog \u652f\u6301\u6570\u636e\u5199\u5165\u65f6\u7684\u4e8b\u52a1\uff0c\u4e8b\u52a1\u7684\u652f\u6301\u9700\u8981\u901a\u8fc7\u8bbe\u7f6e session variable: ",(0,l.yg)("inlineCode",{parentName:"p"},"enable_odbc_transcation "),"\u3002"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},"set enable_odbc_transcation = true; \n")),(0,l.yg)("p",null,"\u4e8b\u52a1\u4fdd\u8bc1\u4e86 JDBC Catalog \u6570\u636e\u5199\u5165\u7684\u539f\u5b50\u6027\uff0c\u4f46\u662f\u4e00\u5b9a\u7a0b\u5ea6\u4e0a\u4f1a\u964d\u4f4e\u6570\u636e\u5199\u5165\u7684\u6027\u80fd\uff0c\u53ef\u4ee5\u8003\u8651\u914c\u60c5\u5f00\u542f\u8be5\u529f\u80fd\u3002"),(0,l.yg)("h2",{id:"\u793a\u4f8b"},"\u793a\u4f8b"),(0,l.yg)("p",null,"\u6b64\u5904\u4ee5 MySQL \u4e3a\u4f8b\uff0c\u5c55\u793a\u5982\u4f55\u521b\u5efa\u4e00\u4e2a MySQL Catalog \u5e76\u67e5\u8be2\u5176\u4e2d\u7684\u6570\u636e\u3002"),(0,l.yg)("p",null,"\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"mysql")," \u7684 Catalog\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE CATALOG mysql PROPERTIES (\n "type"="jdbc",\n "user"="root",\n "password"="secret",\n "jdbc_url" = "jdbc:mysql://example.net:3306",\n "driver_url" = "mysql-connector-j-8.3.0.jar",\n "driver_class" = "com.mysql.cj.jdbc.Driver"\n)\n')),(0,l.yg)("p",null,"\u901a\u8fc7\u8fd0\u884c SHOW DATABASES \u67e5\u770b\u6b64 Catalog \u6240\u6709\u6570\u636e\u5e93\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},"SHOW DATABASES FROM mysql;\n")),(0,l.yg)("p",null,"\u5982\u679c\u60a8\u6709\u4e00\u4e2a\u540d\u4e3a test \u7684 MySQL \u6570\u636e\u5e93\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7\u8fd0\u884c SHOW TABLES \u67e5\u770b\u8be5\u6570\u636e\u5e93\u4e2d\u7684\u8868\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},"SHOW TABLES FROM mysql.test;\n")),(0,l.yg)("p",null,"\u6700\u540e\uff0c\u60a8\u53ef\u4ee5\u8bbf\u95ee MySQL \u6570\u636e\u5e93\u4e2d\u7684\u8868\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},"SELECT * FROM mysql.test.table;\n")),(0,l.yg)("h2",{id:"\u8bed\u53e5\u900f\u4f20"},"\u8bed\u53e5\u900f\u4f20"),(0,l.yg)("p",null,"Doris \u652f\u6301\u901a\u8fc7\u900f\u4f20\u7684\u65b9\u5f0f\uff0c\u76f4\u63a5\u6267\u884c JDBC \u6570\u636e\u6e90\u7684 DDL\u3001DML \u8bed\u53e5\u548c\u67e5\u8be2\u8bed\u53e5\u3002"),(0,l.yg)("h3",{id:"\u900f\u4f20-ddl-\u548c-dml"},"\u900f\u4f20 DDL \u548c DML"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre"},'CALL EXECUTE_STMT("catalog_name", "raw_stmt_string");\n')),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"EXECUTE_STMT()")," \u8fc7\u7a0b\u6709\u4e24\u4e2a\u53c2\u6570\uff1a"),(0,l.yg)("ul",null,(0,l.yg)("li",{parentName:"ul"},"Catalog Name\uff1a\u76ee\u524d\u4ec5\u652f\u6301 JDBC \u7c7b\u578b Catalog\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u6267\u884c\u8bed\u53e5\uff1a\u76ee\u524d\u4ec5\u652f\u6301 DDL \u548c DML \u8bed\u53e5\uff0c\u5e76\u4e14\u9700\u8981\u76f4\u63a5\u4f7f\u7528\u6570\u636e\u6e90\u5bf9\u5e94\u7684\u8bed\u6cd5\u3002")),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre"},'CALL EXECUTE_STMT("jdbc_catalog", "insert into db1.tbl1 values(1,2), (3, 4)");\n\nCALL EXECUTE_STMT("jdbc_catalog", "delete from db1.tbl1 where k1 = 2");\n\nCALL EXECUTE_STMT("jdbc_catalog", "create table dbl1.tbl2 (k1 int)");\n')),(0,l.yg)("h3",{id:"\u900f\u4f20\u67e5\u8be2"},"\u900f\u4f20\u67e5\u8be2"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},'query(\n "catalog" = "catalog_name", \n "query" = "select * from db_name.table_name where condition"\n );\n')),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"query")," \u8868\u51fd\u6570\u6709\u4e24\u4e2a\u53c2\u6570\uff1a"),(0,l.yg)("ul",null,(0,l.yg)("li",{parentName:"ul"},(0,l.yg)("inlineCode",{parentName:"li"},"catalog"),"\uff1a Catalog \u540d\u79f0\uff0c\u9700\u8981\u6309\u7167 Catalog \u7684\u540d\u79f0\u586b\u5199\u3002"),(0,l.yg)("li",{parentName:"ul"},(0,l.yg)("inlineCode",{parentName:"li"},"query"),"\uff1a \u9700\u8981\u6267\u884c\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u5e76\u4e14\u9700\u8981\u76f4\u63a5\u4f7f\u7528\u6570\u636e\u6e90\u5bf9\u5e94\u7684\u8bed\u6cd5\u3002")),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},'select * from query("catalog" = "jdbc_catalog", "query" = "select * from db_name.table_name where condition");\n')),(0,l.yg)("h3",{id:"\u539f\u7406\u548c\u9650\u5236"},"\u539f\u7406\u548c\u9650\u5236"),(0,l.yg)("p",null,"\u901a\u8fc7 ",(0,l.yg)("inlineCode",{parentName:"p"},"CALL EXECUTE_STMT()")," \u547d\u4ee4\uff0cDoris \u4f1a\u76f4\u63a5\u5c06\u7528\u6237\u7f16\u5199\u7684 SQL \u8bed\u53e5\u53d1\u9001\u7ed9 Catalog \u5bf9\u5e94\u7684 JDBC \u6570\u636e\u6e90\u8fdb\u884c\u6267\u884c\u3002\u56e0\u6b64\uff0c\u8fd9\u4e2a\u64cd\u4f5c\u6709\u5982\u4e0b\u9650\u5236\uff1a"),(0,l.yg)("ul",null,(0,l.yg)("li",{parentName:"ul"},"SQL \u8bed\u53e5\u5fc5\u987b\u662f\u6570\u636e\u6e90\u5bf9\u5e94\u7684\u8bed\u6cd5\uff0cDoris \u4e0d\u4f1a\u505a\u8bed\u6cd5\u548c\u8bed\u4e49\u68c0\u67e5\u3002"),(0,l.yg)("li",{parentName:"ul"},"SQL \u8bed\u53e5\u4e2d\u5f15\u7528\u7684\u8868\u540d\u5efa\u8bae\u662f\u5168\u9650\u5b9a\u540d\uff0c\u5373 ",(0,l.yg)("inlineCode",{parentName:"li"},"db.tbl")," \u8fd9\u79cd\u683c\u5f0f\u3002\u5982\u679c\u672a\u6307\u5b9a db\uff0c\u5219\u4f1a\u4f7f\u7528 JDBC Catalog \u7684 JDBC URL \u4e2d\u6307\u5b9a\u7684 db \u540d\u79f0\u3002"),(0,l.yg)("li",{parentName:"ul"},"SQL \u8bed\u53e5\u4e2d\u4e0d\u53ef\u5f15\u7528 JDBC \u6570\u636e\u6e90\u4e4b\u5916\u7684\u5e93\u8868\uff0c\u4e5f\u4e0d\u53ef\u4ee5\u5f15\u7528 Doris \u7684\u5e93\u8868\u3002\u4f46\u53ef\u4ee5\u5f15\u7528\u5728 JDBC \u6570\u636e\u6e90\u5185\u7684\uff0c\u4f46\u662f\u6ca1\u6709\u540c\u6b65\u5230 Doris JDBC Catalog \u7684\u5e93\u8868\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u6267\u884c DML \u8bed\u53e5\uff0c\u65e0\u6cd5\u83b7\u53d6\u63d2\u5165\u3001\u66f4\u65b0\u6216\u5220\u9664\u7684\u884c\u6570\uff0c\u53ea\u80fd\u83b7\u53d6\u547d\u4ee4\u662f\u5426\u6267\u884c\u6210\u529f\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u53ea\u6709\u5bf9 Catalog \u6709 LOAD \u6743\u9650\u7684\u7528\u6237\uff0c\u624d\u80fd\u6267\u884c",(0,l.yg)("inlineCode",{parentName:"li"},"CALL EXECUTE_STMT()"),"\u547d\u4ee4\u3002"),(0,l.yg)("li",{parentName:"ul"},"\u53ea\u6709\u5bf9 Catalog \u6709 SELECT \u6743\u9650\u7684\u7528\u6237\uff0c\u624d\u80fd\u6267\u884c",(0,l.yg)("inlineCode",{parentName:"li"},"query()"),"\u8868\u51fd\u6570\u3002"),(0,l.yg)("li",{parentName:"ul"},(0,l.yg)("inlineCode",{parentName:"li"},"query")," \u8868\u51fd\u6570\u8bfb\u53d6\u5230\u7684\u7684\u6570\u636e\uff0c\u6570\u636e\u7c7b\u578b\u7684\u652f\u6301\u4e0e\u6240\u67e5\u8be2\u7684 catalog \u7c7b\u578b\u652f\u6301\u7684\u6570\u636e\u7c7b\u578b\u4e00\u81f4\u3002")))}m.isMDXComponent=!0}}]); |