| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[43780],{15680:(e,a,t)=>{t.d(a,{xA:()=>y,yg:()=>s});var n=t(296540);function l(e,a,t){return a in e?Object.defineProperty(e,a,{value:t,enumerable:!0,configurable:!0,writable:!0}):e[a]=t,e}function r(e,a){var t=Object.keys(e);if(Object.getOwnPropertySymbols){var n=Object.getOwnPropertySymbols(e);a&&(n=n.filter((function(a){return Object.getOwnPropertyDescriptor(e,a).enumerable}))),t.push.apply(t,n)}return t}function p(e){for(var a=1;a<arguments.length;a++){var t=null!=arguments[a]?arguments[a]:{};a%2?r(Object(t),!0).forEach((function(a){l(e,a,t[a])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(t)):r(Object(t)).forEach((function(a){Object.defineProperty(e,a,Object.getOwnPropertyDescriptor(t,a))}))}return e}function i(e,a){if(null==e)return{};var t,n,l=function(e,a){if(null==e)return{};var t,n,l={},r=Object.keys(e);for(n=0;n<r.length;n++)t=r[n],a.indexOf(t)>=0||(l[t]=e[t]);return l}(e,a);if(Object.getOwnPropertySymbols){var r=Object.getOwnPropertySymbols(e);for(n=0;n<r.length;n++)t=r[n],a.indexOf(t)>=0||Object.prototype.propertyIsEnumerable.call(e,t)&&(l[t]=e[t])}return l}var g=n.createContext({}),o=function(e){var a=n.useContext(g),t=a;return e&&(t="function"==typeof e?e(a):p(p({},a),e)),t},y=function(e){var a=o(e.components);return n.createElement(g.Provider,{value:a},e.children)},m="mdxType",u={inlineCode:"code",wrapper:function(e){var a=e.children;return n.createElement(n.Fragment,{},a)}},N=n.forwardRef((function(e,a){var t=e.components,l=e.mdxType,r=e.originalType,g=e.parentName,y=i(e,["components","mdxType","originalType","parentName"]),m=o(t),N=l,s=m["".concat(g,".").concat(N)]||m[N]||u[N]||r;return t?n.createElement(s,p(p({ref:a},y),{},{components:t})):n.createElement(s,p({ref:a},y))}));function s(e,a){var t=arguments,l=a&&a.mdxType;if("string"==typeof e||l){var r=t.length,p=new Array(r);p[0]=N;var i={};for(var g in a)hasOwnProperty.call(a,g)&&(i[g]=a[g]);i.originalType=e,i[m]="string"==typeof e?e:l,p[1]=i;for(var o=2;o<r;o++)p[o]=t[o];return n.createElement.apply(null,p)}return n.createElement.apply(null,t)}N.displayName="MDXCreateElement"},514384:(e,a,t)=>{t.r(a),t.d(a,{assets:()=>g,contentTitle:()=>p,default:()=>u,frontMatter:()=>r,metadata:()=>i,toc:()=>o});var n=t(58168),l=(t(296540),t(15680));const r={title:"\u4e25\u683c\u6a21\u5f0f",language:"zh-CN"},p=void 0,i={unversionedId:"data-operate/import/load-strict-mode",id:"version-2.1/data-operate/import/load-strict-mode",title:"\u4e25\u683c\u6a21\u5f0f",description:"\x3c!--",source:"@site/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/import/load-strict-mode.md",sourceDirName:"data-operate/import",slug:"/data-operate/import/load-strict-mode",permalink:"/zh-CN/docs/data-operate/import/load-strict-mode",draft:!1,tags:[],version:"2.1",frontMatter:{title:"\u4e25\u683c\u6a21\u5f0f",language:"zh-CN"},sidebar:"docs",previous:{title:"\u6700\u5c0f\u5199\u5165\u526f\u672c\u6570",permalink:"/zh-CN/docs/data-operate/import/min-load-replica-num"},next:{title:"\u6570\u636e\u66f4\u65b0\u6982\u8ff0",permalink:"/zh-CN/docs/data-operate/update/update-overview"}},g={},o=[{value:"\u5982\u4f55\u8bbe\u7f6e",id:"\u5982\u4f55\u8bbe\u7f6e",level:2},{value:"\u4e25\u683c\u6a21\u5f0f\u7684\u4f5c\u7528",id:"\u4e25\u683c\u6a21\u5f0f\u7684\u4f5c\u7528",level:2},{value:"\u5bf9\u4e8e\u5bfc\u5165\u8fc7\u7a0b\u4e2d\u7684\u5217\u7c7b\u578b\u8f6c\u6362\u8fdb\u884c\u4e25\u683c\u8fc7\u6ee4\u3002",id:"\u5bf9\u4e8e\u5bfc\u5165\u8fc7\u7a0b\u4e2d\u7684\u5217\u7c7b\u578b\u8f6c\u6362\u8fdb\u884c\u4e25\u683c\u8fc7\u6ee4",level:3},{value:"\u9650\u5b9a\u90e8\u5206\u5217\u66f4\u65b0\u53ea\u80fd\u66f4\u65b0\u5df2\u6709\u7684\u5217",id:"\u9650\u5b9a\u90e8\u5206\u5217\u66f4\u65b0\u53ea\u80fd\u66f4\u65b0\u5df2\u6709\u7684\u5217",level:3}],y={toc:o},m="wrapper";function u(e){let{components:a,...t}=e;return(0,l.yg)(m,(0,n.A)({},y,t,{components:a,mdxType:"MDXLayout"}),(0,l.yg)("p",null,"\u4e25\u683c\u6a21\u5f0f\uff08strict_mode\uff09\u4e3a\u5bfc\u5165\u64cd\u4f5c\u4e2d\u7684\u4e00\u4e2a\u53c2\u6570\u914d\u7f6e\u3002\u8be5\u53c2\u6570\u4f1a\u5f71\u54cd\u67d0\u4e9b\u6570\u503c\u7684\u5bfc\u5165\u884c\u4e3a\u548c\u6700\u7ec8\u5bfc\u5165\u7684\u6570\u636e\u3002"),(0,l.yg)("p",null,"\u672c\u6587\u6863\u4e3b\u8981\u8bf4\u660e\u5982\u4f55\u8bbe\u7f6e\u4e25\u683c\u6a21\u5f0f\uff0c\u4ee5\u53ca\u4e25\u683c\u6a21\u5f0f\u4ea7\u751f\u7684\u5f71\u54cd\u3002"),(0,l.yg)("h2",{id:"\u5982\u4f55\u8bbe\u7f6e"},"\u5982\u4f55\u8bbe\u7f6e"),(0,l.yg)("p",null,"\u4e25\u683c\u6a21\u5f0f\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u90fd\u4e3a False\uff0c\u5373\u5173\u95ed\u72b6\u6001\u3002"),(0,l.yg)("p",null,"\u4e0d\u540c\u7684\u5bfc\u5165\u65b9\u5f0f\u8bbe\u7f6e\u4e25\u683c\u6a21\u5f0f\u7684\u65b9\u5f0f\u4e0d\u5c3d\u76f8\u540c\u3002"),(0,l.yg)("ol",null,(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("a",{parentName:"p",href:"../../sql-manual/sql-statements/Data-Manipulation-Statements/Load/BROKER-LOAD"},"BROKER LOAD")),(0,l.yg)("pre",{parentName:"li"},(0,l.yg)("code",{parentName:"pre",className:"language-sql"},'LOAD LABEL example_db.label1\n(\n DATA INFILE("bos://my_bucket/input/file.txt")\n INTO TABLE `my_table`\n COLUMNS TERMINATED BY ","\n)\nWITH BROKER bos\n(\n "bos_endpoint" = "http://bj.bcebos.com",\n "bos_accesskey" = "xxxxxxxxxxxxxxxxxxxxxxxxxx",\n "bos_secret_accesskey"="yyyyyyyyyyyyyyyyyyyyyyyyyy"\n)\nPROPERTIES\n(\n "strict_mode" = "true"\n)\n'))),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("a",{parentName:"p",href:"../../sql-manual/sql-statements/Data-Manipulation-Statements/Load/STREAM-LOAD"},"STREAM LOAD")),(0,l.yg)("pre",{parentName:"li"},(0,l.yg)("code",{parentName:"pre",className:"language-bash"},'curl --location-trusted -u user:passwd \\\n-H "strict_mode: true" \\\n-T 1.txt \\\nhttp://host:port/api/example_db/my_table/_stream_load\n'))),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("a",{parentName:"p",href:"../../sql-manual/sql-statements/Data-Manipulation-Statements/Load/CREATE-ROUTINE-LOAD"},"ROUTINE LOAD")),(0,l.yg)("pre",{parentName:"li"},(0,l.yg)("code",{parentName:"pre",className:"language-sql"},'CREATE ROUTINE LOAD example_db.test_job ON my_table\nPROPERTIES\n(\n "strict_mode" = "true"\n) \nFROM KAFKA\n(\n "kafka_broker_list" = "broker1:9092,broker2:9092,broker3:9092",\n "kafka_topic" = "my_topic"\n);\n'))),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("a",{parentName:"p",href:"../../sql-manual/sql-statements/Data-Manipulation-Statements/Manipulation/INSERT"},"INSERT")),(0,l.yg)("p",{parentName:"li"},"\u901a\u8fc7",(0,l.yg)("a",{parentName:"p",href:"../../query/query-variables/variables"},"\u4f1a\u8bdd\u53d8\u91cf"),"\u8bbe\u7f6e\uff1a"),(0,l.yg)("pre",{parentName:"li"},(0,l.yg)("code",{parentName:"pre",className:"language-sql"},"SET enable_insert_strict = true;\nINSERT INTO my_table ...;\n")))),(0,l.yg)("h2",{id:"\u4e25\u683c\u6a21\u5f0f\u7684\u4f5c\u7528"},"\u4e25\u683c\u6a21\u5f0f\u7684\u4f5c\u7528"),(0,l.yg)("h3",{id:"\u5bf9\u4e8e\u5bfc\u5165\u8fc7\u7a0b\u4e2d\u7684\u5217\u7c7b\u578b\u8f6c\u6362\u8fdb\u884c\u4e25\u683c\u8fc7\u6ee4"},"\u5bf9\u4e8e\u5bfc\u5165\u8fc7\u7a0b\u4e2d\u7684\u5217\u7c7b\u578b\u8f6c\u6362\u8fdb\u884c\u4e25\u683c\u8fc7\u6ee4\u3002"),(0,l.yg)("p",null,"\u4e25\u683c\u8fc7\u6ee4\u7684\u7b56\u7565\u5982\u4e0b\uff1a"),(0,l.yg)("p",null,"\u5bf9\u4e8e\u5217\u7c7b\u578b\u8f6c\u6362\u6765\u8bf4\uff0c\u5982\u679c\u5f00\u542f\u4e25\u683c\u6a21\u5f0f\uff0c\u5219\u9519\u8bef\u7684\u6570\u636e\u5c06\u88ab\u8fc7\u6ee4\u3002\u8fd9\u91cc\u7684\u9519\u8bef\u6570\u636e\u662f\u6307\uff1a\u539f\u59cb\u6570\u636e\u5e76\u4e0d\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"null"),"\uff0c\u800c\u5728\u8fdb\u884c\u5217\u7c7b\u578b\u8f6c\u6362\u540e\u7ed3\u679c\u4e3a ",(0,l.yg)("inlineCode",{parentName:"p"},"null")," \u7684\u8fd9\u4e00\u7c7b\u6570\u636e\u3002"),(0,l.yg)("p",null,"\u8fd9\u91cc\u8bf4\u6307\u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"\u5217\u7c7b\u578b\u8f6c\u6362"),"\uff0c\u5e76\u4e0d\u5305\u62ec\u7528\u51fd\u6570\u8ba1\u7b97\u5f97\u51fa\u7684 ",(0,l.yg)("inlineCode",{parentName:"p"},"null")," \u503c\u3002"),(0,l.yg)("p",null,"\u5bf9\u4e8e\u5bfc\u5165\u7684\u67d0\u5217\u7c7b\u578b\u5305\u542b\u8303\u56f4\u9650\u5236\u7684\uff0c\u5982\u679c\u539f\u59cb\u6570\u636e\u80fd\u6b63\u5e38\u901a\u8fc7\u7c7b\u578b\u8f6c\u6362\uff0c\u4f46\u65e0\u6cd5\u901a\u8fc7\u8303\u56f4\u9650\u5236\u7684\uff0c\u4e25\u683c\u6a21\u5f0f\u5bf9\u5176\u4e5f\u4e0d\u4ea7\u751f\u5f71\u54cd\u3002\u4f8b\u5982\uff1a\u5982\u679c\u7c7b\u578b\u662f ",(0,l.yg)("inlineCode",{parentName:"p"},"decimal(1,0)"),", \u539f\u59cb\u6570\u636e\u4e3a 10\uff0c\u5219\u5c5e\u4e8e\u53ef\u4ee5\u901a\u8fc7\u7c7b\u578b\u8f6c\u6362\u4f46\u4e0d\u5728\u5217\u58f0\u660e\u7684\u8303\u56f4\u5185\u3002\u8fd9\u79cd\u6570\u636e strict \u5bf9\u5176\u4e0d\u4ea7\u751f\u5f71\u54cd\u3002"),(0,l.yg)("p",null,(0,l.yg)("strong",{parentName:"p"},"1. \u4ee5\u5217\u7c7b\u578b\u4e3a TinyInt \u6765\u4e3e\u4f8b\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},"\u539f\u59cb\u6570\u636e\u7c7b\u578b"),(0,l.yg)("th",{parentName:"tr",align:null},"\u539f\u59cb\u6570\u636e\u4e3e\u4f8b"),(0,l.yg)("th",{parentName:"tr",align:null},"\u8f6c\u6362\u4e3a TinyInt \u540e\u7684\u503c"),(0,l.yg)("th",{parentName:"tr",align:null},"\u4e25\u683c\u6a21\u5f0f"),(0,l.yg)("th",{parentName:"tr",align:null},"\u7ed3\u679c"))),(0,l.yg)("tbody",{parentName:"table"},(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},"\\N"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f00\u542f\u6216\u5173\u95ed"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},'"abc" or 2000'),(0,l.yg)("td",{parentName:"tr",align:null},"NULL"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f00\u542f"),(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u6cd5\u503c\uff08\u88ab\u8fc7\u6ee4\uff09")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},'"abc"'),(0,l.yg)("td",{parentName:"tr",align:null},"NULL"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5173\u95ed"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},"1"),(0,l.yg)("td",{parentName:"tr",align:null},"1"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f00\u542f\u6216\u5173\u95ed"),(0,l.yg)("td",{parentName:"tr",align:null},"\u6b63\u786e\u5bfc\u5165")))),(0,l.yg)("admonition",{type:"tip"},(0,l.yg)("p",{parentName:"admonition"},"\u8bf4\u660e\uff1a"),(0,l.yg)("ol",{parentName:"admonition"},(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u8868\u4e2d\u7684\u5217\u5141\u8bb8\u5bfc\u5165\u7a7a\u503c")),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("inlineCode",{parentName:"p"},"abc")," \u53ca ",(0,l.yg)("inlineCode",{parentName:"p"},"2000")," \u5728\u8f6c\u6362\u4e3a TinyInt \u540e\uff0c\u4f1a\u56e0\u7c7b\u578b\u6216\u7cbe\u5ea6\u95ee\u9898\u53d8\u4e3a NULL\u3002\u5728\u4e25\u683c\u6a21\u5f0f\u5f00\u542f\u7684\u60c5\u51b5\u4e0b\uff0c\u8fd9\u7c7b\u6570\u636e\u5c06\u4f1a\u88ab\u8fc7\u6ee4\u3002\u800c\u5982\u679c\u662f\u5173\u95ed\u72b6\u6001\uff0c\u5219\u4f1a\u5bfc\u5165 ",(0,l.yg)("inlineCode",{parentName:"p"},"null"),"\u3002")))),(0,l.yg)("p",null,(0,l.yg)("strong",{parentName:"p"},"2. \u4ee5\u5217\u7c7b\u578b\u4e3a Decimal(1,0) \u4e3e\u4f8b")),(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},"\u539f\u59cb\u6570\u636e\u7c7b\u578b"),(0,l.yg)("th",{parentName:"tr",align:null},"\u539f\u59cb\u6570\u636e\u4e3e\u4f8b"),(0,l.yg)("th",{parentName:"tr",align:null},"\u8f6c\u6362\u4e3a Decimal \u540e\u7684\u503c"),(0,l.yg)("th",{parentName:"tr",align:null},"\u4e25\u683c\u6a21\u5f0f"),(0,l.yg)("th",{parentName:"tr",align:null},"\u7ed3\u679c"))),(0,l.yg)("tbody",{parentName:"table"},(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},"\\N"),(0,l.yg)("td",{parentName:"tr",align:null},"null"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f00\u542f\u6216\u5173\u95ed"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},"aaa"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f00\u542f"),(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u6cd5\u503c\uff08\u88ab\u8fc7\u6ee4\uff09")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},"aaa"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5173\u95ed"),(0,l.yg)("td",{parentName:"tr",align:null},"NULL")),(0,l.yg)("tr",{parentName:"tbody"},(0,l.yg)("td",{parentName:"tr",align:null},"\u975e\u7a7a\u503c"),(0,l.yg)("td",{parentName:"tr",align:null},"1 or 10"),(0,l.yg)("td",{parentName:"tr",align:null},"1 or 10"),(0,l.yg)("td",{parentName:"tr",align:null},"\u5f00\u542f\u6216\u5173\u95ed"),(0,l.yg)("td",{parentName:"tr",align:null},"\u6b63\u786e\u5bfc\u5165")))),(0,l.yg)("admonition",{type:"tip"},(0,l.yg)("p",{parentName:"admonition"},"\u8bf4\u660e\uff1a"),(0,l.yg)("ol",{parentName:"admonition"},(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},"\u8868\u4e2d\u7684\u5217\u5141\u8bb8\u5bfc\u5165\u7a7a\u503c")),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("inlineCode",{parentName:"p"},"abc")," \u5728\u8f6c\u6362\u4e3a Decimal \u540e\uff0c\u4f1a\u56e0\u7c7b\u578b\u95ee\u9898\u53d8\u4e3a NULL\u3002\u5728\u4e25\u683c\u6a21\u5f0f\u5f00\u542f\u7684\u60c5\u51b5\u4e0b\uff0c\u8fd9\u7c7b\u6570\u636e\u5c06\u4f1a\u88ab\u8fc7\u6ee4\u3002\u800c\u5982\u679c\u662f\u5173\u95ed\u72b6\u6001\uff0c\u5219\u4f1a\u5bfc\u5165 ",(0,l.yg)("inlineCode",{parentName:"p"},"null"),"\u3002")),(0,l.yg)("li",{parentName:"ol"},(0,l.yg)("p",{parentName:"li"},(0,l.yg)("inlineCode",{parentName:"p"},"10")," \u867d\u7136\u662f\u4e00\u4e2a\u8d85\u8fc7\u8303\u56f4\u7684\u503c\uff0c\u4f46\u662f\u56e0\u4e3a\u5176\u7c7b\u578b\u7b26\u5408 decimal \u7684\u8981\u6c42\uff0c\u6240\u4ee5\u4e25\u683c\u6a21\u5f0f\u5bf9\u5176\u4e0d\u4ea7\u751f\u5f71\u54cd\u3002",(0,l.yg)("inlineCode",{parentName:"p"},"10")," \u6700\u540e\u4f1a\u5728\u5176\u4ed6\u5bfc\u5165\u5904\u7406\u6d41\u7a0b\u4e2d\u88ab\u8fc7\u6ee4\u3002\u4f46\u4e0d\u4f1a\u88ab\u4e25\u683c\u6a21\u5f0f\u8fc7\u6ee4\u3002")))),(0,l.yg)("h3",{id:"\u9650\u5b9a\u90e8\u5206\u5217\u66f4\u65b0\u53ea\u80fd\u66f4\u65b0\u5df2\u6709\u7684\u5217"},"\u9650\u5b9a\u90e8\u5206\u5217\u66f4\u65b0\u53ea\u80fd\u66f4\u65b0\u5df2\u6709\u7684\u5217"),(0,l.yg)("p",null,"\u5728\u4e25\u683c\u6a21\u5f0f\u4e0b\uff0c\u90e8\u5206\u5217\u66f4\u65b0\u63d2\u5165\u7684\u6bcf\u4e00\u884c\u6570\u636e\u5fc5\u987b\u6ee1\u8db3\u8be5\u884c\u6570\u636e\u7684 Key \u5728\u8868\u4e2d\u5df2\u7ecf\u5b58\u5728\u3002\u800c\u5728\u800c\u975e\u4e25\u683c\u6a21\u5f0f\u4e0b\uff0c\u8fdb\u884c\u90e8\u5206\u5217\u66f4\u65b0\u65f6\u53ef\u4ee5\u66f4\u65b0 Key \u5df2\u7ecf\u5b58\u5728\u7684\u884c\uff0c\u4e5f\u53ef\u4ee5\u63d2\u5165 Key \u4e0d\u5b58\u5728\u7684\u65b0\u884c\u3002"),(0,l.yg)("p",null,"\u4f8b\u5982\u6709\u8868\u7ed3\u6784\u5982\u4e0b\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre"},"mysql> desc user_profile;\n+------------------+-----------------+------+-------+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+------------------+-----------------+------+-------+---------+-------+\n| id | INT | Yes | true | NULL | |\n| name | VARCHAR(10) | Yes | false | NULL | NONE |\n| age | INT | Yes | false | NULL | NONE |\n| city | VARCHAR(10) | Yes | false | NULL | NONE |\n| balance | DECIMALV3(9, 0) | Yes | false | NULL | NONE |\n| last_access_time | DATETIME | Yes | false | NULL | NONE |\n+------------------+-----------------+------+-------+---------+-------+\n")),(0,l.yg)("p",null,"\u8868\u4e2d\u6709\u4e00\u6761\u6570\u636e\u5982\u4e0b\uff1a"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},'1,"kevin",18,"shenzhen",400,"2023-07-01 12:00:00"\n')),(0,l.yg)("p",null,"\u5f53\u7528\u6237\u4f7f\u7528\u975e\u4e25\u683c\u6a21\u5f0f\u7684 Stream Load \u90e8\u5206\u5217\u66f4\u65b0\u5411\u8868\u4e2d\u63d2\u5165\u5982\u4e0b\u6570\u636e\u65f6"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-sql"},"1,500,2023-07-03 12:00:01\n3,23,2023-07-03 12:00:02\n18,9999999,2023-07-03 12:00:03\n")),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-bash"},'curl --location-trusted -u root -H "partial_columns:true" -H "strict_mode:false" -H "column_separator:," -H "columns:id,balance,last_access_time" -T /tmp/test.csv http://host:port/api/db1/user_profile/_stream_load\n')),(0,l.yg)("p",null,"\u8868\u4e2d\u539f\u6709\u7684\u4e00\u6761\u6570\u636e\u5c06\u4f1a\u88ab\u66f4\u65b0\uff0c\u6b64\u5916\u8fd8\u5411\u8868\u4e2d\u63d2\u5165\u4e86\u4e24\u6761\u65b0\u6570\u636e\u3002\u5bf9\u4e8e\u63d2\u5165\u7684\u6570\u636e\u4e2d\u7528\u6237\u6ca1\u6709\u6307\u5b9a\u7684\u5217\uff0c\u5982\u679c\u8be5\u5217\u6709\u9ed8\u8ba4\u503c\uff0c\u5219\u4f1a\u4ee5\u9ed8\u8ba4\u503c\u586b\u5145\uff1b\u5426\u5219\uff0c\u5982\u679c\u8be5\u5217\u53ef\u4ee5\u4e3a NULL\uff0c\u5219\u5c06\u4ee5 NULL \u503c\u586b\u5145\uff1b\u5426\u5219\u672c\u6b21\u63d2\u5165\u4e0d\u6210\u529f\u3002"),(0,l.yg)("p",null,"\u800c\u5f53\u7528\u6237\u4f7f\u7528\u4e25\u683c\u6a21\u5f0f\u7684 Stream Load \u90e8\u5206\u5217\u66f4\u65b0\u5411\u8868\u4e2d\u63d2\u5165\u4e0a\u8ff0\u6570\u636e\u65f6"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre",className:"language-bash"},'curl --location-trusted -u root -H "partial_columns:true" -H "strict_mode:true" -H "column_separator:," -H "columns:id,balance,last_access_time" -T /tmp/test.csv http://host:port/api/db1/user_profile/_stream_load\n')),(0,l.yg)("p",null,"\u6b64\u65f6\uff0c\u7531\u4e8e\u5f00\u542f\u4e86\u4e25\u683c\u6a21\u5f0f\u4e14\u7b2c\u4e8c\u3001\u4e09\u884c\u7684\u6570\u636e\u7684 key(",(0,l.yg)("inlineCode",{parentName:"p"},"(3)"),", ",(0,l.yg)("inlineCode",{parentName:"p"},"(18)"),") \u4e0d\u5728\u539f\u8868\u4e2d\uff0c\u6240\u4ee5\u672c\u6b21\u5bfc\u5165\u4f1a\u5931\u8d25\u3002"))}u.isMDXComponent=!0}}]); |