aidb
aidb copied to clipboard
Don't support User Defined Function as an intermediate filter predicate to filter blobs
For queries that require multiple inference services, our system does not support using User Defined Functions (UDFs) as intermediate filter predicates for filtering inputs. Consider the following example query:
SELECT frame, x_min, color
FROM objects00.frame = colors02.frame AND objects00.object_id = colors02.object_id
WHERE function1(x_min, y_min) > 100.
Although the UDF 'function1' is capable of filtering inputs at an earlier stage, potentially decreasing the number of calls to 'colors02', our current system only executes User Defined Function after all inference services have been completed.