| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[75863],{15680:(e,t,a)=>{a.d(t,{xA:()=>N,yg:()=>c});var r=a(296540);function n(e,t,a){return t in e?Object.defineProperty(e,t,{value:a,enumerable:!0,configurable:!0,writable:!0}):e[t]=a,e}function l(e,t){var a=Object.keys(e);if(Object.getOwnPropertySymbols){var r=Object.getOwnPropertySymbols(e);t&&(r=r.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),a.push.apply(a,r)}return a}function g(e){for(var t=1;t<arguments.length;t++){var a=null!=arguments[t]?arguments[t]:{};t%2?l(Object(a),!0).forEach((function(t){n(e,t,a[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(a)):l(Object(a)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(a,t))}))}return e}function y(e,t){if(null==e)return{};var a,r,n=function(e,t){if(null==e)return{};var a,r,n={},l=Object.keys(e);for(r=0;r<l.length;r++)a=l[r],t.indexOf(a)>=0||(n[a]=e[a]);return n}(e,t);if(Object.getOwnPropertySymbols){var l=Object.getOwnPropertySymbols(e);for(r=0;r<l.length;r++)a=l[r],t.indexOf(a)>=0||Object.prototype.propertyIsEnumerable.call(e,a)&&(n[a]=e[a])}return n}var p=r.createContext({}),d=function(e){var t=r.useContext(p),a=t;return e&&(a="function"==typeof e?e(t):g(g({},t),e)),a},N=function(e){var t=d(e.components);return r.createElement(p.Provider,{value:t},e.children)},i="mdxType",m={inlineCode:"code",wrapper:function(e){var t=e.children;return r.createElement(r.Fragment,{},t)}},o=r.forwardRef((function(e,t){var a=e.components,n=e.mdxType,l=e.originalType,p=e.parentName,N=y(e,["components","mdxType","originalType","parentName"]),i=d(a),o=n,c=i["".concat(p,".").concat(o)]||i[o]||m[o]||l;return a?r.createElement(c,g(g({ref:t},N),{},{components:a})):r.createElement(c,g({ref:t},N))}));function c(e,t){var a=arguments,n=t&&t.mdxType;if("string"==typeof e||n){var l=a.length,g=new Array(l);g[0]=o;var y={};for(var p in t)hasOwnProperty.call(t,p)&&(y[p]=t[p]);y.originalType=e,y[i]="string"==typeof e?e:n,g[1]=y;for(var d=2;d<l;d++)g[d]=a[d];return r.createElement.apply(null,g)}return r.createElement.apply(null,a)}o.displayName="MDXCreateElement"},379780:(e,t,a)=>{a.r(t),a.d(t,{assets:()=>p,contentTitle:()=>g,default:()=>m,frontMatter:()=>l,metadata:()=>y,toc:()=>d});var r=a(58168),n=(a(296540),a(15680));const l={title:"JDBC \u5916\u8868",language:"zh-CN"},g=void 0,y={unversionedId:"lakehouse/external-table/jdbc",id:"version-1.2/lakehouse/external-table/jdbc",title:"JDBC \u5916\u8868",description:"\x3c!--",source:"@site/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/external-table/jdbc.md",sourceDirName:"lakehouse/external-table",slug:"/lakehouse/external-table/jdbc",permalink:"/zh-CN/docs/1.2/lakehouse/external-table/jdbc",draft:!1,tags:[],version:"1.2",frontMatter:{title:"JDBC \u5916\u8868",language:"zh-CN"},sidebar:"docs",previous:{title:"Elasticsearch \u5916\u8868",permalink:"/zh-CN/docs/1.2/lakehouse/external-table/es"},next:{title:"ODBC \u5916\u8868",permalink:"/zh-CN/docs/1.2/lakehouse/external-table/odbc"}},p={},d=[{value:"Doris\u4e2d\u521b\u5efaJDBC\u7684\u5916\u8868",id:"doris\u4e2d\u521b\u5efajdbc\u7684\u5916\u8868",level:3},{value:"1. \u901a\u8fc7JDBC_Resource\u6765\u521b\u5efaJDBC\u5916\u8868",id:"1-\u901a\u8fc7jdbc_resource\u6765\u521b\u5efajdbc\u5916\u8868",level:4},{value:"\u67e5\u8be2\u7528\u6cd5",id:"\u67e5\u8be2\u7528\u6cd5",level:3},{value:"\u6570\u636e\u5199\u5165",id:"\u6570\u636e\u5199\u5165",level:3},{value:"\u4e8b\u52a1",id:"\u4e8b\u52a1",level:4},{value:"1.Mysql\u6d4b\u8bd5",id:"1mysql\u6d4b\u8bd5",level:4},{value:"2.PostgreSQL\u6d4b\u8bd5",id:"2postgresql\u6d4b\u8bd5",level:4},{value:"3.SQLServer\u6d4b\u8bd5",id:"3sqlserver\u6d4b\u8bd5",level:4},{value:"4.oracle\u6d4b\u8bd5",id:"4oracle\u6d4b\u8bd5",level:4},{value:"5.ClickHouse\u6d4b\u8bd5",id:"5clickhouse\u6d4b\u8bd5",level:4},{value:"6.Sap Hana\u6d4b\u8bd5",id:"6sap-hana\u6d4b\u8bd5",level:4},{value:"7.Trino\u6d4b\u8bd5",id:"7trino\u6d4b\u8bd5",level:4},{value:"8.OceanBase\u6d4b\u8bd5",id:"8oceanbase\u6d4b\u8bd5",level:4},{value:"\u7c7b\u578b\u5339\u914d",id:"\u7c7b\u578b\u5339\u914d",level:2},{value:"MySQL",id:"mysql",level:3},{value:"PostgreSQL",id:"postgresql",level:3},{value:"Oracle",id:"oracle",level:3},{value:"SQL server",id:"sql-server",level:3},{value:"ClickHouse",id:"clickhouse",level:3},{value:"SAP HANA",id:"sap-hana",level:3},{value:"Trino",id:"trino",level:3},{value:"OceanBase",id:"oceanbase",level:3},{value:"Q&A",id:"qa",level:2}],N={toc:d},i="wrapper";function m(e){let{components:t,...a}=e;return(0,n.yg)(i,(0,r.A)({},N,a,{components:t,mdxType:"MDXLayout"}),(0,n.yg)("h1",{id:"jdbc-\u5916\u8868"},"JDBC \u5916\u8868"),(0,n.yg)("version",{deprecated:"1.2.2"},(0,n.yg)("p",null,"\u63a8\u8350\u4f7f\u7528 ",(0,n.yg)("a",{parentName:"p",href:"/zh-CN/docs/1.2/lakehouse/multi-catalog/jdbc"},"JDBC Catalog")," \u8bbf\u95ee JDBC \u5916\u8868\uff0c1.2.2\u7248\u672c\u540e\u5c06\u4e0d\u518d\u7ef4\u62a4\u8be5\u529f\u80fd\u3002")),(0,n.yg)("version",{since:"1.2.0"},(0,n.yg)("p",null,"JDBC External Table Of Doris \u63d0\u4f9b\u4e86Doris\u901a\u8fc7\u6570\u636e\u5e93\u8bbf\u95ee\u7684\u6807\u51c6\u63a5\u53e3(JDBC)\u6765\u8bbf\u95ee\u5916\u90e8\u8868\uff0c\u5916\u90e8\u8868\u7701\u53bb\u4e86\u7e41\u7410\u7684\u6570\u636e\u5bfc\u5165\u5de5\u4f5c\uff0c\u8ba9Doris\u53ef\u4ee5\u5177\u6709\u4e86\u8bbf\u95ee\u5404\u5f0f\u6570\u636e\u5e93\u7684\u80fd\u529b\uff0c\u5e76\u501f\u52a9Doris\u672c\u8eab\u7684OLAP\u7684\u80fd\u529b\u6765\u89e3\u51b3\u5916\u90e8\u8868\u7684\u6570\u636e\u5206\u6790\u95ee\u9898\uff1a"),(0,n.yg)("ol",null,(0,n.yg)("li",{parentName:"ol"},"\u652f\u6301\u5404\u79cd\u6570\u636e\u6e90\u63a5\u5165Doris"),(0,n.yg)("li",{parentName:"ol"},"\u652f\u6301Doris\u4e0e\u5404\u79cd\u6570\u636e\u6e90\u4e2d\u7684\u8868\u8054\u5408\u67e5\u8be2\uff0c\u8fdb\u884c\u66f4\u52a0\u590d\u6742\u7684\u5206\u6790\u64cd\u4f5c")),(0,n.yg)("p",null,"\u672c\u6587\u6863\u4e3b\u8981\u4ecb\u7ecd\u8be5\u529f\u80fd\u7684\u4f7f\u7528\u65b9\u5f0f\u7b49\u3002")),(0,n.yg)("h3",{id:"doris\u4e2d\u521b\u5efajdbc\u7684\u5916\u8868"},"Doris\u4e2d\u521b\u5efaJDBC\u7684\u5916\u8868"),(0,n.yg)("p",null,"\u5177\u4f53\u5efa\u8868\u8bed\u6cd5\u53c2\u7167\uff1a",(0,n.yg)("a",{parentName:"p",href:"/zh-CN/docs/1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE"},"CREATE TABLE")),(0,n.yg)("h4",{id:"1-\u901a\u8fc7jdbc_resource\u6765\u521b\u5efajdbc\u5916\u8868"},"1. \u901a\u8fc7JDBC_Resource\u6765\u521b\u5efaJDBC\u5916\u8868"),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE EXTERNAL RESOURCE jdbc_resource\nproperties (\n "type"="jdbc",\n "user"="root",\n "password"="123456",\n "jdbc_url"="jdbc:mysql://192.168.0.1:3306/test?useCursorFetch=true",\n "driver_url"="http://IP:port/mysql-connector-java-5.1.47.jar",\n "driver_class"="com.mysql.jdbc.Driver"\n);\n \nCREATE EXTERNAL TABLE `baseall_mysql` (\n `k1` tinyint(4) NULL,\n `k2` smallint(6) NULL,\n `k3` int(11) NULL,\n `k4` bigint(20) NULL,\n `k5` decimal(9, 3) NULL\n) ENGINE=JDBC\nPROPERTIES (\n"resource" = "jdbc_resource",\n"table" = "baseall",\n"table_type"="mysql"\n);\n')),(0,n.yg)("p",null,"\u53c2\u6570\u8bf4\u660e\uff1a"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"\u53c2\u6570"),(0,n.yg)("th",{parentName:"tr",align:null},"\u8bf4\u660e"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"type")),(0,n.yg)("td",{parentName:"tr",align:null},'"jdbc", \u5fc5\u586b\u9879\u6807\u5fd7\u8d44\u6e90\u7c7b\u578b')),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"user")),(0,n.yg)("td",{parentName:"tr",align:null},"\u8bbf\u95ee\u5916\u8868\u6570\u636e\u5e93\u6240\u4f7f\u7684\u7528\u6237\u540d")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"password")),(0,n.yg)("td",{parentName:"tr",align:null},"\u8be5\u7528\u6237\u5bf9\u5e94\u7684\u5bc6\u7801\u4fe1\u606f")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"jdbc_url")),(0,n.yg)("td",{parentName:"tr",align:null},'JDBC\u7684URL\u534f\u8bae\uff0c\u5305\u62ec\u6570\u636e\u5e93\u7c7b\u578b\uff0cIP\u5730\u5740\uff0c\u7aef\u53e3\u53f7\u548c\u6570\u636e\u5e93\u540d\uff0c\u4e0d\u540c\u6570\u636e\u5e93\u534f\u8bae\u683c\u5f0f\u4e0d\u4e00\u6837\u3002\u4f8b\u5982mysql: "jdbc:mysql://127.0.0.1:3306/test?useCursorFetch=true"\u3002')),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"driver_class")),(0,n.yg)("td",{parentName:"tr",align:null},"\u8bbf\u95ee\u5916\u8868\u6570\u636e\u5e93\u7684\u9a71\u52a8\u5305\u7c7b\u540d\uff0c\u4f8b\u5982mysql\u662f:com.mysql.jdbc.Driver.")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"driver_url")),(0,n.yg)("td",{parentName:"tr",align:null},'\u7528\u4e8e\u4e0b\u8f7d\u8bbf\u95ee\u5916\u90e8\u6570\u636e\u5e93\u7684jar\u5305\u9a71\u52a8URL\u3002http://IP:port/mysql-connector-java-5.1.47.jar\u3002\u672c\u5730\u5355\u673a\u6d4b\u8bd5\u65f6\uff0c\u53ef\u5c06jar\u5305\u653e\u5728\u672c\u5730\u8def\u5f84\u4e0b\uff0c"driver_url"="file:///home/disk1/pathTo/mysql-connector-java-5.1.47.jar",\u591a\u673a\u65f6\u9700\u4fdd\u8bc1\u5177\u6709\u5b8c\u5168\u76f8\u540c\u7684\u8def\u5f84\u4fe1\u606f\u3002')),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"resource")),(0,n.yg)("td",{parentName:"tr",align:null},"\u5728Doris\u4e2d\u5efa\u7acb\u5916\u8868\u65f6\u4f9d\u8d56\u7684\u8d44\u6e90\u540d\uff0c\u5bf9\u5e94\u4e0a\u6b65\u521b\u5efa\u8d44\u6e90\u65f6\u7684\u540d\u5b57\u3002")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"table")),(0,n.yg)("td",{parentName:"tr",align:null},"\u5728Doris\u4e2d\u5efa\u7acb\u5916\u8868\u65f6\uff0c\u4e0e\u5916\u90e8\u6570\u636e\u5e93\u76f8\u6620\u5c04\u7684\u8868\u540d\u3002")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},(0,n.yg)("strong",{parentName:"td"},"table_type")),(0,n.yg)("td",{parentName:"tr",align:null},"\u5728Doris\u4e2d\u5efa\u7acb\u5916\u8868\u65f6\uff0c\u8be5\u8868\u6765\u81ea\u90a3\u4e2a\u6570\u636e\u5e93\u3002\u4f8b\u5982mysql,postgresql,sqlserver,oracle")))),(0,n.yg)("blockquote",null,(0,n.yg)("p",{parentName:"blockquote"},(0,n.yg)("strong",{parentName:"p"},"\u6ce8\u610f\uff1a")),(0,n.yg)("p",{parentName:"blockquote"},"\u5982\u679c\u4f60\u662f\u672c\u5730\u8def\u5f84\u65b9\u5f0f\uff0c\u8fd9\u91cc\u6570\u636e\u5e93\u9a71\u52a8\u4f9d\u8d56\u7684jar\u5305\uff0cFE\u3001BE\u8282\u70b9\u90fd\u8981\u653e\u7f6e")),(0,n.yg)("version",{since:"1.2.1"},(0,n.yg)("blockquote",null,(0,n.yg)("p",{parentName:"blockquote"},"\u57281.2.1\u53ca\u4e4b\u540e\u7684\u7248\u672c\u4e2d\uff0c\u53ef\u4ee5\u5c06 driver \u653e\u5230 FE/BE \u7684 ",(0,n.yg)("inlineCode",{parentName:"p"},"jdbc_drivers")," \u76ee\u5f55\u4e0b\uff0c\u5e76\u76f4\u63a5\u6307\u5b9a\u6587\u4ef6\u540d\uff0c\u5982\uff1a",(0,n.yg)("inlineCode",{parentName:"p"},'"driver_url" = "mysql-connector-java-5.1.47.jar"'),"\u3002\u7cfb\u7edf\u4f1a\u81ea\u52a8\u5728 ",(0,n.yg)("inlineCode",{parentName:"p"},"jdbc_drivers")," \u76ee\u5f55\u5bfb\u627e\u6587\u4ef6\u3002"))),(0,n.yg)("h3",{id:"\u67e5\u8be2\u7528\u6cd5"},"\u67e5\u8be2\u7528\u6cd5"),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre"},"select * from mysql_table where k1 > 1000 and k3 ='term';\n")),(0,n.yg)("p",null,'\u7531\u4e8e\u53ef\u80fd\u5b58\u5728\u4f7f\u7528\u6570\u636e\u5e93\u5185\u90e8\u7684\u5173\u952e\u5b57\u4f5c\u4e3a\u5b57\u6bb5\u540d\uff0c\u4e3a\u89e3\u51b3\u8fd9\u79cd\u72b6\u51b5\u4e0b\u4ecd\u80fd\u6b63\u786e\u67e5\u8be2\uff0c\u6240\u4ee5\u5728SQL\u8bed\u53e5\u4e2d\uff0c\u4f1a\u6839\u636e\u5404\u4e2a\u6570\u636e\u5e93\u7684\u6807\u51c6\u81ea\u52a8\u5728\u5b57\u6bb5\u540d\u4e0e\u8868\u540d\u4e0a\u52a0\u4e0a\u8f6c\u4e49\u7b26\u3002\u4f8b\u5982 MYSQL(``)\u3001PostgreSQL("")\u3001SQLServer([])\u3001ORACLE("")\uff0c\u6240\u4ee5\u6b64\u65f6\u53ef\u80fd\u4f1a\u9020\u6210\u5b57\u6bb5\u540d\u7684\u5927\u5c0f\u5199\u654f\u611f\uff0c\u5177\u4f53\u53ef\u4ee5\u901a\u8fc7explain sql\uff0c\u67e5\u770b\u8f6c\u4e49\u540e\u4e0b\u53d1\u5230\u5404\u4e2a\u6570\u636e\u5e93\u7684\u67e5\u8be2\u8bed\u53e5\u3002'),(0,n.yg)("h3",{id:"\u6570\u636e\u5199\u5165"},"\u6570\u636e\u5199\u5165"),(0,n.yg)("p",null,"\u5728Doris\u4e2d\u5efa\u7acbJDBC\u5916\u8868\u540e\uff0c\u53ef\u4ee5\u901a\u8fc7insert into\u8bed\u53e5\u76f4\u63a5\u5199\u5165\u6570\u636e\uff0c\u4e5f\u53ef\u4ee5\u5c06Doris\u6267\u884c\u5b8c\u67e5\u8be2\u4e4b\u540e\u7684\u7ed3\u679c\u5199\u5165JDBC\u5916\u8868\uff0c\u6216\u8005\u662f\u4ece\u4e00\u4e2aJDBC\u5916\u8868\u5c06\u6570\u636e\u5bfc\u5165\u53e6\u4e00\u4e2aJDBC\u5916\u8868\u3002"),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre"},'insert into mysql_table values(1, "doris");\ninsert into mysql_table select * from table;\n')),(0,n.yg)("h4",{id:"\u4e8b\u52a1"},"\u4e8b\u52a1"),(0,n.yg)("p",null,"Doris\u7684\u6570\u636e\u662f\u7531\u4e00\u7ec4batch\u7684\u65b9\u5f0f\u5199\u5165\u5916\u90e8\u8868\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\u4ee5JDBC\u5916\u8868\u652f\u6301\u6570\u636e\u5199\u5165\u65f6\u7684\u4e8b\u52a1\uff0c\u4e8b\u52a1\u7684\u652f\u6301\u9700\u8981\u901a\u8fc7\u8bbe\u7f6esession variable: ",(0,n.yg)("inlineCode",{parentName:"p"},"enable_odbc_transcation "),"(ODBC\u4e8b\u52a1\u4e5f\u53d7\u6b64\u53d8\u91cf\u63a7\u5236)\u3002"),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre"},"set enable_odbc_transcation = true; \n")),(0,n.yg)("p",null,"\u4e8b\u52a1\u4fdd\u8bc1\u4e86JDBC\u5916\u8868\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,n.yg)("h4",{id:"1mysql\u6d4b\u8bd5"},"1.Mysql\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"Mysql\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"Mysql JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"8.0.30"),(0,n.yg)("td",{parentName:"tr",align:null},"mysql-connector-java-5.1.47.jar")))),(0,n.yg)("h4",{id:"2postgresql\u6d4b\u8bd5"},"2.PostgreSQL\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"PostgreSQL\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"PostgreSQL JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"14.5"),(0,n.yg)("td",{parentName:"tr",align:null},"postgresql-42.5.0.jar")))),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE EXTERNAL RESOURCE jdbc_pg\nproperties (\n "type"="jdbc",\n "user"="postgres",\n "password"="123456",\n "jdbc_url"="jdbc:postgresql://127.0.0.1:5442/postgres?currentSchema=doris_test",\n "driver_url"="http://127.0.0.1:8881/postgresql-42.5.0.jar",\n "driver_class"="org.postgresql.Driver"\n);\n\nCREATE EXTERNAL TABLE `ext_pg` (\n `k1` int\n) ENGINE=JDBC\nPROPERTIES (\n "resource" = "jdbc_pg",\n "table" = "pg_tbl",\n "table_type"="postgresql"\n);\n')),(0,n.yg)("h4",{id:"3sqlserver\u6d4b\u8bd5"},"3.SQLServer\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"SQLserver\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"SQLserver JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"2022"),(0,n.yg)("td",{parentName:"tr",align:null},"mssql-jdbc-11.2.0.jre8.jar")))),(0,n.yg)("h4",{id:"4oracle\u6d4b\u8bd5"},"4.oracle\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"Oracle\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"Oracle JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"11"),(0,n.yg)("td",{parentName:"tr",align:null},"ojdbc6.jar")))),(0,n.yg)("p",null,"\u76ee\u524d\u53ea\u6d4b\u8bd5\u4e86\u8fd9\u4e00\u4e2a\u7248\u672c\u5176\u4ed6\u7248\u672c\u6d4b\u8bd5\u540e\u8865\u5145"),(0,n.yg)("h4",{id:"5clickhouse\u6d4b\u8bd5"},"5.ClickHouse\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"ClickHouse\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"ClickHouse JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"22"),(0,n.yg)("td",{parentName:"tr",align:null},"clickhouse-jdbc-0.3.2-patch11-all.jar")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"22"),(0,n.yg)("td",{parentName:"tr",align:null},"clickhouse-jdbc-0.4.1-all.jar")))),(0,n.yg)("h4",{id:"6sap-hana\u6d4b\u8bd5"},"6.Sap Hana\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"Sap Hana\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"Sap Hana JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"2.0"),(0,n.yg)("td",{parentName:"tr",align:null},"ngdbc.jar")))),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE EXTERNAL RESOURCE jdbc_hana\nproperties (\n "type"="jdbc",\n "user"="SYSTEM",\n "password"="SAPHANA",\n "jdbc_url" = "jdbc:sap://localhost:31515/TEST",\n "driver_url" = "file:///path/to/ngdbc.jar",\n "driver_class" = "com.sap.db.jdbc.Driver"\n);\n\nCREATE EXTERNAL TABLE `ext_hana` (\n `k1` int\n) ENGINE=JDBC\nPROPERTIES (\n "resource" = "jdbc_hana",\n "table" = "TEST.HANA",\n "table_type"="sap_hana"\n);\n')),(0,n.yg)("h4",{id:"7trino\u6d4b\u8bd5"},"7.Trino\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"Trino\u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"Trino JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"389"),(0,n.yg)("td",{parentName:"tr",align:null},"trino-jdbc-389.jar")))),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE EXTERNAL RESOURCE jdbc_trino\nproperties (\n "type"="jdbc",\n "user"="hadoop",\n "password"="",\n "jdbc_url" = "jdbc:trino://localhost:8080/hive",\n "driver_url" = "file:///path/to/trino-jdbc-389.jar",\n "driver_class" = "io.trino.jdbc.TrinoDriver"\n);\n\nCREATE EXTERNAL TABLE `ext_trino` (\n `k1` int\n) ENGINE=JDBC\nPROPERTIES (\n "resource" = "jdbc_trino",\n "table" = "hive.test",\n "table_type"="trino"\n);\n')),(0,n.yg)("h4",{id:"8oceanbase\u6d4b\u8bd5"},"8.OceanBase\u6d4b\u8bd5"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:null},"OceanBase \u7248\u672c"),(0,n.yg)("th",{parentName:"tr",align:null},"OceanBase JDBC\u9a71\u52a8\u7248\u672c"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:null},"3.2.3"),(0,n.yg)("td",{parentName:"tr",align:null},"oceanbase-client-2.4.2.jar")))),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE EXTERNAL RESOURCE jdbc_oceanbase\nproperties (\n "type"="jdbc",\n "user"="root",\n "password"="",\n "jdbc_url" = "jdbc:oceanbase://localhost:2881/test",\n "driver_url" = "file:///path/to/oceanbase-client-2.4.2.jar",\n "driver_class" = "com.oceanbase.jdbc.Driver",\n "oceanbase_mode" = "mysql" or "oracle"\n);\n\nCREATE EXTERNAL TABLE `ext_oceanbase` (\n `k1` int\n) ENGINE=JDBC\nPROPERTIES (\n "resource" = "jdbc_oceanbase",\n "table" = "test.test",\n "table_type"="oceanbase"\n);\n')),(0,n.yg)("blockquote",null,(0,n.yg)("p",{parentName:"blockquote"},(0,n.yg)("strong",{parentName:"p"},"\u6ce8\u610f\uff1a")),(0,n.yg)("p",{parentName:"blockquote"},"\u5728\u521b\u5efaOceanBase\u5916\u8868\u65f6\uff0c\u53ea\u9700\u5728\u521b\u5efaResource\u65f6\u6307\u5b9a",(0,n.yg)("inlineCode",{parentName:"p"},"oceanbase_mode"),"\u53c2\u6570\uff0c\u521b\u5efa\u5916\u8868\u7684table_type\u4e3aoceanbase\u3002")),(0,n.yg)("h2",{id:"\u7c7b\u578b\u5339\u914d"},"\u7c7b\u578b\u5339\u914d"),(0,n.yg)("p",null,"\u5404\u4e2a\u6570\u636e\u5e93\u4e4b\u95f4\u6570\u636e\u7c7b\u578b\u5b58\u5728\u4e0d\u540c\uff0c\u8fd9\u91cc\u5217\u51fa\u4e86\u5404\u4e2a\u6570\u636e\u5e93\u4e2d\u7684\u7c7b\u578b\u548cDoris\u4e4b\u4e2d\u6570\u636e\u7c7b\u578b\u5339\u914d\u7684\u60c5\u51b5\u3002"),(0,n.yg)("h3",{id:"mysql"},"MySQL"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"MySQL"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIT(1)"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"INT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT UNSIGNED"),(0,n.yg)("td",{parentName:"tr",align:"center"},"LARGEINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL")))),(0,n.yg)("h3",{id:"postgresql"},"PostgreSQL"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"PostgreSQL"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"INT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"TIMESTAMP"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"REAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL")))),(0,n.yg)("h3",{id:"oracle"},"Oracle"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"Oracle"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"INT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"REAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"NUMBER"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL")))),(0,n.yg)("h3",{id:"sql-server"},"SQL server"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"SQLServer"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"INT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"REAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL")))),(0,n.yg)("h3",{id:"clickhouse"},"ClickHouse"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"ClickHouse"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Boolean"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"String"),(0,n.yg)("td",{parentName:"tr",align:"center"},"STRING")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Date/Date32"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE/DATEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DateTime/DateTime64"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME/DATETIMEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Float32"),(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Float64"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Int8"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Int16/UInt8"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Int32/UInt16"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Int64/Uint32"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Int128/UInt64"),(0,n.yg)("td",{parentName:"tr",align:"center"},"LARGEINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Int256/UInt128/UInt256"),(0,n.yg)("td",{parentName:"tr",align:"center"},"STRING")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Decimal"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL/DECIMALV3/STRING")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"Enum/IPv4/IPv6/UUID"),(0,n.yg)("td",{parentName:"tr",align:"center"},"STRING")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},(0,n.yg)("version",{since:"dev",type:"inline"}," Array(T) ")),(0,n.yg)("td",{parentName:"tr",align:"center"},"ARRAY\\<T",">")))),(0,n.yg)("p",null,(0,n.yg)("strong",{parentName:"p"},"\u6ce8\u610f\uff1a")),(0,n.yg)("ul",null,(0,n.yg)("li",{parentName:"ul"},(0,n.yg)("version",{since:"dev",type:"inline"}," \u5bf9\u4e8eClickHouse\u91cc\u7684Array\u7c7b\u578b,\u53ef\u7528Doris\u7684Array\u7c7b\u578b\u6765\u5339\u914d\uff0cArray\u5185\u7684\u57fa\u7840\u7c7b\u578b\u5339\u914d\u53c2\u8003\u57fa\u7840\u7c7b\u578b\u5339\u914d\u89c4\u5219\u5373\u53ef\uff0c\u4e0d\u652f\u6301\u5d4c\u5957Array ")),(0,n.yg)("li",{parentName:"ul"},"\u5bf9\u4e8eClickHouse\u91cc\u7684\u4e00\u4e9b\u7279\u6b8a\u7c7b\u578b\uff0c\u5982UUID,IPv4,IPv6,Enum8\u53ef\u4ee5\u7528Doris\u7684Varchar/String\u7c7b\u578b\u6765\u5339\u914d,\u4f46\u662f\u5728\u663e\u793a\u4e0aIPv4,IPv6\u4f1a\u989d\u5916\u5728\u6570\u636e\u6700\u524d\u9762\u663e\u793a\u4e00\u4e2a",(0,n.yg)("inlineCode",{parentName:"li"},"/"),",\u9700\u8981\u81ea\u5df1\u7528",(0,n.yg)("inlineCode",{parentName:"li"},"split_part"),"\u51fd\u6570\u5904\u7406"),(0,n.yg)("li",{parentName:"ul"},"\u5bf9\u4e8eClickHouse\u7684Geo\u7c7b\u578bPoint,\u65e0\u6cd5\u8fdb\u884c\u5339\u914d")),(0,n.yg)("h3",{id:"sap-hana"},"SAP HANA"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"SAP_HANA"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"INTERGER"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLDECIMAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL/DECIMALV3")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL/DECIMALV3")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"REAL"),(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE/DATEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"TIME"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TEXT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"TIMESTAMP"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME/DATETIMEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SECONDDATE"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME/DATETIMEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"VARCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TEXT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"NVARCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TEXT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"ALPHANUM"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TEXT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"SHORTTEXT"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TEXT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"CHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"CHAR")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"NCHAR"),(0,n.yg)("td",{parentName:"tr",align:"center"},"CHAR")))),(0,n.yg)("h3",{id:"trino"},"Trino"),(0,n.yg)("table",null,(0,n.yg)("thead",{parentName:"table"},(0,n.yg)("tr",{parentName:"thead"},(0,n.yg)("th",{parentName:"tr",align:"center"},"Trino"),(0,n.yg)("th",{parentName:"tr",align:"center"},"Doris"))),(0,n.yg)("tbody",{parentName:"table"},(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"boolean"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BOOLEAN")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"tinyint"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TINYINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"smallint"),(0,n.yg)("td",{parentName:"tr",align:"center"},"SMALLINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"integer"),(0,n.yg)("td",{parentName:"tr",align:"center"},"INT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"bigint"),(0,n.yg)("td",{parentName:"tr",align:"center"},"BIGINT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"decimal"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DECIMAL/DECIMALV3")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"real"),(0,n.yg)("td",{parentName:"tr",align:"center"},"FLOAT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"double"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DOUBLE")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"date"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATE/DATEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"timestamp"),(0,n.yg)("td",{parentName:"tr",align:"center"},"DATETIME/DATETIMEV2")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"varchar"),(0,n.yg)("td",{parentName:"tr",align:"center"},"TEXT")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"char"),(0,n.yg)("td",{parentName:"tr",align:"center"},"CHAR")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"array"),(0,n.yg)("td",{parentName:"tr",align:"center"},"ARRAY")),(0,n.yg)("tr",{parentName:"tbody"},(0,n.yg)("td",{parentName:"tr",align:"center"},"others"),(0,n.yg)("td",{parentName:"tr",align:"center"},"UNSUPPORTED")))),(0,n.yg)("h3",{id:"oceanbase"},"OceanBase"),(0,n.yg)("p",null,"MySQL \u6a21\u5f0f\u8bf7\u53c2\u8003 ",(0,n.yg)("a",{parentName:"p",href:"#MySQL"},"MySQL\u7c7b\u578b\u6620\u5c04"),"\nOracle \u6a21\u5f0f\u8bf7\u53c2\u8003 ",(0,n.yg)("a",{parentName:"p",href:"#Oracle"},"Oracle\u7c7b\u578b\u6620\u5c04")),(0,n.yg)("h2",{id:"qa"},"Q&A"),(0,n.yg)("p",null,"\u8bf7\u53c2\u8003 ",(0,n.yg)("a",{parentName:"p",href:"/zh-CN/docs/1.2/lakehouse/multi-catalog/jdbc"},"JDBC Catalog")," \u4e2d\u7684 \u5e38\u89c1\u95ee\u9898\u4e00\u8282\u3002"))}m.isMDXComponent=!0}}]); |