{"id":390,"date":"2019-07-31T19:28:36","date_gmt":"2019-07-31T11:28:36","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=390"},"modified":"2019-08-01T17:03:07","modified_gmt":"2019-08-01T09:03:07","slug":"%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=390","title":{"rendered":"TDT6.1 oracle_to_inceptor \u57fa\u4e8eID\u548cTIME\u589e\u91cf\u5bfc\u5165"},"content":{"rendered":"<h2>\u57fa\u4e8eID\u589e\u91cf\u5bfc\u5165<\/h2>\n<h2>\u4e00\uff0e   TDT\u4fa7\u914d\u7f6e<\/h2>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564572719688.png\" alt=\"file\" \/><\/p>\n<h3>1.1 \u914d\u7f6eoracle\u548cinceptor\u8fde\u63a5<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564572727490.png\" alt=\"file\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564572736241.png\" alt=\"file\" \/><\/p>\n<h3>1.2 JDBC Reader\u914d\u7f6e<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564572772178.png\" alt=\"file\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564572780985.png\" alt=\"file\" \/><\/p>\n<blockquote>\n<p>Oracle\u4fa7\u8868 lkw.emp01<\/p>\n<\/blockquote>\n<pre><code class=\"language-sql\">create table EMP01\n(\n  empno    NUMBER(4) not null,\n  ename    VARCHAR2(10),\n  job      VARCHAR2(9),\n  mgr      NUMBER(4),\n  hiredate DATE,\n  sal      NUMBER(7,2),\n  comm     NUMBER(7,2),\n  deptno   NUMBER(2)\n)\ntablespace PFM;<\/code><\/pre>\n<blockquote>\n<p>Inceptor \u4fa7orc\u4e8b\u52a1\u8868 new_emp01(\u9700\u8981\u63d0\u524d\u521b\u5efa)\uff1a<\/p>\n<\/blockquote>\n<pre><code class=\"language-sql\">CREATE  TABLE lkw.new_emp01(\n  empno int DEFAULT NULL COMMENT '\u96c7\u5458\u7f16\u53f7', \n  ename string DEFAULT NULL COMMENT '\u96c7\u5458\u59d3\u540d', \n  job string DEFAULT NULL COMMENT '\u5de5\u4f5c\u804c\u4f4d', \n  mgr int DEFAULT NULL COMMENT '\u9886\u5bfc\u7f16\u53f7', \n  hiredate date DEFAULT NULL COMMENT '\u96c7\u4f63\u65e5\u671f', \n  sal int DEFAULT NULL COMMENT '\u6708\u85aa', \n  comm int DEFAULT NULL COMMENT '\u5956\u91d1\uff0c\u6216\u8005\u4e3a\u4f63\u91d1', \n  deptno int DEFAULT NULL COMMENT '\u90e8\u95e8\u7f16\u53f7'\n)\nCLUSTERED BY ( \n  empno) \nINTO 1 BUCKETS stored as orc_transaction;<\/code><\/pre>\n<h3>1.3 JDBCBunch WRITER\u914d\u7f6e<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573093120.png\" alt=\"file\" \/><\/p>\n<h2>\u4e8c\uff0e   Workflow\u4fa7\u914d\u7f6e<\/h2>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573100909.png\" alt=\"file\" \/><\/p>\n<h3>2.1 SQL\u4efb\u52a1<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573108628.png\" alt=\"file\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573114583.png\" alt=\"file\" \/><\/p>\n<h3>2.2 \u6570\u636e\u6d41\u4efb\u52a1<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573129788.png\" alt=\"file\" \/><\/p>\n<h3>2.3 \u5de5\u4f5c\u6d41\u53c2\u6570\u914d\u7f6e<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573137134.png\" alt=\"file\" \/><\/p>\n<h3>2.4 \u8c03\u5ea6\u5468\u671f<\/h3>\n<blockquote>\n<p>\u6309\u9700\u6c42\u5b9a\u4e49\u8c03\u5ea6\u5468\u671f\uff0c\u6d4b\u8bd5\u7684\u8bdd\u8bbe\u7f6e\u6210\u4e00\u5206\u949f\u4e00\u6b21<\/p>\n<\/blockquote>\n<h2>\u4e09\uff0e   \u6d4b\u8bd5<\/h2>\n<h3>3.1 \u9996\u6b21\u8c03\u5ea6<\/h3>\n<blockquote>\n<p>\u7b2c\u4e00\u6b21\u8c03\u5ea6\uff0c\u4f1a\u5c06\u6240\u6709empno&gt;0\u7684\u5168\u90e8\u5bfc\u5165<\/p>\n<\/blockquote>\n<h3>3.2 \u63d2\u5165\u6570\u636e\u6d4b\u8bd5<\/h3>\n<blockquote>\n<p>Oracle\u4fa7\u63d2\u5165\u4e00\u6761\u6d4b\u8bd5\u6570\u636e\uff0c\u7b49\u5f85wf\u8c03\u5ea6\uff0c\u8c03\u5ea6\u6210\u529f\u4e4b\u540e\uff0c\u68c0\u67e5inceptor\u4fa7\u6570\u636e\u662f\u5426\u5bfc\u5165\u6210\u529f<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573158546.png\" alt=\"file\" \/><\/p>\n<h2>\u57fa\u4e8eTIME\u589e\u91cf\u5bfc\u5165<\/h2>\n<h2>\u4e00\uff0e   TDT\u4fa7\u914d\u7f6e<\/h2>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573167560.png\" alt=\"file\" \/><\/p>\n<h3>1.1 JDBC Reader\u914d\u7f6e<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573175333.png\" alt=\"file\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573181703.png\" alt=\"file\" \/><\/p>\n<blockquote>\n<p>Oracle\u4fa7\u8868 lkw.emp01<br \/>\nInceptor \u4fa7orc\u4e8b\u52a1\u8868 tdt_dataflow_with_date (\u9700\u8981\u63d0\u524d\u521b\u5efa)\uff1a<\/p>\n<\/blockquote>\n<pre><code class=\"language-sql\">CREATE  TABLE lkw.tdt_dataflow_with_date(\n  empno decimal(38,0) DEFAULT NULL, \n  ename string DEFAULT NULL, \n  job string DEFAULT NULL, \n  mgr decimal(38,0) DEFAULT NULL, \n  hiredate timestamp DEFAULT NULL, \n  sal decimal(7,2) DEFAULT NULL, \n  comm decimal(7,2) DEFAULT NULL, \n  deptno decimal(38,0) DEFAULT NULL\n)\nCLUSTERED BY ( \n  empno) \nINTO 3 BUCKETS STORED AS ORC_TRANSACTION;<\/code><\/pre>\n<h3>1.2 JDBCBunch WRITER\u914d\u7f6e<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573215402.png\" alt=\"file\" \/><\/p>\n<h2>\u4e8c\uff0e Workflow\u4fa7\u914d\u7f6e<\/h2>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564572889334.png\" alt=\"file\" \/><\/p>\n<h3>2.1 \u6570\u636e\u6d41\u4efb\u52a1<\/h3>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573238923.png\" alt=\"file\" \/><\/p>\n<h3>2.2 \u8c03\u5ea6\u5468\u671f<\/h3>\n<blockquote>\n<p>\u53c2\u6570\u8bbe\u7f6e\u662f\u6309\u7167\u5929\u589e\u91cf\u5bfc\u5165\u7684\uff0c\u4e3a\u4e86\u6d4b\u8bd5\u65b9\u4fbf\uff0c\u6211\u4eec\u628a\u8c03\u5ea6\u5468\u671f\u8bbe\u7f6e\u62101min<\/p>\n<\/blockquote>\n<h2>\u4e09\uff0e \u6d4b\u8bd5<\/h2>\n<h3>3.1 \u63d2\u5165\u6570\u636e\u6d4b\u8bd5<\/h3>\n<blockquote>\n<p>\u6267\u884cinsert\u8bed\u53e5\uff0c<\/p>\n<\/blockquote>\n<pre><code class=\"language-sql\">insert into emp01 (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)\nvalues ('8000', 'lkw1', 'master', '7839', to_date('17-6-2019', 'dd-mm-yyyy'), '99999', 99999, '20');\ninsert into emp01(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)\nvalues ('8001', 'lkw1', 'master', '7839', to_date('18-6-2019', 'dd-mm-yyyy'), '99999', 99999, '20');\ninsert into emp01(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)\nvalues ('8002', 'lkw1', 'master', '7839', to_date('19-6-2019', 'dd-mm-yyyy'), '99999', 99999, '20');<\/code><\/pre>\n<blockquote>\n<p>\u7531\u4e8e\u8c03\u5ea6\u5468\u671f\u662f1min\uff0c\u6bcf\u5206\u949f\u90fd\u4f1a\u628a\u6700\u8fd11d\u5185\u65b0\u589e\u7684\u8fd93\u6761\u6570\u636e\u63d2\u5165\u5230\u76ee\u6807\u8868\uff0c\u6240\u4ee5\u4f1a\u770b\u5230\u5f88\u591a\u91cd\u590d\u6570\u636e\uff0c\u6d4b\u8bd5\u901a\u8fc7<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573286831.png\" alt=\"file\" \/><\/p>\n<blockquote>\n<p>\u4e0b\u9762\u4e5f\u4f1a\u770b\u52304\u4efd\u65b0\u589e\u6570\u636e<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2019\/07\/image-1564573294551.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u57fa\u4e8eID\u589e\u91cf\u5bfc\u5165 \u4e00\uff0e TDT\u4fa7\u914d\u7f6e 1.1 \u914d\u7f6eoracle\u548cinceptor\u8fde\u63a5 1.2 JDBC Rea ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=390\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-390","post","type-post","status-publish","format-standard","hentry","category-configuration"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=390"}],"version-history":[{"count":1,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions"}],"predecessor-version":[{"id":417,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions\/417"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}