Detail
When running a query with multiple predicates of different types certain part of the query will be pushed down to the Aerospike Database while others will be handled on the Starburst/Trino side.Answer
Starburst Aerospike Connector only pushes simple Scalar filter. We pushdown String and Long type variant(i.e short, int, long (not double and float)) to the db.In the following example, the first predicate `condition1year=2023` will be pushed down to the Aerospike Database. The other filters would be done one the Starburst/Trino side.
Select
__key
from
"MyDatabase"."Mynamespace"."Mysetname"
where
condition1year=2025 AND
element_at(
cast(condition1day as map(INT, array (double))),
11012025
) is NULL