evadb.EvaDBQuery.filter#

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

Filters rows using the given condition. Multiple filters can be chained using 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")