Rikai Spark UDFs¶

Rikai provides many Spark User-Defined-Functions (UDF) to work with unstructured semantic types, like images, videos, and annotations.

Geometry UDFs.¶

area(box: Box2d): float calculates the area of a 2-D bounding box (Box2d).

Example

SELECT * FROM dataset WHERE area(pred.box) > 2000

box2d(coords: array<float>): Box2d builds a Box2d from [xmin,ymin,xmax,ymax] array.

Example

SELECT box2d(array(1, 2, 3.5, 4.0))

box2d_from_top_left(coords: array<float>): Box2d builds a Box2d from [x0, y0, width, height] array.

Example

SELECT box2d_from_top_left(array(1, 2, 15, 20))

box2d_from_center(coords: array<float>): Box2d builds a Box2d from [center_x, center_y, width, height] array.

Builds an Image from bytes or URI.

Example

SELECT to_image("s3://bucket/to/image.png")

image_copy(image: Image, uri: str): Image copies image to another URI and returns the new Image object.

Example

SELECT image_copy(img, "s3://bucket/to/new_image.png") FROM images

copy(src: str, dest: str): str copies a file from the source to dest, and returns the destination URI.