mysql版本5.7.38-log
doris版本Version : doris-2.0.10
navicat15
报错sql:
mysql> select records from mytable where id = 1501418226155900000;
ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: type JSON is unsupported for Nereids
mysql同步doris自动生成的数据库表。
CREATE TABLE `direct_consignment_weight` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`shopify_store_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '站点Id',
`order_id` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号 保持唯一)',
`records` json NOT NULL COMMENT '参数',
`input_name` varchar(64) NOT NULL DEFAULT '' COMMENT '操作人',
`input_time` varchar(64) NOT NULL DEFAULT '' COMMENT '操作时间',
`weight` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT '更新的数量',
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
`is_dispatch` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否发货 0:未发 1:已发',
`logistics_service_type` tinyint(2) NOT NULL COMMENT '务类型成',
`is_deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE,
KEY `shopify_store_id` (`shopify_store_id`,`order_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1802870686369726467 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='xxxx'
在mysql查询的json格式为:
[
{
"sku": "aaabbb",
"quantity": 1,
"contractSn": "xxx20220123010",
"supplierSn": "xxx081",
"batchNumber": 1
}
]