产品概述
基本概念
集群架构
产品优势
应用场景
INSERT INTO SELECT 的方式导入外部表的数据。CREATE EXTERNAL RESOURCE `oracle_test_odbc`PROPERTIES ("type" = "odbc_catalog","host" = "192.168.0.10","port" = "8086","user" = "oracle","password" = "oracle","database" = "oracle","odbc_type" = "oracle","driver" = "Oracle");
oracle_test_odbc 的 Resource，其类型为 odbc_catalog，表示这是一个用于存储 ODBC 信息的 Resource。odbc_type 为 oracle，表示这个 ODBC Resource 是用于连接 Oracle 数据库的。CREATE EXTERNAL TABLE `ext_oracle_demo` (`k1` decimal(9, 3) NOT NULL COMMENT "",`k2` char(10) NOT NULL COMMENT "",`k3` datetime NOT NULL COMMENT "",`k5` varchar(20) NOT NULL COMMENT "",`k6` double NOT NULL COMMENT "") ENGINE=ODBCCOMMENT "ODBC"PROPERTIES ("odbc_catalog_resource" = "oracle_test_odbc","database" = "oracle","table" = "baseall");
ext_oracle_demo 外部表，并引用了之前创建的 oracle_test_odbc Resource。ext_oracle_demo 一样：CREATE TABLE `doris_oralce_tbl` (`k1` decimal(9, 3) NOT NULL COMMENT "",`k2` char(10) NOT NULL COMMENT "",`k3` datetime NOT NULL COMMENT "",`k5` varchar(20) NOT NULL COMMENT "",`k6` double NOT NULL COMMENT "")COMMENT "Doris Table"DISTRIBUTED BY HASH(k1) BUCKETS 2;PROPERTIES ("replication_num" = "1");
ext_oracle_demo表 导入到 doris_oracle_tbl 表)INSERT INTO doris_oracle_tbl SELECT k1,k2,k3 FROM ext_oracle_demo limit 100;
文档反馈