查询json格式出现type JSON is unsupported for Nereids

Viewed 29

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
    }
]
1 Answers
set enable_fallback_to_original_planner=true; 

后是否能正常查询,2.0新优化器不支持复杂类型。