doris问题

20220314

https://www.jianshu.com/p/c0341aa6f820
如何同步mysql数据到Doris中

20220127

doris是一个数据库分析引擎支持大规模并行处理
doris直接使用mysql的sql语法?

20220111

CREATE EXTERNAL TABLE `tb_onekey_goods_info_manual_match_test` (
  `id` bigint(20) NOT NULL COMMENT "业务主键 自增id",
  `goods_id` varchar(200) NULL COMMENT "商品id",
  `hz_goods_id` varchar(200) NULL COMMENT "合纵商品id",
  `goods_name` varchar(200) NULL COMMENT "商品名称",
  `pinyin` varchar(200) NULL COMMENT "拼音",
  `barcode` varchar(200) NULL COMMENT "商品条码",
  `license_no` varchar(200) NULL COMMENT "批准文号",
  `specification` varchar(200) NULL COMMENT "规格",
  `manufacturer` varchar(200) NULL COMMENT "生产厂家",
  `place_of_production` varchar(200) NULL COMMENT "产地",
  `goods_category_code` int(11) NULL COMMENT "产品类别编码",
  `goods_category_name` varchar(200) NULL COMMENT "产品类别名称",
  `goods_native_code` varchar(200) NULL COMMENT "药品本位码",
  `goods_native_code_remark` varchar(200) NULL COMMENT "药品本位码备注",
  `goods_register_name` varchar(200) NULL COMMENT "药品注册名称",
  `goods_english_name` varchar(200) NULL COMMENT "药品英文名称",
  `dosage_form` varchar(200) NULL COMMENT "剂型",
  `unit` varchar(200) NULL COMMENT "单位",
  `update_time` datetime NULL COMMENT "修改时间",
  `update_times` int(11) NULL COMMENT "修改次数",
  `match_status` int(11) NULL COMMENT "对码状态, 0：忽略，1：已对码，2：未对码"
) ENGINE=MYSQL  (和mysql库里面表的映射关系,数据还是)
COMMENT "手动对码结果-商品信息表(商品粒度)"
PROPERTIES (
"host" = "192.168.1.106",
"port" = "3306",
"user" = "engine",
"password" = "",
"database" = "onekey_bi",
"table" = "tb_onekey_goods_info_manual_match_test"
);

doris和mysql表的映射的情况下,数据在mysql里面 无法通过doris对表进行插入，更新等操作
处分新建表的时候 不要下面的部分  不要和mysql进行映射
ENGINE=MYSQL  (和mysql库里面表的映射关系,数据还是)
COMMENT "手动对码结果-商品信息表(商品粒度)"
PROPERTIES (
"host" = "192.168.1.106",
"port" = "3306",
"user" = "engine",
"password" = "",
"database" = "onekey_bi",
"table" = "tb_onekey_goods_info_manual_match_test"
);

SQL 错误 [1064] [42000]: New planner only support insert into olap table