SELECT#
SELECT FRAMES WITH PREDICATES#
Search for frames with a car
SELECT id, frame
FROM MyVideo
WHERE ['car'] <@ FastRCNNObjectDetector(frame).labels
ORDER BY id;
Search frames with a pedestrian and a car
SELECT id, frame
FROM MyVideo
WHERE ['pedestrian', 'car'] <@ FastRCNNObjectDetector(frame).labels;
Search for frames containing greater than 3 cars
SELECT id FROM MyVideo
WHERE Array_Count(FastRCNNObjectDetector(data).label, 'car') > 3
ORDER BY id;
SELECT WITH MULTIPLE UDFS#
Compose multiple user-defined functions in a single query to construct semantically complex queries.
SELECT id, bbox, EmotionDetector(Crop(data, bbox))
FROM HAPPY JOIN LATERAL UNNEST(FaceDetector(data)) AS Face(bbox, conf)
WHERE id < 15;