语句:
WITH TopCheckpoints AS (SELECT device_name AS "设备名称", COUNT(*) AS "抓拍次数"
FROM t_data_vehicle
WHERE collect_time >= DATE_TRUNC(NOW(), 'day') - INTERVAL '7' DAY
GROUP BY device_name
ORDER BY COUNT(*) DESC
LIMIT 3),
VehicleCounts AS (SELECT device_name AS "设备名称", plate_no AS "车牌号", COUNT(*) AS "抓拍次数"
FROM t_data_vehicle
WHERE collect_time >= DATE_TRUNC(NOW(), 'day') - INTERVAL '7' DAY
AND device_name IN (SELECT "设备名称" FROM TopCheckpoints)
GROUP BY device_name, plate_no)
SELECT * from VehicleCounts;
explain后
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|Explain String(Nereids Planner) |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 7:VOlapScanNode(894) |
| TABLE: shizong_77.t_data_vehicle(t_data_vehicle), PREAGGREGATION: ON |
| PREDICATES: ((device_name[#36] = '设备名称') AND (collect_time[#33] >= '2025-07-17 00:00:00')) |
| partitions=98/367 (p20241009,p20241011,p20241012,p20241014,p20241015,p20241018,p20241021,p20241022,p20241023,p20241024,p20241028,p20241029,p20241030,p20241031,p20241101,p20241102,p20241104,p20241105,p20241106,p20241107,p20241108,p20241111,p20241113,p20241118,p20241119,p20241120,p20241121,p20241125,p20241126,p20241203,p20241205,p20241208,p20241210,p20241212,p20241213,p20241217,p20241218,p20241219,p20241222,p20241225,p20241226,p20250102,p20250107,p20250108,p20250114,p20250116,p20250117,p20250120,p20250122,p20250124,p20250210,p20250211,p20250212,p20250213,p20250214,p20250217,p20250219,p20250221,p20250224,p20250225,p20250226,p20250227,p20250305,p20250306,p20250308,p20250310,p20250314,p20250317,p20250324,p20250325,p20250331,p20250408,p20250409,p20250410,p20250411,p20250412,p20250424,p20250428,p20250506,p20250508,p20250509,p20250510,p20250514,p20250515,p20250516,p20250519,p20250529,p20250610,p20250620,p20250625,p20250627,p20250703,p20250705,p20250707,p20250708,p20250710,p20250717,p20250722)|
| tablets=1176/1176, tabletList=20134193,20134195,20134197 ... |
| cardinality=9978, avgRowSize=0.0, numNodes=1 |
| pushAggOp=NONE |
| final projections: plate_no[#30], device_name[#36] |
| final project output tuple id: 8 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
解析计划有问题 导致查询无结果
