LOAD#

LOAD VIDEO#

LOAD VIDEO 'test_video.mp4' INTO MyVideo;

  • test_video.mp4 is the location of the video file in the filesystem on the client.

  • MyVideo is the name of the table in EVA where this video is loaded. Subsequent queries over the video must refer to this table name.

When a video is loaded, there is no need to specify the schema for the video table. EVA automatically generates the following schema with two columns: id and data, that correspond to the frame id and frame content (in Numpy format).

LOAD CSV#

To LOAD a CSV file, we need to first specify the table schema.

CREATE TABLE IF NOT EXISTS MyCSV (
                id INTEGER UNIQUE,
                frame_id INTEGER,
                video_id INTEGER,
                dataset_name TEXT(30),
                label TEXT(30),
                bbox NDARRAY FLOAT32(4),
                object_id INTEGER
            );

LOAD CSV 'test_metadata.csv' INTO MyCSV;

  • test_metadata.csv needs to be loaded onto the server using LOAD statement.

  • The CSV file may contain additional columns. EVA will only load the columns listed in the defined schema.