公司目前准备迁移mysql的数据到doris中，原本的一套分析报表查询的是mysql，今天测试准备迁移 报表的sql，发现有些子查询的语法好像不支持，以下是建表语句与 sql脚本
建表语句：
CREATE TABLE uk_callcenter_event (
ID varchar(300) NOT NULL COMMENT '主键ID',
NAME varchar(150) NULL COMMENT '名称',
STARTTIME datetime NULL COMMENT '通话开始时间',
CALLTYPE varchar(60) NULL COMMENT '呼叫方向类型|计费类型',
membersessionid varchar(150) NULL COMMENT '转接前通话ID',
invitetime datetime NULL COMMENT '邀评发起时间'
) ENGINE=OLAP
DUPLICATE KEY(ID)
COMMENT '通话记录表'
DISTRIBUTED BY HASH(ID) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);
sql 脚本如下：
select
(select starttime from uk_callcenter_event where calltype='outsidequene' and uk_callcenter_event.membersessionid=c.id order by starttime limit 1 ) as aa
from uk_callcenter_event c
请问可以支持吗？
