aidb icon indicating copy to clipboard operation
aidb copied to clipboard

Don't support User Defined Function as an intermediate filter predicate to filter blobs

Open ttt-77 opened this issue 2 years ago • 0 comments

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.

ttt-77 avatar Dec 22 '23 05:12 ttt-77