GPUdb.filter( table_name = None, view_name = '', expression = None, options = {}
)
Filters data based on the specified expression. The results are stored in a result set with the given input parameter view_name.
For details see concepts.
The response message contains the number of points for which the expression evaluated to be true, which is equivalent to the size of the result view.
Input Parameter Description
| Name | Type | Description |
|---|---|---|
| table_name | str | Name of the table to filter. This may be the ID of a collection, table or a result set (for chaining queries). Collections may be filtered only if all tables within the collection have the same type ID. |
| view_name | str | If provided, then this will be the name of the view containing the results. Must not be an already existing collection, table or view . Default value is ''. |
| expression | str | The select expression GPUdb uses to filter the specified table. For details see concepts. |
| options | dict of str | Optional parameters. Default value is an empty dict ( {} ). |
Output Parameter Description
| Name | Type | Description |
|---|---|---|
| count | long | The number of records that matched the given select expression. |