【详述】Oracle 导入 StarRocks datax 导入，已导入6千万条数据，报错
Error: Value count does not match column count.
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】例如：2.2.2
【集群规模】例如：2fe（1 follower+1observer）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【附件】
sr 建表语句：
CREATE TABLE wx_sum_sinfo (
DATA_MONTH date NOT NULL COMMENT “YYYY-MM-DD”,
SHOP_AREA_CODE varchar(50) NULL COMMENT “”,
PLATFORM_ID varchar(500) NULL COMMENT “”,
PLATFORM varchar(500) NULL COMMENT “”,
SHOP_ID varchar(500) NULL COMMENT “”,
SHOP_NAME varchar(500) NULL COMMENT “”,
COMPANY_NAME_T varchar(200) NULL COMMENT “”,
CREDITCODE varchar(100) NULL COMMENT “”,
COMPANY_NAME varchar(1000) NULL COMMENT “”,
SHOP_SALES_VOLUME varchar(50) NULL COMMENT “”,
SHOP_SALES_AMOUNT varchar(50) NULL COMMENT “”,
SHOP_SALES_VOLUME_SUM varchar(50) NULL COMMENT “”,
SHOP_SALES_AMOUNT_SUM varchar(50) NULL COMMENT “”,
SHOP_SALES_VOLUME_YOY varchar(50) NULL COMMENT “”,
SHOP_SALES_AMOUNT_YOY varchar(50) NULL COMMENT “”,
SHOP_SALES_VOLUME_SUM_YOY varchar(50) NULL COMMENT “”,
SHOP_SALES_AMOUNT_SUM_YOY varchar(50) NULL COMMENT “”,
SHOP_ITEM_NUM varchar(50) NULL COMMENT “”,
IS_SELF_RUN varchar(20) NULL COMMENT “”,
SHOP_URL varchar(8000) NULL COMMENT “”,
SHOP_OPEN_DATE varchar(50) NULL COMMENT “”,
SHOP_OPEN_YEARS varchar(50) NULL COMMENT “”,
SHOP_SATATUS varchar(500) NULL COMMENT “”,
SHOP_CLOSE_DATE varchar(50) NULL COMMENT “”,
MAIN_BUSINESS varchar(500) NULL COMMENT “”,
STAT_MAIN_BUSINESS varchar(1000) NULL COMMENT “”,
BUSINESS_SCOPE varchar(16000) NULL COMMENT “”,
COMPANY_PROVINCE varchar(500) NULL COMMENT “”,
COMPANY_CITY varchar(500) NULL COMMENT “”,
COMPANY_COUNTY varchar(500) NULL COMMENT “”,
COMPANY_AREA_CODE varchar(50) NULL COMMENT “”,
SHOP_PROVINCE varchar(500) NULL COMMENT “”,
SHOP_CITY varchar(500) NULL COMMENT “”,
SHOP_COUNTY varchar(500) NULL COMMENT “”,
SHOP_DELIVERY_PROVINCE varchar(500) NULL COMMENT “”,
SHOP_DELIVERY_CITY varchar(500) NULL COMMENT “”,
SHOP_DELIVERY_COUNTY varchar(500) NULL COMMENT “”,
SHOP_DELIVERY_CODE varchar(500) NULL COMMENT “”,
CREATTIME varchar(50) NULL COMMENT “”,
UPDATETIME varchar(50) NULL COMMENT “”,
SHOP_IMG_URL varchar(16000) NULL COMMENT “”
) ENGINE=OLAP
DUPLICATE KEY(DATA_MONTH, SHOP_AREA_CODE)
COMMENT “OLAP”
DISTRIBUTED BY HASH(SHOP_AREA_CODE) BUCKETS 12
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
oracle 建表语句
CREATE TABLE “WX_SUM_SINFO” (
“DATA_MONTH” DATE ,
“PLATFORM_ID” VARCHAR2(10 BYTE) ,
“PLATFORM” VARCHAR2(100 BYTE) ,
“SHOP_ID” VARCHAR2(100 BYTE) ,
“SHOP_NAME” VARCHAR2(500 BYTE) ,
“COMPANY_NAME_T” VARCHAR2(200 BYTE) ,
“CREDITCODE” VARCHAR2(18 BYTE) ,
“COMPANY_NAME” VARCHAR2(200 BYTE) ,
“SHOP_SALES_VOLUME” NUMBER ,
“SHOP_SALES_AMOUNT” NUMBER ,
“SHOP_SALES_VOLUME_SUM” NUMBER ,
“SHOP_SALES_AMOUNT_SUM” NUMBER ,
“SHOP_SALES_VOLUME_YOY” NUMBER ,
“SHOP_SALES_AMOUNT_YOY” NUMBER ,
“SHOP_SALES_VOLUME_SUM_YOY” NUMBER ,
“SHOP_SALES_AMOUNT_SUM_YOY” NUMBER ,
“SHOP_ITEM_NUM” NUMBER ,
“IS_SELF_RUN” VARCHAR2(2 BYTE) DEFAULT ‘否’ ,
“SHOP_URL” VARCHAR2(1000 BYTE) ,
“SHOP_OPEN_DATE” DATE ,
“SHOP_OPEN_YEARS” NUMBER ,
“SHOP_SATATUS” VARCHAR2(100 BYTE) ,
“SHOP_CLOSE_DATE” DATE ,
“MAIN_BUSINESS” VARCHAR2(100 BYTE) ,
“STAT_MAIN_BUSINESS” VARCHAR2(100 BYTE) ,
“BUSINESS_SCOPE” VARCHAR2(4000 BYTE) ,
“COMPANY_PROVINCE” VARCHAR2(100 BYTE) ,
“COMPANY_CITY” VARCHAR2(100 BYTE) ,
“COMPANY_COUNTY” VARCHAR2(100 BYTE) ,
“COMPANY_AREA_CODE” VARCHAR2(6 BYTE) ,
“SHOP_PROVINCE” VARCHAR2(100 BYTE) ,
“SHOP_CITY” VARCHAR2(100 BYTE) ,
“SHOP_COUNTY” VARCHAR2(100 BYTE) ,
“SHOP_AREA_CODE” VARCHAR2(6 BYTE) ,
“SHOP_DELIVERY_PROVINCE” VARCHAR2(100 BYTE) ,
“SHOP_DELIVERY_CITY” VARCHAR2(100 BYTE) ,
“SHOP_DELIVERY_COUNTY” VARCHAR2(100 BYTE) ,
“SHOP_DELIVERY_CODE” VARCHAR2(100 BYTE) ,
“CREATTIME” DATE ,
“UPDATETIME” DATE ,
“SHOP_IMG_URL” VARCHAR2(4000 BYTE)
)
报错数据
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-04-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0’, ‘0’, NULL, NULL, NULL, NULL, ‘16’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.4’, ‘开店’, NULL, ‘母婴童装’, ‘粮油、食品’, ‘母婴童装’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 12:57:32’, ‘2021-09-10 12:57:32’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-05-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0.0008’, ‘0.348’, ‘0.0008’, ‘0.348’, NULL, NULL, NULL, NULL, ‘30’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.5’, ‘开店’, NULL, NULL, NULL, ‘母婴童装’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 13:06:30’, ‘2021-09-10 13:06:30’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-06-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0.0252’, ‘16.1183’, ‘0.026’, ‘16.4663’, NULL, NULL, NULL, NULL, ‘37’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.6’, ‘开店’, NULL, ‘母婴童装’, ‘粮油、食品’, ‘母婴童装’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 13:15:23’, ‘2021-09-10 13:15:23’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-07-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0.0068’, ‘5.0455’, ‘0.0328’, ‘21.5118’, NULL, NULL, NULL, NULL, ‘37’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.7’, ‘开店’, NULL, ‘母婴童装’, ‘粮油、食品’, ‘母婴童装’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 13:24:20’, ‘2021-09-10 13:24:20’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-08-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0.0056’, ‘2.313’, ‘0.0384’, ‘23.8248’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.8’, ‘开店’, NULL, ‘母婴童装’, ‘粮油、食品’, ‘母婴童装’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 13:33:45’, ‘2021-09-10 13:33:45’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-09-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0.0384’, ‘23.8248’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.8’, ‘开店’, NULL, NULL, NULL, ‘母婴童装’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 14:16:42’, ‘2021-09-10 14:16:42’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-10-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0.0384’, ‘23.8248’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘0.9’, ‘开店’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 14:35:55’, ‘2021-09-10 14:35:55’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-11-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0.0384’, ‘23.8248’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1’, ‘开店’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 14:55:32’, ‘2021-09-10 14:55:32’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2020-12-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0.0384’, ‘23.8248’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.1’, ‘开店’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 15:16:33’, ‘2021-09-10 15:16:33’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-01-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0’, ‘0’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.2’, ‘开店’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 15:39:45’, ‘2021-09-10 15:39:45’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-02-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', ‘0’, ‘0’, ‘0’, ‘0’, NULL, NULL, NULL, NULL, ‘42’, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘开店’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 15:57:49’, ‘2021-09-10 15:57:49’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-03-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, NULL, NULL, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 16:26:56’, ‘2021-09-10 16:26:56’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-04-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, NULL, NULL, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 16:49:14’, ‘2021-09-10 16:49:14’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-05-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 17:13:27’, ‘2021-09-10 17:13:27’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-06-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 17:43:08’, ‘2021-09-10 17:43:08’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-07-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 18:04:32’, ‘2021-09-10 18:04:32’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-08-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-09-10 18:39:16’, ‘2021-09-10 18:39:16’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-09-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-10-06 20:39:38’, ‘2021-10-06 20:39:38’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-10-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-11-09 10:42:37’, ‘2021-11-09 10:42:37’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-11-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2021-12-08 10:26:08’, ‘2021-12-08 10:26:08’, NULL);
INSERT INTO “”(“DATA_MONTH”, “PLATFORM_ID”, “PLATFORM”, “SHOP_ID”, “SHOP_NAME”, “COMPANY_NAME_T”, “CREDITCODE”, “COMPANY_NAME”, “SHOP_SALES_VOLUME”, “SHOP_SALES_AMOUNT”, “SHOP_SALES_VOLUME_SUM”, “SHOP_SALES_AMOUNT_SUM”, “SHOP_SALES_VOLUME_YOY”, “SHOP_SALES_AMOUNT_YOY”, “SHOP_SALES_VOLUME_SUM_YOY”, “SHOP_SALES_AMOUNT_SUM_YOY”, “SHOP_ITEM_NUM”, “IS_SELF_RUN”, “SHOP_URL”, “SHOP_OPEN_DATE”, “SHOP_OPEN_YEARS”, “SHOP_SATATUS”, “SHOP_CLOSE_DATE”, “MAIN_BUSINESS”, “STAT_MAIN_BUSINESS”, “BUSINESS_SCOPE”, “COMPANY_PROVINCE”, “COMPANY_CITY”, “COMPANY_COUNTY”, “COMPANY_AREA_CODE”, “SHOP_PROVINCE”, “SHOP_CITY”, “SHOP_COUNTY”, “SHOP_AREA_CODE”, “SHOP_DELIVERY_PROVINCE”, “SHOP_DELIVERY_CITY”, “SHOP_DELIVERY_COUNTY”, “SHOP_DELIVERY_CODE”, “CREATTIME”, “UPDATETIME”, “SHOP_IMG_URL”) VALUES (‘2021-12-01’, ‘12’, ‘环球捕手’, ‘26582’, ‘美赞臣母婴海外旗舰店’, '卓烨贸易有限公司
', NULL, '卓烨贸易有限公司
', NULL, NULL, ‘0’, ‘0’, NULL, NULL, ‘-100’, ‘-100’, NULL, ‘否’, ‘wap.myzebravip.com/store/?shopId=26582’, ‘2019-12-02 13:12:44’, ‘1.3’, ‘关店’, ‘2021-03-01 00:00:00’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘其他’, NULL, NULL, NULL, ‘2022-01-06 14:59:54’, ‘2022-01-06 14:59:54’, NULL);
datax json 文件
查询sql 语句
SELECT TO_CHAR(DATA_MONTH,‘YYYY-MM-DD’) DATA_MONTH , PLATFORM_ID,PLATFORM, SHOP_ID, SHOP_NAME, COMPANY_NAME_T, CREDITCODE, COMPANY_NAME, SHOP_SALES_VOLUME, SHOP_SALES_AMOUNT, SHOP_SALES_VOLUME_SUM, SHOP_SALES_AMOUNT_SUM, SHOP_SALES_VOLUME_YOY, SHOP_SALES_AMOUNT_YOY, SHOP_SALES_VOLUME_SUM_YOY, SHOP_SALES_AMOUNT_SUM_YOY, SHOP_ITEM_NUM, IS_SELF_RUN, SHOP_URL, TO_CHAR(SHOP_OPEN_DATE,‘YYYY-MM-DD HH24:mi:ss’) SHOP_OPEN_DATE , SHOP_OPEN_YEARS,SHOP_SATATUS,TO_CHAR(SHOP_CLOSE_DATE,‘YYYY-MM-DD HH24:mi:ss’) SHOP_CLOSE_DATE, MAIN_BUSINESS, STAT_MAIN_BUSINESS, BUSINESS_SCOPE, COMPANY_PROVINCE, COMPANY_CITY, COMPANY_COUNTY, COMPANY_AREA_CODE, SHOP_PROVINCE, SHOP_CITY, SHOP_COUNTY, SHOP_AREA_CODE,SHOP_DELIVERY_PROVINCE,SHOP_DELIVERY_CITY, SHOP_DELIVERY_COUNTY, SHOP_DELIVERY_CODE, TO_CHAR(CREATTIME,‘YYYY-MM-DD HH24:mi:ss’) CREATTIME , TO_CHAR(UPDATETIME,‘YYYY-MM-DD HH24:mi:ss’) UPDATETIME, SHOP_IMG_URL FROM WX_SUM_SINFO WHERE shop_name = ‘美赞臣母婴海外旗舰店’"
报错日志：
请问是否是数据类型对应有问题？ 关键是已经成功导入6千万了，
上述21条报错数据，使用datax reader sql 在oracle 查询后转insert 在starRocks中 能正常插入