CREATE TABLE `video_auto` (
`id` bigint(12) NOT NULL AUTO_INCREMENT,
`video_id` bigint(12) NOT NULL COMMENT '视频id',
`brand_id` bigint(20) DEFAULT NULL COMMENT '品牌id',
`series_id` bigint(20) DEFAULT NULL COMMENT '车系id',
`score` float DEFAULT NULL COMMENT '相关度',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_del` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态 0 正常 1 删除',
PRIMARY KEY (`id`),
KEY `idx_auto_video_id` (`video_id`),
KEY `idx_auto_brand_id` (`brand_id`),
KEY `idx_auto_series_id` (`series_id`),
KEY `IDX_brand_id_is_del` (`brand_id`,`is_del`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=386273;
select id from video_auto GROUP BY video_id ORDER BY create_time DESC limit 10 ;
Projection_8 10.00 10 root time:558.3ms, loops:2, Concurrency:OFF svda.video_auto.id 744 Bytes N/A
└─TopN_11 10.00 10 root time:558.3ms, loops:2 svda.video_auto.create_time:desc, offset:0, count:10 27.7 KB N/A
└─HashAgg_21 129367.61 129312 root time:550.3ms, loops:129, PartialConcurrency:4, FinalConcurrency:4 group by:svda.video_auto.video_id, funcs:firstrow(Column#10)->svda.video_auto.id, funcs:firstrow(Column#11)->svda.video_auto.create_time 3.01 MB N/A
└─TableReader_22 129367.61 129312 root time:263.3ms, loops:2, cop_task: {num: 1, max: 263.2ms, proc_keys: 267001, tot_proc: 236ms, rpc_num: 1, rpc_time: 263.2ms, copr_cache: disabled} data:HashAgg_15 2.96 MB N/A
└─HashAgg_15 129367.61 129312 cop[tikv] tikv_task:{time:231ms, loops:261} group by:svda.video_auto.video_id, funcs:firstrow(svda.video_auto.id)->Column#10, funcs:firstrow(svda.video_auto.create_time)->Column#11 N/A N/A
└─TableFullScan_20 266941.00 267001 cop[tikv] table:video_auto tikv_task:{time:151ms, loops:261} keep order:false N/A N/A
是因为 GROUP BY的字段分散在多个region上所以还是去要拿回tidb聚合么