select(
columns: Column[],
filter: WhereClause,
orderBy: Filter[],
limit:| Name | Type | Description |
|---|---|---|
columns | Column[] | Optional. Columns to include in the result set. If omitted, all columns are selected. |
filter | WhereClause | Optional. Conditions to apply to the query for filtering results. |
orderBy | Filter[] | Optional. Criteria to sort the result set. |
limit | number | Optional. Maximum number of records to return. |
allowFiltering | boolean | |
fetchSize | number | |
pagingState | string |
Executes a SELECT query on the Cassandra table with optional filtering, ordering, and pagination. Allows for specifying columns to return, filter conditions, sort order, and limits on the number of results.
Optional. Enables ALLOW FILTERING option for queries that cannot be executed directly due to Cassandra's query restrictions.
Optional. The number of rows to fetch per page (for pagination).
Optional. The paging state from a previous query execution, used for pagination.