evadb.EVADBQuery.filter#

EVADBQuery.filter(expr: str) EVADBQuery[source]#

Filters rows using the given condition. Multiple chained filters results in AND

Parameters:

expr (str) – The filter expression.

Returns:

Filtered EVADBQuery.

Return type:

EVADBQuery

Examples

>>> relation = conn.table("sample_table")
>>> relation.filter("col1 > 10")

Filter by sql string

>>> relation.filter("col1 > 10 AND col1 < 20")