MySQL [ods_banggood_work]> show create table dm_affiliate_info_extend \G
*************************** 1. row ***************************
Table: dm_affiliate_info_extend
Create Table: CREATE TABLE dm_affiliate_info_extend
(
id
bigint(20) NOT NULL COMMENT “id”,
affiliate_id
bigint(20) NOT NULL DEFAULT “0” COMMENT “Affiliate ID”,
influencer_id
bigint(20) NOT NULL DEFAULT “0” COMMENT “红人ID”,
admin_id
bigint(20) NOT NULL DEFAULT “0” COMMENT “管理员id”,
label_id
varchar(300) NOT NULL DEFAULT “” COMMENT “标签”,
trade_model
varchar(150) NOT NULL DEFAULT “” COMMENT “交易模式”,
pay_model
varchar(150) NOT NULL DEFAULT “” COMMENT “支付方式”,
pay_bank
varchar(150) NOT NULL DEFAULT “” COMMENT “支付账号”,
uc_code
varchar(765) NOT NULL DEFAULT “” COMMENT “uc code”,
image
varchar(300) NOT NULL DEFAULT “” COMMENT “附件”,
customers_type
smallint(6) NOT NULL DEFAULT “1” COMMENT “用户类型”
) ENGINE=OLAP
PRIMARY KEY(id
)
COMMENT “aff扩展表”
DISTRIBUTED BY HASH(id
) BUCKETS 3
PROPERTIES (
“replication_num” = “2”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
1 row in set (0.00 sec)
MySQL [ods_banggood_work]> show create table link_dm_affiliate_info_extend \G
*************************** 1. row ***************************
Table: link_dm_affiliate_info_extend
Create Table: CREATE EXTERNAL TABLE link_dm_affiliate_info_extend
(
id
bigint(20) NOT NULL COMMENT “id”,
affiliate_id
bigint(20) NOT NULL DEFAULT “0” COMMENT “Affiliate ID”,
influencer_id
bigint(20) NOT NULL DEFAULT “0” COMMENT “红人ID”,
admin_id
bigint(20) NOT NULL DEFAULT “0” COMMENT “管理员id”,
label_id
varchar(300) NOT NULL DEFAULT “” COMMENT “标签”,
trade_model
varchar(150) NOT NULL DEFAULT “” COMMENT “交易模式”,
pay_model
varchar(150) NOT NULL DEFAULT “” COMMENT “支付方式”,
pay_bank
varchar(150) NOT NULL DEFAULT “” COMMENT “支付账号”,
uc_code
varchar(765) NOT NULL DEFAULT “” COMMENT “uc code”,
image
varchar(300) NOT NULL DEFAULT “” COMMENT “附件”,
customers_type
smallint(6) NOT NULL DEFAULT “1” COMMENT “用户类型”
) ENGINE=MYSQL
COMMENT “MYSQL”
PROPERTIES (
“host” = “10.177.13.172”,
“port” = “3306”,
“user” = “etl”,
“password” = “”,
“database” = “banggood_work”,
“table” = “dm_affiliate_info_extend”
);
1 row in set (0.00 sec)
MySQL [ods_banggood_work]> insert into dm_affiliate_info_extend select * from link_dm_affiliate_info_extend limit 10;
ERROR 1064 (HY000): intolerable failure in opening node channels